首页>
外国专利>
AN ONLINE ANALYTICAL PROCESSING SYSTEM FOR BIG DATA BY CACHING THE RESULTS AND GENERATING 2-LEVEL QUERIES BY SQL PARSING
AN ONLINE ANALYTICAL PROCESSING SYSTEM FOR BIG DATA BY CACHING THE RESULTS AND GENERATING 2-LEVEL QUERIES BY SQL PARSING
展开▼
机译:缓存结果并通过SQL解析生成2级查询的大数据在线分析处理系统
展开▼
页面导航
摘要
著录项
相似文献
摘要
The present invention relates to an online analytical processing method for processing big data by caching results and generating two-level queries with SQL parsing in an analytical processing server which processes a request query for a database requested by a client. The method comprises: (a) extracting column names included in the request query by parsing the request query; (b) generating a query (hereafter referred to as a basic query) which refers to the same table referred to by the request query, with reference to the extracted column names, and an extended query which retrieves result data requested by the request query, with reference to the result data for the basic query; (c) searching the result data for the basic query in a server cache of the server; (d) requesting data with the basic query from the database, if the result data for the basic query is not found in the server cache, and then storing the result data for the basic query, which has been received from the database, in the server cache; and (e) obtaining result data for the extended query by applying the extended query to the result data for the basic query, and then transmitting the obtained result data to the client. As a result, the speed with which a query is processed in an analytical environment for business intelligence is specifically increased by caching data for a basic query among requested queries, thereby providing analytical results to a user in real time.
展开▼