DATABASE SYSTEMS, METHODS AND COMPUTER PROGRAM PRODUCTS INCLUDING RECONFIGURABLE DYNAMIC TIME WINDOW MANAGEMENT

摘要

The database systems, method and computer program product include a database that stores temporal data, a database management system that partitions the database of temporal data into a first plurality of partitions for each of a second plurality of time intervals, and a dynamic time window manager for the database management system. The dynamic time window manager for the database management system is configured to automatically control the database management system, to create the first plurality of partitions prior to expiration of one of the time intervals for storing therein temporal data for an immediately succeeding time interval. The dynamic time window manager also is configured to automatically delete the first plurality of partitions that correspond to an oldest one of the second plurality of time intervals after expiration of the one of the time intervals. A reconfigurable time window manager also may be provided that is responsive to input of a desired number of partitions and/or a desired number of time intervals, to automatically control the database management system to maintain the desired number of partitions and/or the desired number of time intervals as the temporal data is accumulated. The reconfigurable dynamic time window manager may be configured to automatically control the database management system, to create at least one partition prior to expiration of one of the time intervals, for storing therein temporal data for an immediately succeeding time interval.