摘要 |
PROBLEM TO BE SOLVED: To provide an online analytical processing method using 2 level query by SQL parsing and result cashing, for drastically improving an activation of a request query for data base and a result provision speed.SOLUTION: An online analytical processing method includes: (a) a step S12 of generating a query (hereinafter, referred to as a basic query) referring to a table to which a request query refers while using a column name included in the request query as a reference item, and an extended query taking result data requested by the request query while referring to the result data of the basic query; (b) a step S13 of retrieving the result data of the basic query from a server cache, (c) a step S14 of requesting the database for data by the basic query if the result data is not available in the server cache, and (d) a step S15 of acquiring the result data by applying the extended query to the result data of the basic query. |