Cart
Free Shipping in Australia
Proud to be B-Corp

Databases in Theory and Practice J. A. Jones

Databases in Theory and Practice By J. A. Jones

Databases in Theory and Practice by J. A. Jones


$17.19
Condition - Well Read
Only 1 left

Summary

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.

Databases in Theory and Practice Summary

Databases in Theory and Practice by J. A. Jones

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.

Table of Contents

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.

Additional information

GOR002791624
9781850322887
1850322880
Databases in Theory and Practice by J. A. Jones
Used - Well Read
Paperback
Cengage Learning EMEA
1997-01-30
256
N/A
Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
This is a used book. We do our best to provide good quality books for you to read, but there is no escaping the fact that it has been owned and read by someone else previously. Therefore it will show signs of wear and may be an ex library book

Customer Reviews - Databases in Theory and Practice