Invention Grant
- Patent Title: Table creation for partitioned tables
- Patent Title (中): 分区表的表创建
-
Application No.: US13336942Application Date: 2011-12-23
-
Publication No.: US08880565B2Publication Date: 2014-11-04
- Inventor: Lars Fricke , Christian Bensberg
- Applicant: Lars Fricke , Christian Bensberg
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Mintz Levin Cohn Ferris Glovsky and Popeo, P.C.
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
A table creation request pertaining to a table in a database maintained on a multi-node data partitioning landscape that comprises a plurality of processing nodes can specify a number of partitions to be generated. At run time, a currently available number of processing nodes in the multi-node data partitioning landscape can be queried, and this currently available number of processing nodes can be compared with the specified number of partitions to be generated for the created table. The table can be generated with the specified number of partitions such that the generated partitions are located across the plurality of partitions according to a load balancing approach if the number of processing nodes equals the number of partitions to be generated or according to other information in the table request if the number of processing nodes does not equal the specified number of partitions.
Public/Granted literature
- US20130166606A1 TABLE CREATION FOR PARTITIONED TABLES Public/Granted day:2013-06-27
Information query