Database systems : a practical approach to design, implementation, and management / Thomas M. Connolly, Carolyn E. Begg.
Language: English Publisher: Boston, Mass. London : Addison-Wesley, 2009Edition: 5. edDescription: xlviii, 1243 s. ill. 24 cmISBN:- 9780321523068
- 0321523067
- 005.74 22
- Pubdh
Item type | Current library | Shelving location | Call number | Status | Date due | Barcode | Item holds | |
---|---|---|---|---|---|---|---|---|
Book | Biblioteket HKR | Biblioteket | 005 Connolly | Available | 11156000171299 |
Enhanced descriptions from Syndetics:
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 and XML. Business 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.
Includes Internet access
Previous ed.: 2005
Table of contents provided by Syndetics
- I Background
- 1 Introduction to Databases
- 2 Database Environment
- 3 Database Architectures and the Web
- II The Relational Model and Languages
- 4 The Relational model
- 5 Relational Algebra and Relational Calculus
- 6 SQL: Data Manipulation
- 7 SQL: Data Definition
- 8 Query-By-Example (QBE)
- III Database Analysis and Design
- 9 Database System Lifecycle
- 10 Database Analysis and the DreamHome: Case Study
- 11 Entity-Relationship Modeling
- 12 Enhanced Entity-Relationship Modeling
- 13 Normalization
- 14 Advanced Normalization
- IV Methodology
- 15 Methodology-Conceptual Database Design
- 16 Methodology-Logical Database Design for Relational Model
- 17 Methodology-Physical Database Design for Relational Databases
- 18 Methodology-Monitoring and Tuning the Operational System
- V Selected Database Issues
- 19 Security and Administration
- 20 Professional, Legal, and Ethical Issues
- 21 Transaction Management
- 22 Query Processing
- VI Distributed DBMSs and Replication
- 23 Distributed DBMSs-Concepts and Design
- 24 Distributed DBMSs-Advanced Concepts
- 25 Replication and Mobile Databases
- VII Object DBMSs
- 26 Object-Oriented DBMSs-Concepts and Design
- 27 Object-Oriented DBMSs-Standards and Languages
- 28 Object-Relational DBMSs
- VIII Web and DBMSs
- 29 Web Technology and DBMSs
- 30 Semistructured Data and XML
- IX Business Intelligence Technologies
- 31 Data Warehousing Concepts
- 32 Data Warehousing Design
- 33 OLAP
- 34 Data Mining
- Appendices
- A Users'
- B Other Case Studies
- C Alternative Data Modeling Notations
- D Summary of the Database Design Methodology for Relational Databases
- E Introduction to Pyrrho-A Liteweight RDBMS
- Web Appendices
- F File Organization and Storage Structures
- G When Is a DBMS Relational?
- H Commercial DBMSs: Access and Oracle
- I Programmatic SQL
- J Estimating Disk Space Requirements
- K Introduction to Object-Orientation
- L Example Web Scripts