OBIEE - Oracle BI Server Execution Engine

Bi Server Architecture

Parallel SQL Execution Engine

The Oracle BI Server execution engine is a parallel SQL execution engine extended with analytical execution operators.

It leverages the sophisticated technology and architectural concepts developed over the past 20 years in the database research community. Some of its key features:

  • Function Shipping:

The Oracle BI Server ships directives for native SQL query strings; directives to execute one or more aggregation passes; and directives for various types of filters to the source database.

  • Parallel Query Execution:

The Oracle BI Server allows multiple queries to be submitted and executed in parallel, perhaps on different machines. Any cancellations would also be done in parallel.

  • Sort Optimizations:

If sorts required for the FULL OUTER JOIN cannot be pushed to the databases, the Oracle BI Server has facilities to allow sorts to be done in parallel. It ensures that no rows are lost between the two queries.

  • Merge:

The Oracle BI Server has sophisticated join facilities to merge two or more result sets from several parallel queries.

  • Ranking and Filtering:

The Oracle BI Server can rank and filter rows efficiently.

Discover More
Bi Server Architecture With Client
OBIEE - BI Server (OBIS|nqsserver|nqs)

OBI Server is also known as: OBIS (Oracle Business Intelligence Server) or nqsserver (The process name) OBI Server is principally a query and analysis server software: that can integrate data...
Bi Server Architecture
OBIEE - Query Compiler

The query compiler is responsible of the compilation of a logical sql in the query processing process of BI Server. The query compilation is composed of the following five phases: parsing, , navigation,...
Bi Server Architecture
OBIEE - Query Processing (What happens when you issue an Logical SQL Request (through Answers for instance) ?

Query processing in OBIEE Logical SQL Request Logical Request Generation (Logical SQL Request with security) Query compilation Cache service. The server will check to see if this request can...

Share this page:
Follow us:
Task Runner