-
公开(公告)号:US11176132B2
公开(公告)日:2021-11-16
申请号:US16159084
申请日:2018-10-12
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
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.
-
公开(公告)号:US10664497B2
公开(公告)日:2020-05-26
申请号:US15380720
申请日:2016-12-15
Applicant: SAP SE
Inventor: Yongsik Yoon , Chanho Jeong , Juchang Lee , Chang Bin Song , Yong Sik Kwon , Sang Kyun Cha
IPC: G06F16/22 , G06F16/28 , G06F16/27 , G06F16/9535 , G06F40/177 , G06F16/23
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.
-
公开(公告)号:US20160378813A1
公开(公告)日:2016-12-29
申请号:US15260181
申请日:2016-09-08
Applicant: SAP SE
Inventor: Yongsik Yoon , Chanho Jeong , Juchang Lee , Chang Bin Song , Yong Sik Kwon , Sang Kyun Cha
IPC: G06F17/30
CPC classification number: G06F16/23 , G06F16/22 , G06F16/2282 , G06F16/2453 , G06F16/24544 , G06F16/2455 , G06F16/278 , G06F16/9535
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.
-
公开(公告)号:US20160292227A1
公开(公告)日:2016-10-06
申请号:US15140794
申请日:2016-04-28
Applicant: SAP SE
Inventor: Chanho Jeong , Sangyong Hwang , Sang Kyun Cha , Sung Heun Wi
IPC: G06F17/30
CPC classification number: G06F17/30463 , G06F17/30 , G06F17/30286 , G06F17/30471 , G06F17/30492 , G06F17/30569
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.
Abstract translation: 公开了用于处理与正在查询的数据库存储模型不同的数据库查询的设备,方法和系统。 可以通过接收对存储在数据库中的一个或多个数据项的查询来确定是否使用至少一个使用具有不同于存储模型的格式的数据的查询运算符来执行独立于查询数据库的存储模型的数据库查询 格式化存储在数据库中的一个或多个数据项中的至少一个,并且将由至少一个查询运算符使用的数据的格式转换为与存储的一个或多个数据项中的至少一个的存储模型格式相匹配的格式 在数据库中。 还描述了相关系统,方法和制品。
-
公开(公告)号:US09361340B2
公开(公告)日:2016-06-07
申请号:US14508524
申请日:2014-10-07
Applicant: SAP SE
Inventor: Chanho Jeong , Sangyong Hwang , Sang Kyun Cha , Sung Heun Wi
CPC classification number: G06F17/30463 , G06F17/30 , G06F17/30286 , G06F17/30471 , G06F17/30492 , G06F17/30569
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.
Abstract translation: 公开了用于处理与正在查询的数据库存储模型不同的数据库查询的设备,方法和系统。 可以通过接收对存储在数据库中的一个或多个数据项的查询来确定是否使用至少一个使用具有不同于存储模型的格式的数据的查询运算符来执行独立于查询数据库的存储模型的数据库查询 格式化存储在数据库中的一个或多个数据项中的至少一个,并且将由至少一个查询运算符使用的数据的格式转换为与存储的一个或多个数据项中的至少一个的存储模型格式相匹配的格式 在数据库中。 还描述了相关系统,方法和制品。
-
公开(公告)号:US11755575B2
公开(公告)日:2023-09-12
申请号:US17500194
申请日:2021-10-13
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/24547 , G06F16/24557 , G06F16/258
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.
-
公开(公告)号:US20220035815A1
公开(公告)日:2022-02-03
申请号:US17500194
申请日:2021-10-13
Applicant: SAP SE
Inventor: Chanho Jeong , Sangyong Hwang , Sang Kyun Cha , Sung Heun Wi
IPC: G06F16/2453 , 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.
-
公开(公告)号: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.
-
公开(公告)号:US12222944B2
公开(公告)日:2025-02-11
申请号: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/2455 , 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.
-
公开(公告)号:US20190324648A1
公开(公告)日:2019-10-24
申请号:US16503122
申请日:2019-07-03
Applicant: SAP SE
Inventor: Yong Sik Kwon , Jaeyun Noh , Juchang Lee , Ji Hoon Jang , Sang Kyun Cha
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).
-
-
-
-
-
-
-
-
-