Sale!

Relational Theory for Computer Professionals 1st Edition by CJ Date ISBN 144936943X 9781449369439

Original price was: $50.00.Current price is: $35.00.

Relational Theory for Computer Professionals 1st Edition C.J. Date Digital Instant Download

Author(s): C.J. Date
ISBN(s): 9781449369439, 144936943X
Edition: 1
File Details: PDF, 25.01 MB
Year: 2013
Language: english
SKU: EB-4166270 Category: Tag:

Relational Theory for Computer Professionals 1st Edition by CJ Date – Ebook PDF Instant Download/Delivery: 144936943X, 9781449369439
Full download Relational Theory for Computer Professionals 1st Edition after payment

Product details:

ISBN 10: 144936943X 
ISBN 13: 9781449369439
Author: CJ Date

All of today’s mainstream database products support the SQL language, and relational theory is what SQL is supposed to be based on. But are those products truly relational? Sadly, the answer is no. This book shows you what a real relational product would be like, and how and why it would be so much better than what’s currently available. With this unique book, you will: Learn how to see database systems as programming systems Get a careful, precise, and detailed definition of the relational model Explore a detailed analysis of SQL from a relational point of view There are literally hundreds of books on relational theory or the SQL language or both. But this one is different. First, nobody is more qualified than Chris Date to write such a book. He and Ted Codd, inventor of the relational model, were colleagues for many years, and Chris’s involvement with the technology goes back to the time of Codd’s first papers in 1969 and 1970. Second, most books try to use SQL as a vehicle for teaching relational theory, but this book deliberately takes the opposite approach. Its primary aim is to teach relational theory as such. Then it uses that theory as a vehicle for teaching SQL, showing in particular how that theory can help with the practical problem of using SQL correctly and productively. Any computer professional who wants to understand what relational systems are all about can benefit from this book. No prior knowledge of databases is assumed.

Relational Theory for Computer Professionals 1st Table of contents:

I. Foundations

  1. Basic Database Concepts

    • What’s a database?

    • The Running Example

    • What’s a DBMS?

    • Data Independence

    • Other DBMS Functions

    • What’s a relational DBMS?

    • Database systems vs. programming systems

    • More on Types

    • Exercises

    • Answers

  2. Relations and Relvars

    • Relations

    • Attributes

    • Tuples

    • Properties of Relations

    • Relvars

    • Exercises

    • Answers

  3. Keys, Foreign Keys, and Related Matters

    • Integrity constraints

    • Keys

    • Foreign keys

    • Relvar definitions

    • Loading the database

    • Database systems vs. programming systems bis

    • Exercises

    • Answers

  4. Relational Operators I

    • Codd’s original algebra

    • Restrict

    • Project

    • Closure Revisited

    • Exercises I

    • Answers I

    • Union, intersection, and difference

    • Union

    • Intersection

    • Difference

    • Some Formal Properties

    • Rename

    • Exercises II

    • Answers II

    • Join

    • Cartesian Product

    • Intersection Revisited

    • Primitive Operators

    • Relational comparisons

    • Update operator expansions

    • Exercises III

    • Answers III

  5. Relational Operators II

    • MATCHING and NOT MATCHING

    • EXTEND

    • Image relations

    • Aggregation and summarization

    • Summarization

    • Explicit SUMMARIZE

    • “Generalized Restriction”

    • Exercises

    • Answers

  6. Constraints and Predicates

    • Database constraints

    • Relvar predicates

    • Relations vs. Types

    • Predicates vs. constraints

    • Exercises

    • Answers

  7. The Relational Model

    • The relational model defined

    • Types

    • The RELATION type generator

    • Relation variables

    • Relational assignment

    • Relational operators

    • Security

    • Views

    • Concluding remarks

II. Transactions and Database Design

  1. Transactions

    • What’s a transaction?

    • Recovery

    • The Recovery Log

    • The ACID Properties

    • Concurrency

    • Locking

    • A remark on SQL

    • Exercises

    • Answers

  2. Database Design

    • Nonloss decomposition

    • Functional dependencies

    • Irreducible FDs

    • Second normal form

    • Third normal form

    • Boyce/Codd normal form

    • Concluding remarks

    • Exercises

    • Answers

III. SQL

  1. SQL Tables

    • A little history

    • Basic concepts

    • Properties of tables

    • More on Terminology

    • Table updates

    • Equality comparisons

    • Table definitions

    • “Table Literals”

    • SQL systems vs. programming systems

    • Exercises

    • Answers

  2. SQL Operators I

    • Restrict

    • Project

    • Union, intersection, and difference

    • Formal Properties

    • Rename

    • Exercises I

    • Answers I

    • Join

    • Alternative Formulations

    • Formal Properties

    • Cartesian Product

    • Evaluating table expressions

    • Table comparisons

    • Displaying results

    • Exercises II

    • Answers II

  3. SQL Operators II

    • MATCHING and NOT MATCHING

    • EXTEND

    • Image relations

    • Aggregation and summarization

    • Summarization

    • “Generalized Restriction”

    • Exercises

    • Answers

  4. SQL Constraints

    • Database constraints

    • Type constraints

    • Exercises

    • Answers

  5. SQL vs. the Relational Model

    • Some generalities

    • Some SQL departures from the relational model

    • Exercises

    • Answers

IV. Appendixes

A. A Tutorial D Grammar

  • Expressions

  • Assignments

B. TABLE_DUM and TABLE_DEE

C. Set Theory

  • What’s a set?

  • Subsets and supersets

  • Exercises

  • Answers

  • Set operators

  • Exercises

  • Answers

  • Some identities

  • Exercises

  • Answers

  • The algebra of sets

  • Cartesian product

  • Concluding remarks

D. Relational Calculus

  • Sample queries

  • Sample constraints

  • A simplified grammar

  • Exercises

  • Answers

E. A Guide to Further Reading

  • Papers by E. F. Codd

  • Books by C. J. Date

  • Books by C. J. Date and Hugh Darwen

  • Other Publications Related to SQL

People also search for Relational Theory for Computer Professionals 1st:

relational theory for computer professionals pdf
    
relational computer science
    
relational.theory
    
relational operators computer science
    
relational operator computer science

Tags: CJ Date, Theory, Computer Professionals