Abstract: 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—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.

Abstract: 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.

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: 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—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.

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.

Abstract: 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.

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: 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.

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: Techniques for performing a time period change analysis include identifying a performance indicator associated with a set of data, the performance indicator representing a statistical metric associated with the set of data; identifying one or more master data measures associated with the performance indicator from a plurality of master data measures, the performance indicator based on the one the master data measures; for each time period of a plurality of times periods, determining a value of the one or more master data measures; for each master data measure, determining a difference between the values of the master data measure associated with two time periods of the plurality of time period; and preparing the determined difference for display to a user through a graphical user interface.

Abstract: 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.

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.