1 / 20

Oracle10 g for Data Warehousing

Oracle10 g for Data Warehousing. Jiangang Luo Jiangang.Luo@oracle.com. Gartner Data Warehouse Magic Quadrant. http://mediaproducts.gartner.com/reprints/oracle/121302.html. Oracle Terabyte DW Customers.

sandro
Download Presentation

Oracle10 g for Data Warehousing

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle10g for Data Warehousing Jiangang Luo Jiangang.Luo@oracle.com

  2. Gartner Data Warehouse Magic Quadrant http://mediaproducts.gartner.com/reprints/oracle/121302.html

  3. Oracle Terabyte DW Customers Consumer Packaged Goods / Retail Communications Financial Services Manufacturing. Every major platform, Every major architecture

  4. Questions for today’s Enterprise • Do you have the information you need to make timely, optimized decisions for improving your revenue and profits? • Can you analyze and drill down on information to make precise decisions for optimizing your day-to-day business operations? • Do you have a personalized, single point of access to all your intelligence? • Do you have multiple departmental data marts across your enterprise? • How do you ensure users can only access information pertinent to their role or job duties?

  5. Business Intelligence: The Old Way Independent Data Marts ETL Processing OLAPEngine Sales SQL Server Marketing MiningEngine DB2 Finance Oracle Reporting Fragmented Data Fragmented Analysis

  6. Marketing OLAP Finance Data Mining ETL Sales Business Intelligence: The Best Way Enterprise Data Warehouse Oracle Data Mart Consolidate Data Consolidate Analysis

  7. OLTP ODS Data Warehouse “Hub” Data Data Data “Dependent” Data Mart “Independent” Data Mart Data Data Data Data ADS ADS ADS FDS FDS ADS ADS ADS The Evolving Approach to Warehouse Architecture Traditional Warehouse Infrastructure Enterprise Warehouse Infrastructure • Executive highly summarized • Reporting/Performance layer- Dimensional • Single database infrastructure • EDW – 3NF - Atomic • Staging Area/ODS • OLTP systems While data warehouse architectural options are debatable…… the need for one is not.

  8. BI /DW Overview

  9. ETL OLAP Web DB 企业 应用程序 Data Mining Legacy Oracle BI/DW Solution DW BI Reports Reports Oracle 10g Oracle Warehouse Builder Oracle Application Server Discoverer Discoverer BI Beans BI Beans

  10. Reports Discoverer Customer Time Revenue OLAP JDeveloper (BI Beans) Product Channel ETL Scripts Dictionary Data Model Cubes Portal Discoverer Portlets Data Data Miner Oracle Datawarehousing Busines External Data Warehouse Builder Data Warehouse

  11. Oracle10g for Business Intelligence • A scalable, full-featured data engine, running on any hw platform, providing enterprise-strength security and reliability • not a server running on proprietary or special-purpose hardware • A single platform delivering all analytic capabilities • not a collection of special-purpose analytic engines with separate repositories • An integral component of a company's information architecture • not an island of data and analytical results

  12. Data Warehousing • Warehouse Builder • Extensible framework for designing and deploying DW’s ETL • Transformation Engine • Integrated in Oracle DB • Scalable (parallel) • Extensible (Java, PL/SQL) • Efficient (no data staging) OLAP Data Mining Platform for Business Intelligence:ETL Oracle9i

  13. Data Warehousing ETL OLAP Data Mining Oracle Data Mining • Data Mining embedded in OracleDatabase • Simplifies process, eliminates data movement, and delivers performance and scalability • Enhances applications with predictions and insights • Available inside the database • Java-based API • For developing business intelligence applications Oracle10g

  14. Data Warehousing ETL OLAP Data Mining Platform for Business Intelligence:OLAP • What is the Oracle OLAP? • Industrial-strength multidimensional calculation engine • Multidimensional data types • OLAP API to the Oracle9i Database • Why do I need the OLAP? • Complements relational technology by enhancing the Database's calculation capabilities • Multidimensional queries • Planning functions • What-if analysis Oracle9i

  15. Oracle OLAP • Full set of OLAP capabilities • All storage and processing in the Oracle database • Multidimensional structures (dimensions,cubes) stored natively in the database • No exterior file storage or separateolap process (unlike competitive products) • SQL access to multidimensionalobjects & calculations • BI Beans for rapid development ofinternet applications OLAP

  16. Data Replication Data Warehouse Data Warehouse Business ProblemReplication and Fragmentation

  17. OLAPEngine DataIntegrationEngine Data Warehouse Engine MiningEngine Oracle10g changes this … Data Warehouse • Multiple databases • Multiple servers • Multiple engines • Proprietary interfaces • Complex environment • Slow conversion of data to information

  18. Oracle10gDB Data Warehousing ETL OLAP Data Mining Into this … Data Warehouse • Single database • Single server • Single engine • Standard interfaces • Simplified environment • Fastest conversion ofdata to information

  19. Key 10g Manageability Featuresfor DW/BI • Workload Repository • Collects and maintains key system metrics: performance measures, SQL workload, feature usage, … • Automatic SQL Tuning • Re-optimizes poor performing queries in background • Applies plan improvements to subsequent executions • Self-Tuning Memory • No more parameters for shared_pool, large_pool, … • Two parameters only: PGA, SGA • Automated Storage Management • Removes need to manage storage at the “file” level • Simplified management at “disk group” level

More Related