Fundamentals of Database Systems / Edition 4

Fundamentals of Database Systems / Edition 4

by Ramez Elmasri, Shamkant B. Navathe, Shamkant Navathe, Shamkadant B. Navathe
     
 

View All Available Formats & Editions

ISBN-10: 0321122267

ISBN-13: 9780321122261

Pub. Date: 07/25/2003

Publisher: Addison Wesley

For database systems courses in Computer Science

This book introduces the fundamental concepts necessary for designing, using, and implementing database systems and database applications. Our presentation stresses the fundamentals of database modeling and design, the languages and models provided by the database management systems, and database system

Overview

For database systems courses in Computer Science

This book introduces the fundamental concepts necessary for designing, using, and implementing database systems and database applications. Our presentation stresses the fundamentals of database modeling and design, the languages and models provided by the database management systems, and database system implementation techniques.

The book is meant to be used as a textbook for a one- or two-semester course in database systems at the junior, senior, or graduate level, and as a reference book. The goal is to provide an in-depth and up-to-date presentation of the most important aspects of database systems and applications, and related technologies. It is assumed that readers are familiar with elementary programming and data-structuring concepts and that they have had some exposure to the basics of computer organization.

Product Details

ISBN-13:
9780321122261
Publisher:
Addison Wesley
Publication date:
07/25/2003
Edition description:
Fourth Edition
Pages:
1030
Product dimensions:
7.66(w) x 9.40(h) x 1.73(d)

Table of Contents

I. INTRODUCTION AND CONCEPTUAL MODELING.

1. Databases and Database Users.
2. Database System Concepts and Architecture.
3. Data Modeling Using the Entity-Relationship Model.
4. Enhanced Entity-Relationship and UML Modeling.

II. RELATIONAL MODEL: CONCEPTS, CONSTRAINTS, LANGUAGES, DESIGN, AND PROGRAMMING.

5. The Relational Data Model and Relational Database Constraints.
6. Relational Algebra and Relational Calculus.
7. Relational Database Design by ER- and EER-to-Relational Mapping.
8. SQL99-Schema Definition, Constraints, and Queries.
9. More SQL-Assertions, Views, and Programming Techniques.

III. DATABASE DESIGN THEORY AND METHODOLOGY.

10. Functional Dependencies and Normalization for Relational Databases.
11. Relational Database Design Algorithms and Further Dependencies.
12. Practical Database Design Methodology Using UML.

IV. DATA STORAGE, INDEXING, QUERY PROCESSING, AND PHYSICAL DESIGN.

13. Disk Organization, Basic File Structures, and Hashing.
14. Indexing Structures for Files.
15. Algorithms for Query Processing and Optimization.
16. Physical Database Design and Tuning.

V. TRANSACTION PROCESSING CONCEPTS.

17. Introduction to Transaction Processing Concepts and Theory.
18. Concurrency Control Techniques.
19. Database Recovery Techniques.

VI. OBJECT AND OBJECT-RELATIONAL DATABASES.

20. Object Database Concepts.
21. The ODMG Standard for Object Databases.
22. Object-Relational Systems and SQL3.

VII. FURTHER TOPICS.

23. Database Security, Authorization, and Encryption.
24. Enhanced Data Models for Advanced Applications.
25. Distributed Databases and Client-Server Architectures.

VIII. EMERGING TECHNOLOGIES.

26. Internet Databases and XML.
27. Data Warehousing and Data Mining Concepts.
28. Emerging Database Technologies and Applications.
Appendix A. Alternative Diagrammatic Notations for ER models.
Appendix B. Database Design and Application Implementation Case Study.
(New appendix on the Web including a detailed database design case study).
Appendix C. Parameters of Disks (old Appendix B).
Appendix D. The QBE Language (old section 9.5).
Appendix E. Hierarchical Data Model (old Appendix C dropped - moved to Web).
Appendix F. Network Data Model (old Appendix D dropped - moved to Web).
Bibliographic References.
Index.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >