Sap Se

Sap Ag

Yingyu Chen

Bin Dong

Yongyuan Shen

Xiaowei Liu

Xin Xu

Han Li

Zheng Long Wei

Yihan Song

Huixin Xu

Zhijian Wang

Hui Wang

Wen-Syan Li

Jing Gu

Jie Zhao

Hermann Lueckhoff

Jun Shi

Pranav Wankawala

Yinghui Li

Xiwei Zhou

Fu Zhao

Zhenglong Wei

Juan Qi

Zheren Zhu

A framework for performing aggregation methods on hierarchical data objects is described herein. A data aggregation request is received, the request including a tree of nodes to aggregate, an aggregation method, and a filter criteria. A configuration table is used to identify previously generated aggregation hierarchies that correspond to the received request, and a mapping of attributes of the received nodes to attributes of the previously generated aggregation hierarchies. For each node in the tree of nodes, when a corresponding node in the previously generated aggregation hierarchy is identified, attribute values from the corresponding node are used to create a node in a target aggregation hierarchy. When a corresponding node does not exist, but corresponding child nodes do exist in the previously generated aggregation hierarchy, the aggregation method is applied to the corresponding child nodes and the result is used to create a node in the target aggregation hierarchy.

Virtual Aggregation

The embodiments provide a cloud brainstorming service implemented on at least one cloud server. The brainstorming service includes a message service component configured to receive a plurality of ideas, over a network, from one or more users of devices. The users represent members of a brainstorming session. The brainstorming service also includes a brainstorming logic component configured to process the plurality of ideas and store the plurality of processed ideas in an in-memory database system, and a clustering component configured to retrieve the plurality of processed ideas from the in-memory database system and arrange the plurality of processed ideas into one or more clusters, where each cluster is a group of similar ideas. The message service component is configured to provide the plurality of processed ideas that are arranged into the one or more clusters, over the network, to the one or more users for display.

Brainstorming in a cloud environment

A table selector may receive a selection of a replicated table storing data replicated from an original table of a first system, the replicated table being stored using a second system and currently executing a process of receiving the replicated data. A suspension manager may suspend the process of receiving the replicated data, and a table attribute manager may change a replicated table attribute of the replicated table, while the process of receiving the replicated data is suspended. The suspension manager may then resume the process of receiving the replicated data.

Table attribute management for replicated data tables

A computer system includes at least one processor and at least one memory operably coupled to the at least one processor. The memory includes a memory pool and a database partitioned into multiple fragments. Each of the fragments is allocated a block of memory from the memory pool and the fragments store compressed data in a columnar table format. A database operation is applied in a compressed format to the compressed data in at least one of the fragments.

Database operations on a columnar table database

Described herein is a technology for facilitating delta data load. In some implementations, history tables corresponding to physical tables in a data source are provided in a database layer. The database layer includes change list tables corresponding to the history tables and a physical data model based on one or more physical tables. Delta data is determined by analyzing the change list table to create delta data summary tables. Key lists are generated for summary tables corresponding to physical tables which physical data is based. The delta data is applied to the physical data model.

Universal delta data load

An automated database analyzer is uses templates to accommodate multiple database languages, such as SQL and its dialects. The templates are combined with metadata that define a database schema and operations on the database schema. An SQL file instantiates the database schema on a database system being tested. Operations on the database schema may then be performed to assess the performance of the database system being tested.

Template based database analyzer

Described herein is a technology to facilitate automated question answering. In one implementation, an input question is first received. Different search strategies may be used to search multiple types of data from multiple types of knowledge databases to generate one or more candidate answers to the input question. The one or more candidate answers are evaluated to generate a final answer to the input question.

Question answering framework

Described herein is a technology to facilitate large volume data transfer. In one implementation, an application server determines if an application is invoking a procedure in a data server. If the application is determined to be invoking the procedure, the application data is encoded to compress application data volume. The encoded application data is then transferred from the application server to a data server. At the data server, the application data is decoded for processing by the data server.

Large volume data transfer

Described herein is a technology to facilitate dynamic bridging of an application server and a data server. In accordance with one aspect, a query script based on source code of an application is generated at the application server. The query script may include at least one placeholder that represents a dynamic term in the source code of the application. The query script may be processed by replacing the placeholder with a static term generated based on one or more values received during execution of the application. The query script is then executed to manage data at a data server.

Dynamic bridging of application and data servers

Implementations include a method, system, and apparatus for receiving, from a user communicably connected to a network, a selection of one or more gateway service data categories; receiving, from the user, a selection of an operating platform of a mobile device operable to be communicably connected to the network; generating a configuration file comprising a selection of gateway service data associated with one or more gateway service data categories and the operating platform selection; generating a data store file and a development library associated with the operating platform selection; transferring the configuration file, the data store file, and the development library to a repository communicably connected to the network; and generating an application template comprising the configuration file, the data store file, and the development library, wherein the mobile application is developed on the mobile device from the application template while the mobile device is communicably disconnected from the network.

Gateway data distribution engine

Described herein is a technology for facilitating optimization of database queries is described herein. In some implementations, a first query is received. At least one scenario for optimization is automatically recognized by detecting specific syntax in the query. A second query is then automatically generated by re-writing the first query using a pre-defined operation corresponding to the recognized scenario.

Optimization of database query

The embodiments provide an in-memory database system having an extraction module configured to extract data (e.g., business data and address data) from one or more external data sources and transform the data into a standard format, a geocoder configured to geocode the address data including obtaining spatial data based on the address data using an internal reference table, and an internal database configured to store the internal reference table, the business data, the address data, and the spatial data.

In-memory spatial database for geocoding/geoprocessing

Disclosed is system for monitoring data changes during a data replication process. The system includes a modeling module configured to select tables and fields to be monitored during execution of the data replication process, a trigger module configured to track changes of data being generated during execution of a program by inserting triggers into a destination system at the start of a program execution and then dropping the trigger at the end of program execution, a snapshot module configured to track changes of data being generated during execution of a program by generating a snapshot of data at the beginning and the end of program execution, and a report module configured to generate a report indicating changes in data based on the changes in data indicated by the triggers and based on the changes in data indicated by the snapshots of data.

Inspecting replicated data

In one embodiment the present invention includes a computer implemented method of relating data and generating reports. The method includes storing, by an OLAP system, a network data structure that relates a plurality of data objects. The method further includes storing transactional data in an in-memory database in the OLAP system. The method further includes generating, by the OLAP system, a report using the stored transactional data according to the network data structure. In this manner, deficiencies of the traditional star schema paradigm of data warehousing may be avoided.

Growing community of inventors

Shanghai, China

Yingyu Chen