公开(公告)号：US12174836B1

公开(公告)日：2024-12-24

申请号：US18496449

申请日：2023-10-27

Applicant: SAP SE

Inventor： Yinghua Ouyang

IPC: G06F16/00 ,  G06F16/22 ,  G06F16/2453 ,  G06F16/2455

Abstract: The present disclosure involves systems, software, and computer implemented methods for efficiently authorizing parameterized query views. An example method includes parsing a received query to generate a global query parse tree. In response to determining that the query includes a parameterized query view, the parameterized query view is parsed to generate a view parse tree which is then attached to the global query parse tree. In response to determining that an object in the global query parse tree is a parameterized query view, a view parse tree portion of the global query parse tree is traversed to identify objects associated with the parameterized query view. The parameterized query view and the identified objects are authorized in a single authorization step. For objects in the global query parse tree that are not parameterized query views, the object is authorized. In response to all objects being authorized, the query is executed.

公开(公告)号：US11972012B2

公开(公告)日：2024-04-30

申请号：US17462121

申请日：2021-08-31

Applicant: SAP SE

Inventor： Yinghua Ouyang

IPC: G06F21/62 ,  G06F9/54 ,  G06F16/2455

CPC classification number: G06F21/6227 ,  G06F9/54 ,  G06F16/24564

Abstract: Implementations of the present disclosure include receiving, by a database system, a query, providing, by the database system, a set of checker objects including one or more inner checker objects and an outer checker object, each checker object corresponding to a nested sub-query of the query, providing, by the database system, an authorization list associated with the outer checker object, and executing an authorization check on the query at least partially by: adding collected objects of each inner checker object to the authorization list, adding collected objects of the outer checker object to the authorization list, and determining authorization of an entity based on the authorization list.

公开(公告)号：US20240160627A1

公开(公告)日：2024-05-16

申请号：US17985294

申请日：2022-11-11

Applicant: SAP SE

Inventor： Yinghua Ouyang

IPC: G06F16/2453 ,  G06F11/34

CPC classification number: G06F16/24542 ,  G06F11/3409 ,  G06F16/24537

Abstract: The present disclosure involves systems, software, and computer implemented methods for efficiently accessing shared operators in database query plans. One example method includes identifying a query plan tree that represents a query plan for a database query. A node identifier of each node of the query plan tree is initialized to a default node identifier value and a global node identifier counter for the query plan tree is initialized. The query plan tree is traversed including determining whether a node identifier of a current node equals the default node identifier value. If the node identifier of the current node equals the default node identifier value, the current node is processed, the node identifier of the current node is set to a current value of the global node identifier counter, and the global node identifier counter is incremented. Otherwise processing of the current node is skipped.

公开(公告)号：US20240152513A1

公开(公告)日：2024-05-09

申请号：US17983589

申请日：2022-11-09

Applicant: SAP SE

Inventor： Yinghua Ouyang ,  Zhen Tian

IPC: G06F16/2453 ,  G06F16/242

CPC classification number: G06F16/24535 ,  G06F16/244

Abstract: The present disclosure involves systems, software, and computer implemented methods for processing correlated calculated fields in correlated subqueries. One example method includes receiving a request to process a database query that includes at least one subquery and processing each subquery. A determination is made as to whether each subquery includes a correlated calculated field that is a calculated field that is not included in a first datasource queried by the subquery but is included in a second datasource queried by an outer query that includes the subquery. If the subquery does not include a correlated calculated field, the subquery is processed without modification. If the subquery includes a correlated calculated field, metadata is retrieved for the outer query of the subquery that queries the second datasource and includes the correlated calculated field. The subquery is rewritten using the metadata and the rewritten subquery is processed.

公开(公告)号：US11061927B2

公开(公告)日：2021-07-13

申请号：US16373691

申请日：2019-04-03

Applicant: SAP SE

Inventor： Yinghua Ouyang ,  Priya Sharma ,  Mahendra Chavan

IPC: G06F17/00 ,  G06F16/27 ,  G06F16/2453 ,  G06F16/25

Abstract: Disclosed herein are system, method, and computer program product embodiments for appropriately routing requests for data stored in multiple storage mediums. An embodiment operates by maintaining a first and second data stored on a first storage medium in communication with a second storage medium. Thereafter, a replicate of the first data stored in the first storage medium may be created for the second storage medium to store a replica data mirroring the first data. Subsequently, a request for retrieval of the first data may be received. Afterward, a previous update time of the second storage medium in receiving the replicate of the first data stored in the first storage medium may be determined. Lastly, based on the previous update time, the request may be forwarded to the first storage medium or second storage medium.

公开(公告)号：US20180341689A1

公开(公告)日：2018-11-29

申请号：US15602373

申请日：2017-05-23

Applicant: SAP SE

Inventor： Sen Zhang ,  Yinghua Ouyang ,  Jian Wang ,  Zhen Tian

IPC: G06F17/30

CPC classification number: G06F16/258 ,  G06F16/214 ,  G06F16/221 ,  G06F16/235 ,  G06F16/2393

Abstract: Methods, systems, and computer-readable storage media for providing a table in a database system, the table including a column having a column data type set to an abstract data type, receiving a first data record to be added to the table, the first data record including a first data value to be included in the column, determining a first data type corresponding to a data type of the first data value, changing the column data type from the abstract data type to the first data type, receiving a second data record to be added to the table, the second data record including a second data value to be including in the column, determining a second data type corresponding to the data type of the second data value, and selectively changing the column data type to the second data type.

公开(公告)号：US11775521B2

公开(公告)日：2023-10-03

申请号：US18118943

申请日：2023-03-08

Applicant: SAP SE

Inventor： Yinghua Ouyang ,  Zhen Tian

IPC: G06F16/2453 ,  G06F16/2458 ,  G06F16/27 ,  G06F16/23 ,  G06F9/50

CPC classification number: G06F16/24542 ,  G06F9/5083 ,  G06F16/2379 ,  G06F16/2471 ,  G06F16/27

Abstract: A method for workload balancing is implemented in a computer system including a primary database system and a secondary database system, the secondary database system being configured as a backup system for the primary database system. The method includes compiling a query received from a client application. The query indicates one or more source tables have corresponding replicate tables. The compiling comprises replace the one or more source tables with the corresponding replicate tables. The method can generate a query execution plan based on the compiled query, determine a per-table result lag based on minimum commit times of the corresponding replicate tables, and compare the per-table result lag with a predefined threshold. Responsive to a determination that the per-table result lag exceeds the predefined threshold, the method can recompile the query by falling back to the one or more source tables from the corresponding replicate tables.

公开(公告)号：US20230063528A1

公开(公告)日：2023-03-02

申请号：US17462121

申请日：2021-08-31

Applicant: SAP SE

Inventor： Yinghua Ouyang

IPC: G06F21/62 ,  G06F16/2455 ,  G06F9/54

Abstract: Implementations of the present disclosure include receiving, by a database system, a query, providing, by the database system, a set of checker objects including one or more inner checker objects and an outer checker object, each checker object corresponding to a nested sub-query of the query, providing, by the database system, an authorization list associated with the outer checker object, and executing an authorization check on the query at least partially by: adding collected objects of each inner checker object to the authorization list, adding collected objects of the outer checker object to the authorization list, and determining authorization of an entity based on the authorization list.

公开(公告)号：US11423024B2

公开(公告)日：2022-08-23

申请号：US16834289

申请日：2020-03-30

Applicant: SAP SE

Inventor： Yinghua Ouyang ,  Zhen Tian

IPC: G06F16/2453 ,  G06F16/27

Abstract: A secondary database system is configured to act as a backup system for a primary database system. The primary database system receives a query request from a client application in advance of receiving a query. Thereafter, the primary database system determines that a routing hint in the query request indicates that workload from the query may be shifted to the secondary database system. It can then be determined that execution of the query does not involve writing data. The primary database system then determines to instruct the client application to route the query to the secondary database system based on the routing hint. The primary database system then instructs the client application to route the query to the secondary database system. The query is then compiled and executed on the secondary database system such that a replica table does not replace the source table.

公开(公告)号：US11379477B2

公开(公告)日：2022-07-05

申请号：US16836469

申请日：2020-03-31

Applicant: SAP SE

Inventor： Yinghua Ouyang ,  Zhen Tian

IPC: G06F16/2453 ,  G06F16/2458 ,  G06F16/27 ,  G06F16/23 ,  G06F9/50

Abstract: A computer system is configured to provide a database system. The computer system comprises one or more processors, a primary database system implemented by the one or more processors, and a secondary database system implemented by the one or more processors. The secondary database system is configured as a hot-standby system for the primary database system. The secondary database system is capable of providing at least a minimum amount of essential functionality of the primary database system during a disruption to the primary database system. The primary database system is configured by programming instructions, executable on the computer system, to cause the one or more processors to determine from a query request from a client application directed to the primary database system that workload from a query may be shifted to the secondary database system and selectively instruct the client application to direct the secondary database system to execute the query based on a per-table calculated result lag. Related apparatus, systems, techniques and articles are also described.