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. A computer-implemented method of managing an index of a table of a database, the method comprising:
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; determining, in response to a request to create the index including the first field, the first dynamic data function is deterministic; determining, in response to the first dynamic data function being deterministic, the first output value for the first field using the first dynamic data function; and storing in the index, in response to determining the first output value for the first field, the first output value for the first field.