Invention Grant
US09230008B2 System and method for automated online reorganization of sequential access databases 有权
用于顺序访问数据库的自动在线重组的系统和方法

System and method for automated online reorganization of sequential access databases
Abstract:
Various systems, non-transitory computer readable media, and methods reorganize data records of a database in response to an efficiency parameter. A system may use an efficiency parameter that indicates a satisfactory level of organizational efficiency of at least a portion of a database table having a group of rows stored using a plurality of data blocks. The system may determine an efficiency of the group of rows based on a number of data block changes that occur during a sequential access of the group of rows. When the determined efficiency is less than the efficiency indicated by the efficiency parameter, the server may generate a control card to reorganize the group of rows when the efficiency is not satisfactory. The control card is used by an online reorganization process that reorganizes the group of rows.
Information query
Patent Agency Ranking
0/0