公开(公告)号：US20200320094A1

公开(公告)日：2020-10-08

申请号：US16373691

申请日：2019-04-03

Applicant: SAP SE

Inventor： Yinghua Ouyang ,  Priya Sharma ,  Mahendra Chavan

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

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.

公开(公告)号：US20200301901A1

公开(公告)日：2020-09-24

申请号：US16356240

申请日：2019-03-18

Applicant: SAP SE

Inventor： Zhilong Hao ,  Priya Sharma ,  Yinghua Ouyang

IPC: G06F16/22 ,  G06F12/0804 ,  G06F16/2455

Abstract: Disclosed herein are system, method, and computer program product embodiments for providing index and storage management for multi-tiered databases. An embodiment operates by receiving a request to create an index on a multi-tiered database including both an in-memory store and a disk store. A multi-store table associated with the index is determined, wherein the multi-store table includes both a first set of data stored on the memory store and a second set of data stored on the disk store. Either the first set of data or the second set of data on which to create the index is selected based on the request. The index for the selected set of data of the multi-store table is generated. The index is stored on either the disk store or the memory store as corresponding to the selected set of data for which the index was generated.

公开(公告)号：US12235839B2

公开(公告)日：2025-02-25

申请号：US17983589

申请日：2022-11-09

Applicant: SAP SE

Inventor： Yinghua Ouyang ,  Zhen Tian

IPC: G06F16/24 ,  G06F16/242 ,  G06F16/2453

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.

公开(公告)号：US20240303364A1

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

申请号：US18180221

申请日：2023-03-08

Applicant: SAP SE

Inventor： Xun Zhang ,  Taehyung Lee ,  Yinghua Ouyang ,  Dongmei XV ,  Yanchen Cao ,  Hong-Hai Do ,  Taeyoung Jeong ,  Zhen Tian

IPC: G06F21/62

CPC classification number: G06F21/6227 ,  G06F2221/2141

Abstract: 1. Implementations of the present disclosure include receiving, by a database system, a query from an entity, providing a parse tree based on the query, the parse tree including nodes representative of operations to be executed and data objects stored within the database system, generating a module tree based on the parse tree, the module tree including a set of modules provided in sequential order from a root module to a leaf module, and executing an authorization check using the module tree by, for each module, determining a set of data objects and, for each data object in the set of data objects, determining whether the entity is one or more of authorized access the data object and perform an operation on the data object.

公开(公告)号：US12045155B1

公开(公告)日：2024-07-23

申请号：US18169271

申请日：2023-02-15

Applicant: SAP SE

Inventor： Yinghua Ouyang ,  Zhen Tian

IPC: G06F16/00 ,  G06F9/50 ,  G06F11/07 ,  G06F11/36

CPC classification number: G06F11/3636 ,  G06F9/5016 ,  G06F11/0751

Abstract: The present disclosure involves systems, software, and computer implemented methods for efficient memory leak detection in database systems. One example method includes receiving a query at a database system. Memory allocations and deallocations are traced during processing of the query. Each memory allocation entry in a tracing file can be processed, including determining, for each allocation, whether a memory deallocation entry exists in the tracing file. A determination can be made as to whether a memory leak has occurred in response to determining whether a memory deallocation entry corresponding to a memory allocation entry exists in the tracing file. For example, a determination can be made that a memory leak has occurred in response to determining that no memory deallocation entry corresponding to an allocated memory address exists in the tracing file. One or more actions can be performed in response to determining that a memory leak has occurred.

公开(公告)号：US11494359B2

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

申请号：US16356240

申请日：2019-03-18

Applicant: SAP SE

Inventor： Zhilong Hao ,  Priya Sharma ,  Yinghua Ouyang

IPC: G06F17/00 ,  G06F7/00 ,  G06F16/22 ,  G06F16/2455 ,  G06F12/0804

Abstract: Disclosed herein are system, method, and computer program product embodiments for providing index and storage management for multi-tiered databases. An embodiment operates by receiving a request to create an index on a multi-tiered database including both an in-memory store and a disk store. A multi-store table associated with the index is determined, wherein the multi-store table includes both a first set of data stored on the memory store and a second set of data stored on the disk store. Either the first set of data or the second set of data on which to create the index is selected based on the request. The index for the selected set of data of the multi-store table is generated. The index is stored on either the disk store or the memory store as corresponding to the selected set of data for which the index was generated.

公开(公告)号：US20220245149A1

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

申请号：US17722104

申请日：2022-04-15

Applicant: SAP SE

Inventor： Yinghua Ouyang ,  Zhen Tian

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

Abstract: A computer system comprises one or more processors, a primary database system, and a secondary database system. 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.

公开(公告)号：US20210303572A1

公开(公告)日：2021-09-30

申请号：US16836469

申请日：2020-03-31

Applicant: SAP SE

Inventor： Yinghua Ouyang ,  Zhen Tian

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

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.

公开(公告)号：US20250139276A1

公开(公告)日：2025-05-01

申请号：US18496416

申请日：2023-10-27

Applicant: SAP SE

Inventor： Yinghua Ouyang

IPC: G06F21/62

Abstract: The present disclosure involves systems, software, and computer implemented methods for user-specific access control for metadata tables. An example method includes receiving, from a user, a query that queries a metadata table. For each metadata table row, a determination is made as to whether the user owns the object represented by the metadata table row. If the user owns the object, the row is included in a result set for the query. If the user does not own the object, a determination is made as to whether the user has access permission to the object. If the user has access permission to the object, the row is included in the result set. If the user does not have access permission to the object, the row is excluded from the result set. After all metadata tables rows are processed, the result set is provided in response to the query.

公开(公告)号：US12135713B2

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

申请号：US17985294

申请日：2022-11-11

Applicant: SAP SE

Inventor： Yinghua Ouyang

IPC: G06F16/2453 ,  G06F11/34

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.