TWO-STAGE QUERY PROCESSING SYSTEM FOR INTEGRATION FOUNDATION OF CACHE TABLE

摘要

PROBLEM TO BE SOLVED: To provide a system which can reduce a data loading time and can suppress generation of a large amount of basic queries according to a reference condition in a query for requesting big data.SOLUTION: A processing server 50 creates a basic query for requesting big data with reference to a data cube and an expansion query for requesting big data with reference to a server cache, from a request query of the data cube requested by a client. The processing server makes a search to determine whether there is a parent query for the basic query, and creates and registers a parent query for the basic query if no parent query has been found. The basic query is corrected with the same content as the content of the parent query and the expansion query is corrected to a query which refers to the parent cache by the parent query. When data of the parent cache is fetched from the data cube and is loaded, the loading is done per unit cache of the parent cache. When the corrected expansion query is processed, reference is made per unit cache of the parent cache.SELECTED DRAWING: Figure 12