-
公开(公告)号:US08880508B2
公开(公告)日:2014-11-04
申请号:US12982673
申请日:2010-12-30
申请人: Chanho Jeong , Sang Yong Hwang , Sang Kyun Cha , Sung Heun Wi
发明人: Chanho Jeong , Sang Yong Hwang , Sang Kyun Cha , Sung Heun Wi
CPC分类号: G06F17/30463 , G06F17/30 , G06F17/30286 , G06F17/30471 , G06F17/30492 , G06F17/30569
摘要: 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.
摘要翻译: 公开了用于处理与正在查询的数据库存储模型不同的数据库查询的设备,方法和系统。 可以通过接收对存储在数据库中的一个或多个数据项的查询来确定是否使用至少一个使用具有不同于存储模型的格式的数据的查询运算符来执行独立于查询数据库的存储模型的数据库查询 格式化存储在数据库中的一个或多个数据项中的至少一个,并且将由至少一个查询运算符使用的数据的格式转换为与存储的一个或多个数据项中的至少一个的存储模型格式相匹配的格式 在数据库中。 还描述了相关系统,方法和制品。
-
公开(公告)号:US20120173515A1
公开(公告)日:2012-07-05
申请号:US12982673
申请日:2010-12-30
申请人: Chanho Jeong , Sang Yong Hwang , Sang Kyun Cha , Sung Heun Wi
发明人: Chanho Jeong , Sang Yong Hwang , Sang Kyun Cha , Sung Heun Wi
IPC分类号: G06F17/30
CPC分类号: G06F17/30463 , G06F17/30 , G06F17/30286 , G06F17/30471 , G06F17/30492 , G06F17/30569
摘要: 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.
摘要翻译: 公开了用于处理与正在查询的数据库存储模型不同的数据库查询的设备,方法和系统。 可以通过接收对存储在数据库中的一个或多个数据项的查询来确定是否使用至少一个使用具有不同于存储模型的格式的数据的查询运算符来执行独立于查询数据库的存储模型的数据库查询 格式化存储在数据库中的一个或多个数据项中的至少一个,并且将由至少一个查询运算符使用的数据的格式转换成与存储的一个或多个数据项中的至少一个的存储模型格式相匹配的格式 在数据库中。 还描述了相关系统,方法和制品。
-
公开(公告)号:US07930274B2
公开(公告)日:2011-04-19
申请号:US11854140
申请日:2007-09-12
申请人: Sang Yong Hwang , Ki Hong Kim , Sung Heun Wi , Sang Kyun Cha
发明人: Sang Yong Hwang , Ki Hong Kim , Sung Heun Wi , Sang Kyun Cha
IPC分类号: G06F7/00
CPC分类号: G06F17/30551 , G06F17/30348
摘要: 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.
摘要翻译: 各种实施例包括允许在数据库管理系统中双重访问并发数据的系统,方法,软件和数据结构中的一个或多个,包括未提交的更新数据。 一些实施例包括多版本并发控制风格数据库中的数据的双重快照,但是这里描述的实施例同样适用于几乎任何其他类型的数据库和数据库管理系统。
-
公开(公告)号:US08046334B2
公开(公告)日:2011-10-25
申请号:US13045867
申请日:2011-03-11
申请人: Sang Yong Hwang , Ki Hong Kim , Sung Heun Wi , Sang Kyun Cha
发明人: Sang Yong Hwang , Ki Hong Kim , Sung Heun Wi , Sang Kyun Cha
IPC分类号: G06F7/00
CPC分类号: G06F17/30551 , G06F17/30348
摘要: 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.
-
公开(公告)号:US20110161300A1
公开(公告)日:2011-06-30
申请号:US13045867
申请日:2011-03-11
申请人: Sang Yong Hwang , Ki Hong Kim , Sung Heun Wi , Sang Kyun Cha
发明人: Sang Yong Hwang , Ki Hong Kim , Sung Heun Wi , Sang Kyun Cha
CPC分类号: G06F17/30551 , G06F17/30348
摘要: 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.
摘要翻译: 各种实施例包括允许在数据库管理系统中双重访问并发数据的系统,方法,软件和数据结构中的一个或多个,包括未提交的更新数据。 一些实施例包括多版本并发控制风格数据库中的数据的双重快照,但是这里描述的实施例同样适用于几乎任何其他类型的数据库和数据库管理系统。
-
公开(公告)号:US20090070330A1
公开(公告)日:2009-03-12
申请号:US11854140
申请日:2007-09-12
申请人: Sang Yong Hwang , Ki Hong Kim , Sung Heun Wi , Sang Kyun Cha
发明人: Sang Yong Hwang , Ki Hong Kim , Sung Heun Wi , Sang Kyun Cha
IPC分类号: G06F17/30
CPC分类号: G06F17/30551 , G06F17/30348
摘要: 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.
摘要翻译: 各种实施例包括允许在数据库管理系统中双重访问并发数据的系统,方法,软件和数据结构中的一个或多个,包括未提交的更新数据。 一些实施例包括多版本并发控制风格数据库中的数据的双重快照,但是这里描述的实施例同样适用于几乎任何其他类型的数据库和数据库管理系统。
-
公开(公告)号:US20150026154A1
公开(公告)日:2015-01-22
申请号:US14508524
申请日:2014-10-07
申请人: Chanho Jeong , Sangyong Hwang , Sang Kyun Cha , Sung Heun Wi
发明人: Chanho Jeong , Sangyong Hwang , Sang Kyun Cha , Sung Heun Wi
IPC分类号: G06F17/30
CPC分类号: G06F17/30463 , G06F17/30 , G06F17/30286 , G06F17/30471 , G06F17/30492 , G06F17/30569
摘要: 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.
摘要翻译: 公开了用于处理与正在查询的数据库存储模型不同的数据库查询的设备,方法和系统。 可以通过接收对存储在数据库中的一个或多个数据项的查询来确定是否使用至少一个使用具有不同于存储模型的格式的数据的查询运算符来执行独立于查询数据库的存储模型的数据库查询 格式化存储在数据库中的一个或多个数据项中的至少一个,并且将由至少一个查询运算符使用的数据的格式转换为与存储的一个或多个数据项中的至少一个的存储模型格式相匹配的格式 在数据库中。 还描述了相关系统,方法和制品。
-
公开(公告)号:US09892163B2
公开(公告)日:2018-02-13
申请号:US14450114
申请日:2014-08-01
申请人: Ki Hong Kim , Sangyong Hwang , Sung Heun Wi , Jane Jung Lee , Joo Young Yoon , Sang Kyun Cha
发明人: Ki Hong Kim , Sangyong Hwang , Sung Heun Wi , Jane Jung Lee , Joo Young Yoon , Sang Kyun Cha
IPC分类号: G06F17/30
CPC分类号: G06F17/30469 , G06F17/30463 , G06F17/30466
摘要: Total global minimum costs can be determined for multiple sub-plans for completing a multi-operation database process to be performed in a distributed database management system that includes a plurality of nodes. The multiple sub-plans can include different distributions of node locations of a plurality of operators among the plurality of nodes. An optimal plan having a lowest total minimum global cost can be selected from the multiple sub-plans.
-
公开(公告)号:US20150149442A1
公开(公告)日:2015-05-28
申请号:US14450114
申请日:2014-08-01
申请人: Ki Hong Kim , Sangyong Hwang , Sung Heun Wi , Jane Jung Lee , Joo Young Yoon , Sang Kyun Cha
发明人: Ki Hong Kim , Sangyong Hwang , Sung Heun Wi , Jane Jung Lee , Joo Young Yoon , Sang Kyun Cha
IPC分类号: G06F17/30
CPC分类号: G06F17/30469 , G06F17/30463 , G06F17/30466
摘要: Total global minimum costs can be determined for multiple sub-plans for completing a multi-operation database process to be performed in a distributed database management system that includes a plurality of nodes. The multiple sub-plans can include different distributions of node locations of a plurality of operators among the plurality of nodes. An optimal plan having a lowest total minimum global cost can be selected from the multiple sub-plans.
摘要翻译: 可以确定用于完成在包括多个节点的分布式数据库管理系统中执行的多操作数据库过程的多个子计划的全局最小成本。 多个子计划可以包括多个节点中的多个运营商的节点位置的不同分布。 可以从多个子计划中选择具有最低总体最小全局成本的最优计划。
-
公开(公告)号:US09846724B2
公开(公告)日:2017-12-19
申请号:US14540792
申请日:2014-11-13
申请人: Christoph Weyerhaeuser , Tobias Mindnich , Johannes Merx , Yongsik Yoon , Sung Heun Wi , Jeong Ae Han
发明人: Christoph Weyerhaeuser , Tobias Mindnich , Johannes Merx , Yongsik Yoon , Sung Heun Wi , Jeong Ae Han
IPC分类号: G06F17/30
CPC分类号: G06F17/30463
摘要: 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.
-
-
-
-
-
-
-
-
-