MANAGING AN INDEX OF A TABLE OF A DATABASE

摘要

A method, a system, and a computer program product for managing a database are disclosed. Managing the database includes managing an index of a table of the database. Managing the index includes determining the table includes a first field having a first input value configured to identify a first dynamic data function utilized to determine a first output value for the first field. In embodiments, managing the index includes determining the first dynamic data function is deterministic, determining the first output value for the first field using the first dynamic data function, and storing the first output value for the first field. In embodiments, managing the index includes determining the first dynamic data function is nondeterministic, determining a first special value to represent the first output value for the first field, and storing the first special value for the first field.

主权项

1. An apparatus, comprising:
a processor; and a memory coupled to the processor, wherein the memory comprises instructions which, when executed by the processor, cause the processor to: determine a table includes a first field having a first input value configured to identify a first dynamic data function utilized to determine a first output value for the first field, determine, in response to a request to create an index including the first field, whether the first dynamic data function is deterministic, determine, in response to determining the first dynamic data function to be deterministic, the first output value for the first field using the first dynamic data function, and store in the index, in response to determining the first output value for the first field, the first output value for the first field.