IT-eBooks.directory Facebook Icon Image IT-eBooks.directory Google Plus Icon Image IT-eBooks.directory Twitter Icon Image
IT-eBooks.directory Logo Image

Database Design and Relational Theory

Normal Forms and All That Jazz

Database Design and Relational Theory Image

Book details:

Publisher:O'Reilly Media
Category: OReilly
Author:
Edition:1
ISBN-10:1449328016
ISBN-13:9781449328016
Pages:278
Published:
Posted:Jun 30 2016
Language:English
Book format:PDF
Book size:31.02 MB

Book Description:

What makes this book different from others on database design? Many resources on design practice do little to explain the underlying theory, and books on design theory are aimed primarily at theoreticians. In this book, renowned expert Chris Date bridges the gap by introducing design theory in ways practitioners can understandamp;#8212;drawing on lessons learned over four decades of experience to demonstrate why proper database design is so critical in the first place. Every chapter includes a set of exercises that show how to apply the theoretical ideas in practice, provide additional information, or ask you to prove some simple theoretical result. If youamp;#8217;re a database professional familiar with the relational model, and have more than a passing interest in database design, this book is for you. Questions this book answers include:Why is Heathamp;#8217;s Theorem so important? What is The Principle of Orthogonal Design? What makes some Jds reducible and others irreducible? Why does dependency preservation matter? Should data redundancy always be avoided? Can it be? Databases often stay in production for decades, and careful design is critical for avoiding subtle errors and processing problems over time. If theyamp;#8217;re badly designed, the negative impacts can be incredibly widespread. This gentle introduction shows you how to use important theoretical results to create good database designs.

Download Link:

Related Books:

Database in Depth Image

Database in Depth

Jun 30 2016 This book sheds light on the principles behind the relational model, which is fundamental to all database-backed applications--and, consequently, most of the work that goes on in the computing world today. Database in Depth: The Relational Model for Practitioners goes beyond the hype and gets to the heart of how relational databases actually work.Ideal for experienced database developers and designers, this concise guide gives you a clear view of the technology--a view that's not influenced by any vendor or product. Featuring an extensive set of exercises, it will help you:understand why and h...

Pro SQL Server 2012 Relational Database Image

Pro SQL Server 2012 Relational Database

Jun 30 2016 Learn effective and scalable database design techniques in a SQL Server environment. Pro SQL Server 2012 Relational Database Design and Implementation covers everything from design logic that business users will understand, all the way to the physical implementation of design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, Louis Davidson shows how to get it right in SQL Server database design and lay a solid groundwork for the future use of valuable business data. Gives a solid foundation in best practices and relational theory Covers ...

Time and Relational Theory Image

Time and Relational Theory

Jun 30 2016 Time and Relational Theory provides an in-depth description of temporal database systems, which provide special facilities for storing, querying, and updating historical and future data. Traditionally, database management systems provide little or no special support for temporal data at all. This situation is changing because: * Cheap storage enables retention of large volumes of historical data in data warehouses* Users are now faced with temporal data problems, and need solutions * Temporal features have recently been incorporated into the SQL standard, and vendors have begun to add temporal...

SQL and Relational Theory Image

SQL and Relational Theory

Jun 30 2016 Understanding SQL's underlying theory is the best way to guarantee that your SQL code is correct and your database schema is robust and maintainable. On the other hand, if you're not well versed in the theory, you can fall into several traps. In SQL and Relational Theory, author C.J. Date demonstrates how you can apply relational theory directly to your use of SQL. With numerous examples and clear explanations of the reasoning behind them, you'll learn how to deal with common SQL dilemmas, such as:Should database access granted be through views instead of base tables? Nulls in your database ar...

IT-eBooks.directory