Loading patent…
AssigneeInternational Business Machines Corporation
InventorsJames L FINNIE, Sam S LIGHTSTONE, Richard S SIDLE, Adam J. STORM
Estimating the term…
In updating a synopsis table of a database system, a database management unit performs a transaction to insert row(s) in a section of the base table and determines whether a synopsis entry for the section is stored in the memory. If stored in the memory, the in-memory synopsis entry is retrieved and metadata values in the in-memory synopsis entry are updated with data from the row(s) to be inserted. If not stored in the memory, the in-memory synopsis entry is generated and the metadata values in the in-memory synopsis entry are updated with data from the row(s). The insert transaction is then committed. Synopsis entry on-disk updates are thus avoided, significantly reducing the cost of updating the synopsis entries from the insert transaction. This yields enhanced performance especially for inserts of a small number of rows, while the benefits of synopsis entries are still available.
A method for regenerating a missing in-memory synopsis entry corresponding to a section of a base table stored in a storage medium comprised in a database system, the storage medium further storing a synopsis table, the database system further comprising a memory and a database management unit for implementing the method comprising:
A database system comprising:
A computer program product for regenerating a missing in-memory synopsis entry corresponding to a section of a base table stored in a storage medium comprised in a database system, the storage medium further storing a synopsis table, the computer program product comprising a computer readable storage medium having program instructions embodied therewith, the program instructions executable by a processor to cause the database system to perform a method comprising:
Dependencies are inferred from the claim text.