Abstract: Systems, methods, and other embodiments associated with patching database objects while a database system is online are described. In one embodiment, a patch command is defined and identifies a database code object, wherein the patch command is configured to modify code of the database code object. A serialized lock is requested from the database system for the database code object, wherein the serialized lock prohibits executing applications of the database system from accessing the database code object. In response to receiving the serialized lock from the database system, the code of the database code object is modified with a patch code to generate a modified database code object. The modified database code object is compiled and the serialized lock on the database code object is released to allow other executing applications to call and access the database code object.

Abstract: A database system provided according to an aspect of the present disclosure provides indexed data for non-deterministic functions. In an embodiment, a request to maintain an indexed data for a non-deterministic function is received. The non-deterministic function specifies a set of input variables and a set of output variables and a manner in which respective output values are generated for the set of output variables based on corresponding input values for the input variables. Generating output values entails performing operations defined based on a set of data classes in the database system. An indexed data is formed, indicating corresponding output values for respective set of input values present in the set of data classes in the database system. The indexed data is updated when a change to data elements of a first data class of the set of data classes is processed.

Abstract: A database system provided according to an aspect of the present disclosure provides indexed data for non-deterministic functions. In an embodiment, a request to maintain an indexed data for a non-deterministic function is received. The non-deterministic function specifies a set of input variables and a set of output variables and a manner in which respective output values are generated for the set of output variables based on corresponding input values for the input variables. Generating output values entails performing operations defined based on a set of data classes in the database system. An indexed data is formed, indicating corresponding output values for respective set of input values present in the set of data classes in the database system. The indexed data is updated when a change to data elements of a first data class of the set of data classes is processed.