Sap Se

Sap Ag

Jan Nolte-Boemelburg

Axel Herbst

Toni Fabijancic

Mathias Roeher

Herbert Hackmann

Frank Rust

Archiving may be integrated into an organization's existing data management systems instead of being configured as a separate system. This integration may occur by adding an archiving table to an existing database of the organization containing data that is to be archived. The archiving table may include multiple records, each record storing a binary large object representing a complete, self-contained archive of the organization's data at a preselected time. Incorporating archiving and archived data into the organization's existing data management systems in this manner may eliminate the need for a dedicated archiving system and may eliminate synchronization and interconnectivity issues with an independent archiving system.

Embedding archived data in a data source

In one embodiment, a method determines data stored in a plurality of tables in a first database for archiving. The data is combined from the plurality of tables into a set of objects in a readable format where an object in the set of objects includes terms from the plurality of tables associated with the object. The method then stores the set of objects in the text format in a second database where a search query processor is able to search terms in the set of objects in the readable format. Then, the data stored in the plurality of tables in the first database is deleted in response to the archiving.

Archival of objects and dynamic search

Legacy computing system archive files may have unique data structures designed for long-term data retention purposes and not particularly suited for data mining, querying, and other data collection functions needed to prepare certain types of reports. A report specific template may be created to facilitate the extract of specific legacy system data necessary to complete report that is stored in legacy system archive files. Once the data objects containing information relevant to the report have been identified, a hierarchical list of tables and fields of each table associated with each identified data object may be obtained from an external data source for further selection. Copies of the selected table and/or field data may then be extracted, compared, and merged with other data, such as other field and table data, obtained from other sources.

Standardized framework for reporting archived legacy system data

A method and apparatus for deleting archived data are disclosed. Identification keys of archived data objects to be deleted from a database are requested. At least one data object identified in response to a request for the identification keys is deleted while additional identification keys of data objects to be deleted are requested.

Growing community of inventors

Bad Schoenborn, Germany

Jan Nolte-Boemelburg