Joe Celko's Data and Databases : Concepts in Practice

by Celko

• ISBN13: 9781558604322
• ISBN10: 1558604324
• Format: Paperback
• Copyright: 1999-07-27
• Publisher: Elsevier Science

Summary

Do you need an introductory book on data and databases? If the book is by Joe Celko, the answer is yes. Data and Databases: Concepts in Practice is the first introduction to relational database technology written especially for practicing IT professionals. If you work mostly outside the database world, this book will ground you in the concepts and overall framework you must master if your data-intensive projects are to be successful. If you're already an experienced database programmer, administrator, analyst, or user, it will let you take a step back from your work and examine the founding principles on which you rely every day-helping you to work smarter, faster, and problem-free. Whatever your field or level of expertise, Data and Databases offers you the depth and breadth of vision for which Celko is famous. No one knows the topic as well as he, and no one conveys this knowledge as clearly, as effectively-or as engagingly. Filled with absorbing war stories and no-holds-barred commentary, this is a book you'll pick up again and again, both for the information it holds and for the distinctive style that marks it as genuine Celko. * Supports its extensive conceptual information with example code and other practical illustrations. * Explains fundamental issues such as the nature of data and data modeling, and moves to more specific technical questions such as scales, measurements, and encoding. * Offers fresh, engaging approaches to basic and not-so-basic issues of database programming, including data entities, relationships and values, data structures, set operations, numeric data, character string data, logical data and operations, and missing data among others. * Covers the conceptual foundations of modern RDBMS technology, making it an ideal choice for students.

Table of Contents

Preface

The Nature of Data

Entities, Attributes, Values and Relationships

Data Structures

Relational Tables

Access Structures

Numeric Data

Character String Data

Logic and Databases

Temporal Data

Textual Data

Exotic Data

Missing data

Scales and Measurements

Data Encoding Schemes

Check Digits

The Basic Relational Model

Keys

Different Relational Models

Basic Relational Operations

Transactions and Concurrency Control

Functional Dependencies

Normalization

Denormalization

Metadata

Table of Contents provided by Publisher. All Rights Reserved.