公开(公告)号：US09846724B2

公开(公告)日：2017-12-19

申请号：US14540792

申请日：2014-11-13

Applicant: Christoph Weyerhaeuser ,  Tobias Mindnich ,  Johannes Merx ,  Yongsik Yoon ,  Sung Heun Wi ,  Jeong Ae Han

Inventor： Christoph Weyerhaeuser ,  Tobias Mindnich ,  Johannes Merx ,  Yongsik Yoon ,  Sung Heun Wi ,  Jeong Ae Han

IPC: G06F17/30

CPC classification number: G06F17/30463

Abstract: According to an aspect, a database system for integrating calculation models into execution plans includes a first engine configured to parse a query to be applied on a database. The first engine is configured to invoke a second engine during query compilation. The second engine is configured to instantiate a calculation model based on the query, and the second engine is configured to derive a converted calculation model by converting the calculation model into a format compatible with the first engine. The first engine is configured to incorporate the converted calculation model into an execution plan during the query compilation and execute the query on the database according to execution plan.

公开(公告)号：US07930274B2

公开(公告)日：2011-04-19

申请号：US11854140

申请日：2007-09-12

Applicant: Sang Yong Hwang ,  Ki Hong Kim ,  Sung Heun Wi ,  Sang Kyun Cha

Inventor： Sang Yong Hwang ,  Ki Hong Kim ,  Sung Heun Wi ,  Sang Kyun Cha

IPC: G06F7/00

CPC classification number: G06F17/30551 ,  G06F17/30348

Abstract: Various embodiments include one or more of systems, methods, software, and data structures that allow dual access to concurrent data in a database management system including uncommitted updated data. Some embodiments include a dual snapshot of data in a multi-version concurrency control style database, but the embodiments described herein are equally applicable to virtually any other type of database and database management system.

Abstract translation: 各种实施例包括允许在数据库管理系统中双重访问并发数据的系统，方法，软件和数据结构中的一个或多个，包括未提交的更新数据。 一些实施例包括多版本并发控制风格数据库中的数据的双重快照，但是这里描述的实施例同样适用于几乎任何其他类型的数据库和数据库管理系统。

公开(公告)号：US20150363463A1

公开(公告)日：2015-12-17

申请号：US14307092

申请日：2014-06-17

Applicant: Tobias Mindnich ,  Jeong Ae Han ,  Johannes Merx ,  Christoph Weyerhaeuser ,  Yongsik Yoon ,  Sung Heun Wi

Inventor： Tobias Mindnich ,  Jeong Ae Han ,  Johannes Merx ,  Christoph Weyerhaeuser ,  Yongsik Yoon ,  Sung Heun Wi

IPC: G06F17/30

CPC classification number: G06F17/30442

Abstract: A query is received by a database server from a remote application server. The query is associated with a calculation scenario that defines a data flow model that includes one or more nodes that each define one or more operations for execution by a calculation engine on the database server. Thereafter, the database server instantiates a runtime model of the calculation scenario based on the nodes of the instantiated calculation scenario. Subsequently, one or more of the nodes are identified as being convertible into a relational database format. These nodes are then used to form a container node. An execution plan of the runtime model of the calculation scenario including the container node is built that is executed by the database server to result in a data set which is provided by the database server to the application server.

Abstract translation: 数据库服务器从远程应用程序服务器接收到查询。 该查询与定义包含一个或多个节点的数据流模型的计算方案相关联，每个节点定义一个或多个操作，以供数据库服务器上的计算引擎执行。 此后，数据库服务器基于实例化计算方案的节点实例化计算方案的运行时模型。 随后，一个或多个节点被识别为可转换为关系数据库格式。 然后使用这些节点形成容器节点。 构建包含容器节点的计算场景的运行时模型的执行计划，该运行时模型由数据库服务器执行以产生由数据库服务器向应用服务器提供的数据集。

公开(公告)号：US20150026154A1

公开(公告)日：2015-01-22

申请号：US14508524

申请日：2014-10-07

Applicant: Chanho Jeong ,  Sangyong Hwang ,  Sang Kyun Cha ,  Sung Heun Wi

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: 公开了用于处理与正在查询的数据库存储模型不同的数据库查询的设备，方法和系统。 可以通过接收对存储在数据库中的一个或多个数据项的查询来确定是否使用至少一个使用具有不同于存储模型的格式的数据的查询运算符来执行独立于查询数据库的存储模型的数据库查询 格式化存储在数据库中的一个或多个数据项中的至少一个，并且将由至少一个查询运算符使用的数据的格式转换为与存储的一个或多个数据项中的至少一个的存储模型格式相匹配的格式 在数据库中。 还描述了相关系统，方法和制品。

公开(公告)号：US08880508B2

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

申请号：US12982673

申请日：2010-12-30

Applicant: Chanho Jeong ,  Sang Yong Hwang ,  Sang Kyun Cha ,  Sung Heun Wi

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

IPC: G06F17/30 ,  G06F7/00

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: 公开了用于处理与正在查询的数据库存储模型不同的数据库查询的设备，方法和系统。 可以通过接收对存储在数据库中的一个或多个数据项的查询来确定是否使用至少一个使用具有不同于存储模型的格式的数据的查询运算符来执行独立于查询数据库的存储模型的数据库查询 格式化存储在数据库中的一个或多个数据项中的至少一个，并且将由至少一个查询运算符使用的数据的格式转换为与存储的一个或多个数据项中的至少一个的存储模型格式相匹配的格式 在数据库中。 还描述了相关系统，方法和制品。

公开(公告)号：US20120173515A1

公开(公告)日：2012-07-05

申请号：US12982673

申请日：2010-12-30

Applicant: Chanho Jeong ,  Sang Yong Hwang ,  Sang Kyun Cha ,  Sung Heun Wi

Inventor： Chanho Jeong ,  Sang Yong 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: 公开了用于处理与正在查询的数据库存储模型不同的数据库查询的设备，方法和系统。 可以通过接收对存储在数据库中的一个或多个数据项的查询来确定是否使用至少一个使用具有不同于存储模型的格式的数据的查询运算符来执行独立于查询数据库的存储模型的数据库查询 格式化存储在数据库中的一个或多个数据项中的至少一个，并且将由至少一个查询运算符使用的数据的格式转换成与存储的一个或多个数据项中的至少一个的存储模型格式相匹配的格式 在数据库中。 还描述了相关系统，方法和制品。

公开(公告)号：US10061808B2

公开(公告)日：2018-08-28

申请号：US14294818

申请日：2014-06-03

Applicant: Ki Hong Kim ,  Norman May ,  Alexander Boehm ,  Sung Heun Wi ,  Jeong Ae Han ,  Sang Il Song ,  Yongsik Yoon

Inventor： Ki Hong Kim ,  Norman May ,  Alexander Boehm ,  Sung Heun Wi ,  Jeong Ae Han ,  Sang Il Song ,  Yongsik Yoon

IPC: G06F17/30

CPC classification number: G06F16/24552 ,  G06F16/2445

Abstract: Embodiments relate to view caching techniques that cache for a limited time, some of the (intermediate) results of a previous query execution, in order to avoid expensive re-computation of query results. Particular embodiments may utilize a cache manager to determine whether information relevant to a subsequent user request can be satisfied by an existing cache instance or view, or whether creation of an additional cache instance is appropriate. At design time, cache defining columns of a view are defined, with user input parameters automatically being cache defining. Cache instances are created for each tuple of literals for the cache defining columns, and for each explicit or implicit group by clause. Certain embodiments may feature enhanced reuse between cache instances, in order to limit memory footprint. Over time a cache instances may be evicted from memory based upon implementation of a policy such as a Least Recently Used (LRU) strategy.

公开(公告)号：US20110161300A1

公开(公告)日：2011-06-30

申请号：US13045867

申请日：2011-03-11

Applicant: Sang Yong Hwang ,  Ki Hong Kim ,  Sung Heun Wi ,  Sang Kyun Cha

Inventor： Sang Yong Hwang ,  Ki Hong Kim ,  Sung Heun Wi ,  Sang Kyun Cha

IPC: G06F7/00 ,  G06F17/30

CPC classification number: G06F17/30551 ,  G06F17/30348

Abstract: Various embodiments include one or more of systems, methods, software, and data structures that allow dual access to concurrent data in a database management system including uncommitted updated data. Some embodiments include a dual snapshot of data in a multi-version concurrency control style database, but the embodiments described herein are equally applicable to virtually any other type of database and database management system.

Abstract translation: 各种实施例包括允许在数据库管理系统中双重访问并发数据的系统，方法，软件和数据结构中的一个或多个，包括未提交的更新数据。 一些实施例包括多版本并发控制风格数据库中的数据的双重快照，但是这里描述的实施例同样适用于几乎任何其他类型的数据库和数据库管理系统。

公开(公告)号：US20090070330A1

公开(公告)日：2009-03-12

申请号：US11854140

申请日：2007-09-12

Applicant: Sang Yong Hwang ,  Ki Hong Kim ,  Sung Heun Wi ,  Sang Kyun Cha

Inventor： Sang Yong Hwang ,  Ki Hong Kim ,  Sung Heun Wi ,  Sang Kyun Cha

IPC: G06F17/30

CPC classification number: G06F17/30551 ,  G06F17/30348

Abstract: Various embodiments include one or more of systems, methods, software, and data structures that allow dual access to concurrent data in a database management system including uncommitted updated data. Some embodiments include a dual snapshot of data in a multi-version concurrency control style database, but the embodiments described herein are equally applicable to virtually any other type of database and database management system.

Abstract translation: 各种实施例包括允许在数据库管理系统中双重访问并发数据的系统，方法，软件和数据结构中的一个或多个，包括未提交的更新数据。 一些实施例包括多版本并发控制风格数据库中的数据的双重快照，但是这里描述的实施例同样适用于几乎任何其他类型的数据库和数据库管理系统。

公开(公告)号：US20160140175A1

公开(公告)日：2016-05-19

申请号：US14540792

申请日：2014-11-13

Applicant: Christoph Weyerhaeuser ,  Tobias Mindnich ,  Johannes Merx ,  Yongsik Yoon ,  Sung Heun Wi ,  Jeong Ae Han

Inventor： Christoph Weyerhaeuser ,  Tobias Mindnich ,  Johannes Merx ,  Yongsik Yoon ,  Sung Heun Wi ,  Jeong Ae Han

IPC: G06F17/30

CPC classification number: G06F17/30463

Abstract: According to an aspect, a database system for integrating calculation models into execution plans includes a first engine configured to parse a query to be applied on a database. The first engine is configured to invoke a second engine during query compilation. The second engine is configured to instantiate a calculation model based on the query, and the second engine is configured to derive a converted calculation model by converting the calculation model into a format compatible with the first engine. The first engine is configured to incorporate the converted calculation model into an execution plan during the query compilation and execute the query on the database according to execution plan.

Abstract translation: 根据一方面，用于将计算模型集成到执行计划中的数据库系统包括被配置为解析要应用于数据库的查询的第一引擎。 第一个引擎配置为在查询编译期间调用第二个引擎。 第二引擎被配置为基于查询实例化计算模型，并且第二引擎被配置为通过将计算模型转换成与第一引擎兼容的格式来导出转换的计算模型。 第一个引擎被配置为在查询编译期间将转换的计算模型合并到执行计划中，并根据执行计划对数据库执行查询。