Patent ID: 8495056
Filing Date: 2013-07-23
Classification: G06F

Abstract:
1. A method of predictive report caching in a database system, the method comprising: recording, by a processing device, a user identification, a timestamp including a connection date, and a query associated with a report requested by a user from the database system for each connection of the user identification to the database system during a predetermined period; defining, by the processing device, a plurality of intervals in the predetermined period based on a pattern of user identification connections to the database system; retrieving, by the processing device, instances of the user identification associated with connections of the user identification to the database system during a threshold number of the plurality of intervals based on a position that a current date occupies in a current interval, such that a position of each connection date in a respective interval is the same as the position that the current date occupies in the current interval, the respective interval and the current interval being the same; executing, by the processing device, the query to generate the report from the database system on the current date associated with a current connection of the user identification to the database system prior to a request for the report from the user; and storing, by the processing device, the report generated in a cache.