Name: Database Systems By Thomas Connolly
SKU: 9780201342871
Price: 5.24 USD
Availability: InStock

Database Systems Summary

Database Systems: A Practical Approach to Design, Implementation and Management by Thomas Connolly

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.

Additional information

Sku

CIN0201342871VG

ISBN 13

9780201342871

ISBN 10

0201342871

Title

Database Systems: A Practical Approach to Design, Implementation and Management by Thomas Connolly

Author

Thomas Connolly

Series

International Computer Science Series

Condition

Used - Very Good

Binding type

Paperback

Publisher

Pearson Education (US)

Year published

1998-09-14

Number of pages

1136

Prizes

N/A

Cover note

Book picture is for illustrative purposes only, actual binding, cover or edition may vary.

Note

This is a used book - there is no escaping the fact it has been read by someone else and it will show signs of wear and previous use. Overall we expect it to be in very good condition, but if you are not entirely satisfied please get in touch with us

Database Systems Thomas Connolly

Database Systems by Thomas Connolly

Summary

Faster Shipping

Database Systems Summary

Database Systems: A Practical Approach to Design, Implementation and Management by Thomas Connolly

Table of Contents

Additional information

Customer Reviews - Database Systems