Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

 

 


Chris Date releases free book chapter

June 18, 2005

Chris Date, co-founder of the relational database model has just released a free chapter from his latest book "Database In Depth" by O'Reilly:

http://searchoracle.techtarget.com/searchOracle/downloads/Database_in_Depth_Chapter_1.pdf

Back in the 1970's when Codd and Date first developed the rules of normalization, disk was very expensive and the goal of relational demoralization was the elimination of redundancy.  Today, disk is a cheap commodity, and many of the original rules of normalization no longer apply because redundancy is cheaper than the run-time performance overhead of joining tables together unnecessarily. 

Also, vendors such as Oracle have extended their relational offerings by offering data structures that violates Dates original rules of normalization:

1 - The ability to create non-first-normal-form tables (i.e. tables with repeating groups via PL/SQL varray data types).

2 - The ability to hard-link rows via pointers, using constructs such as Oracle nested tables and stored arrays of pointers (Object ID's).

3 - The ability to incorporate physical storage rules into the structures, such as the APPEND hint, and the Oracle cluster table structure, where related table rows can be placed on adjacent data blocks, and index organized tables, where the table data is stored inside the index tree structure.

In the sample chapter, Date notes that his relational model condemns these practices:

The fact that the relational model says nothing about physical storage is deliberate, of course. The idea was to give implementers the freedom to implement the model in whatever way they chose—in particular, in whatever way seemed likely to yield good performance—without compromising on data independence.

The sad fact is, however, that SQL vendors seem mostly not to have understood this point; instead, they map base tables fairly directly to physical storage,* and (as noted in the previous section) their products therefore provide far less data independence than relational systems are theoretically capable of.

 

 

 


 

 
 
��  
 
 
Oracle Training at Sea
 
 
 
 
oracle dba poster
 

 
Follow us on Twitter 
 
Oracle performance tuning software 
 
Oracle Linux poster
 
 
 

 

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2017

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.

Remote Emergency Support provided by Conversational