On-demand multi-version denormalized data dictionary to support log-based applications

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.