FreeBookSpot Databases Latest Books

SQL and Relational Theory: How to Write Accurate SQL Code 2nd edition
Posted: December 24th, 2011, 10:53pm CET

Tags:    [edit]


Product Description: SQL is full of difficulties and traps for the unwary. You can avoid them if you understand relational theory, but only if you know how to put the theory into practice. In this insightful book, author C.J. Date explains relational theory in depth, and demonstrates through numerous examples and exercises how you can apply it directly to your use of SQL. This second edition includes new material on recursive queries, “missing information” without nulls, new update operators, and topics such as aggregate operators, grouping and ungrouping, and view updating. If you have a modest-to-advanced background in SQL, you’ll learn how to deal with a host of common SQL dilemmas. * Why is proper column naming so important? * Nulls in your database are causing you to get wrong answers. Why? What can you do about it? * Is it possible to write an SQL query to find employees who have never been in the same department for more than six months at a time? * SQL supports “quantified comparisons,” but they’re better avoided. Why? How do you avoid them? * Constraints are crucially important, but most SQL products don’t support them properly. What can you do to resolve this situation? Database theory and practice have evolved since the relational model was developed more than 40 years ago. SQL and Relational Theory draws on decades of research to present the most up-to-date treatment of SQL available. C.J. Date has a stature that is unique within the Read more...

Tags:    [edit]

Product Description: This book provides a comprehensive understanding of database development on the Internet. Read more...

Tags:    [edit]

Product Description: The amount of data being generated, processed, and stored has reached unprecedented levels. Even during the recent economic crisis, there has been no slow down or information recession. Instead, the need to process, move, and store data has only increased. Consequently, IT organizations are looking to do more with what they have while supporting growth along with new services without compromising on cost and service delivery. Cloud and Virtual Data Storage Networking, by savvy IT industry veteran Greg Schulz, looks at converging IT resources and management technologies for facilitating efficient and effective delivery of information services, including enabling of Information Factories. Regardless of your experience level, Schulz guides you through the various technologies and techniques available for achieving efficient information services delivery. Coverage includes: * Information services delivery model options and best practices * Metrics for efficient E2E IT management * Server, storage, I/O networking, and data center virtualization * Converged and cloud storage services (IaaS, PaaS, SaaS) * Data protection for virtual, cloud, and physical environments * Data footprint reduction and data protection modernization * High availability, business continuance, and disaster recovery This much-needed reference brings together technology themes and topics that are converging in IT and data center environments for enabling Read more...

Tags:    [edit]

Product Description: Summary MongoDB in Action is a comprehensive guide to MongoDB for application developers. The book begins by explaining what makes MongoDB unique and describing its ideal use cases. A series of tutorials designed for MongoDB mastery then leads into detailed examples for leveraging MongoDB in e-commerce, social networking, analytics, and other common applications. About the Technology Big data can mean big headaches. MongoDB is a document-oriented database designed to be flexible, scalable, and very fast, even with big data loads. It's built for high availability, supports rich, dynamic schemas, and lets you easily distribute data across multiple servers. About this Book MongoDB in Action introduces you to MongoDB and the document-oriented database model. This perfectly paced book provides both the big picture you'll need as a developer and enough low-level detail to satisfy a system engineer. Numerous examples will help you develop confidence in the crucial area of data modeling. You'll also love the deep explanations of each feature, including replication, auto-sharding, and deployment This book is written for developers. No MongoDB or NoSQL experience required. What's Inside * Indexes, queries, and standard DB operations * Map-reduce for custom aggregations and reporting * Schema design patterns * Deploying for scale and high availability ========================================?========== Table of ContentsPART 1 GETTI Read more...

Tags:    [edit]

Product Description: Gillenson's new edition of Fundamentals of Database Management Systems provides concise coverage of the fundamental topics necessary for a deep understanding of the basics. In this issue, there is more emphasis on a practical approach, with new "your turn" boxes and much more coverage in a separate supplement on how to implement databases with Access. In every chapter, the author covers concepts first, then show how they're implemented in continuing case(s.) "Your Turn" boxes appear several times throughout the chapter to apply concepts to projects. And "Concepts in Action" boxes contain examples of concepts used in practice. This pedagogy is easily demonstrable and the text also includes more hands-on exercises and projects and a standard diagramming style for the data modeling diagrams. Furthermore, revised and updated content and organization includes more coverage on database control issues, earlier coverage of SQL, and new coverage on data quality issues. Read more...

Tags:    [edit]

Product Description: Clear explanations of theory and design, broad coverage of models and real systems, and an up-to-date introduction to modern database technologies result in a leading introduction to database systems. Intended for computer science majors, Fundamentals of Database Systems, 6/e emphasizes math models, design issues, relational algebra, and relational calculus.  A lab manual and problems give students opportunities to practice the fundamentals of design and implementation. Real-world examples serve as engaging, practical illustrations of database concepts. The Sixth Edition maintains its coverage of the most popular database topics, including SQL, security, and data mining, and features increased emphasis on XML and semi-structured data. Read more...

Tags:    [edit]

Product Description: Control Intellectual Property, and Avoid Information Overload Glean actionable business information from your "digital landfill" by deploying a flexible, cost-effective content management framework across your entire organization. Transforming Infoglut!: A Pragmatic Strategy for Oracle Enterprise Content Management details, step-by-step, how to rein in the current data explosion and gain the competitive edge. Get tips for building an enterprise content management (ECM) team, centralizing storage, finding and managing information, incorporating legacy systems, and handling unstructured content. You''ll also learn how to secure your system, optimize performance, and ensure regulatory compliance. * Design and manage a dynamic Oracle ECM infrastructure * Consolidate corporate data using Oracle Universal Content Management * Implement a flexible, scalable, and extensible middleware layer * Centralize storage with Oracle Universal Records Management Suite * Encrypt and secure data enterprise-wide using Oracle Information Rights Management * Integrate Oracle WebCenter Services and Oracle Secure Enterprise Search * Enhance structured enterprise applications with unstructured content * Extend ECM functionality using cutting-edge Enterprise 2.0 tools Read more...

Tags:    [edit]

Mobile communications and ubiquitous computing generate large volumes of data. Mining this data can produce useful knowledge, yet individual privacy is at risk. This book investigates the various scientific and technological issues of mobility data, open problems, and roadmap. The editors manage a research project called GeoPKDD, Geographic Privacy-Aware Knowledge Discovery and Delivery, and this book relates their findings in 13 chapters covering all related subjects. Read more...

Tags:    [edit]

Product Description: The LNCS Journal on Data Semantics is devoted to the presentation of notable work that, in one way or another, addresses research and development on issues related to data semantics. The scope of the journal ranges from theories supporting the formal definition of semantic content to innovative domain-specific applications of semantic knowledge. Read more...

Tags:    [edit]

Product Description: A data-driven, fact-based, quantitative text on Oracle performance and scalability With database concepts and theories clearly explained in Oracle''s context, readers quickly learn how to fully leverage Oracle''s performance and scalability capabilities at every stage of designing and developing an Oracle-based enterprise application. The book is based on the author''s more than ten years of experience working with Oracle, and is filled with dependable, tested, and proven performance optimization techniques. Oracle Database Performance and Scalability is divided into four parts that enable readers to progressively learn and apply new skills: * Part 1, Getting Started with Oracle, describes how to set up a working Oracle environment, offering a quick tour to illustrate major database concepts * Part 2, Oracle Architecture from Performance and Scalability Perspectives, explains all the major database concepts and architectural features that readers need to know to optimize Oracle performance and scalability * Part 3, Optimizing Oracle Performance and Scalability, offers hands-on instructions to optimize and fine-tune performance and scalability for all database applications * Part 4, Case Studies: Oracle Meeting Real-World Performance and Scalability Challenges, sets forth quantitative case studies based on the author''s first-hand experience that demonstrate how readers can apply proven techniques to dramatically improve the p Read more...

Tags:    [edit]

Product Description: This lecture covers several core issues in user-centered data management, including how to design usable interfaces that suitably support database tasks, and relevant approaches to visual querying, information visualization, and visual data mining. Novel interaction paradigms, e.g., mobile and interfaces that go beyond the visual dimension, are also discussed. Table of Contents: Why User-Centered / The Early Days: Visual Query Systems / Beyond Querying / More Advanced Applications / Non-Visual Interfaces / Conclusions Read more...

Tags:    [edit]

This three-volume-set (CCIS 219, CCIS 220, and CCIS 221) constitutes the refereed proceedings of the International Conference on ENTERprise Information Systems, CENTERIS 2011, held in Vilamoura, Portugal, in September 2011. The approx. 120 revised full papers presented in the three volumes were carefully reviewed and selected from 180 submissions. The papers are organized in topical sections on knowledge society, EIS adoption and design, EIS implementation and impact, EIS applications, social aspects and IS in education, IT/IS management, telemedicine and imaging technologies, healthcare information management, medical records and business processes, decision support systems and business intelligence in health and social care contexts, architectures and emerging technologies in healthcare organizations, as well as m-health. Read more...

Tags:    [edit]

This three-volume-set (CCIS 219, CCIS 220, and CCIS 221) constitutes the refereed proceedings of the International Conference on ENTERprise Information Systems, CENTERIS 2011, held in Vilamoura, Portugal, in September 2011. The approx. 120 revised full papers presented in the three volumes were carefully reviewed and selected from 180 submissions. The papers are organized in topical sections on knowledge society, EIS adoption and design, EIS implementation and impact, EIS applications, social aspects and IS in education, IT/IS management, telemedicine and imaging technologies, healthcare information management, medical records and business processes, decision support systems and business intelligence in health and social care contexts, architectures and emerging technologies in healthcare organizations, as well as m-health. Read more...

Tags:    [edit]

Written by industry professionals who have been working with SQL Server 2008 since the earliest code, this reference expertly covers the programming fundamentals for SQL Server 2008 with crucial real-world context and extensive code samples. Get the hands-on programming instruction, practical examples, and best practices you need to master the core programmability features in SQL Server 2008. Led by three experts in database design and business intelligence solutions, you ll learn the essential tools and techniques for developing robust applications. Discover how to: -Program views, stored applications, triggers, and functions using T-SQL -Work with the new data types, LINQ, and the ADO.NET Entity Framework -Automate common administration and maintenance tasks -Debug databases, reports, and objects using Microsoft Visual Studio 2008 -Write transactional code and implement local and distributed transactions -Use business intelligence tools, such as SQL Server Reporting Services, SQL Server Analysis Services, and SQL Server Integration Services Many of the book s examples, exercises, and code samples are available for download from the companion Web site. Read more...

Tags:    [edit]

Product Description: This book constitutes the refereed proceedings of the 7th International Workshop on Databases in Networked Information Systems, DNIS 2011, held in Aizu-Wakamatsu, Japan in December 2011. The 18 revised full papers presented together with 6 invited talks and 1 keynote lecture were carefully reviewed and selected for inclusion in the book. The workshop generally puts the main focus on data semantics and infrastructure for information management and interchange. The papers are organized in topical sections on cloud computing access to information resources information and knowledge management bio-medical information management information extraction from data resources geo-spatial decision making networked information systems: infrastructure. Read more...