Question: What is data modeling for
Oracle, and how is data modeling for Oracle different from other
Answer: Traditional logical relational
data modeling is database independent, but Oracle data modeling is
more flexible because it offers non-relational extensions that
effect your data modeling. See these important notes on
For example, Oracle supports non-first-normal form (0NF) data
models , and Oracle data modeling also allows for massive
table columns and materialized
views to pre-joins tables and pre-summarize detailed
data. Another unique Oracle data modeling technique are
way to hard code pointers to rows in a non-relational form.
From a physical
data modeling view, Oracle has many extensions that allow for
many flexible data modeling options. For more details,
see the book
Oracle Physical Design by Donald K. Burleson.
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.