公开(公告)号：US10346383B2

公开(公告)日：2019-07-09

申请号：US15260181

申请日：2016-09-08

Applicant: SAP SE

Inventor： Yongsik Yoon ,  Chanho Jeong ,  Juchang Lee ,  Chang Bin Song ,  Yong Sik Kwon ,  Sang Kyun Cha

IPC: G06F16/27 ,  G06F16/2453 ,  G06F16/2455 ,  G06F16/9535 ,  G06F16/23 ,  G06F16/22

Abstract: A hybrid database table is stored as both a row and a column store. One or more techniques may be employed alone or in combination to enhance performance of the hybrid table by regulating access to, and/or the size of, the processing-intensive column store data. For example during an insert operation, the column store data may be searched for a uniqueness violation only after certain filtering and/or boundary conditions have been considered. In another technique, a hybrid table manager may control movement of data to the column store based upon considerations such as frequency of access, or underlying business logic. In still another technique, querying of the hybrid table may result in a search of the column store data only after an initial search of row store data fails to return a result.

公开(公告)号：US20230376487A1

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

申请号：US18362399

申请日：2023-07-31

Applicant: SAP SE

Inventor： Chanho Jeong ,  Sangyong Hwang ,  Sang Kyun Cha ,  Sung Heun Wi

IPC: G06F16/2453 ,  G06F16/00 ,  G06F16/20 ,  G06F16/25 ,  G06F16/2455

CPC classification number: G06F16/24542 ,  G06F16/00 ,  G06F16/20 ,  G06F16/258 ,  G06F16/24547 ,  G06F16/24557

Abstract: Devices, methods and systems for processing database queries formatted differently than the database storage model being queried are disclosed. Processing database queries independent of the storage model of the queried database may be performed by receiving a query for one or more data items stored in a database, determining whether to use at least one query operator that uses data having a format different from the storage model format of at least one of one or more data items stored in the database and converting the format of the data used by the at least one query operator to a format that matches the storage model format of at least one of one or more data items stored in the database. Related systems, methods, and articles of manufacture are also described.

公开(公告)号：US11137911B2

公开(公告)日：2021-10-05

申请号：US16503122

申请日：2019-07-03

Applicant: SAP SE

Inventor： Yong Sik Kwon ,  Jaeyun Noh ,  Juchang Lee ,  Ji Hoon Jang ,  Sang Kyun Cha

IPC: G06F3/06 ,  G06F9/46 ,  G06F9/54 ,  G06F9/44 ,  G06F9/48 ,  G06F9/52 ,  G06F13/16 ,  G06F9/445 ,  G06F9/4401

Abstract: Technologies are described for restarting an application while maintaining data in memory (e.g., using shared memory). For example, shared memory can be associated with an application. The shared memory can also be associated with a holder process to maintain the shared memory from the time the application stops to the time the application starts again. When the application starts, the shared memory can be associated with the started application. In addition, restart of in-memory databases can be provided using shared memory. For example, in-memory data can be maintained when a database process or database management system stops and starts (e.g., during a restart).

公开(公告)号：US20190138523A1

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

申请号：US16159084

申请日：2018-10-12

Applicant: SAP SE

Inventor： Chanho Jeong ,  Sangyong Hwang ,  Sang Kyun Cha ,  Sung Heun Wi

IPC: G06F16/2453 ,  G06F16/2455 ,  G06F16/00 ,  G06F16/20 ,  G06F16/25

Abstract: Devices, methods and systems for processing database queries formatted differently than the database storage model being queried are disclosed. Processing database queries independent of the storage model of the queried database may be performed by receiving a query for one or more data items stored in a database, determining whether to use at least one query operator that uses data having a format different from the storage model format of at least one of one or more data items stored in the database and converting the format of the data used by the at least one query operator to a format that matches the storage model format of at least one of one or more data items stored in the database. Related systems, methods, and articles of manufacture are also described.

公开(公告)号：US10127278B2

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

申请号：US15140794

申请日：2016-04-28

Applicant: SAP SE

Inventor： Chanho Jeong ,  Sangyong Hwang ,  Sang Kyun Cha ,  Sung Heun Wi

IPC: G06F17/30

Abstract: Devices, methods and systems for processing database queries formatted differently than the database storage model being queried are disclosed. Processing database queries independent of the storage model of the queried database may be performed by receiving a query for one or more data items stored in a database, determining whether to use at least one query operator that uses data having a format different from the storage model format of at least one of one or more data items stored in the database and converting the format of the data used by the at least one query operator to a format that matches the storage model format of at least one of one or more data items stored in the database. Related systems, methods, and articles of manufacture are also described.

公开(公告)号：US20170097977A1

公开(公告)日：2017-04-06

申请号：US15380720

申请日：2016-12-15

Applicant: SAP SE

Inventor： Yongsik Yoon ,  Chanho Jeong ,  Juchang Lee ,  Chang Bin Song ,  Yong Sik Kwon ,  Sang Kyun Cha

IPC: G06F17/30

Abstract: A hybrid database table is stored as both a row and a column store. One or more techniques may be employed alone or in combination to enhance performance of the hybrid table by regulating access to, and/or the size of, the processing-intensive column store data. For example during an insert operation, the column store data may be searched for a uniqueness violation only after certain filtering and/or boundary conditions have been considered. In another technique, a hybrid table manager may control movement of data to the column store based upon considerations such as frequency of access, or underlying business logic. In still another technique, querying of the hybrid table may result in a search of the column store data only after an initial search of row store data fails to return a result.