Sap Se

Sap Ag

Axel Herbst

Bernhard Brinkmoeller

Jan Nolte-Boemelburg

Mathias Roeher

Toni Fabijancic

Heiko Gerwens

Christian Bensberg

Marcus Pfeifer

Ralf Dentzer

Holger Schwedes

Knut Manske

Stefan Elfner

Ajalesh Puthenparambil Gopi

Santosh V

Herbert Hackmann

Veit Bolik

Tenzin Choegyen

Sharath Jois

Ulrich Marquard

Christian Kraus

Georg Fischer

Frank Rust

In a database environment including a plurality of logical object definitions having relationships defined according to a schema, and logical object instances following the logical object definitions include attribute names and respective attribute values indicating status of an enterprise in an enterprise resource planning system, the method can receive a starting exception definition specifying a first query against the logical object instances and derive a new exception definition based on the starting exception definition and one or more stored, acted-upon exception definition proposals. The first query can include one or more initial situational trigger conditions. The new exception definition can specify a second query against the logical object instances and the second query can include one or more modified situational trigger conditions.

Intelligent and automatic exception handling

A system, a method, and a computer program product for providing transparent access to multi-temperature data are disclosed. A query for accessing data is received. The query includes at least one selection parameter for retrieval of data. The data is stored in a plurality of partitions of a database system. Each partition has a maximum data value per column, a minimum data value per column, and a predetermined date associated with the data contained in the partition. A determination is made whether at least one selection parameter is greater than the minimum data value per column and less than the maximum data value per column. The queried data is retrieved from the partition using the predetermined date associated with the data contained in the partition.

Transparent access to multi-temperature data

The user of an application may query a data storage system with a request to access a dataset from a database of the system. The system identifies at least one data access rule that is applicable to the dataset, with the at least one data access rule specifying at least one user group authorized to access a restricted portion of the dataset. The system identifies an authorized access group associated with the application user and compares it to the at least one user group authorized to access the restricted portion of the dataset. If the authorized access group associated with the user does not match one of the at least one user group authorized to access the restricted portion of the dataset, the system assembles a modified dataset based on the dataset and the at least one data access rule and transmits the modified dataset to the application.

Data access rules in a database layer

A database includes a plurality of partitions with respective partition dates. A query is received for data from a view of the database, the query containing a filtering parameter for retrieval of the data. A definition of the view is analyzed to determine a table of the database that contributes to the view and an aging object associated with the table. A restriction rule associated with the aging object is identified, for example, based on an annotation in the definition of the view. A restriction date for the aging object is determined based on the restriction rule. A partition, from the plurality of partitions, is selected based on the partition date of the partition being equal to or later than the restriction date. The queried data is retrieved from the selected partition according to the filtering parameter and a response to the query is generated based on the retrieved data.

Optimizing data access based on data aging

According to some embodiments, a database, containing entries, may be stored across first and second storage medium, entries in the second storage medium being default invisible for online transactional processing. A central software layer processor between the database and an application may identify a subset of the entries stored in the first storage medium as being default visible for online transactional processing, wherein entries stored in the first storage medium that are not within the subset are default invisible for online transactional processing. Note that entries in the first storage medium may be accessible by the application more quickly as compared to entries in the second storage medium.

Systems and methods to manage online analytical and transactional processing for an in-memory columnar database

Embodiments relate to data archiving utilizing an existing big data platform (e.g., HADOOP) as a cost-effective target infrastructure for storage. Particular embodiments construct a logical structure (hereafter, 'vault') in the big data platform so that a source, type, and context of the data is maintained, and metadata can be added to aid searching for snapshots according to a given time, version, and other considerations. A vaulting process transforms relationally stored data in an object view to allow for object-based retrieval or object-wise operations (such as destruction due to legal data privacy reasons), and provide references to also store unstructured data (e.g., sensor data, documents, streams) as attachments. A legacy archive extractor provides extraction services for existing archives, so that extracted information is stored in the same vault. This allows for cross queries over legacy data and data from other sources, facilitating the application of new analysis techniques by data scientists.

Data archive vault in big data platform

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 computer-implemented method for archiving information includes: executing a first application in a first process; determining that the first application is an archiving application configured to archive information stored in a transactional system; assigning, based on the determination, an archiving mode to the first process; receiving, from the first process and after assigning the archiving mode, a request to delete information; and processing the request to delete information according to the archiving mode.

Archiving&#x2014;safe replication of relational data

Archiving-safe replication of relational data

A method of anonymize business data. The method includes responsive to a request from an application for data objects stored in a database system, retrieving the data objects from a non-transitory storage of the database system, prior to transmitting the data object to the application, retrieving pre-determined rules from a rule engine, wherein the rules include conditions for retaining data, comparing the request against the rules to determine portions of the data objects that are to be anonymized, anonymizing the portions of the data objects, and transmitting the data object to the application.

Rule-based anonymizer for business data

Methods, systems, and software for enforcing archival of data objects into archive objects and managed destruction of the archive objects are disclosed. In some cases, the computer techniques include enforcing a retention rule, such as a retention date and archive properties, and a destruction indication, such as an expiration date, of data identified for archival. The data objects are archived under hierarchical paths in a long-term storage system according to retention-related properties of the data objects and the retention rules. Further, the archived data can be destroyed according to destruction indications. Once archived, destruction of the data may be prevented by a hold applied to the data.

System, method, and software for enforcing information retention using uniform retention rules

Systems, methods, and software for archiving structured data and associated unstructured data associated are disclosed. Particularly, the structured and unstructured data are archived such that the structured data and the unstructured data remain associated to each other. Properties of the structured data are also applied to the unstructured data, enabling the unstructured data to be retained with the structured data throughout the retention period of the structured data. Moreover, destruction (or prevention of destruction) of the archive data object can be managed and propagated to the unstructured data instances.

System, method, and software for managing information retention using uniform retention rules

Methods and apparatus, including computer program products, for processing data objects having data items. The method includes classifying each data object into a write-enabled object or a read-only object, storing write-enabled data objects in a database, and archiving read-only data objects. The archiving includes converting the data objects to markup objects, wherein each markup object represents the data items of the corresponding data object, concatenating the markup objects to a single data structure that is byte addressable, and indexing object identification for each markup object to addresses of the data structure.

Growing community of inventors

Eppingen, Germany

Axel Herbst