Query Cache Architecture

-
The query cache consists of cache storage space, cache metadata, and cache detection in query
compilation.
The process of accessing the cache metadata is very fast. If the metadata shows a cache hit, the
bulk of the query processing is eliminated, and the results are immediately returned to the user. The process of adding the new results to the cache is independent of the results being returned to the user; the only effect on the running query is the resources consumed in the process of writing the cached results.

When a user request a query, the Presentation Server translate the query into Logical Query and send it to the BI Server. The BI Server searches the Cache Metadata for a matched Logical Query. If the matched Logical query is found (called as Cache Hit), then the results are retrieved from Query Cache by BI Server and sent it to Presentation Server. If the matched query is not found, then the BI server will generate the Physical Query and send it to the underlying Database. The Database processes the physical query and return the result to the BI Server, the Bi Server will send back the result set to Presentation Server and at the same time store the result set in the Query Cache.



Comments

Post a Comment

Thanks for your comment.

Popular posts from this blog

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P:OI2DL65P

-
Image
User gets the below shown error in Presentation Services when he try  to issue any requests to OBI Server. Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43081] Illegal operation attempted on a closed session. (HY000) The most possible reason for this error is :  The BI Server Administrator might have disconnected the current user's session and that user might be still sending request to the BI Server. Solution : When the BI Server Administrator disconnects USER from the current session, then such user can not send request to the BI Server. Because that user in no more in the session to request. Solution : Log out from the Presentation Services (just click on the Log Out button) and again Log in and check the same request.
Read more

Connection Pool

-
Image
The connection pool is an object in the Physical layer, it contains information about the connection between the Oracle BI Server and that data source. The Physical layer in the Administration Tool contains at least one connection pool for each database. When you create the physical layer by importing a schema for a data source, the connection pool is created automatically. You can configure multiple connection pools for a database.It is recommended that you create a dedicated connection pool for initialization blocks. About Connection Pools for Initialization Blocks It is recommended that you create a dedicated connection pool for initialization blocks. This connection pool should not be used for queries. Additionally, it is recommended that you isolate the connections pools for different types of initialization blocks. This also makes sure that authentication and login-specific initialization blocks do not slow down the login process. The following types should
Read more

Alias Table in OBIEE

-
Image
Alias table means it is a reference table for the physical Table. When you create any alias table, then the alias table will inherit all the properties of the physical table. We can not modify the alias table properties, like 1. can not rename the column name. 2. Can not change the  column data type . 3. Can not delete the columns But we can only change the alias table name according to our naming convention. Steps to create Alias table : 1. Right click on the physical table, New Object -->Alias 2. Give the name for alias table. Then click on OK. Advantages of Alias Table : 1. OBIEE does not support Circular join in BMM layer, so we can overcome from this problem by creating alias table for one of the table in that circular join. 2. OBIEE does not support self join, so we can overcome from this problem by creating alias table. 3. If a fact table having relationship with dimention table on more than one key, then we can create aliases for the dimension talbe, t
Read more