公开(公告)号：US09619514B2

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

申请号：US14307092

申请日：2014-06-17

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

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

IPC分类号： G06F17/30

CPC分类号： G06F17/30442

摘要： 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.

公开(公告)号：US20150370865A1

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

申请号：US14311670

申请日：2014-06-23

申请人： Sang Il Song ,  Won Seok Kim ,  Sanghyun Choi ,  Yongsik Yoon

发明人： Sang Il Song ,  Won Seok Kim ,  Sanghyun Choi ,  Yongsik Yoon

IPC分类号： G06F17/30

CPC分类号： G06F17/30554 ,  G06F17/30398 ,  G06F17/30448 ,  G06F17/3046 ,  G06F17/30463 ,  G06F17/30507

摘要： Embodiments relate to re-writing database query plans, and visualizing such re-written query plans. A query re-write framework includes a query normalization engine in communication with a rule catalog comprising query re-write rules in the form of rule classes. The framework receives as input, a query plan graph to be re-written. Based upon the engine's application of re-write rules from the catalog, the framework produces a re-written query plan graph as output. An interface component of the framework may provide a visualization of the re-written query plan graph as part of a dashboard. A user may access the framework to enable/disable existing rules in the catalog, add new rules to the catalog, and/or control a sequence and a precedence in which rules are applied to re-write the query plan. A user may interact with the visualization of the re-written query plan for purposes of de-bugging, re-write optimization, and/or query development.

摘要翻译： 实施例涉及重写数据库查询计划，以及可视化这种重写的查询计划。 查询重写框架包括与规则目录通信的查询规范化引擎，其包括规则类形式的查询重写规则。 该框架作为输入接收要重新写入的查询计划图。 基于引擎从目录中重写规则的应用程序，该框架生成重写的查询计划图作为输出。 框架的界面组件可以提供重写的查询计划图的可视化，作为仪表板的一部分。 用户可以访问框架以启用/禁用目录中的现有规则，向目录添加新规则，和/或控制应用规则重写查询计划的序列和优先级。 用户可以与重新编写的查询计划的可视化进行交互，以便进行解码，重写优化和/或查询开发。

公开(公告)号：US20130166534A1

公开(公告)日：2013-06-27

申请号：US13334711

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

公开(公告)号：US09558258B2

公开(公告)日：2017-01-31

申请号：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分类号： G06F7/00 ,  G06F17/30 ,  G06F17/24

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.

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

公开(公告)号：US20150363463A1

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

申请号：US14307092

申请日：2014-06-17

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

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

IPC分类号： G06F17/30

CPC分类号： G06F17/30442

摘要： 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.

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

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