 |
|
| RELATIONAL DATABASE SYSTEMS
| |
| | |
|
|
 To order this title, and for more information, click here
By
Dan Simovici, University of Massachusetts
Richard Tenney, University of Massachusetts
Description
Relational Database Systems provides a timely introduction to the type of systems that are the current mainstay of the database
management field. This book serves as a text for advanced undergraduate and graduate students, as well as an informative reference for
researchers and professionals in all database aspects of computer science. It presents important querying systems including SQL and QUEL,
and covers their respective theoretical foundations in relational algebra, tuple calculus, and domain calculus.
The presentation of
SQL adheres to the ANSI standard; however, the book discusses the most popular SQL dialects; a separate chapter covers imbedded SQL.
The text also contains references to many significant relational database products, including INGRES, ORACLE, DB2, PARADOX, and SYBASE.
Relational Database Systems concentrates on those issues that are most relevant to database design and application development.
Exercises that constitute important extensions of the material are provided at the end of each chapter. The book assumes a knowledge
of programming languages and datastructures, and some mathematical induction.
Audience
This book serves as a text for advanced undergraduate and graduate students and as a reference for researchers in all database aspects of computer science.
Contents
Introduction to Database Concepts:
Databases and Database Systems. The Entity-Relationship Model.
The Relational Model:
The Relational Model. Relational Algebra Operations. Relational Algebra Computations. Relational Algebra Expressions. Other Operations.
SQL--The Interactive Language:
The Data Definition Component. The Data Manipulation Component. SQL and Database Administration.
SQL Dialects.
Embedded SQL:
Structure of Embedded SQL Programs. Variablesin Embedded SQL. Flow of Control. Cursors. Updates in
Embedded SQL. Dynamic SQL. SQL92 and Embedded SQL.
Relational Calculi:
Domain Calculus. Tuple Calculus. The QUEL Query Language.
Query-by-Example. Paradoxs QBE Facility.
Constraints and Schemas:
Constraints and Schemas. Project-Join Mappings. SQL and Integrity
Constraints.
Functional Dependencies:
Proofs and Functional Dependencies. Keys and Functional Dependencies. Covers. Tableaux.
Normalization:
Normal Forms. Normalization.
Multivalued and Join Dependencies:
Multivalued and Join Dependencies. Rules
of Inference. Dependency Bases. Further Normalization. Tableaux and Multivalued Dependencies. Hypergraphs.
Physical Design Principles:
Basic Data Structures. Hierarchical Systems of Indices. Hashing. Product-Specific Data Structures.
Query Processing:
Algebraic
Manipulation. Selection Query Processing. Join Processing. The Wong-Youssefi Algorithm. Informed Decisions.
Concurrency In Database
Systems:
Transactions. Serializability. Concurrency Control Algorithms. Recovery. SQL Support for Transactions. List of Notation.
Index.
| Bibliographic details |
Hardbound, 485 pages, publication date: AUG-1995
ISBN-13: 978-0-12-644375-2
ISBN-10: 0-12-644375-0
Imprint: ACADEMIC PRESS
|
| Price and Ordering |
Price:
USD 71.95
EUR 68.95
GBP 45.99
|  |
Books and book related electronic products are priced in US dollars (USD), euro (EUR), and Great Britain Pounds (GBP). USD prices apply to the Americas and Asia Pacific. EUR prices apply in Europe and the Middle East. GBP prices apply to the UK and all other countries.
|
See also information about conditions of sale & ordering procedures, and links to our regional sales offices.
|
077/762
Last update: 27 Sep 2008
|
|
| |
| | |
|
|
| |
