Patent ID: 8688658
Filing Date: 2014-04-01
Classification: G06F,Y10S

Abstract:
1. A method, on an information processing system, for preserving information in time variant data schemas, the method comprising: intercepting at least one modification request associated with a database schema prior to a modification being made to the database schema based on the modification request; identifying, based on the modification request and prior to a modification being made to the database schema based on the modification request, a modification type associated with a modification to be performed on the database schema by the modification request, wherein the modification type identifies a specific modification to be performed on the database schema by the modification request; altering, prior to a modification being made to the database schema based on the modification request, the modification request by adding at least one instruction to the modification request that instructs the modification request to add at least one entry to a metadata table associated with the database schema, wherein the metadata table is separate from the database schema, wherein the at least one instruction that is added to the modification request is dependent upon the modification type that has been identified, and wherein the altering is performed automatically and without user intervention based on the modification type that has been identified; and updating, by the modification request based on the at least one instruction added thereto, the metadata table to include the at least one entry associated with the modification request, wherein the entry identifies an instance in time when an action associated with the modification request was performed.