
xxvi What Is in this Book?
The data model can be tuned using data warehouse–specific design
methodologies.
In Oracle Database and other databases a data warehouse can imple-
ment numerous special feature structures including proper indexing,
partitioning, and materialized views.
SQL code for execution of queries against a data warehouse can be
extensively tuned, usually hand-in-hand with use of specialized
objects, such as materialized views.
Highly complex SQL code can be replaced with specialized Oracle
SQL code functionality, such as ROLLUP and MODEL clauses, a
proliferation of analytical functions, and even an OLAP add-on
option.
The ...