The server provides centralized data access to all business related information in a corporate entity.
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.
Query compilation in BI server has five phases: The multi-functional parser accepts the full ANSI SQL92 syntax as its input and its main function is to generate a parse tree which is a tree data structure that represents the syntactic structure of a string as its output.
The phase of rewriting covers: Code generation in the server produces native query processing language directives to communicate with remote databases.