Overview of OLAP Data Acquisition Subsystems - OLAP

Oracle Warehouse Builder can transform a wide variety of data sources into a star schema and, from the star schema, into an analytic workspace. As an alternative method, you can create an analytic workspace containing empty standard form objects, and populate these objects directly from the data sources using the facilities of the OLAP DML.

Even if you have successfully built your analytic workspace using either Analytic Workspace Manager or Oracle Warehouse Builder, you may want to add measures from other sources, such as syndicated data or government business statistics. In that case, you can use the information provided in topic, "Exploring a Standard Form Analytic Workspace", and topic, "Adding Measures to a Standard Form Analytic Workspace" to define and register the standard form workspace objects.

Then you can use one of the methods introduced in this chapter to populate the objects.
This chapter shows how to use OLAP tools to generate a standard form analytic workspace, then how to populate it manually from various sources using the OLAP DML.
The OLAP DML has facilities to load data from these sources:

  • Flat files. The file reader commands load data from flat files, so that you can use data from spreadsheets, syndicated and government sources, or legacy database systems.
  • Relational tables. The OLAP DML SQL command enables you to issue most SQL commands from an analytic workspace. Using the SQL command, you can fetch data with appropriate data types from any relational table or view into an analytic workspace. OLAP tools, such as the DBMS_AWM package, use the SQL command to populate analytic workspaces.
  • EIF files. The IMPORT and EXPORT commands enable you to create standard form analytic workspaces from legacy Express databases. A conversion program is available for those containing Oracle Express Objects metadata.

All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

OLAP Topics