Morgan Kaufmann - Joe Celko's Data And Databases, Concepts In Practice (1999).pdf
(
1550 KB
)
Pobierz
Microsoft Word - Joe Celko's Data and Databases-Concepts in Practice - Morg.
Joe Celko's Data and Databases: Concepts in Practice
by Joe Celko
ISBN: 1558604324
Morgan Kaufmann Publishers
© 1999, 382 pages
A "big picture" look at database design and programming for
all levels of developers.
Table of Contents
Colleague Comments
Back Cover
Synopsis
by
Dean Andrews
In this book, outspoken database magazine columnist Joe Celko waxes
philosophic about fundamental concepts in database design and
development. He points out misconceptions and plain ol' mistakes commonly
made while creating databases including mathematical calculation errors,
inappropriate key field choices, date representation goofs and more. Celko
also points out the quirks in SQL itself. A detailed table-of-contents will quickly
route you to your area of interest.
Table of Contents
Joe Celko’s Data and Databases: Concepts in Practice
- 4
Chapter 1
-
The Nature of Data - 13
Chapter 2
-
Entities, Attributes, Values, and Relationships - 23
Chapter 3
-
Data Structures - 31
Chapter 4
-
Relational Tables - 49
Chapter 5
-
Access Structures - 69
Chapter 6
-
Numeric Data - 84
Chapter 7
-
Character String Data - 92
Chapter 8
-
Logic and Databases - 104
Chapter 9
-
Temporal Data - 123
Chapter 10
-
Textual Data - 131
Chapter 11
-
Exotic Data - 135
Chapter 12
-
Scales and Measurements - 146
Chapter 13
-
Missing Data - 151
Chapter 14
-
Data Encoding Schemes - 163
- 2 -
Preface
- 6
Chapter 15
-
Check Digits - 163
Chapter 16
-
The Basic Relational Model - 178
Chapter 17
-
Keys - 188
Chapter 18
-
Different Relational Models - 202
Chapter 19
-
Basic Relational Operations - 205
Chapter 20
-
Transactions and Concurrency Control - 207
Chapter 21
-
Functional Dependencies - 214
Chapter 22
-
Normalization - 217
Chapter 23
-
Denormalization - 238
Chapter 24
-
Metadata - 252
References
- 258
Back Cover
Do you need an introductory book on data and databases? If the book is by
Joe Celko, the answer is yes.
Data & 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 work smarter, faster, and problem-
free.
Whatever your field or level of expertise,
Data & 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.
•
Covers the conceptual foundations of modern RDBMS technology,
making it an ideal choice for students.
About the Author
- 3 -
Joe Celko is a noted consultant, lecturer, writer, and teacher, whose column in
Intelligent Enterprise
has won several Reader’s Choice Awards. He is well
known for his ten years of service on the ANSI SQL standards committee, his
dependable help on the DBMS CompuServe Forum, and, of course, his war
stories, which provide real-world insight into SQL programming.
Joe Celko’s Data and Databases: Concepts in
Practice
Joe Celko
Senior Editor:
Diane D. Cerra
Director of Production and Manufacturing:
Yonie Overton
Production Editor:
Cheri Palmer
Editorial Coordinator:
Belinda Breyer
Cover and Text Design:
Side by Side Studios
Cover and Text Series Design:
ThoughtHouse, Inc.
Copyeditor:
Ken DellaPenta
Proofreader:
Jennifer McClain
Composition:
Nancy Logan
Illustration:
Cherie Plumlee
Indexer:
Ty Koontz
Printer:
Courier Corporation
Designations used by companies to distinquish their products are often claimed as
trademarks or registered trademarks. In all instances where Morgan Kaufmann
Publishers is aware of a claim, the product names appear in initial capital or all capital
letters. Readers, however, should contact the appropriate companies for more complete
information regarding trademarks and registration.
Morgan Kaufmann Publishers
Editorial and Sales Office
340 Pine Street, Sixth Floor
San Francisco, CA 94104-3205
USA
Telephone: 415/392-2665
Facsimile: 415-982-2665
E-mail: mkp@mkp.com
www:
http://www.mkp.com
Order toll free: 800/745-7323
© 1999 by Morgan Kaufmann Publishers
All rights reserved
- 4 -
Printed in the United States of America
To my father, Joseph Celko Sr., and to my daughters, Takoga Stonerock and Amanda
Pattarozzi
Preface
Overview
This book is a collection of ideas about the nature of data and databases. Some of the
material has appeared in different forms in my regular columns in the computer trade and
academic press, on CompuServe forum groups, on the Internet, and over beers at
conferences for several years. Some of it is new to this volume.
This book is not a complete, formal text about any particular database theory and will not
be too mathematical to read easily. Its purpose is to provide foundations and philosophy
to the working programmer so that they can understand what they do for a living in
greater depth. The topic of each chapter could be a book in itself and usually has been.
This book is supposed to make you think and give you things to think about. Hopefully, it
succeeds.
Thanks to my magazine columns in
DBMS, Database Programming & Design, Intelligent
Enterprise,
and other publications over the years, I have become the apologist for
ANSI/ISO standard SQL. However, this is
not
an SQL book per se. It is more oriented
toward the philosophy and foundations of data and databases than toward programming
tips and techniques. However, I try to use the ANSI/ISO SQL-92 standard language for
examples whenever possible, occasionally extending it when I have to invent a notation
for some purpose.
If you need a book on the SQL-92 language, you should get a copy of
Understanding the
New SQL,
by Jim Melton and Alan Simon (Melton and Simon 1993). Jim’s other book,
Understanding SQL’s Stored Procedures
(Melton 1998), covers the procedural language
that was added to the SQL-92 standard in 1996.
If you want to get SQL tips and techniques, buy a copy of my other book,
SQL for Smarties
(Celko 1995), and then see if you learned to use them with a copy of
SQL Puzzles &
Answers
(Celko 1997).
Organization of the Book
The book is organized into nested, numbered sections arranged by topic. If you have a
problem and want to look up a possible solution now, you can go to the index or table of
contents and thumb to the right section. Feel free to highlight the parts you need and to
write notes in the margins.
I hope that the casual conversational style of the book will serve you well. I simply did not
have the time or temperament to do a formal text. If you want to explore the more formal
side of the issues I raise, I have tried to at least point you toward detailed references.
- 5 -
Plik z chomika:
adszy1
Inne pliki z tego folderu:
Wrox - SQL Functions Programmer's Reference (2005).pdf
(9573 KB)
Wiley - Beginning Sql (2005).pdf
(9149 KB)
O'Reilly - SQL Cookbook (2005).chm
(673 KB)
Premier - SQL Learn in a Weekend (2002).pdf
(5657 KB)
Morgan Kaufmann - SQL Practical Guide for Developers (2005).pdf
(4245 KB)
Inne foldery tego chomika:
Ajax
Apache & Tomcat
APress
ASP.NET
Bazy danych
Zgłoś jeśli
naruszono regulamin