Database insert with deferred materialization

Patent metadata

Field	Value
Publication number	US-9390111-B2
Application number	US-201414296035-A
Country	US
Kind code	B2
Filing date	Jun 4, 2014
Priority date	Sep 16, 2013
Publication date	Jul 12, 2016
Grant date	Jul 12, 2016

Abstract

According to one embodiment of the present invention, a system inserts data into a database object. The system associates the database object with a parameter specifying materialization of data for the database object. The system inserts data into the database object and materializes the data in accordance with the parameter to provide access to the data from the database object, wherein the parameter specifies a portion of the data to be materialized upon insertion. Embodiments of the present invention further include a method and computer program product for inserting data into a database object in substantially the same manners described above.

First claim

What is claimed is:

1. A computer-implemented method of inserting data into a database object comprising:
associating the database object with a parameter specifying materialization of data for the database object;
upon receiving a request to insert data into the database object, bypassing the database object and inserting the data directly into a database log; and
inserting the data from the database log into the database object and materializing the data in accordance with the parameter to provide access to the data from the database object, wherein the parameter specifies a portion of the data to be materialized upon insertion.

2. The computer-implemented method of claim 1 , wherein the parameter specifies that no data is to be materialized upon insertion into the database object, thereby precluding reading of the data from the database object.

3. The computer-implemented method of claim 1 , wherein the parameter specifies deferred materialization and the materialization is performed asynchronously to the data insertion.

4. The computer-implemented method of claim 3 , wherein the inserting the data includes:
inserting the data into a database log; and
wherein the materialization includes:
identifying data in the database log associated with deferred materialization and extracting identified data designated for insertion into the database object; and
materializing the extracted data within the database object and one or more indexes to provide access to the data from the database object.

5. The computer-implemented method of claim 1 , wherein the parameter specifies materialization of an index and the data is accessible upon insertion.

6. The computer-implemented method of claim 5 , wherein the materialization is performed asynchronously to the data insertion, and the inserting the data includes:
inserting the data into a database log and constructing the index with pointers to the database log to provide access to the data; and
wherein the materialization includes:
identifying data in the database log associated with the index materialization and extracting identified data designated for insertion into the database object; and
materializing the extracted data within the database object and one or more indexes to provide access to the data from the database object.

7. The computer-implemented method of claim 2 , further comprising:
inserting the data into a database log; and
reading the log to replicate the database object.

Assignees

• IBM

Inventors

• Kozin Daniel
• Lin Meichi M
• Marais Arthur
• Slinger Nigel G
• Tobler John B
• Zhu Wen J

Classifications

• G06F17/30292 Primary

  Physics · mapped topic

• G06F17/30383

  Physics · mapped topic

• G06F16/211 Primary

  Schema design and management · CPC title

• G06F16/2393 Primary

  Updating materialised views · CPC title