Oracle BI Server

Oracle BI Server

As it was written above the OBIEE consists of 8 interdependent components. Each of them is described in detail below:

Oracle BI Server is a high-impact query, reporting and analysis server that provides services to the other components of the Business Intelligence Suite such as Answers, Dashboards, Data Mining, Reporting, and Analytic Applications. The Oracle BI Server uses ODBC 2.0 //Open Database Connectivity provides a standard software API method for using database management systems// and JDBC //Java Database Connectivity is an API for the Java programming language that defines how a client may access a database// interfaces to shows its services. The services of the BI server have two primary functions. Firstly, they compile incoming query requests into an executable code and then execute the code. Clients of the BI Server work with a logical data /simplified logical SQL/ independent of the data sources, and they submit them to the BI server. The server translates the data to some combination of physical SQL and sends them to the back-end databases. Server administration functions include facilities such as monitoring, statistics logging, cancellation, session and query management, and others. The administration of the server is managed internally with using standard protocols e.g. AD //Active Directory is an implementation of LDAP services// or LDAP//The Lightweight Directory Access Protocol is an application protocol for querying and modifying directory services running over TCP/IP//.

Query compilation has five phases:

• parsing
• logical request generation
• navigation
• rewrite
• code generation