A method, system, and computer program product provides a data dictionary
that can represent multiple versions of the schema objects, and which
provides improved performance, reduced computing costs, and more accurate
results in a variety of applications, such as in a database redo log
mining system. A method of providing a data dictionary comprises the
steps of determining whether information about the data object is present
in a denormalized data dictionary history table, and if the information
about the data object is not present in the denormalized data dictionary
history table, then querying a normalized data dictionary to obtain the
information about the data object, including a version identifier of the
data object, and storing the version identifier and the obtained
information about the data object including the version identifier in the
denormalized data dictionary history table.