OBIEE - BI Server (OBIS|nqsserver|nqs)
Table of Contents
1 - Introduction
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:
The Weblogic biserver is a Weblogic managed server and not an OBIEE BI Server.>
The Oracle BI Server exposes its data dictionary (the presentation layer) through a standard ODBC 2.0 and a JDBC compliant interface. Clients of the Oracle BI Server see then a logical schema view (the presentation layer) independent of the source physical database schemas.
Oracle BI Server clients (such as Presentation Service) submit simplified logical SQL, which ultimately gets translated by the server to some combination of physical SQL sent to the back-end databases (or files), in addition to intermediate processing within the Oracle BI Server Execution Engine.
Repository design is the creation and configuration task of this three layer and is the most important development part of BI Server.
The Oracle BI Server infrastructure includes facilities such as:
- statistics logging (log),
2 - Articles Related
3 - Architecture features
3.1 - Query Processing
To process the logical sql query in the most efficient way possible, the server includes:
3.2 - Performance and scalability
The Oracle BI Server Design offers several performance and scalability optimizations including:
- sophisticated optimization algorithms
- custom heap memory management to avoid memory contention issues
- hashing to avoid central locking
- specialized synchronization mechanisms such as spin latches
- high-throughput connectivity adapters.
- latch contention
to optimize query processing and analysis.
When performance requirements exceed the capability of a single server, Oracle BI Servers can be clustered together with session replication and automatic fail-over.
3.3 - Multithreaded Architecture
In Windows, the BI Server runs as a multithreaded service, and in UNIX, as a multithreaded process. The server loads all the metadata stored and processes queries based on what is configured in the repositories (The BI Server can access multiple repositories)
4 - Accessing Oracle BI Server
Oracle BI Server presents itself through the presentation layer to other applications as an ODBC 2.0 and JDBC data source. This means that virtually any ODBC-JDBC-capable report writer or query tool can use the Oracle BI Server as if it were a relational database.
When it does, the query/reporting tool:
- does not need connectivity to underlying data sources;
- is completely insulated from changes in source tables and database platforms;
- immediately becomes aggregate aware;
- automatically takes advantage of the built-in security and connection pooling,
- and can use all the measures and columns of the subject area as if they were stored in a single simple database schema.
Users of these tools are insulated against returning erroneous results as a result of incorrect table joins or missing data – SQL traps sometimes known as:
- chasm traps,
- fan traps,
- or missing data traps.