MTU Cork Library Catalogue

Syndetics cover image
Image from Syndetics

An introduction to database systems / C.J. Date.

By: Date, C. J.
Material type: materialTypeLabelBookSeries: Addison-Wesley systems programming series.Publisher: Reading, Mass. : Addison-Wesley, 1995Edition: 6th ed.Description: xxiii, 839 p. : ill. ; 24 cm. + hbk.ISBN: 020154329X.Subject(s): Database managementDDC classification: 005.74
Contents:
Part I: Basic Concepts -- An Overview of Database Management -- An Architecture for a Database System -- An introduction to Relational Databases -- Part II: The Relational Model -- Relational Data Objects: Domains and Relations -- Relational Data Integrity: Candidate keys and related matters -- Relational Operators I: Relational Algebra -- Relational Operators II: Relational Calculus -- The SQL Language -- Part III: Database Design -- Functional Dependencies -- Further Normalization I: INF, 2NF, 3NF, BCNF -- Further Normalization II: Higher Normal Forms -- The Entity/Relationship Model -- Part IV: Data Protection -- Recovery -- Concurrency -- Security -- Integrity -- Part V: Further Topics -- Views -- Optimization -- Domains, Relations and Data Types -- Missing Information -- Distributed Database and Client/Server Systems -- Part VI: Object-Oriented Systems -- Basic OO Concepts -- A Cradle-to-Grave Example -- Additional OO Concepts -- Toward an OO/Relational Reapproachment.
Holdings
Item type Current library Call number Copy number Status Date due Barcode Item holds
General Lending MTU Bishopstown Library Store Item 005.74 (Browse shelf(Opens below)) 1 Available 00156223
General Lending MTU Bishopstown Library Lending 005.74 (Browse shelf(Opens below)) 1 Available 00014154
General Lending MTU Bishopstown Library Store Item 005.74 (Browse shelf(Opens below)) 1 Available 00014370
Total holds: 0

Enhanced descriptions from Syndetics:

A comprehensive, up-to-date treatment of database technology. This edition features: updated coverage of object-oriented database systems, including a proposal for rapprochement between OO and relational technologies; expanded treatment of distributed databases, including client/server architectures, with an emphasis on database design issues; a comprehensive introduction to all aspects of the relational model - the basis of modern database technology; and new chapters on functional dependencies, views, domains and missing information.

Includes bibliographical references and index.

Part I: Basic Concepts -- An Overview of Database Management -- An Architecture for a Database System -- An introduction to Relational Databases -- Part II: The Relational Model -- Relational Data Objects: Domains and Relations -- Relational Data Integrity: Candidate keys and related matters -- Relational Operators I: Relational Algebra -- Relational Operators II: Relational Calculus -- The SQL Language -- Part III: Database Design -- Functional Dependencies -- Further Normalization I: INF, 2NF, 3NF, BCNF -- Further Normalization II: Higher Normal Forms -- The Entity/Relationship Model -- Part IV: Data Protection -- Recovery -- Concurrency -- Security -- Integrity -- Part V: Further Topics -- Views -- Optimization -- Domains, Relations and Data Types -- Missing Information -- Distributed Database and Client/Server Systems -- Part VI: Object-Oriented Systems -- Basic OO Concepts -- A Cradle-to-Grave Example -- Additional OO Concepts -- Toward an OO/Relational Reapproachment.

Table of contents provided by Syndetics

  • (All chapters begin with an Introduction end with a Summary, Exercises, and Reference and Bibliography)
  • I Preliminaries
  • 1 An Overview of Database Management
  • What is a database system?
  • What is a database?
  • Why database?
  • Data independence
  • Relational systems and others
  • 2 Database System Architecture
  • The three levels of the architecture
  • The external level
  • The conceptual level
  • The internal level
  • Mappings
  • The database administrator
  • The database management system
  • Data communications
  • Client/server architecture
  • Utilities
  • Distributed processing
  • 3 An Introduction to Relational Databases
  • An informal look at the relational model
  • Relations and relvars
  • What relations mean
  • Optimization
  • The catalog
  • Base relvars and views
  • Transactions
  • The suppliers-and-parts database
  • 4 An Introduction to SQL
  • Overview
  • The catalog
  • Views
  • Transactions
  • Embedded SQL
  • Dynamic SQL and SQL/CLI
  • SQL is not perfect
  • II The Relational Model
  • 5 Types
  • Values v Variables
  • Types v Representations
  • Type Definition
  • Operators
  • Type generators
  • SQL facilities
  • 6 Relations
  • Tuples
  • Relation types
  • Relation values
  • Relation variables
  • SQL facilities
  • 7 Relational Algebra
  • Closure revisited
  • The original algebra: Syntax
  • The original algebra: Semantics
  • Examples
  • What is the algebra for?
  • Further points
  • Additional operators
  • Grouping and ungrouping
  • 8 Relational Calculus
  • Tuple calculus
  • Examples
  • Calculus vs. algebra
  • Computational capabilities
  • SQL facilities
  • Domain calculus
  • Query-By-Example
  • 9 Integrity
  • A closer look
  • Predicates and propositions
  • Relvar predicates and database predicates
  • Checking the constraints
  • Internal v external constraints
  • Correctness v consistency
  • Integrity and views
  • A constraint classification scheme
  • Keys
  • Triggers (a digression)
  • SQL facilities
  • 10 Views
  • What are views for?
  • View retrievals
  • View updates
  • Snapshots (a digression)
  • SQL facilities
  • III Database Design
  • 11 Functional Dependencies
  • Basic definitions
  • Trivial and nontrivial dependencies
  • Closure of a set of dependencies
  • Closure of a set of attributes
  • Irreducible sets of dependencies
  • 12 Further Normalization I: 1NF, 2NF, 3NF, BCNF
  • Nonloss decomposition and functional dependencies
  • First, second, and third normal forms
  • Dependency preservation
  • Boyce/Codd normal form
  • A note on relation-valued attributes
  • 13 Further Normalization II: Higher Normal Forms
  • Multi-valued dependencies and fourth normal form
  • Join dependencies and fifth normal form
  • The normalization procedure summarized
  • A note on denormalization
  • Orthogonal design (a digression)
  • Other normal forms
  • 14 Semantic Modeling
  • The overall approach
  • The E/R model
  • E/R diagrams
  • Database design with the E/R model
  • A brief analysis
  • IV Transaction Management
  • 15 Recovery
  • Transactions
  • Transaction recovery
  • System recovery
  • Media recovery
  • Two-phase commit
  • Savepoints (a digression)
  • SQL facilities
  • 16 Concurrency
  • Three concurrency problems
  • Locking
  • The three concurrency problems revisited
  • Deadlock
  • Serializability
  • Recovery revisited
  • Isolation levels
  • Intent locking
  • ACID dropping
  • SQL facilities
  • V Further Topics
  • 17 Security
  • Discretionary access control
  • Mandatory access control
  • Statistical databases
  • Data encryption
  • SQL facilities
  • 18 Optimization
  • A motivating example
  • An overview of query processing
  • Expression transformation
  • Database statistics
  • A divide-and-conquer strategy
  • Implementing the relational operators
  • 19 Missing Information
  • An overview of the 3VL approach
  • Some consequences of the foregoing scheme
  • Nulls and keys
  • Outer join (a digression)
  • Special values
  • SQL facilities
  • 20 Type Inheritance
  • Type hierarchies
  • Polymorphism and substitutability
  • Variables and assignments
  • Specialization by constraint
  • Comparisons
  • Operators, versions, and signatures
  • Is a circle an ellipse?
  • Specialization by constraint revisited
  • SQL facilities
  • 21 Distributed Databases
  • Some preliminaries
  • The twelve objectives
  • Problems of distributed systems
  • Client/server systems
  • DBMS independence
  • SQL facilities
  • 22 Decision Support
  • Aspects of decision support
  • Database design for decision support
  • Data preparation
  • Data warehouses and data marts
  • Online analytical processing
  • Data mining
  • SQL facilities
  • 23 Temporal Databases
  • What is the problem?
  • Intervals
  • Packing and unpacking relations
  • Generalizing the relational operators
  • Database work design
  • Integrity constraints
  • 24 Logic-Based Databases
  • Overview
  • Propositional calculus
  • Predicate calculus
  • A proof-theoretic view of databases
  • Deductive database systems
  • Recursive query processing
  • VI Objects, Relations, And Xml
  • 25 Object Databases
  • Objects, classes, methods, and messages
  • A closer look
  • A cradle-to-grave example
  • Miscellaneous issues
  • 26 Object / Relational Databases
  • The First Great Blunder
  • The Second Great Blunder
  • Implementation issues
  • Benefits of true rapprochement
  • SQL facilities
  • 27 The World Wide Web and XML
  • The Web and the Internet
  • An overview of XML
  • XML data definition
  • XML data manipulation
  • XML and databases
  • SQL facilities
  • Appendixes
  • Appendix A The TransRelationalâäó Model
  • Three levels of abstraction
  • The basic idea
  • Condensed columns
  • Merged columns
  • Implementing the relational operators
  • Appendix B SQL Expressions, Table Expressions, and Boolean Expressions
  • Appendix C Abbreviations, Acronyms, and Symbol
  • Appendix D Online storage structures and access methods, database access: an overview, page sets and files, indexing, hashing, pointer chains, and compression techniques
  • Index

Powered by Koha