Inteligencia de negocios

Data Modeling Techniques Using Oracle BI Server
Mark Rittman, Director, Rittman Mead Consulting Oracle Open World 2008, San Francisco. Session #S300202
T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com W: www.rittmanmead.com

Who Am I?
• Oracle BI&W Architecture and Development Specialist • Co-Founder of Rittman Mead Consulting ‣ Oracle BI&W Project Delivery Specialists • 10+ yearswith Discoverer, OWB etc • Oracle ACE Director, ACE of the Year 2005 • Writer for OTN and Oracle Magazine • Longest-running Oracle blog ‣ http://www.rittmanmead.com/blog • Chair of UKOUG BIRT SIG • Co-Chair of ODTUG BI&DW SIG • Speaker at IOUG and BIWA events

T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com W: www.rittmanmead.com

Rittman Mead Consulting
• Oracle BI&DW ProjectSpecialists • Consulting, Training, Support • Works with you to ensure OBIEE and Oracle BI Applications project success • Small, focused team • OWB, Oracle BI, DW technical specialists • Clients in the UK, Europe, USA

T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com W: www.rittmanmead.com

What is this Presentation About?
• For performance and data integration reasons, most mature OBIEEsystems source their data from one (or more) data warehouses • For initial implementations though, data is often initially accessed directly • OBIEE has some powerful features for creating integrated “virtual” logical models ‣ For bringing together data from disparate systems (“federation”) ‣ For integrating historic and real-time data (“fragmentation”) ‣ For creating calculations and derivations ‣ Forhandling multi-valued dimensions • OBIEE also requires that any normalized data is converted into a “star schema” • These data modeling techniques, coupled with more formal data warehouses, can allow you to deploy very flexible, agile data models to support your reporting • This presentation will take you through some of these data modeling techniques and will discuss how these initial models aremigrated to a more formal data warehouse

T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com W: www.rittmanmead.com

Oracle Business Intelligence Enterprise Edition

T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com W: www.rittmanmead.com

OBIEE 10.1.3.2 Architecture
Web Server (IIS, Tomcat, Websphere, iPlanet)
SAW Bridge (J2EE/ISAPI) XML, HTML, XLS, PDF, TXT over HTTP/HTTPSWeb Browser
Javascript for Usability & Interactivity

Oracle BI Publisher
Delivery Server Layout Interfaces XSL Data Logic

Oracle BI Presentation Services
SOAP Web Services, XML and URL Interface Oracle Interactive Dashboards Oracle Answers

TCP/IP (SSL) Web Catalog Service XML Framework

User Profiling, Security and Session Mngmt Cache Services (Web) & Connection Mngmt

HTML, SOAPover HTTP/HTTPS

External Applications and Portals

ODBC over TCP/IP (SSL)

Oracle Delivers Server
Scheduling/Event Services Agent Execution Logic Device Adaptive Content

TCP/IP (SSL)

Oracle BI Server
Logical SQL ODBC/JDBC (Logical Business Model)

Session Management Intelligent Request Generation

Metadata Interchange

Load Balancer

Oracle BI Cluster Controller

LogicalRequest Generation Cache Services Navigator Multi-Pass / Sub-Request Logic Fragmentation Optimization Aggregate Navigator Optimized Query Rewrites Execution Engine

Oracle BI Administration
Metadata Management Services Multi-User Development Services Metadata Documentation Services Server Management Services

Externalized Authentication LDAP DB Authentication Custom Authenticator

DataSource Adapters
ODBC, CLI, OCI, XML, MDX Analytical and Operational Data Sources

T : +44 (0) 8446 697 995 E : enquiries@rittmanmead.com W: www.rittmanmead.com

System / Perf Monitoring

Security Services Security Services

Query Govern. Query Govern.

Data Access
• Reporting data may be sourced from multiple databases, applications ‣ Oracle Database (including Oracle OLAP) ‣ IBM DB2 ‣...