Oracle Business Intelligence Application Architect
☎ +91 9994883085
Don't miss

Saturday, 11 March 2017

Define Operational Data Store (ODS)

By on 13:22:00

An ODS is an integrated database of operational data. ODS is a subject-oriented, integrated, current-valued and volatile collection of detailed data that provides a true enterprise view of information. ODS is frequently updated (synchronously, hourly, daily or batch processing). The frequency of update and degree of integration depends on the specific business requirements. The detailed current information in the ODS is transactional in nature. An ODS may contain 30 to 60 days of information. ODS can also provide a stepping-stone to feed operational data into the data warehouse. The data warehouse industry has developed ODS, usually presenting it as running on a separate platform, to satisfy tactical decision making requirements.

ODS can deliver operational reports, especially when both the legacy systems and the OLTP systems do not provide adequate operational reports. It relieves production system of reporting and analysis demands and provides access to current data.

ODS can be a third physical system sitting between the operational systems and the data warehouse or a partition of the data warehouse itself. ODS is optional.

ODS can be transient or persistent.

1. Data Presentation

The data presentation area is where the data is stored and optimized for direct querying, reporting, and analysis. It consists of the data warehouse or a series of integrated data marts. For business community, presentation area is the data warehouse. Data in the presentation area strictly is in dimensional form. It must contain detailed, atomic data. It must adhere to the data warehouse bus architecture. While the logical design of presentation area is dimensional model, physical implementation may be in RDBMS or MDDB. If RDBMS is used, data is stored in tables referred to as star schemas. If MDDB is used, then data is stored in cubes.

2. Data Access Tools

Data access tools are used by the business community to query the data warehouse’s presentation area.They may be ad hoc query tools, data mining tools, or application tools. Users may need to perform simple to complex business modeling, complex drill-down, simple queries on prepared summary information, what-if analysis, trend analysis and forecasting and data mining using data spanning several time periods.

3. Metadata

Metadata is information about the actual data itself. Metadata explains what data exists, where it is located and how to access it. It comes in many shapes and forms and it supports the data warehouse’s technical, administrative, and business user groups.


Post a Comment

Blog Archive


1z0-482 Dumps (2) 1Z0-525 Dumps (1) BI Apps Installation (1) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (47) Informatica Online Training (1) informatica scenarios questions (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) Normalization in Oracle (1) OBIA (1) OBIA (3) OBIA Installation (33) OBIEE (2) OBIEE 10G (8) OBIEE 11G (138) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) Power BI (5) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)