Here you can order books and two series of papers targeted at the data professional/user who thinks critically and independently and appreciates a scientific approach rather than follows the IT industry's fad-driven "cookbook mode". Both series offer accessible explanations of the real RDM—what we believe it would have been had E.F. Codd completed his work—and the practical implications thereof. It is derived from a re-interpretation of his work that is consistent with its theoretical foundation and is distinct from the conventional wisdom that emerged in the industry after Codd's passing.
Scroll down to order.
UNDERSTANDING THE REAL RDM Series ($30/paper)
This series review, analyze and interpret E. F. Codd’s published papers to make the letter and spirit of the real RDM from which its practical advantages derive accessible to the independent, critical thinking practitioner who prefers understanding to following the fad-driven, “cookbook approach” of the industry.
PRACTICAL DATABASE FOUNDATIONS ($20/paper)
This series:
- Dispels common, misuse and abuse of data and relational fundamentals;
- Clarifies fundamental terminology, concepts and features of the real RDM that are ignored, distorted and misunderstood in the industry;
- Conveys the practical advantages of RDM of which practitioners are unaware and/or which the industry has failed to deliver.
NEW!
Table of Contents
Series Preface
Abstract
Introduction
1. Entities, Properties, Names, and Identification
2. Relational Representation
3. Relational Keys
3.1. Kinds of Keys
3.1.1. Candidate, Primary and Alternate Keys
3.1.2. Natural and Surrogate Keys
4. Formal Primary Key Mandate
5. Primary Key Designation
6. Keys and Constraints
7. Keys and Performance
7.1. Keys and Indexes
Conclusion
References
Appendix A: Keys in SQL
Appendix B: Duplicates and Consequences
B1. Duplicate Interpretation
B2. Duplicates in SQL
B2.1. Duplicates and Correctness
B2.2. Duplicates and Query Nestability
B2.3. Language Redundancy & Duplicates
B2.4. Duplicates and Performance Optimization
B2.5. Duplicate Removal
Introduction
1. The Normal Form
2. The First Normal Form
3. Domain Decomposability & Atomicity
4. 1NF & Tables
5. SQL & 1NF
5.1. Repeating Groups & Repeated Attributes
5.2. IP & SQL
More forthcoming:
DATABASE RELATIONS - A Definitive Guide (in progress)
THE FINAL NULL IN THE COFFIN - A Relational Solution to Missing Data
CONCEPTUAL MODELING FOR DATABASE DESIGN - The Correct Approach
RELATIONAL DOMAINS - The Database Glue
How to order
Check or Money Order preferred (email me with wanted papers for mailing address).
Paypal (email me with wanted papers for instructions.)
Revisions and new editions:
Same year revisions free.
Later revisions half price
New editions (full rewrites) full price.
Last updated 2/12/24
1122
ReplyDelete