公开(公告)号：US20190303251A1

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

申请号：US15942151

申请日：2018-03-30

Applicant: SAP SE

Inventor： Seyeong Bae ,  Ji Hoon Jang ,  Yong Sik Kwon ,  Hyeong Seog Kim

IPC: G06F11/16 ,  G06F17/30 ,  G06F11/10

Abstract: Improved database consistency and consistency checking may be provided by cross-referenced split data storage for irregular fields using auxiliary pointers. A fixed-size memory slot may be allocated to a database table in a database system, where the fixed-size memory slot has an address. A variable-size memory slot may be allocated to the database table, where the variable-size memory slot has a different address. For an irregular field in the database table, one or more properties of the irregular field may be stored in the fixed-size memory slot. The one or more properties may include a first pointer which may have the address of the variable-size memory slot. For the irregular field in the database table, at least a portion of data of the irregular field and a second pointer, which may have the address of the fixed-size memory slot, may be stored in the variable-size memory slot.

公开(公告)号：US20190272265A1

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

申请号：US16418381

申请日：2019-05-21

Applicant: SAP SE

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

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

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.

公开(公告)号：US20190005080A1

公开(公告)日：2019-01-03

申请号：US16107917

申请日：2018-08-21

Applicant: SAP SE

Inventor： Yong Sik Kwon ,  Yongsik Yoon ,  Joo Yeon Lee ,  Oliver M. Steinau ,  Markus Hartmann

IPC: G06F17/30

Abstract: An in-memory database server hosting a tenant of a multi-tenant software architecture can receive a definition of a custom data field that is unique to an organization having isolated access to the tenant. The custom data field can extend a standard table defined by central metadata stored at a system tenant of the multi-tenant software architecture. Tenant private metadata that includes the definition can be stored in memory accessible only to the tenant. A tenant-dependent table that includes the custom data field can be formed, for example by retrieving central metadata defining the standard table from the system tenant and adding the custom data field using the definition. The tenant-dependent table can be presented for access via a database client at the organization. Related systems, articles of manufacture, and computer-implemented methods are disclosed.

公开(公告)号：US10162710B2

公开(公告)日：2018-12-25

申请号：US15361946

申请日：2016-11-28

Applicant: SAP SE

Inventor： Yong Sik Kwon ,  Hyeong Seog Kim ,  Kyu Hwan Kim ,  Seyeong Bae ,  Joo Yeon Lee ,  Beomsoo Kim ,  Juchang Lee ,  Marcel Birn

IPC: G06F11/14 ,  G06F17/30

Abstract: A computer implemented method is provided. The method comprises initializing a first database image of a first database system based on a recovery image comprising committed transactions, visible uncommitted transactions, and undo logs associated with the visible uncommitted transactions, undoing the visible uncommitted transactions using the undo logs, generating redo logs from the undo logs, replaying the redo logs to create invisible uncommitted transactions, and after replaying the redo logs, replaying transaction logs received from a second database system. Related apparatus, systems, techniques and articles are also described.