Sap Se

Sumanth Hegde

Santosh V

Tarun Shetty

Santosh Vijayan

Dharshan A

According to an embodiment of the present disclosures, systems, methods, and non-transitory computer-readable mediums having program instructions thereon, provide for process of segregating data from database tables into different layers depending on the frequency of access to the data&#x2014;so that each layer of the data can be stored in an appropriate storage mechanism. For example, infrequently-accessed data can be stored in a hard disk drive (HDD) and frequently-accessed can be stored in random-access memory (RAM). Further, the data can also be stored in a sold-state drive (SSD) or other memory-storing devices. In an embodiment, grading attributes are used to layer the data and, accordingly, segregate the data into appropriate storage mechanisms.

Data aging in hana using grading attributes

A method and system for accessing data in a de-commissioned legacy system are provided. Data are automatically extracted from the legacy system, although data structure(s) of the legacy system might not be known, by finding views corresponding to a query for the data. Attributes, metadata, and/or fields ('attributes') can be parsed from the query. Tables and/or fields including the parsed attributes are identified. Views can be then identified, where the views contain the tables and/or fields including the parsed attributes. The views can be ranked in an order from those that include the greatest number of parsed attributes to those including the least number of parsed attributes. A data request understandable by the legacy system, e.g. a packet, can then be formed using the least number of views, where the views can collectively include all of the parsed attributes.

Automated metadata lookup for legacy systems

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.

System decommissioning through reverse archiving of data

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.

Dynamic relevant reporting

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.

Automated Database Archiving

The disclosure generally describes computer-implemented methods, software, and systems for providing a generic semantic layer for in-memory database reporting. One computer-implemented method for combining online transactional processing and online analytical processing in an in-memory database, comprises: retrieving two or more tables from an online transaction processing system; identifying related tables among the two or more tables; determining relationships between the related tables; determining a measure based on the relationships; and outputting the measure.

Growing community of inventors

Bengaluru, India

Sumanth Hegde