OMBDB: An Innovative Paradigm for Data Warehousing Architectures - Anthony D. Noriega

In one of the most innovative presentations at IOUG Live! 2005, Anthony Noriega made a very insightful presentation about the massive benefits of using the Oracle9i multiple block size feature to optimize Oracle data warehouses.

Managing a multi-block data warehouse database falls in a special category that involves business intelligence and combines expertise in areas such as Extract Transform Load (ETL), On-Line-Analytical Process (OLAP), Data Mining, in conjunction with custom applications, legacy systems, and related business process applications, such as Supply Change Management (SCM), Customer Relationship Management (CRM), and Enterprise Resource Planning (ERP) systems.

This paper intends to enhance a blueprint for major production applications in VLDB. The paper and presentation will discuss how to best utilize multiple block size databases in conjunction with table partitioning and related techniques, table compression, and best strategies for extent and segment space management and related tablespace utilization, including best Index Allocation, Index Organized Tables benchmarks.

I have long been a proponent of multiple blocksizes for the Oracle data warehouse, and Mr. Noriega shared some insights from his personal experience:

Utilizing Oracle multiblock databases in data warehousing based systems will prove in the long-term to be a reliable methodology to approach the diversity of information and related business intelligence applications processes when integrating existing systems, consolidating older systems with existing or newly created ones, to avoid redundancy and lower costs of operations, among other factors.

The input received from those already using multiblock databases in highly satisfactory in areas such as marketing, advertisement, finance, pharmaceutical, document management, manufacturing, inventory control, and entertainment industry.

Overall, Mr. Noriega get my award for the most innovative technology at IOUG Live! 2005 with this excellent leveraging of Oracle technology for data warehouse performance.

��