公开(公告)号：US20150074082A1

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

申请号：US14543022

申请日：2014-11-17

申请人： 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/30345 ,  G06F17/30312 ,  G06F17/30339 ,  G06F17/30442 ,  G06F17/30466 ,  G06F17/30477 ,  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.

摘要翻译： 混合数据库表存储为行和列存储。 可以单独使用或组合使用一种或多种技术，以通过调节处理密集型列存储数据的访问和/或大小来增强混合表的性能。 例如，在插入操作期间，只有在考虑了某些过滤和/或边界条件之后，才能搜索列存储数据以获得唯一性违规。 在另一技术中，混合表管理器可以基于诸如访问频率或基础业务逻辑等考虑来控制数据到列存储的移动。 在另一种技术中，对混合表的查询可以仅在行存储数据的初始搜索不能返回结果之后才能搜索列存储数据。

公开(公告)号：US20140304219A1

公开(公告)日：2014-10-09

申请号：US14299843

申请日：2014-06-09

申请人： 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/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.

摘要翻译： 混合数据库表存储为行和列存储。 可以单独使用或组合使用一种或多种技术，以通过调节处理密集型列存储数据的访问和/或大小来增强混合表的性能。 例如，在插入操作期间，只有在考虑了某些过滤和/或边界条件之后，才能搜索列存储数据以获得唯一性违规。 在另一技术中，混合表管理器可以基于诸如访问频率或基础业务逻辑等考虑来控制数据到列存储的移动。 在另一种技术中，对混合表的查询可以仅在行存储数据的初始搜索不能返回结果之后才能搜索列存储数据。

公开(公告)号：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.

摘要翻译： 计算机系统为用户提供交互式制定，可视化和修改要呈现给数据库的查询计划的能力。 计算机系统以具有可选择/可选择的节点的决策树的形式提供查询可视化，以搜索具有较低或最小执行时间的替代查询计划。 可以根据矩形区域元标记来映射查询计划的子树的估计成本和/或执行时间，其中矩形的面积由表示方案树中的父节点的较大矩形所包围。 系统可以保存查询计划，以便以后方便他们的可视化，优化和/或修改。

公开(公告)号：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.

公开(公告)号：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.

公开(公告)号：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.

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

公开(公告)号：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.

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

公开(公告)号：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.

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

公开(公告)号：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维成员之间的值。

公开(公告)号：US20150149409A1

公开(公告)日：2015-05-28

申请号：US14302320

申请日：2014-06-11

申请人： Joo Yeon Lee ,  Juchang Lee ,  Kyu Hwan Kim ,  Chul Won Lee ,  Yong Sik Kwon ,  Sang Kyun Cha

发明人： Joo Yeon Lee ,  Juchang Lee ,  Kyu Hwan Kim ,  Chul Won Lee ,  Yong Sik Kwon ,  Sang Kyun Cha

IPC分类号： G06F17/30

CPC分类号： G06F17/30575

摘要： Technologies are described for performing replication within a database environment. For example, replication of database data can be performed using data manipulation language (DML) statements and logical logs. A database node can execute a DML statement, create a logical log comprising the DML statement, and insert the logical log into a logical log queue. The logical log can be sent to one or more other database nodes for execution of the DML statement stored within the logical log. Logical logs can be grouped for sending to other nodes. Logical logs can be executed on a first node and one or more other nodes within the same transaction boundary. Execution of DML statements can be decoupled from sending, receiving, grouping, and/or processing of logical logs.

摘要翻译： 描述了在数据库环境中执行复制的技术。 例如，可以使用数据操作语言（DML）语句和逻辑日志来执行数据库数据的复制。 数据库节点可以执行DML语句，创建包含DML语句的逻辑日志，并将逻辑日志插入到逻辑日志队列中。 可以将逻辑日志发送到一个或多个其他数据库节点，以执行逻辑日志中存储的DML语句。 逻辑日志可以分组发送到其他节点。 逻辑日志可以在同一事务边界内的第一个节点和一个或多个其他节点上执行。 DML语句的执行可以与逻辑日志的发送，接收，分组和/或处理分离。