Change management system for data synchronization within an enterprise portal application

A method for maintaining a cache in an enterprise portal application, comprising:

• synchronizing, by a change management system, a cache including cache data comprising table data and index data of one or more databases of an enterprise portal application, the synchronizing, in response to an indication that the cache is invalid, including:
• receiving a changeset comprising changes to the one or more databases,
• comparing the changeset to schema data, generated by a schema layer in communication with the change management system, to verify that the changeset is compatible with the cache data and the schema data, and
• at least one of passing the changeset to the cache for updating the cache data or refreshing the schema data by the schema layer.

A non-transitory computer readable medium including program instructions for execution by a processor of an enterprise portal application, the instructions causing the processor to:

• provide a cache including cache data comprising table data and index data of one or more databases of the enterprise portal application;
• provide a schema layer comprising database schema objects for representing the schema of the one or more databases, wherein the schema layer is configured to generate schema data representing the cache data;
• provide a change management system in communication with the schema layer and the cache and the one or more databases, wherein the change management system is configured to:
• validate, by the schema layer, that the cache data and data of the one or more databases are synchronized;
• and
• synchronize, in response to an indication that the cache is invalid, the cache data to the one or more databases by:
• receiving a changeset comprising changes to the one or more databases,
• comparing the changeset to the schema data for verifying that the changeset is compatible with the cache data and the schema data, and
• at least one of pass the changeset to the cache for updating the cache data or refresh the schema data by the schema layer.

A system for maintaining a maintained system in an enterprise portal application, comprising:

• at least one maintained system including maintained data comprising table data and index data of one or more source systems of the enterprise portal application;
• a schema layer comprising database schema objects for representing the schema of the one or more source systems, wherein the schema layer is configured to generate schema data representing the maintained data;
• a change management system in communication with the schema layer, the maintained system, and the one or more source systems, wherein the change management system is configured to:
• validate, by the schema layer, that the maintained data and source data of the one or more source systems are synchronized;
• and
• synchronize, in response to an indication that the maintained system is invalid, the maintained data to the source data by:
• receiving a changeset comprising changes to the one or more source systems,
• comparing the changeset to the schema data for verifying that the changeset is compatible with the maintained data and the schema data, and
• at least one of passing the changeset to the maintained system for updating the maintained data or refreshing the schema data by the schema layer.