发明名称 Dynamic optimization of data aggregation
摘要 A method includes receiving a first database query, in which the first database query requests particular data associated with a first object that is stored on a data source. The method also includes determining whether the first database query includes an aggregation function. The method also includes sending an instruction to generate current aggregate data based on the aggregation function to the data source in response to determining that the first database query includes the aggregation function, in which the current aggregate data corresponds to the particular data. The data source is configured to generate the current aggregate data in response to receiving the instruction. The method includes generating a second database query based on the first database query, in which the second database query requests the current aggregate data. The method also includes retrieving the current aggregate data using the second database query and providing the current aggregate data.
申请公布号 US9256641(B1) 申请公布日期 2016.02.09
申请号 US201314057074 申请日期 2013.10.18
申请人 CA, Inc. 发明人 Zlatnik Pavel
分类号 G06F17/30 主分类号 G06F17/30
代理机构 Baker Botts L.L.P. 代理人 Baker Botts L.L.P.
主权项 1. A method comprising: receiving a first database query, the first database query requesting particular data associated with a first object, the first object stored on a data source; determining whether the first database query comprises an aggregation; sending an instruction to generate current aggregate data based on the aggregation to the data source in response to determining that the first database query comprises the aggregation, wherein: the instruction to generate the current aggregate data is generated based on the aggregation,the current aggregate data corresponds to the particular data,the data source is configured to generate the current aggregate data in response to receiving the instruction to generate the current aggregate data; generating a second database query based on the first database query in response to sending the instruction to generate the current aggregate data, the second database query requesting the current aggregate data; retrieving the current aggregate data using the second database query in response to generating the second database query; providing the current aggregate data in response to retrieving the current aggregate data; and issuing the first query in response to determining that the first database query does not comprise the aggregation.
地址 New York NY US