Invention Grant
- Patent Title: Automatic reduction of table memory footprint using column cardinality information
- Patent Title (中): 使用列基数信息自动减少表内存占用
-
Application No.: US11732310Application Date: 2007-04-02
-
Publication No.: US07809771B2Publication Date: 2010-10-05
- Inventor: Jens-Peter Dittrich , Olaf Meincke , Guenter Radestock , Andrew Ross
- Applicant: Jens-Peter Dittrich , Olaf Meincke , Guenter Radestock , Andrew Ross
- Applicant Address: DE Walldorf
- Assignee: SAP AG
- Current Assignee: SAP AG
- Current Assignee Address: DE Walldorf
- Agency: Mintz, Levin, Cohn, Ferris, Glovsky & Popeo, P.C.
- Main IPC: G06F7/00
- IPC: G06F7/00

Abstract:
In a business system, one or more methods can be used to reduce an amount of redundancy in the storage of data. One implementation includes a method of reducing a memory footprint of a database table having multiple rows and one or more columns, in which each of the one or more columns has a cardinality, and the cardinality is a total number of different values in the rows of each column. The method includes comparing the cardinality with a total number of possible values in the rows of at least one column based on a width of the column. The method also includes reducing the width of the column if the cardinality is less than a threshold based on the total number of possible values in the rows of the column.
Public/Granted literature
- US20070233749A1 Automatic reduction of table memory footprint using column cardinality information Public/Granted day:2007-10-04
Information query