Publication Date: March 6, 2009 | ISBN-10: 0321523067 ISBN-13 :978-0,321,523,068 | Version: 5
Database design method, this best-selling text describes a concise yet comprehensive manner, providing technical and non-technical readers can use the of database theory behind. Relational database management system is a simple, step-by-step instructions with the use of the concept of three distinct phases, logical and physical database design a realistic example.
Background: database, database environment, database architecture, and network. Relationship of the relational model and language model, relational algebra and relational calculus, SQL data, SQL data definition; query by example (QBE). Database analysis and design: database system life cycle; database analysis and the DreamHome the case study; entity relationship modeling, entity-relationship modeling enhanced; standardization; advanced normalization. Method: the method of database conceptual design method, the method of logical database design relational model, relational databases, physical database design methods to monitor and optimize the operation mechanism. Database issues: professional, legal and ethical issues of security and management, transaction management, query processing. The Distributed DBMS and copy: the concept of distributed database management system and the design of distributed DBMS Advanced Concepts copying and moving databases. Object database management system: the concept and design of object-oriented database management systems, object-oriented database management system standards and language, object – relational DBMS. Web and database management systems: Web technology and DBMS, semi-structured data and XML. Business intelligence technology: the concept of the data warehouse; design of the data warehouse, OLAP, data mining. Appendix: User requirements specification case study DreamHome; Other case studies; alternate data modeling notation; summary of the method of the database design of the relational database; the Hira-A Liteweight the RDBMS. Network attachments: file organization and storage structures; When a DBMS relations; commercial database management systems: Access and Oracle SQL programmatically, it is estimated that the demand for disk space; example of object-oriented Web scripting.
This book is ideal for readers interested in database management or database design.
