Scaling to Infinity: Partitioning in Oracle Data Warehouses
There are several errors present in many data warehouse implementation on Oracle. Central to these is the lack of use of partitioning, or (more prevalent) ineffective use of partitioning. Partitioning is crucial to data warehouses, but how do you use this complex functionality effectively? What other major features of Oracle does partitioning enable, and how and why? This presentation is the result of long practical experience in logical and physical database design for data warehouses, driven by the combination of business requirements and systems requirements and painfully-gained understandings of data warehousing. It will provide straight answers and solid guidelines to best utilize Oracle DW features to ensure success. Data warehouses that utilize partitioning effectively often succeed, while data warehouses that are not designed to use partitioning effectively often dies painfully.
When asked to "Select a payment method" for your free download, choose "Print and Call". Your download code will be e-mailed to you after we authorize it. International customers should enter TruTek's address as the shipping address and enter their real shipping address in the Special Instructions field on the payment screen.
- Author:: Tim Gorman
- Item #: Paper0009
