1. A method of generating predictive reports in a database system, the method comprising: recording, by a processing device, a user identification, a timestamp and a query, the user identification associated with a user, the timestamp including a connection date, the query being associated with a report requested by the user from the database system for each connection to the database system associated with the user identification during a predetermined period; defining, by the processing device, a plurality of intervals in the predetermined period based on a pattern of connections to the database system associated with the user identification; retrieving, by the processing device, instances of the user identification associated with connections 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; and 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.