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.