Invention Grant
- Patent Title: Bulk data insertion in analytical databases
-
Application No.: US15371565Application Date: 2016-12-07
-
Publication No.: US10296614B2Publication Date: 2019-05-21
- Inventor: Thomas F. Boehme , Andreas Brodt , Oliver Schiller
- 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: Edell, Shapiro & Finnan, LLC
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
A present invention embodiment relates to inserting data to a data table, where the data table has multiple data records and involves at least one organizing attribute. The embodiment defines a set of data blocks having records of the data table and assigns to each data block of the set of data blocks a predefined maximum number of records of the data table or a predefined maximum amount of storage. Data records for each data block of the set of data blocks may be stored on a storage system. Further data records may be sorted based on values of the organizing attribute in the buffered data records. The sorted data records may be written on the storage system in their order. Attribute value information may be determined for the further data blocks for supporting query processing against the data table.
Public/Granted literature
- US20180157694A1 BULK DATA INSERTION IN ANALYTICAL DATABASES Public/Granted day:2018-06-07
Information query