Database Systems: A Practical Approach to Design, Implementation and Management
This best-selling text introduces the theory behind databases in a concise yet comprehensive manner, providing database design methodology that can be used by both technical and non-technical readers. The methodology for relational Database Management Systems is presented in simple, step-by-step instructions in conjunction with a realistic worked example using three explicit phases—conceptual, logical, and physical database design.\ \ Background: Introduction to Databases; Database...
Search in google:
This best-selling text introduces the theory behind databases in a concise yet comprehensive manner, providing database design methodology that can be used by both technical and non-technical readers. The methodology for relational Database Management Systems is presented in simple, step-by-step instructions in conjunction with a realistic worked example using three explicit phases—conceptual, logical, and physical database design. Background: Introduction to Databases; Database Environment; Database Architectures and the Web. The Relational Model and Languages: The Relational model; Relational Algebra and Relational Calculus; SQL: Data Manipulation; SQL: Data Definition; Query-By-Example (QBE). Database Analysis and Design: Database System Lifecycle; Database Analysis and the DreamHome Case Study; Entity–Relationship Modeling; Enhanced Entity–Relationship Modeling; Normalization; Advanced Normalization. Methodology: Methodology—Conceptual Database Design; Methodology—Logical Database Design for Relational Model; Methodology—Physical Database Design for Relational Databases; Methodology—Monitoring and Tuning the Operational System. Selected Database Issues: Security and Administration; Professional, Legal, and Ethical Issues; Transaction Management; Query Processing. Distributed DBMSs and Replication: Distributed DBMSs—Concepts and Design; Distributed DBMSs—Advanced Concepts; Replication and Mobile Databases. Object DBMSs: Object-Oriented DBMSs—Concepts and Design; Object-Oriented DBMSs—Standards and Languages; Object-Relational DBMSs. Web and DBMSs: Web Technology and DBMSs; Semistructured Data andBusiness Intelligence Technologies: Data Warehousing Concepts; Data Warehousing Design; OLAP; Data Mining. Appendices: Users' Requirements Specification for DreamHome Case Study; Other Case Studies; Alternative Data Modeling Notations; Summary of the Database Design Methodology for Relational Databases; Introduction to Pyrrho—A Liteweight RDBMS. Web Appendices: File Organization and Storage Structures; When Is a DBMS Relational?; Commercial DBMSs: Access and Oracle; Programmatic SQL; Estimating Disk Space Requirements; Introduction to Object-Orientation; Example Web Scripts. This book is ideal for readers interested in database management or database design.
Ch. 1Introduction to databases3Ch. 2Database environment33Ch. 3The relational model69Ch. 4Relational algebra and relational calculus88Ch. 5SQL : data manipulation112Ch. 6SQL : data definition157Ch. 7Query-by-example198Ch. 8Commercial RDBMSs : Office Access and Oracle225Ch. 9Database planning, design, and administration281Ch. 10Fact-finding techniques314Ch. 11Entity-relationship modeling342Ch. 12Enhanced entity-relationship modeling371Ch. 13Normalization387Ch. 14Advanced normalization415Ch. 15Methodology - conceptual database design437Ch. 16Methodology - logical database design for the relational model461Ch. 17Methodology - physical database design for relational databases494Ch. 18Methodology - monitoring and tuning the operational system519Ch. 19Security541Ch. 20Transaction management572Ch. 21Query processing630Ch. 22Distributed DBMSs - concepts and design687Ch. 23Distributed DBMSs - advanced concepts734Ch. 24Replication and mobile databases780Ch. 25Introduction to object DBMSs803Ch. 26Object-oriented DBMSs - concepts847Ch. 27Object-oriented DBMSs - standards and systems888Ch. 28Object-relational DBMSs935Ch. 29Web technology and DBMSs993Ch. 30Semistructured data and XML1065Ch. 31Data warehousing concepts1149Ch. 32Data warehousing design1181Ch. 33OLAP1204Ch. 34Data mining1232
