Database systems : a practical approach to design, implementation, and management
著者
書誌事項
Database systems : a practical approach to design, implementation, and management
（International computer science series）
Addison-Wesley, c1999
2nd ed., rev. and updated by / Thomas M. Connolly, Carolyn E. Begg
大学図書館所蔵 件 / 全10件
-
該当する所蔵館はありません
- すべての絞り込み条件を解除する
注記
Begg's name appears first on the earlier edition
Includes bibliographical references (p. 1054-1067) and index
内容説明・目次
内容説明
The Second Edition of this popular new text is particularly relevant for design-oriented database courses. New coverage brings it right up to date with the inclusion of new material on distributed databases, object-oriented databases, data mining, data warehouses, multimedia databases and the Internet. The practical emphasis of the book is maintained, providing a strong foundation in good design practice so that the student can master the methodology in an accessible, step-by-step fashion. The methodology is then applied to a worked example so that the student learns to design and build applications using a leading commercial database system.
目次
Part One - Background. 1. Introduction to Databases. 1.1 Introduction. 1.2 Traditional File-Based Systems. 1.3 Database Approach. 1.4 Roles in the Database Environment. 1.5 The history of Database Management Systems. 1.6 Advantages and Disadvantages of Database Management Systems. 1.7 The DreamHome Case Study. 2. Database Environment. 2.1 The Three-Level ANSI-SPARC Architecture. 2.2 Database Languages. 2.3 Data Models and Conceptual Modeling. 2.4 Functions of a DBMS. 2.5 Components of a DBMS. 2.6 Multi-User DBMS Architectures. 2.6.1 Teleprocessing. 2.7 System Catalogs. 3. The Relational Model. 3.1 Brief History of the Relational Model. 3.2 Terminology. 3.3 Relational Integrity. 3.4 Relational Languages. 3.5 Views. 3.6 When is a DBMS Relational? 4. Database Planning, Design, and Administration. 4.1 Overview of the Information Systems Lifecycle. 4.2 The Database Application Lifecycle. 4.3 Overview of Database Design. 4.4 Application Design. 4.5 CASE Tools. 4.6 DBMS Selection. 4.7 Data Administration and Database Administration. Part Two - Methodology. 5. Entity - Relationship Modeling. 5.1 The Concepts of the Entity-Relationship Model. 5.2 Structural Constraints. 5.3 The Enhanced Entity-Relationship Model. 5.5 The Manager's View of the DreamHome Case Study - Building and ERR Model. 6. Normalization. 6.1 The Purpose of Normalization. 6.2 Data Redundancy and Update Anomalies. 6.3 Functional Dependencies. 6.4 The Process of Normalization. 6.5 First Normal Form (1NF). 6.6 Second Normal Form (2NF). 6.7 Third Normal Form (3NF). 6.8 Boyce-Codd Normal Form (BCNF). 6.9 Review of Normalization (1NF to BCNF). 6.10 Fourth Normal Form (4NF). 6.11 Fifth Normal Form (5NF). 7. Methodology - Conceptual Database Design. 8. Methodology - Logical Database Design for Relational Model. 9. Methodology - Physical Database Design for Relational Databases. 10. Conceptual Database Design Methodology - Worked Example. 10.1 The Supervisor's Requirements Specification. 10.2 Using the Conceptual Database Design Methodology. 11. Logical Database Design Methodology - Worked Example. 12. Physical Database Design Methodology - Worked Example. Part Three - Database Languages. 13. SQL. 13.1 Introduction to SQL. 13.2 Writing SQL Commands. 13.3 Data Manipulation. 13.4 Data Definition. 14. Advanced SQL. 14.1 Views. 14.2 Integrity Enhancement Feature (IEF). 14.3 Advanced Data Definition. 14.4 Embedded SQL. 14.6 Dynamic SQL. 14.7 SQL-92 and Beyond. 14.8 The Open Database Connectivity (ODBC) Standard. 15. Query-By-Example (QBE). 15.1 Introduction to Microsoft Access Queries. 15.2 Building Select Queries Using QBE. 15.3 Using Advanced Queries. 15.4 Changing the Content of Tables using Action Queries. Part Four - Selected Database Issues. 16. Security. 16.1 Database Security. 16.2 Countermeasures - Computer-Based Controls. 16.3 Countermeasures - Non-Computer-Based Controls. 16.4 PC Security. 16.5 DBMSs and Web Security. 16.6 Security in Statistical Databases. 16.7 Risk Analysis. 16.8 Data Protection and Privacy Laws. 17. Transaction Management. 17.1 Transaction Support. 17.2 Concurrency Control. 17.3 Database Recovery. 17.4 Advanced Transaction Models. 18. Query Processing. 18.1 Overview of Query Processing. 18.2 Query Decomposition. 18.3 Heuristical Approach to Query Optimization. 18.4 Cost Estimation for Relational Algebra Operations. 18.5 Pipelining. Part Five - Current Trends. 19. Distributed DBMSs - Concepts and Design. 19.1 Introduction. 19.2 Overview of Networking. 19.3 Functions and Architecture of a DDBMS. 19.4 Distributed Relational Database Design. 19.5 Transparencies in a DDBMS. 19.6 Date's Twelve Rules for a DDBMS. 20. Distributed DBMSs - Advanced Concepts. 20.1 Distributed Transaction Management. 20.2 Distributed Concurrency Control. 20.3 Distributed Deadlock Management. 20.4 Distributed Database Recovery. 20.5 The X/Open Distributed Transaction Processing (DTP) Model. 20.6 Replication Servers. 20.7 Distributed Query Optimization. 21. Introduction to Object DBMSs. 21.1 Advanced Database Applications. 21.2 Weaknesses of Relational DBMSs. 21.4 Next Generation Database Systems. 22. Object-Oriented DBMSs. 22.1 Introduction to Object-Oriented Data Models and DBMSs. 22.2 OODBMS Perspectives. 22.3 Persistence. 22.4 Issues in OODBMSs. 22.5 The Object-Oriented Database System Manifesto. 22.6 Advantages and Disadvantages of OODBMSs. 22.7 Object-Oriented Database Design. 22.8 Object Database Standard (ODMG 2.0, 1997). 23. Object-Relational DBMSs. 23.1 Introduction to Object-Relational Database Systems. 23.2 The Third-Generation Database Manifestos. 23.3 Early ORDBMSs. 23.4 SQL.3. 23.5 Query Processing and Optimization. 23.6 Comparison of ORDBMS and OODBMS. Part Six - Future Trends. 24. Web Technology and DBMSs. 24.1 Introduction to the Internet and Web. 24.2 The Web as a Database Application Platform. 24.3 Common Gateway Interface (CGI). 24.4 Server-Side Includes. 24.5 HTTP Cookies. 24.6 Extending the Web Server. 24.7 Java. 24.8 Scripting Languages. 24.9 The Microsoft Access Platform. 24.10 ORACLE's Network Computing Architecture (NCA). 24.11 Security. 24.12 HTTP/1.1 and XML. 25. Data Warehousing. 25.1 Introduction to Data Warehousing. 25.2 Data Warehouse Architecture. 25.3 Data Warehouse Information Flows. 25.4 Data Warehousing Tools and Technologies. 25.5 Data Marts. 25.6 Designing Data Warehouses. 26. OLAP and Data Mining. 26.1 Online Analytical Processing (OLAP). 26.2 Data Mining. Appendices. A. The Wellmeadows Hospital Case Study. B. File Organization and Storage Structures. C. Network Data Model. D. Hierarchical Data Model. E. Comparison of Network, Hierarchical, and Relational Database Systems. F. Summary of the Database Design Methodology for Relational Databases. G. Example Web Scripts.
「Nielsen BookData」 より
