Invention Grant
- Patent Title: Database table compression
- Patent Title (中): 数据库表压缩
-
Application No.: US13690346Application Date: 2012-11-30
-
Publication No.: US08843456B2Publication Date: 2014-09-23
- Inventor: Andreas Christian , Joern Klauke , Sergiy Malikov , Jens Seifert
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Cantor Colburn LLP
- Agent Jeanine Ray
- Priority: EP11192043 20111206
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
Embodiments relate to table compression in a database. The database is organized in tables including rows and columns An aspect includes defining a range partition of a table of the database according to a first attribute of the table. Internal ranges of the table of the database are defined according to a second attribute of the table. A target internal range of the internal ranges is determined to insert a row as a new entry into the table. A determination is made as to whether an internal range compression directory exists for the target internal range. Based on determining that no internal range compression directory exists for the target internal range and a predefined threshold value of a number of rows is exceeded in the target internal range, the internal range compression directory for the target internal range is created.
Public/Granted literature
- US20140297605A9 DATABASE TABLE COMPRESSION Public/Granted day:2014-10-02
Information query