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

31. 发明授权

US08782100B2 Hybrid database table stored as both row and column store 有权
公开(公告)号：US08782100B2
公开(公告)日：2014-07-15
申请号：US13334777
申请日：2011-12-22
申请人： Yongsik Yoon , Chanho Jeong , Juchang Lee , Chang Bin Song , Yong Sik Kwon , Sang Kyun Cha
发明人： Yongsik Yoon , Chanho Jeong , Juchang Lee , Chang Bin Song , Yong Sik Kwon , Sang Kyun Cha
IPC分类号： G06F7/00 , G06F17/24 , G06F17/30
CPC分类号： G06F17/30592 , G06F17/245 , G06F17/30312 , G06F17/30315 , G06F17/30321 , G06F17/30377 , G06F17/30584 , G06F17/30867
摘要： 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.

32. 发明申请

US20130166553A1 Hybrid Database Table Stored as Both Row and Column Store 有权
公开(公告)号：US20130166553A1
公开(公告)日：2013-06-27
申请号：US13334669
申请日：2011-12-22
申请人： Yongsik Yoon , Chanho Jeong , Juchang Lee , Chang Bin Song , Yong Sik Kwon , Sang Kyun Cha
发明人： Yongsik Yoon , Chanho Jeong , Juchang Lee , Chang Bin Song , Yong Sik Kwon , Sang Kyun Cha
IPC分类号： G06F17/30
CPC分类号： G06F17/30424 , G06F17/30312 , G06F17/30371 , G06F17/30584
摘要： 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.

33. 发明申请

US20160063378A1 INTERVAL DISAGGREGATE 审中-公开
标题翻译：间隔异常
公开(公告)号：US20160063378A1
公开(公告)日：2016-03-03
申请号：US14471450
申请日：2014-08-28
申请人： Kunsoo Park , Sang Kyun Cha , Chang Bin Song , Ki Hong Kim , Sunho Lee , Cheol Yoo
发明人： Kunsoo Park , Sang Kyun Cha , Chang Bin Song , Ki Hong Kim , Sunho Lee , Cheol Yoo
IPC分类号： G06N5/04 , G06N7/00
CPC分类号： G06N7/005
摘要： A system includes determination of a total target value associated with N dimension members, determination of a set of historical values for each of the N dimension members, for each of the N dimension members, determination of a prediction interval based on the set of historical values of the dimension member, determination of an N-polytope in N-dimensional space based on the N determined prediction intervals, determination of an (N−1)-polytope of the N-dimensional space in which the sum of the N values of each coordinate of the (N−1)-polytope equals the total desired value, determination of an (N−1)-dimensional intersection of the N-polytope and the (N−1) polytope, and determination of a disaggregation of the total target value among the N dimension members based on the coordinates of the (N−1)-dimensional intersection.
摘要翻译：系统包括确定与N维成员相关联的总目标值，确定N维成员中的每一个的N个维度成员中的每一个的一组历史值，基于历史值集合来确定预测间隔根据N个确定的预测间隔确定N维空间中的N-多面体，确定N维空间的（N-1） - 多面体，其中每个（N-1） - 多面体的坐标等于总需要值，确定N-多孔体和（N-1）多面体的（N-1）维交叉点，以及确定总目标的解聚基于（N-1）维交点的坐标，N维成员之间的值。

34. 发明申请

US20110161300A1 DUAL ACCESS TO CONCURRENT DATA IN A 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
IPC分类号： G06F7/00 , 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.
摘要翻译：各种实施例包括允许在数据库管理系统中双重访问并发数据的系统，方法，软件和数据结构中的一个或多个，包括未提交的更新数据。一些实施例包括多版本并发控制风格数据库中的数据的双重快照，但是这里描述的实施例同样适用于几乎任何其他类型的数据库和数据库管理系统。

35. 发明申请

US20090070330A1 DUAL ACCESS TO CONCURRENT DATA IN A 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.
摘要翻译：各种实施例包括允许在数据库管理系统中双重访问并发数据的系统，方法，软件和数据结构中的一个或多个，包括未提交的更新数据。一些实施例包括多版本并发控制风格数据库中的数据的双重快照，但是这里描述的实施例同样适用于几乎任何其他类型的数据库和数据库管理系统。

36. 发明申请

US20130151505A1 Interactive Query Plan Visualization and Optimization 有权
标题翻译：交互式查询计划可视化和优化
公开(公告)号：US20130151505A1
公开(公告)日：2013-06-13
申请号：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.
摘要翻译：计算机系统为用户提供交互式制定，可视化和修改要呈现给数据库的查询计划的能力。计算机系统以具有可选择/可选择的节点的决策树的形式提供查询可视化，以搜索具有较低或最小执行时间的替代查询计划。可以根据矩形区域元标记来映射查询计划的子树的估计成本和/或执行时间，其中矩形的面积由表示方案树中的父节点的较大矩形所包围。系统可以保存查询计划，以便以后方便他们的可视化，优化和/或修改。

37. 发明授权

US09965500B2 Mixed join of row and column database tables in native orientation 有权
公开(公告)号：US09965500B2
公开(公告)日：2018-05-08
申请号：US13323530
申请日：2011-12-12
申请人： Yongsik Yoon , Chanho Jeong , Sang Kyun Cha
发明人： Yongsik Yoon , Chanho Jeong , Sang Kyun Cha
IPC分类号： G06F17/30
CPC分类号： G06F17/30315 , G06F17/30498
摘要： A mixed join between database column and row tables employs an algorithm that recognizes both row and column store, and is executable upon the data in its native form (row or column) without requiring conversion between orientations. The native mixed join algorithm accesses the column dictionary of the column table for efficient join processing. The native mixed join algorithm may also exploit an inverted index (if present) to search a record (e.g. docid) with a given value. In particular, the native mixed join algorithm looks up a column dictionary for a join condition, while iterating the row table and returning matched records in a pipelined manner.

38. 发明申请

US20130151502A1 Mixed Join of Row and Column Database Tables in Native Orientation 有权
标题翻译：混合加入行和列数据库表在原生方向
公开(公告)号：US20130151502A1
公开(公告)日：2013-06-13
申请号：US13323530
申请日：2011-12-12
申请人： Yongsik Yoon , Chanho Jeong , Sang Kyun Cha
发明人： Yongsik Yoon , Chanho Jeong , Sang Kyun Cha
IPC分类号： G06F17/30
CPC分类号： G06F17/30315 , G06F17/30498
摘要： A mixed join between database column and row tables employs an algorithm that recognizes both row and column store, and is executable upon the data in its native form (row or column) without requiring conversion between orientations. The native mixed join algorithm accesses the column dictionary of the column table for efficient join processing. The native mixed join algorithm may also exploit an inverted index (if present) to search a record (e.g. docid) with a given value. In particular, the native mixed join algorithm looks up a column dictionary for a join condition, while iterating the row table and returning matched records in a pipelined manner.
摘要翻译：数据库列和行表之间的混合连接采用识别行和列存储的算法，并且可以以其本机形式（行或列）的数据执行，而不需要在方向之间进行转换。本地混合连接算法访问列表的列字典以进行有效的连接处理。本地混合连接算法还可以利用反向索引（如果存在）来搜索具有给定值的记录（例如，docid）。特别地，本地混合连接算法查找连接条件的列字典，同时迭代行表并以流水线方式返回匹配的记录。

39. 发明授权

US07930274B2 Dual access to concurrent data in a database management system 有权
标题翻译：在数据库管理系统中双重访问并发数据
公开(公告)号：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.
摘要翻译：各种实施例包括允许在数据库管理系统中双重访问并发数据的系统，方法，软件和数据结构中的一个或多个，包括未提交的更新数据。一些实施例包括多版本并发控制风格数据库中的数据的双重快照，但是这里描述的实施例同样适用于几乎任何其他类型的数据库和数据库管理系统。

40. 发明授权

US09892163B2 Optimal operator placement for distributed query processing 有权
公开(公告)号：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.

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式