Cache management method for storage device
    51.
    发明授权
    Cache management method for storage device 失效
    存储设备的缓存管理方法

    公开(公告)号:US06944711B2

    公开(公告)日:2005-09-13

    申请号:US10646699

    申请日:2003-08-25

    Abstract: A cache management method disclosed herein enables optimal cache space settings to be provided on a storage device in a computer system where database management systems (DBMSs) run. Through the disclosed method, cache space partitions to be used per data set are set, based on information about processes to be executed by the DBMSs, which is given as design information. For example, based on estimated rerun time of processes required after DBMS abnormal termination, cache space is adjusted to serve the needs of logs to be output from the DBMS. In another example, initial cache space allocations for table and index data is optimized, based on process types and approximate access characteristics of data. In yet another example, from a combination of results of pre-analysis of processes and cache operating statistics information, a change in process execution time by cache space tuning is estimated and a cache effect is enhanced.

    Abstract translation: 本文公开的高速缓存管理方法使得能够在数据库管理系统(DBMS)运行的计算机系统中的存储设备上提供最佳高速缓存空间设置。 通过所公开的方法,基于由作为设计信息给出的由DBMS执行的处理的信息来设置要针对每个数据集使用的高速缓存空间分区。 例如,基于在DBMS异常终止之后所需的进程的估计重新运行时间,调整缓存空间以满足要从DBMS输出的日志的需要。 在另一个示例中,基于数据的过程类型和近似访问特征来优化表和索引数据的初始高速缓存空间分配。 在另一个示例中,根据进程预分析和高速缓存操作统计信息的结果的组合,估计通过高速缓存空间调整的处理执行时间的改变,并且提高高速缓存效果。

    Cache management method for storage device
    52.
    发明申请
    Cache management method for storage device 失效
    存储设备的缓存管理方法

    公开(公告)号:US20040193803A1

    公开(公告)日:2004-09-30

    申请号:US10646699

    申请日:2003-08-25

    Abstract: A cache management method disclosed herein enables optimal cache space settings to be provided on a storage device in a computer system where database management systems (DBMSs) run. Through the disclosed method, cache space partitions to be used per data set are set, based on information about processes to be executed by the DBMSs, which is given as design information. For example, based on estimated rerun time of processes required after DBMS abnormal termination, cache space is adjusted to serve the needs of logs to be output from the DBMS. In another example, initial cache space allocations for table and index data is optimized, based on process types and approximate access characteristics of data. In yet another example, from a combination of results of pre-analysis of processes and cache operating statistics information, a change in process execution time by cache space tuning is estimated and a cache effect is enhanced.

    Abstract translation: 本文公开的高速缓存管理方法使得能够在数据库管理系统(DBMS)运行的计算机系统中的存储设备上提供最佳高速缓存空间设置。 通过所公开的方法,基于由作为设计信息给出的由DBMS执行的处理的信息来设置要针对每个数据集使用的高速缓存空间分区。 例如,基于在DBMS异常终止之后所需的进程的估计重新运行时间,调整缓存空间以满足要从DBMS输出的日志的需要。 在另一个示例中,基于数据的过程类型和近似访问特征来优化表和索引数据的初始高速缓存空间分配。 在另一个示例中,根据进程预分析和高速缓存操作统计信息的结果的组合,估计通过高速缓存空间调整的处理执行时间的改变,并且提高高速缓存效果。

Patent Agency Ranking