专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

41. 发明申请

US20150149442A1 Optimal Operator Placement for Distributed Query Processing 有权
标题翻译：分布式查询处理的最优运算符位置
公开(公告)号：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.
摘要翻译：可以确定用于完成在包括多个节点的分布式数据库管理系统中执行的多操作数据库过程的多个子计划的全局最小成本。多个子计划可以包括多个节点中的多个运营商的节点位置的不同分布。可以从多个子计划中选择具有最低总体最小全局成本的最优计划。

42. 发明授权

US08046334B2 Dual access to concurrent data in a 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.

43. 发明授权

US07065537B2 Method and system for highly-parallel logging and recovery operation in main-memory transaction processing systems 有权
公开(公告)号：US07065537B2
公开(公告)日：2006-06-20
申请号：US09768301
申请日：2001-01-25
申请人： Sang Kyun Cha , Ju Chang Lee , Ki Hong Kim
发明人： Sang Kyun Cha , Ju Chang Lee , Ki Hong Kim
IPC分类号： G06F17/30
CPC分类号： G06F11/1474 , G06F11/1471 , G06F2201/80 , Y10S707/968 , Y10S707/99953
摘要： An efficient logging method and system is disclosed that can be used to recover from a failure in a transaction system. It is based on a differential logging scheme that allows commutative and associative recovery operations. The method includes the steps of taking a before-image of the primary database in main memory before an update to the primary database; taking an after-image of the primary database after the update; generating a differential log by applying bit-wise exclusive-OR (XOR) between the before-image and the after-image; and performing either a redo or undo operation by applying XOR between said one or more logs and the before-image. Since XOR operations are commutative and associative, correct recovery is possible regardless of the creation sequence of log records. The present invention improves the performance of a logging system by reducing the size of log records and by allowing parallel execution of recovery operations.

44. 发明申请

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

45. 发明授权

US08880508B2 Processing database queries using format conversion 有权
标题翻译：使用格式转换处理数据库查询
公开(公告)号：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
IPC分类号： G06F17/30 , G06F7/00
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.
摘要翻译：公开了用于处理与正在查询的数据库存储模型不同的数据库查询的设备，方法和系统。可以通过接收对存储在数据库中的一个或多个数据项的查询来确定是否使用至少一个使用具有不同于存储模型的格式的数据的查询运算符来执行独立于查询数据库的存储模型的数据库查询格式化存储在数据库中的一个或多个数据项中的至少一个，并且将由至少一个查询运算符使用的数据的格式转换为与存储的一个或多个数据项中的至少一个的存储模型格式相匹配的格式在数据库中。还描述了相关系统，方法和制品。

46. 发明授权

US08838578B2 Interactive query plan visualization and optimization 有权
标题翻译：交互式查询计划可视化和优化
公开(公告)号：US08838578B2
公开(公告)日：2014-09-16
申请号：US13323563
申请日：2011-12-12
申请人： Yongsik Yoon , Chanho Jeong , Sang Kyun Cha
发明人： Yongsik Yoon , Chanho Jeong , Sang Kyun Cha
IPC分类号： G06F17/30
CPC分类号： G06F17/30442
摘要： A computer system affords a user the ability to interactively formulate, visualize, and modify query plans that are to be posed to a database. The computer system provides query visualization in the form of decision trees having nodes selectable/deselectable to search for alternative query plans with lower or minimum execution time. The estimated cost and/or the execution time of a subtree of a query plan may be mapped according to a rectangle area metaphore, with the area of a rectangle enclosed by a larger rectangle representing a parent node in the plan tree. Query plans may be saved by the system in order to facilitate their visualization, optimization, and/or modification at a later date.
摘要翻译：计算机系统为用户提供交互式制定，可视化和修改要呈现给数据库的查询计划的能力。计算机系统以具有可选择/可选择的节点的决策树的形式提供查询可视化，以搜索具有较低或最小执行时间的替代查询计划。可以根据矩形区域元标记来映射查询计划的子树的估计成本和/或执行时间，其中矩形的面积由表示方案树中的父节点的较大矩形所包围。系统可以保存查询计划，以便以后方便他们的可视化，优化和/或修改。

47. 发明申请

US20120173515A1 Processing Database Queries Using Format Conversion 有权
标题翻译：使用格式转换处理数据库查询
公开(公告)号：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.
摘要翻译：公开了用于处理与正在查询的数据库存储模型不同的数据库查询的设备，方法和系统。可以通过接收对存储在数据库中的一个或多个数据项的查询来确定是否使用至少一个使用具有不同于存储模型的格式的数据的查询运算符来执行独立于查询数据库的存储模型的数据库查询格式化存储在数据库中的一个或多个数据项中的至少一个，并且将由至少一个查询运算符使用的数据的格式转换成与存储的一个或多个数据项中的至少一个的存储模型格式相匹配的格式在数据库中。还描述了相关系统，方法和制品。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式