MATERIALIZING INTERNAL COMPUTATIONS IN-MEMORY TO IMPROVE QUERY PERFORMANCE

摘要

Techniques are described for materializing computations in memory. In an embodiment, responsive to a database server instance receiving a query, the database server instance identifies a set of computations for evaluation during execution of the query. Responsive to identifying the set of computations, the database server instance evaluates at least one computation in the set of computations to obtain a first set of computation results for a first computation in the set of computations. After evaluating the at least one computation, the database server instance stores, within an in-memory unit, the first set of computation results. The database server also stores mapping data that maps a set of metadata values associated with the first computation to the first set of computation results.

主权项

1. A method comprising:
receiving, by a database server instance, a query; responsive to receiving the query, identifying, by the database server instance, a set of computations for evaluation during execution of the query; wherein the set of computations includes a first computation; responsive to identifying the set of computations, evaluating the first computation, by the database server instance, to obtain a first set of computation results for the first computation; after evaluating the first computation, storing, by the database server instance within an in-memory unit, the first set of computation results; and storing, by the database server instance within the in-memory unit, mapping data that maps a set of metadata values associated with the first computation to the first set of computation results.