Abstract: The intermittent sampling of storage access frequency is performed by determining a duration of a collection window and a duration of an observation window within the collection window. A position of the observation window within the collection window is randomly selected, and frequencies of accesses of one or more storage objects during the observation window are observed. When a new access of a given storage object occurs, a delta time for the given storage object is calculated as the time of the observed access minus the timestamp of the most recent observed prior access of the given storage object. Optionally, the delta time of two sequential accesses of a given storage object in two different observation windows may be calculated as if the two different observation windows are immediately adjacent to each other.

Abstract: The intermittent sampling of storage access frequency is performed by determining a duration of a collection window and a duration of an observation window within the collection window. A position of the observation window within the collection window is randomly selected, and frequencies of accesses of one or more storage objects during the observation window are observed. When a new access of a given storage object occurs, a delta time for the given storage object is calculated as the time of the observed access minus the timestamp of the most recent observed prior access of the given storage object. Optionally, the delta time of two sequential accesses of a given storage object in two different observation windows may be calculated as if the two different observation windows are immediately adjacent to each other.

Abstract: In defining database objects for storage in a storage hierarchy, frequencies of accesses of a plurality of database objects over a predetermined time period are observed. A mean and standard deviation for the plurality of database objects are computed based on the observed frequencies of accesses of the plurality of database objects. A z-score for a given database object is determined based on a comparison of the frequency of access for the given database with the mean and standard deviation computed for the plurality of database objects by the computing processor; and a level in the storage hierarchy corresponding to the z-score of the given database object is determined. The given database object may then be stored at the level in the storage hierarchy corresponding to the z-score of the given database object.

Abstract: In defining database objects for storage in a storage hierarchy, frequencies of accesses of a plurality of database objects over a predetermined time period are observed. A mean and standard deviation for the plurality of database objects are computed based on the observed frequencies of accesses of the plurality of database objects. A z-score for a given database object is determined based on a comparison of the frequency of access for the given database with the mean and standard deviation computed for the plurality of database objects by the computing processor; and a level in the storage hierarchy corresponding to the z-score of the given database object is determined. The given database object may then be stored at the level in the storage hierarchy corresponding to the z-score of the given database object.

Abstract: In defining database objects for storage in a storage hierarchy, frequencies of accesses of a plurality of database objects over a predetermined time period are observed. A mean and standard deviation for the plurality of database objects are computed based on the observed frequencies of accesses of the plurality of database objects. A z-score for a given database object is determined based on a comparison of the frequency of access for the given database with the mean and standard deviation computed for the plurality of database objects by the computing processor; and a level in the storage hierarchy corresponding to the z-score of the given database object is determined. The given database object may then be stored at the level in the storage hierarchy corresponding to the z-score of the given database object.

Abstract: In defining database objects for storage in a storage hierarchy, frequencies of accesses of a plurality of database objects over a predetermined time period are observed. A mean and standard deviation for the plurality of database objects are computed based on the observed frequencies of accesses of the plurality of database objects. A z-score for a given database object is determined based on a comparison of the frequency of access for the given database with the mean and standard deviation computed for the plurality of database objects by the computing processor; and a level in the storage hierarchy corresponding to the z-score of the given database object is determined. The given database object may then be stored at the level in the storage hierarchy corresponding to the z-score of the given database object.

Abstract: The intermittent sampling of storage access frequency is performed by determining a duration of a collection window and a duration of an observation window within the collection window. A position of the observation window within the collection window is randomly selected, and frequencies of accesses of one or more storage objects during the observation window are observed. When a new access of a given storage object occurs, a delta time for the given storage object is calculated as the time of the observed access minus the timestamp of the most recent observed prior access of the given storage object. Optionally, the delta time of two sequential accesses of a given storage object in two different observation windows may be calculated as if the two different observation windows are immediately adjacent to each other.

Abstract: The intermittent sampling of storage access frequency is performed by determining a duration of a collection window and a duration of an observation window within the collection window. A position of the observation window within the collection window is randomly selected, and frequencies of accesses of one or more storage objects during the observation window are observed. When a new access of a given storage object occurs, a delta time for the given storage object is calculated as the time of the observed access minus the timestamp of the most recent observed prior access of the given storage object. Optionally, the delta time of two sequential accesses of a given storage object in two different observation windows may be calculated as if the two different observation windows are immediately adjacent to each other.

Abstract: A choose tree is generated at compile time to facilitate a determination if any partition of a range partitioned database table includes a particular key at runtime. To generate the choose tree at compile time, a query compiler receives a source code indicative of each partition of the range partitioned database table, and generates the choose tree from the source code at compile time where the choose tree is representative of a pre-computed binary search of the range partitioned database table. Thereafter, the choose tree can be interpreted/executed at runtime to facilitate a traversal of the choose tree for determining if any partition of the range partitioned database table includes the particular key.

Abstract: A method and system are provided to enable restoration of a base table and associated catalog table from a database. Table names and table identifiers are copied to a header of a storage media during a backup of the database. When a restore of a designated table is requested, table identifier data is extracted from the header of the storage media housing the backup of the database. Accordingly, the designated base table and associated catalog table(s) are restored from the storage media based upon data stored in the header of the storage media during the backup of the database.