The Morgan Kaufmann Series in Data Management Systems
1 primary work • 3 total works
Book 3
This work teaches database practitioners the principles of good relational database design. It discusses tradeoffs between theory and practice, for example when it's alright to violate a principle of good design in order to improve performance. The book also shows readers how to construct the SQL statements needed to install well-designed relational databases, and discusses other performance related database design issues, such as indexes and clustering.
Written with both beginner and intermediate database developers in mind, this clear, concise guide teaches readers about the relationships between the distribution of data in a database and the way in which queries of various types are processed. SQL (structured query language) is a complete data manipulation language for relational databases that allows users to modify database structure (tables, views, and indexes), as well as modify and retrieve data. The book teaches not only SQL syntax but also explains the proper structure of SQL queries and how a query affects the SQL processor and system performance.
Object-oriented database management systems are growing in popularity, thanks to changing corporate needs and the emergence of several viable products. However, while most database professionals have had at least some exposure to the basic concepts of object-oriented programming, information relating specifically to object-oriented databases has remained hard to come by. "Object-Oriented Database Design Clearly Explained" remedies this, providing developers and administrators with a ground-up understanding of the logical design of object-oriented databases. Focusing on the principles of the object paradigm while noting the particularities of specific products, this book will give readers the know-how required to produce effective designs in any environment.This title equips the reader with a sound understanding of the object paradigm and all key concepts, illustrating its points with three in-depth case. It presents product and platform-neutral guidelines and advice, teaching readers the underlying object-oriented design principles they will need to apply regardless of the specific technology adopted.
It details today's OODBMS standards and the variety of approaches taken by current products. It serves as a companion volume to "Relational Database Design Clearly Explained" providing parallel examples that help to clarify relational and object-oriented data models.
It details today's OODBMS standards and the variety of approaches taken by current products. It serves as a companion volume to "Relational Database Design Clearly Explained" providing parallel examples that help to clarify relational and object-oriented data models.