Syndetics cover image
Image from Syndetics

Database systems : a practical approach to design, implementation, and management / Thomas M. Connolly, Carolyn E. Begg.

By: Contributor(s): Language: English Publisher: Boston, Mass. London : Addison-Wesley, 2009Edition: 5. edDescription: xlviii, 1243 s. ill. 24 cmISBN:
  • 9780321523068
  • 0321523067
Subject(s): DDC classification:
  • 005.74 22
Other classification:
  • Pubdh
Holdings
Item type Current library Shelving location Call number Status Date due Barcode Item holds
Book Biblioteket HKR Biblioteket 005 Connolly Available 11156000171299
Total holds: 0

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