Joe Celko's Data and Databases: Concepts in Practice

Front Cover
Morgan Kaufmann, 1999 M08 10 - 382 pages

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.

Features:

  • 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.
 

Selected pages

Contents

The Nature of Data
1
Relational Tables
4
1
10
2
16
6
23
5
57
5
71
Numeric Data
81
Check Digits
215
The Basic Relational Model
235
Keys
247
Different Relational Models
269
Transactions and Concurrency Control
277
4
284
Functional Dependencies
289
60
301

Character String Data
101
Logic and Databases
113
Temporal Data
127
Textual Data
157
Exotic Data
169
Scales and Measurements
175
Missing Data
191
Data Encoding Schemes
199
23
317
Metadata
337
References
347
64
351
Index
353
70
357
71
363
Copyright

Common terms and phrases

algorithm ANSI attribute candidate key Celko character check digit Chris Date clause Cobol Codd columns common compound key constraints course_no CREATE TABLE data dictionary data element datatype DBMS decimal defined DELETE denormalization document duplicate E. F. Codd employee empty set encoding schemes entity error example expression FALSE TRUE flight FOREIGN KEY format function fuzzy gate hashing hour implementations inputnumber INSERT INTEGER NOT NULL intelligent key isolation level keycol language logic look maps match means multiset normal form notation NULL PRIMARY KEY operators original pilot predicate PRIMARY KEY problem query record relational database relational model relationship result rows rules scales standard statement stored string structure subset surrogate key syntax things tion transaction unique units update usually vendors word zero

References to this book

About the author (1999)

Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards. Mr. Celko is author a series of books on SQL and RDBMS for Elsevier/MKP. He is an independent consultant based in Austin, Texas. He has written over 1200 columns in the computer trade and academic press, mostly dealing with data and databases.

Bibliographic information

TitleJoe Celko's Data and Databases: Concepts in Practice
The Morgan Kaufmann Series in Data Management Systems, ISSN 1046-1698
AuthorJoe Celko
Editionillustrated
PublisherMorgan Kaufmann, 1999
ISBN1558604324, 9781558604322
Length382 pages
  
Export CitationBiBTeX EndNote RefMan