Invention Grant
US09230008B2 System and method for automated online reorganization of sequential access databases
有权
用于顺序访问数据库的自动在线重组的系统和方法
- Patent Title: System and method for automated online reorganization of sequential access databases
- Patent Title (中): 用于顺序访问数据库的自动在线重组的系统和方法
-
Application No.: US13444951Application Date: 2012-04-12
-
Publication No.: US09230008B2Publication Date: 2016-01-05
- Inventor: Kevin P. Shuma , Joseph B. Lynn , Robert Florian
- Applicant: Kevin P. Shuma , Joseph B. Lynn , Robert Florian
- Applicant Address: US NY New York
- Assignee: CA, Inc.
- Current Assignee: CA, Inc.
- Current Assignee Address: US NY New York
- Agency: Myers Bigel Sibley & Sajovec, P.A.
- Main IPC: G06F17/30
- IPC: G06F17/30

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.
Public/Granted literature
- US20130275367A1 System and Method for Automated Online Reorganization of Sequential Access Databases Public/Granted day:2013-10-17
Information query