公开(公告)号：US20240273008A1

公开(公告)日：2024-08-15

申请号：US18169271

申请日：2023-02-15

Applicant: SAP SE

Inventor： Yinghua Ouyang ,  Zhen Tian

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

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.

公开(公告)号：US20230222122A1

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

申请号：US18118943

申请日：2023-03-08

Applicant: SAP SE

Inventor： Yinghua Ouyang ,  Zhen Tian

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

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

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.

公开(公告)号：US11625397B2

公开(公告)日：2023-04-11

申请号：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.

公开(公告)号：US20210303576A1

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

申请号：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.

公开(公告)号：US10545984B2

公开(公告)日：2020-01-28

申请号：US15602373

申请日：2017-05-23

Applicant: SAP SE

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

IPC: G06F17/30 ,  G06F16/25 ,  G06F16/22 ,  G06F16/21 ,  G06F16/23

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.