Invention Grant
- Patent Title: Method for searching a data page for inserting a data record
- Patent Title (中): 用于搜索数据页以插入数据记录的方法
-
Application No.: US11620187Application Date: 2007-01-05
-
Publication No.: US07693875B2Publication Date: 2010-04-06
- Inventor: Namik Hrle , Johannes Schuetzner , James Teng
- Applicant: Namik Hrle , Johannes Schuetzner , James Teng
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agent Grant A. Johnson
- Priority: EP06100154 20060109
- Main IPC: G06F12/00
- IPC: G06F12/00 ; G06F17/30 ; G06F9/26 ; G06F9/34

Abstract:
A method of searching a data page in a table space of a database for inserting a data record to a first table, wherein the table space comprises space map pages and sets of data pages, wherein each space map page comprises information about the available storage space of one set of data pages, wherein each space map page and the corresponding set of data pages is further assigned to a table range for each table to which at least one data page in the set of data pages belongs to, wherein the database further comprises a clustering index for the first table in the database management system, wherein the database management system comprises a space usage information database, and wherein the space usage information database holds space usage information for each table range.
Public/Granted literature
- US20070168640A1 METHOD FOR SEARCHING A DATA PAGE FOR INSERTING A DATA RECORD Public/Granted day:2007-07-19
Information query