Christopher J. Date ist ein unabhängiger Autor, Dozent, Forscher und Berater, der sich auf die Theorie relationaler Datenbanken spezialisiert hat. Seine Arbeit befasst sich tiefgehend mit den grundlegenden Prinzipien von Datenbanksystemen. Date legt Wert auf sowohl die theoretischen Grundlagen als auch die praktische Anwendung relationaler Datenbankkonzepte. Seine Beiträge prägen maßgeblich das Verständnis und die Implementierung von Datenbanktechnologien.
In this practical book, C.J. Date provides a model for type inheritance that is not programming-language-specific. This model provides programmers who specialize in one language the broader background to understand and implement types in other languages. Exercises are included with most chapters.
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 that theory into practice. In this book, Chris Date explains relational theory in depth, and demonstrates through numerous examples and exercises how you can apply it to your use of SQL.
This book shows you what a real relational product would be like, and how and why it would be so much better than what's currently available. Most books try to use SQL as a vehicle for teaching relational theory, but this book deliberately takes the opposite approach.
Because databases often stay in production for decades, careful design is critical to making the database serve the needs of your users over years, and to avoid subtle errors or performance problems. In this book, CJ Date, a leading exponent of relational databases, lays out the principles of good database design.
Vermeiden Sie Missverständnisse, die Probleme für Design, Programmierung und Nutzung von Datenbanksystemen mit sich bringen können. Ob Sie nun mit Oracle, DB2, SQL Server, MySQL oder PostgreSQL arbeiten: Das Fachwörterbuch Relationale Datenbanken - kurz & gut verhindert Verwirrungen um die genaue Bedeutung von Fachbegriffen (wie z. B. Attribut, 3NF, Eins-zu-Viele-Entsprechung, Prädikat, Wiederholungsgruppe oder Join-Abhängigkeit) und hilft Ihnen, den Erfolg Ihrer Datenbankprojekte sicherzustellen. Diese sorgfältig auf Klarheit, Genauigkeit und Vollständigkeit überprüfte Kurzreferenz erklärt mit vielen Beispielen mehr als 600 Begriffe zu Themen und Konzepten des relationalen Datenmodells. Dieses Wörterbuch ist insofern einmalig, als DBAs, Designer und Implementierer von DBMS, Anwendungsentwickler sowie Informatikdozenten und -studenten hier in einer einzigen, kompakten Quelle die genauen Definitionen nachschlagen können, die sie für ihre tägliche Arbeit benötigen. Nirgendwo sonst sind diese Informationen so einfach verfügbar. Wenn Sie relationale Datenbanken einsetzen, führt an dieser praktischen Taschenreferenz kein Weg vorbei.
This eighth edition offers a thorough introduction to database systems, covering foundational technology and future developments, along with insights into current trends in the field.
A Refernce for the Thinking Practitioner
Databas(e)ics clearly explains the key concepts users and database professionals need to understand in order to build well-designed databases that answer business questions accurately and efficiently. Fabian Pascal, one of the industry's leading experts, identifies ten critical, recurring issues that both database users and vendors often fail to address appropriately. Pascal demonstrates why understanding these fundamentals is so important, providing detailed examples and solutions designed to help users escape the key pitfalls of database development. KEY TOPICS: Among the topics covered: unstructured data and complex data types; business rules and enforcing data integrity; keys; duplicates; normalization; entity subtypes and supertypes; data hierarchies and recursive queries; redundancy; quota queries; and how to handle missing information. Along the way, Pascal offers no-holds-barred assessments of how well current SQL implementations and commercial products address each issue. Databas(e)ics , in short, is a complete guide to building databases right the first time, so they don't have to be rebuilt later. MARKET: For all DBAs, developers, managers, and end-users that need to understand the best ways to design and implement database systems. Databasics clearly explains the key concepts users and database professionals need to understand in order to build well-designed databases that answer business questions accurately and efficiently. Fabian Pascal, one of the industry's leading experts, identifies ten critical, recurring issues that both database users and vendors often fail to address appropriately. Pascal demonstrates why understanding these fundamentals is so important, providing detailed examples and solutions designed to help users escape the key pitfalls of database development. Among the topics covered: unstructured data and complex data types; business rules and enforcing data integrity; keys; duplicates; normalization; entity subtypes and supertypes; data hierarchies and recursive queries; redundancy; quota queries; and how to handle missing information. Along the way, Pascal offers no-holds-barred assessments of how well current SQL implementations and commercial products address each issue. Databasics , in short, is a complete guide to building databases right the first time, so they don't have to be rebuilt later. For all DBAs, developers, managers, and end-users that need to understand the best ways to design and implement database systems.
The foundational concepts for the next generation of business logic servers based on predicate logic are laid out, promising to revolutionize application development. A new technology known as business rules is set to dramatically change how we build computer applications. This approach allows for declarative application development, enabling developers to state WHAT needs to be done rather than HOW to do it. The benefits include ease and speed of initial development, simplified maintenance, platform independence, increased productivity, and enhanced business adaptability. This concise introduction is designed for both managers and technical professionals, divided into two parts. The first part provides a broad overview of business rules, while the second revisits these ideas within the context of relational technology. Key topics include presentation rules, database and application rules, building on the data model, potential advantages and disadvantages, and a fresh perspective on relational fundamentals. Overall, this resource offers a solid grounding in a transformative technology that is poised to reshape business practices in the IT sector.
A User's Guide to the Standard Database Language SQL
The previous edition of this book established itself as the most complete and understandable treatment of the SQL standard generally available. Many changes have occurred in the SQL standards world since that edition was published, a major new component, the Call-Level Interface (SQL/CLI), was added in 1995. Another major new component, the Persistent Stored Modules feature (SQL/PSM), is nearing completion and is due to be added to the standard in late 1996 or early 1997. The original 1992 standard itself has been significantly changed and corrected through the publication of two extensive Technical Corrigenda, one in 1994 and one in 1996.All of these changes are reflected in this Fourth Edition. Earlier editions of this book established a tradition of careful, clear, and accurate explanation of complex technical material. This new edition continues that tradition.
