公开(公告)号：GB2524075A

公开(公告)日：2015-09-16

申请号：GB201404524

申请日：2014-03-14

Applicant: IBM

Inventor： RESE JOACHIM ,  MAYER GEORG ,  HRLE NAMIK

IPC: G06F17/30

Abstract: A method for updating a cache comprising identifying in a query instance that has led to a filling of the cache, a parameter whose values are monotonic ­in particular monotonically increasing or decreasing - over time, wherein the query instance has a first execution time. When generating a new query instance, at a second, later execution time - e.g., at ETL time - instead of the previous value of the parameter, a new value may be used that corresponds to the monotonic previous value at the second execution time. Finally, the new query instance is executed whereby the cache is updated with the results of the new query instance.

公开(公告)号：GB2524072A

公开(公告)日：2015-09-16

申请号：GB201404521

申请日：2014-03-14

Applicant: IBM

Inventor： RESE JOACHIM ,  MAYER GEORG ,  HRLE NAMIK

IPC: G06F17/30

Abstract: A method and builder for automatically generating an aggregate is provided. The method comprises, upon receiving a second query 102 comprising a filter criterion, determining 104 if at least a threshold number of previous first queries comprises a similar filter criterion, and if so generating 106 an aggregate using the similar filter criterion as aggregation criterion, such that future queries comprising the similar filter criterion are satisfied by the aggregate. The queries may be determined to be similar if they are the same or if the first query filter criteria is a subset of the second. The aggregate may be a materialized query table.