Two-stage query processing system with integrated cache table

摘要

In a query for requesting big data, a system is provided that reduces data load time and suppresses the generation of a large amount of basic queries according to reference conditions. A processing server includes a basic query for requesting big data by referring to a data cube and an extended query for requesting big data by referring to a server cache from a request query of the data cube requested by a client. Generate. Whether or not a parent query for the basic query exists is searched, and if not searched, a parent query of the basic query is generated and registered. The basic query is corrected with the same content as the parent query, and the extended query is corrected to a query that references the parent cache by the parent query. When the data of the parent cache is loaded from the data cube and loaded, it is loaded in the unit cache unit constituting the parent cache. When the corrected extended query is processed, it is referenced in the unit cache unit of the parent cache. [Selection] Figure 12