O'Reilly logo

Oracle Fusion Middleware Patterns by Markus Zirn, Harish Gaur

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

EMMA architecture

Knowledge Global chose Oracle BIEE, Oracle Hyperion Essbase, and Oracle Data Integrator to build the EMMA.

The following diagram demonstrates how EMMA integrates data from various data sources (predominantly raw utility meter data) into the EMMA operational database (OLTP). Small queries can be issued onto the OLTP database but large cross-sectional queries will be inefficient and slow.

This very granular data is then summarized into a data mart structure that allows fast interrogation by the OBIEE toolset.

The data mart data set is further summarized into the OLAP database, which allows real slicing and dicing of the data at a macro level. All three databases are able to be queried through the same toolset (via the OBIEE semantic ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required