-
公开(公告)号：US20180018368A1
公开(公告)日：2018-01-18
申请号：US15208736
申请日：2016-07-13
Applicant: SAP SE
Inventor： Stefan Baeuerle , Bjoern Mielenhausen , Daniel Hutzel , Ki Hong Kim , Di Wu , Long Zhang
IPC: G06F17/30
CPC classification number: G06F16/24544 , G06F16/22 , G06F16/24535
Abstract: A system, medium, and method to define a database table and view based on a database model using a database language statement, the database language statement including a statement to create the table and a forward-declared JOIN statement that names the table and view, respectively and includes information regarding a relationship between at least two entities of the database.
-
公开(公告)号：US20160350348A1
公开(公告)日：2016-12-01
申请号：US14727259
申请日：2015-06-01
Applicant: SAP SE
Inventor： Bjoern Mielenhausen
CPC classification number: G06F17/30292 , G06F17/30348 , G06F17/30371
Abstract: Example embodiments involve a system, computer-readable storage medium storing at least one program, and computer-implemented method for modifying a database object with one or more dependent database objects. The method may include receiving a data definition statement involving a modification to a database object. The received data definition statement includes a clause imposing a restriction on the modification to the database object. The method further includes determining whether the modification results in invalidation of at least one dependent database object in response to the clause being included in the received data definition statement. Based on determining that the modification results in the invalidation of at least one dependent database object, the modification to the database object is prevented. Based on determining that the modification does not result in the invalidation any dependent database objects, the modification to the database object is performed in accordance with the data definition statement.
Abstract translation: 示例性实施例涉及存储至少一个程序的系统，计算机可读存储介质和用于使用一个或多个依赖数据库对象修改数据库对象的计算机实现的方法。 该方法可以包括接收涉及对数据库对象的修改的数据定义语句。 接收到的数据定义语句包括对数据库对象进行修改的限制条款。 所述方法还包括确定所述修改是否导致响应于所述子句被包括在所接收的数据定义语句中的至少一个依赖数据库对象的无效。 基于确定修改导致至少一个依赖数据库对象的无效，防止对数据库对象的修改。 基于确定修改不会导致任何依赖数据库对象的无效，对数据库对象的修改根据数据定义语句执行。
-
公开(公告)号：US10042889B2
公开(公告)日：2018-08-07
申请号：US14944952
申请日：2015-11-18
Applicant: SAP SE
Inventor： Bjoern Mielenhausen
Abstract: Various embodiments of systems and methods for retrieving data from database are described herein. A query is received at a user application connected with a database system. The received query may be referred as a user request to retrieve data from database tables stored in the database. The query is processed and analyzed to interpret the user request for retrieving the requisite data. A return set is retrieved from the database based on the received query. Once, the required data is fetched from the database, the return set having the requisite data may be free from duplicate columns that is sent to the user application.
-
公开(公告)号：US10120885B2
公开(公告)日：2018-11-06
申请号：US14727259
申请日：2015-06-01
Applicant: SAP SE
Inventor： Bjoern Mielenhausen
IPC: G06F17/30
Abstract: Example embodiments involve a system, computer-readable storage medium storing at least one program, and computer-implemented method for modifying a database object with one or more dependent database objects. The method may include receiving a data definition statement involving a modification to a database object. The received data definition statement includes a clause imposing a restriction on the modification to the database object. The method further includes determining whether the modification results in invalidation of at least one dependent database object in response to the clause being included in the received data definition statement. Based on determining that the modification results in the invalidation of at least one dependent database object, the modification to the database object is prevented. Based on determining that the modification does not result in the invalidation any dependent database objects, the modification to the database object is performed in accordance with the data definition statement.
-
公开(公告)号：US20160350337A1
公开(公告)日：2016-12-01
申请号：US14727184
申请日：2015-06-01
Applicant: SAP SE
Inventor： Bjoern Mielenhausen
CPC classification number: G06F16/211
Abstract: Example embodiments involve a system, computer-readable storage medium storing at least one program, and computer-implemented method for processing deferred clauses used in conjunction with data definition statements. The method may include receiving a data definition statement signaling creation of a database object. The received data definition statement specifies a dependency of the database object on a non-existing database object. The method may further include determining whether a deferred clause is included in the data definition statement; and based on determining that the deferred clause is included in the data definition statement, creating the database object with the dependency on the non-existing database object.
Abstract translation: 示例性实施例涉及存储至少一个程序的系统，计算机可读存储介质和用于处理与数据定义语句一起使用的延迟子句的计算机实现的方法。 该方法可以包括接收数据定义语句来创建数据库对象的信令。 接收的数据定义语句指定数据库对象对不存在的数据库对象的依赖关系。 该方法还可以包括确定延迟子句是否包括在数据定义语句中; 并且基于确定延迟子句包含在数据定义语句中，创建具有对不存在的数据库对象的依赖性的数据库对象。
-
Patent Agency Ranking
公开(公告)号：US10353879B2
公开(公告)日：2019-07-16
申请号：US14944675
申请日：2015-11-18
Applicant: SAP SE
Inventor： Bjoern Mielenhausen
Abstract: A computer-implemented method for managing the differences in the schema of data stored in a database and the schema of data as consumed by a client application. The method involves creating additional metadata related to a property, attribute, or characteristic of a database object stored in the database, storing this additional metadata in a database catalog, and making the additional metadata available for access or retrieval by a query received from the client application for the database object stored in the database.
-
公开(公告)号：US20180096032A1
公开(公告)日：2018-04-05
申请号：US15282413
申请日：2016-09-30
Applicant: SAP SE
Inventor： Bjoern Mielenhausen , Manuel Caroli , Youssef Hatem
IPC: G06F17/30
CPC classification number: G06F16/24544 , G06F16/25 , G06F16/252
Abstract: Embodiments include a metadata application programming interface (API) for processing ad hoc database queries. Embodiments can be configured to process ad hoc database queries to determine the structure of the resulting data set and to provide metadata in the form of a result table, for example, in response to the queries that describes the structure of the data to be accessed by the queries. In one embodiment, this may be performed without accessing the data that would be retrieved upon executing the query. Certain embodiments may be adapted to prevent execution of the query and to return the metadata describing the structure of the data structure(s) in the resulting data set. A new “describe” statement can be incorporated into a query language expression and configured to work in a functionally coordinated manner with the API to implement a “describe” function in accordance with the techniques described in this disclosure.
-
公开(公告)号：US20170140000A1
公开(公告)日：2017-05-18
申请号：US14944952
申请日：2015-11-18
Applicant: SAP SE
Inventor： Bjoern Mielenhausen
IPC: G06F17/30
CPC classification number: G06F17/30489 , G06F17/30424 , G06F17/30554
Abstract: Various embodiments of systems and methods for retrieving data from database are described herein. A query is received at a user application connected with a database system. The received query may be referred as a user request to retrieve data from database tables stored in the database. The query is processed and analyzed to interpret the user request for retrieving the requisite data. A return set is retrieved from the database based on the received query. Once, the required data is fetched from the database, the return set having the requisite data may be free from duplicate columns that is sent to the user application.
-
公开(公告)号：US20160357815A1
公开(公告)日：2016-12-08
申请号：US14728246
申请日：2015-06-02
Applicant: SAP SE
Inventor： Bjoern Mielenhausen
IPC: G06F17/30
CPC classification number: G06F17/30595 , G06F17/30424 , G06F17/30466
Abstract: In some example embodiments, a first alias creation statement is received. The first alias creation statement comprises a first table identifier of a first table, a second table identifier of a second table, a first alias identifier, and a first common table expression, and the first common table expression comprises the first table identifier. A first alias for the second table is generated based on the first alias creation statement, with the first alias comprising the first alias identifier and the first common table expression. The first alias is stored as metadata of the second table. A first query statement is received, with the first query statement comprising the second table identifier and the first alias identifier, and the first query statement is rewritten using the first common table expression based on the first alias identifier to generate a first rewritten query statement.
Abstract translation: 在一些示例实施例中，接收第一别名创建语句。 第一别名创建语句包括第一表的第一表标识符，第二表的第二表标识符，第一别名标识符和第一公用表表达式，并且第一公用表表达式包括第一表标识符。 基于第一别名创建语句生成第二表的第一别名，其中第一别名包括第一别名标识符和第一公共表表达式。 第一个别名存储为第二个表的元数据。 接收到第一查询语句，其中第一查询语句包括第二表标识符和第一别名标识符，并且基于第一别名标识符使用第一公用表表达式重写第一查询语句，以生成第一重写查询语句。
-
公开(公告)号：US10599650B2
公开(公告)日：2020-03-24
申请号：US15208736
申请日：2016-07-13
Applicant: SAP SE
Inventor： Stefan Baeuerle , Bjoern Mielenhausen , Daniel Hutzel , Ki Hong Kim , Di Wu , Long Zhang
IPC: G06F7/00 , G06F17/30 , G06F16/2453 , G06F16/22
Abstract: A system, medium, and method to define a database table and view based on a database model using a database language statement, the database language statement including a statement to create the table and a forward-declared JOIN statement that names the table and view, respectively and includes information regarding a relationship between at least two entities of the database.
-
-
-
-
-
-
-
-
-
Search Results
11
records
(took 0.023 seconds)
