Designed for students on more practically-oriented computing CIS/MIS courses, this text adopts a pragmatic, technical approach to the subject. The authors set about dealing with the underlying theory of databases in an accessible, non-mathematical manner. Covering all aspects of the subject, the book introduces the concepts from a problem-solving point of view with numerous practical examples and problems. A case study of a banking system highlights the principles and techniques involved and runs throughout the text. Focusing on the relational model, the book also covers more recent technologies, including advanced data models (e.g. enhanced entity relationship model; extended relational; functional; semantic; object) and object-oriented databases.
Auflage
Sprache
Verlagsort
Zielgruppe
Für höhere Schule und Studium
Editions-Typ
Maße
ISBN-13
978-1-85032-288-7 (9781850322887)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Klassifikation
Model to submodel Mapping; Logical Model to Physical model Mapping; Database Analysis vs Systems Analysis; Traditional Systems Analysis; Creation of the Conceptual Model; An Entity; An Attribute; A Relationship; Data Model Diagrams; Functional Analysis; Operations and Events; Problems with Data Analysis; A Solution; Sources for Analysis; Normalization; Unique Identifier; Functional Dependence; First Normal Form; Full Functional dependence; Second Normal Form; Transitive dependence; Third Normal Form; An Intersection Entity; A Determinant; A Strong Third Normal Form; Functional Analysis in Practice; Creation of a Consolidated Conceptual Model; The Additive Approach; The Incremental Approach; Problems with Consolidation; Logical Database Design; Design Objectives; Efficiency vs Privacy; Efficiency vs Logical Data Independence; Problems with the Operating System; Database Design Methodology; Collapse and Fragmentation; CODASYL Relationships; Program Design; Efficiency; Physical Database Design; Data-item Implementation; Checking Functions; Direct Access Methods; Calc Keys; Hashing Functions; Indexing; Other Access Methods; Access-type Decisions; relationship Implementations; Linked Lists; Indexes; Aggregrates; Device Model; Physical Placement; Loading the Database; Load Programs; Load Versions of the Database; Integrity and Recovery; Data Redundancy and Duplication; Integrity Constraints; Concurrency; Error Handling; Physical data Checking; Dumps and Journal Files; Database Versions and Time Stamps; Traditional Views of Privacy; Levels of Privacy; Database Approaches to Privacy; Recovery; Transactions and Checkpoints; Journal Files; Restart Recovery; Program Rollback; Database Rollback; Rollforward; rebuilds; Other Recovery Facilities; Backup Facilities; Time Stamps Revisited; Other Database Facilities; Changing the Database; Restructure; Unload and Load; Change of Record Layouts; Reorganization; Tuning the Database; Program Statistics; Buffer Management; Readaheads; Memory Management; Summary of run-time Statistics; Database Analyser; Data Dictionary.
