Invention Grant
- Patent Title: Prefix-based leaf node storage for database system
- Patent Title (中): 用于数据库系统的基于前缀的叶节点存储
-
Application No.: US13462815Application Date: 2012-05-03
-
Publication No.: US09149054B2Publication Date: 2015-10-06
- Inventor: Markku J. Manner , Simo A. Neuvonen , Vilho T. Raatikka
- Applicant: Markku J. Manner , Simo A. Neuvonen , Vilho T. Raatikka
- Applicant Address: US NY Armonk
- Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Current Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
- Current Assignee Address: US NY Armonk
- Agent Marcia L. Doubet
- Priority: EP11172837 20110706
- Main IPC: G06F17/30
- IPC: G06F17/30 ; A23G1/00

Abstract:
Operating a database system comprises: storing a database table comprising a plurality of rows, each row comprising a key value and one or more attributes; storing a primary index for the database table, the primary index comprising a plurality of leaf nodes, each leaf node comprising one or more key values and respective memory addresses, each memory address defining the storage location of the respective key value; creating a new leaf node comprising one or more key values and respective memory addresses; performing a memory allocation analysis based upon the lowest key value of the new leaf node to identify a non-full memory page storing a leaf node whose lowest key value is similar to the lowest key value of the new leaf node; and storing the new leaf node in the identified non-full memory page.
Public/Granted literature
- US20130013890A1 DATABASE SYSTEM Public/Granted day:2013-01-10
Information query