Database insert with deferred materialization
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.
1. A system for inserting data into a database object comprising:
at least one processor configured to:
associate 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, bypass the database object and insert the data directly into a database log; and
insert the data from the database log into the database object and materialize 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 system 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 system of claim 1 , wherein the parameter specifies deferred materialization and the materialization is performed asynchronously to the data insertion.
4. The system of claim 3 , wherein the processor is further configured to:
insert 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 from the database log 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 system of claim 1 , wherein the parameter specifies materialization of an index and the data is accessible upon insertion.
6. The system of claim 5 , wherein the materialization is performed asynchronously to the data insertion, and the processor is further configured to:
insert the data into a database log and construct 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 system of claim 2 , wherein the processor is further configured to:
insert the data into a database log; and
read the log to replicate the database object.
8. A computer program product for inserting data into a database object comprising:
a computer readable storage device having computer readable program code embodied therewith for execution on a processing system, the computer readable program code comprising computer readable program code configured to:
associate 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, bypass the database object and insert the data directly into a database log; and
insert the data from the database log into the database object and materialize 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.
9. The computer program product of claim 8 , 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.
10. The computer program product of claim 8 , wherein the parameter specifies deferred materialization and the materialization is performed asynchronously to the data insertion.
11. The computer program product of claim 10 , wherein the materialization includes:
identifying data in the database log associated with deferred materialization and extracting identified data from the database log 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.
12. The computer program product of claim 8 , wherein the parameter specifies materialization of an index and the data is accessible upon insertion.
13. The computer program product of claim 12 , wherein the materialization is performed asynchronously to the data insertion, and the computer readable program code is further configured to:
insert the data into a database log and construct 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 from the database log 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.