O'Reilly logo

Oracle Business Intelligence Enterprise Edition 12c - second Edition by Haroun Khan, Christian Screen, Adrian Ward

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

Repository architecture

Before we embark on developing a new repository, let's have a look at how the RPD is structured. The fundamental structure of an RPD is made up of three layers for modeling data:

  • Physical layer: This contains the information, for example table/column names and keys, for your data sources, as they exist in their database along with their connectivity details. No data is actually stored in the RPD, just references to your data sources, that is, it is metadata that is stored in it.

    If needed, we can also connect to other data sources, for example, Flat files and Excel spreadsheets.

  • Business layer: The main purpose of this layer is to create an abstract and simplified model of the physical layer objects. This is especially valuable ...

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