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 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.