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; ;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. Database in Depth Relational Theory for Practitioners.
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 how the relational model is still directly relevant to modern database technology and will remain so for the foreseeable future see why and how the SQL standar Learn effective and scalable database design techniques in a SQL Server environment. 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 the latest implementation features in SQL Server Takes you from conceptual design to an effective, physical implementation What youll learn How to develop c 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. In "Database in Depth," Date writes for experienced database practitioners or other database professionals who "are honest enough to admit they don't understand the theory underlying their own field as well as they might, or should.
To underscore this point, Date dispels many commonly held misconceptions about the relational model, explaining that: -The term "relational" has nothing to do with relating two tables on a common set of columns. They're not flat. They're not two-dimensional. Don't let the term "table" mislead you. An author of numerous books, Date is particularly well known for "An Introduction to Database Systems" Addison-Wesley , the standard text in the field, now in its eighth edition.
Date explains upfront that very little of the technical substance of "Database in Depth" is new: "I've said most of it before, in previous books and publications--I've just looked around and seen that it needs to be said again.
But I've tried to say it differently this time: the sequence is different, the development is different, the style and treatment are different, and the intended audience is different. First, "Database in Depth" is an advanced text, explains Date. The book is also meant for self-study and includes exercises to help reinforce the material. Moreover, as he adds, "My own understanding of the relational model has evolved over the years, and continues to do so.
This book represents my very latest thinking on the subject; thus, if discrepancies exist between this book and previous texts and there are a few , the treatment in this book should be taken as superseding those in earlier ones.
0コメント