Invention Grant
- Patent Title: Reorganizing database tables
- Patent Title (中): 重组数据库表
-
Application No.: US13105536Application Date: 2011-05-11
-
Publication No.: US08386445B2Publication Date: 2013-02-26
- Inventor: Randy L. Egan , Rafal P. Konik , Roger A. Mittelstadt , Mark W. Theuer
- Applicant: Randy L. Egan , Rafal P. Konik , Roger A. Mittelstadt , Mark W. Theuer
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Patterson & Sheridan LLP
- Main IPC: G06F7/00
- IPC: G06F7/00

Abstract:
Techniques are disclosed for reorganizing rows of a database table. In one embodiment, each row is associated with a respective row identifier. A mapping is provided that assigns a logical identifier to each row identifier. Each database index on the database table is configured to use the logical identifier rather than the row identifier. Accordingly, the rows of the database table may be reorganized without having to modify any database index on the database table.
Public/Granted literature
- US20120290588A1 REORGANIZING DATABASE TABLES Public/Granted day:2012-11-15
Information query