Database Reference
In-Depth Information
Figure 1.24
OLTP to Data
Warehouse Links.
There are links between the two sets of OLTP and data warehouse
tables, as highlighted in Figure 1.24.
All scripts used to create tables and their data are provided in Appendix A.
The next chapter will briefly list new features available for SQL in both
Oracle Database 10
g
and Oracle Database 9
i
.
1.8
Endnotes
1.
www.oracledbaexpert.com/oracle/secure/Normalization.doc
2.
Oracle Performance Tuning for 9i and 10g (ISBN: 1-555-58305-9)
3.
My version of the Normalization is a highly simplified version. I
have twisted Normal Forms deliberately.
4.
http://www.oracledbaexpert.com/oracle/secure/
Denormalization.doc
5.
http://www.oracledbaexpert.com/oracle/secure/
TheVeryBasicsOfDataWarehouseDesign.doc
