Database In Depth: Relational Theory For Practitioners

Database In Depth: Relational Theory For Practitioners (Paperback)

By C J Date 
Publisher: O'Reilly
Edition: Paperback
Language: English
ISBN: 8173667802
EAN: 9788173667800
No. of Pages: 250
Publish Date: 2005-1-1
Binding: Paperback
Ships to India.

Description

About the Book :

This book sheds light on the principles behind the relational model, which is fundamental to all database-backed applications--and, consequently, most of the work that goes on in the computing world today. Database in Depth: The Relational Model for Practitioners goes beyond the hype and gets to the heart of how relational databases actually work.

Ideal for experienced database developers and designers, this concise guide gives you a clear view of the technology--a view that's not influenced by any vendor or product. Featuring an extensive set of exercises, it will help you:

  •     understand why and how the relational model is still directly relevant to modern database technology (and will remain so for the foreseeable future)
  •     see why and how the SQL standard is seriously deficient
  •     use the best current theoretical knowledge in the design of their databases and database applications
  •     make informed decisions in their daily database professional activities.


Database in Depth will appeal not only to database developers and designers, but also to a diverse field of professionals and academics, including database administrators (DBAs), information modelers, database consultants, and more. Virtually everyone who deals with relational databases should have at least a passing understanding of the fundamentals of working with relational models. Author C.J. Date has been involved with the relational model from its earliest days. An exceptionally clear-thinking writer, Date lays out principle and theory in a manner that is easily understood. Few others can speak as authoritatively the topic of relational databases as Date can.

About the Author :

Chris Date has a stature that is unique within the database industry. Chris is a prolific writer, and is well-known for his best-selling textbook: An Introduction to Database Systems (Addison Wesley). Chris is an exceptionally clear-thinking writer who can lay out principles and theory in a way easily understood by his audience.

Contents :

Chapter One Introduction

    A Remark on Terminology
    Principles, Not Products
    A Review of the Original Model
    Model Versus Implementation
    Properties of Relations
    Relations Versus Relvars
    Values Versus Variables
    Summary
    Exercises

Chapter Two Relations Versus Types

    Domain-Constrained Comparisons
    Data Value Atomicity
    So What's a Type?
    Scalar Versus Nonscalar Types
    Summary
    Exercises

Chapter Three Tuples and Relations

    What's a Tuple?
    Some Important Consequences
    What's a Relation?
    Further Important Consequences
    Why Duplicate Tuples Are Prohibited
    Why Nulls Are Prohibited
    TABLE_DUM and TABLE_DEE
    Summary
    Exercises

Chapter Four Relation Variables

    Updating Is Set-at-a-Time
    More on Candidate Keys
    More on Foreign Keys
    More on Views
    Relvars and Predicates
    More on Relations Versus Types
    Summary
    Exercises

Chapter Five Relational Algebra

    More on Closure
    The Original Operators
    Evaluating SQL Expressions
    Extend and Summarize
    Group and Ungroup
    Expression Transformation
    Relational Comparisons
    More on Relational Assignment
    The ORDER BY Operator
    Summary
    Exercises

Chapter Six Integrity Constraints

    Type Constraints
    Database Constraints
    Transactions
    Why Database Constraint Checking Must Be Immediate
    But Doesn't Some Checking Have to Be Deferred?
    Constraints and Predicates
    Miscellaneous Issues
    Summary
    Exercises

Chapter Seven Database Design Theory

    The Place of Design Theory
    Functional Dependencies and Boyce/Codd Normal Form
    Join Dependencies and Fifth Normal Form
    Two Cheers for Normalization
    Orthogonality
    Some Remarks on Physical Design
    Summary
    Exercises

Chapter Eight What Is the Relational Model?

    The Relational Model Defined
    Objectives of the Relational Model
    Some Database Principles
    The Relational Model Versus Others
    What Remains to Be Done?
    Summary
    Exercises

Appendix A A Little Bit of Logic

    Propositions
    Predicates
    Quantification
    Free and Bound Variables
    More on Quantification
    Database Constraints
    Queries
    Some Equivalences
    Summary

Appendix Suggestions for Further Reading
Colophon

show moreless

Specification

Title: Database In Depth: Relational Theory For Practitioners
Publisher: O'Reilly
Author: C J Date
Edition: Paperback
Language: English
ISBN: 8173667802
EAN: 9788173667800
No. of Pages: 250
Publish Date: 2005-1-1
Binding: Paperback

Disclaimer

  • The book summary and image may be of a different edition or binding of the same title.
  • Book reviews are added by registered customers. They need not necessarily buy book.
  • These books are NOT available for reading online or for free download in PDF or ebook format.
  • Price can change due to reprinting, price change by publisher or sourcing cost change for imported books.
  • www.infibeam.com/Books is the biggest online bookstore in India for sale of books at best price - fiction, literature, audiobooks, study guides, novels, story books, rare books, textbooks and books by popular authors. These are available in various editions and bindings e.g. paperback and at best discount.
  • For the imported title, once the order gets placed ,it can’t be cancelled


Great Value

Safe Payment

Shop With
Confidence

Help Center

Free & Easy Return

Get Discounts & Offers
Stay Connected

Popular Searches on Infibeam.com

Online Shopping: Deal of The Day / Hot Deals / Best Deals / Offers

Apple iPhones: Iphone Xs Max / Iphone Xs / Iphone XR / iPhone 8 / iPhone 8 / iPhone 7 / iPhone 7 Plus / iPhone 6s / iPhone 5s

Mobile Phones:Unboxed Mobiles / Apple Mobiles / Samsung Mobiles / Micromax Mobiles / Sony Mobiles / Intex Mobiles / Latest Mobiles / Smartphones / 4G Phones / 3G Phones

Computers:Dell Laptops / Lenovo Laptops / Acer Laptops / HP Laptops / External Hard Disks / Pen Drives / Monitors / Softwares / Printers

Appliances:Air Conditioners / Air Coolers / Refrigerators / Geysers / Room Heaters / Immersion Rod / Water Purifiers / Washing Machines / Microwaves & OTG / Air Purifier

Electronics: Tablets / Cameras / Headphones / Power Bank / LED TVs / Gaming Consoles / Speakers / Tablet Accessories / Memory Cards

Men's Clothing: Shirts / T-Shirts / Tracksuits / Trousers / Ethnic Wear / Men's Denim / Cargo Shorts / Tees & Polos / Suits & Blazer

Women's Clothing: Dress Materials / Salwar Suits / Women Sarees / Kurtas & Kurtis / Leggings / Lingerie / Night Suits & Nighties / Women Shorts / Tops

Fashion:Men's Shoes / Women's Footwear / Fastrack Watches / Titan Watches / Timex Watches / Bags / Jewellery / Fastrack Sunglasses / Perfumes & Deodorants / Fashion Accessories

Online Book Store:Best Sellers Books / Business Books / History and Politics / Academic and Professional / Competitive Exams / Biographies and Autobiographies

Best Ecommerce Platform:Online Store Builder / Create Online Store / Best Ecommerce Solutions / Sell Online / Ecommerce Marketing Blog

Ecommerce Website Templates:Free Website Templates / Free Logo Design / SEO Audit Report / Theme Store / Wordpress Themes / Web & App Development Company

Copyright © 2007-2019 Infibeam.com and Affiliates
Site is up