Abstract: In one embodiment, a source database table associated with a source system is received. Further, one or more fields of the received source database table are mapped with one or more fields in an archive file associated with a destination system using a pre-constructed template. One or more entries corresponding to the one or more fields of the source database table is generated in the archive file based on the mapped one or more fields. Furthermore, the source system is decommissioned upon generating the one or more entries in the archive file.

Abstract: Various embodiments of systems and methods of optimizing a database are described herein. Database tables are rated based on at least one of table size and table growth rate. One or more of the database tables are then selected based on the rating of the database tables. Archiving objects for the one or more selected tables are obtained. An archiving object includes one or more archiving programs and defines data related to a business object. The archiving objects are ranked based on dependencies between them. Based on the ranking of the archiving objects, an archiving schedule including an archiving order for the archiving objects is generated. The archiving schedule is then displayed.

Abstract: A system and method provide for an application for matching metadata from a transaction in an online transaction processing subsystem of an enterprise system to query metadata in an online analytical processing subsystem. A business object type is identified from a transaction in the online transaction subsystem using an object repository key and a corresponding data object attribute is determined from a mapping table. A new query of metadata from the online analytical processing subsystem is run, using the value of the data object attribute as a filter. This may allow for the generation of dynamic related report results for the transaction.