Sap Se

Sap Ag

Sap Labs North America

Andreas Kemmler

Torsten Kamenz

Juchang Lee

Christian Bensberg

Norman May

Kyu Hwan Kim

Ki Hong Kim

Alexander Boehm

Sung Heun Wi

Chul Won Lee

Marcus Wefers

Kai Morich

Michael Schaffrath

Jeong Ae Han

Armin Risch

Reinhold Konnerth

Thierry Lieu

Abdelhak Nezzari

Christoph Glania

In an example embodiment, a tri-state variable associated with a table in a database indicates whether the table is automatically sorted at runtime or left unsorted. The value of the tri-state variable also indicates whether code associated with the table assumes the table will be sorted at runtime. In a situation where two parties have code that utilize the table, when the first ensures its code to no longer assumes the table will be sorted, they may set the value of the tri-state variable from automatic sorting enforced to automatic sorting recommended. In this state the table will still be automatically sorted at runtime. When the second ensures its code no longer assumes the table will be sorted, they may set the value of the tri-state variable from automatic sorting recommended to no automatic sort at which time the table is left unsorted.

Handling changes in automatic sort

A method may include receiving a query for data to be provided by a database server, wherein the query includes an indication of a maximum lag. The method may further include determining whether a hint is available to apply to the query, wherein the hint affects an execution of the query. When no hint is available, a baseline database server may be selected to be the database server. When the hint is available, a replication server or a cache server may be selected to be the database server based on the hint and the maximum lag. The query may be processed at the selected database server.

Query hints for caching and replication

A computer system includes a first database system that includes a plurality of tables, and a second database system that includes a subset of the tables in the first database system. The system identifies a plurality of reports that are currently generated using the second database system. The system also identifies a plurality of reports that are not currently generated using the second database system, but that are capable of being generated using the second database system, and displays a list of these reports on a computer display device. In an embodiment, the system further replicates one or more tables that are required for generation of additional reports from the first database system to the second database system.

Enhanced reporting system

A method of adding a program module to an installed program code. A data object having an interface for importation of data into and exportation of data out of the data object, the data object further comprising the program module, a switch identifier and a specification of a call to be inserted into the installed code is provided. Insert the call as specified by the specification of the data object into the installed program code and receive a setting for the switch from a user and storing the setting in a database table.

System and method for modular business applications

In an example embodiment, a delivery unit comprises a plurality of objects. The delivery unit is encapsulated within a transport container for delivery to an entity for installation. As new versions of the objects are created by modifying the source code, the modified versions of objects are included in the delivery unit along with unmodified versions of the remaining objects of the delivery unit. The modified versions of the objects are marked for installation, while the unmodified versions are not marked for installation. Upon installation, the objects marked for installation are extracted from the delivery unit while the objects not marked for installation are discarded. The extracted objects are then installed, thus updating any previous versions of the objects, while unmodified objects are not installed. In one representative embodiment, objects are procedures of a database system, which may be organized hierarchically into folders.

Content maintenance optimization

Methods and systems provide integrated reporting for analytics. A flexible solution may be provided via an integrated delivered reporting model for various deployment scenarios. A customer landscape can vary, e.g., including an on-premise product, an on-demand product, or a combination thereof. The products may originate from more than one vendor. A report may be generated based on a virtual data model (VDM) and be compatible with a variety of scenarios and views for cross-reporting. A report may be generated for various deployment scenarios. A report may be generated for data stored in a relational storage apparatus (e.g., a database) with data structure(s) reflected in a corresponding VDM. Methods and systems provide automatic deployment of VDM parts into different storage apparatus/schema and automatic set up of relevant mapping, e.g., schema mapping.

Integrated reporting for on-demand and on-premise solutions

A system includes reception of a plurality of findings output by runtime checks executed by a plurality of computing systems, determination of whether a first one of the findings is a duplicate of an already-stored finding, storage, in a case it is determined that the first finding is not a duplicate of an already-stored finding, of the first finding in association with a finding identifier, and generation of a message including the finding identifier and information describing a problem associated with the finding.

Code optimization based on customer logs

Disclosed embodiments provide a system, machine-readable medium, and a method that may test computer application functions. A system provides for testing a computer application function by analyzing a testing characteristic of the computer application function information. Based on the analysis of the testing characteristic, the computer application function may be activated for testing in any one of a plurality of test environments. The test environment is selected according to the testing characteristic that indicates the effects that the testing of the selected computer application has on the test environment. This allows users to select a test environment based on the effects that it has on a test system.

System and method for reversibility categories and characteristics of computer application functions

A method of providing tailored add-on applications to an underlying foundational software suite that frequently receives updated versions that would otherwise overwrite changes in the foundational software that are required by the tailored add-on. Instead of functional changes to the foundation, the tailored add-on makes a fairly uniform and simple change in the place of each needed change, by inserting a call to an add-in definition object. The add-in definition object then contains code for performing the functionality needed by the add-on application. The add-in definition object is down-ported to all supported versions of the foundational software. The calls of the add-in definition object are integrated into the foundational software in a way which minimizes conflicts, allows for concurrent implementation while maintaining a clear separation between foundational code and modified code, and minimizes ongoing maintenance development of the add-on application's conflicts with the foundational application.

A system receives database tables from a plurality of computer systems. Each of the database tables is associated with a particular computer system. Each particular computer system is associated with a particular schema. The database tables are stored in a computer storage device according to the particular schema of the computer system with which each database table is associated. Database views are created and stored. Each of the views is associated with a particular schema. A configuration table according to the particular schemas of each of the computer systems is generated. The configuration table is displayed on a display device. A selection of one or more schemas is received from the display on the computer display device. The database view from one of the selected database schemas is used as a template to generate a view for all of the selected schemas.

A method includes identifying a table over a conventional database used by an application, creating a view of the table equivalent to the identified table in an in-memory database, and calling the view with a same call as used for the identified table such that calling the view via the application provides a same result as would have been obtained from the same call to the table in the conventional database.

View based table replacement for applications

A computer-implemented method of optimizing software components. The method may include receiving a software component including a layered hierarchy of structure packages, main packages, and common packages each including objects, grouping common packages into groups according to pre-determined criteria, encapsulating each group with an encapsulation package, wherein the encapsulation package is one of a structure package and a main package, allowing objects in the encapsulation package to communicate directly by bypassing common packages in the encapsulation package, and eliminating package interfaces of the common packages in the encapsulation package that are solely used for communicating with other common packages in the encapsulation package.

Decoupled development in a shared development system

This disclosure includes a method, a system and a computer readable medium. The method includes receiving a data model configured to model data in a first database schema in a database system, using the received data model to generate a first data view of a first instance of the first database schema in the database system, including referencing, using a first view variant, one or more data tables including the first instance of the first database schema to generate the first data view, and using the received data model to generate a second data view of a second instance of the first database schema in the database system, including referencing, using a second view variant, one or more data tables including the second instance of the first database schema to generate the second data view.

View variants in database schema mapping

Schema mapping is provided at several levels of granularity to generate views from a data model. The schema mapping allows for the database tables referenced among the data views contained in the data model to come from a collection of several physical schemas, even though the data model may comprise a single authoring schema.

Growing community of inventors

Boennigheim, Germany

Andreas Kemmler