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

Some definitions

Acronyms

Definitions

ETL

Extract, Transform, and Load: The process of taking data from a source system into a warehouse.

SQL

Structured Query Language: The basic language that databases such as Oracle and SQL Server understand. SQL is used to create data, create database objects such as tables, and to query data.

Performance Data

I use this term to describe any data which helps to speed up reporting performance. This includes creating aggregate tables, for example the Tournament Fact table. It also includes the use of subsets of data, partitioning of tables, and indexing.

Star Transformation

A special feature of Oracle databases is their ability to maximize the performance of a query that uses a star design table ...

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