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

11. 发明授权

US09336284B2 Client-side statement routing in distributed database 有权
标题翻译：分布式数据库中的客户端语句路由
公开(公告)号：US09336284B2
公开(公告)日：2016-05-10
申请号：US14306963
申请日：2014-06-17
申请人： Juchang Lee , Jaeyun Noh , Chulwon Lee , Michael Muehle , Alexander Schroeder , Marco Paskamp , Sang Kyun Cha
发明人： Juchang Lee , Jaeyun Noh , Chulwon Lee , Michael Muehle , Alexander Schroeder , Marco Paskamp , Sang Kyun Cha
IPC分类号： G06F17/30
CPC分类号： G06F17/30545 , G06F17/30477
摘要： A system includes reception of a first query from a client device at a first database node of a database instance comprising two or more database nodes, determination of a second database node of the two or more database nodes associated with the first query, compilation of the first query at the first database node to generate first compiled code, and transmission of the first compiled code and a first identifier of the second database node from the first database node to the client device.
摘要翻译：一种系统包括在包括两个或多个数据库节点的数据库实例的第一数据库节点处从客户端设备接收第一查询，确定与第一查询相关联的两个或多个数据库节点的第二数据库节点，在第一数据库节点处首先查询以生成第一编译代码，以及将第一编译代码和第二数据库节点的第一标识符从第一数据库节点传输到客户端设备。

12. 发明申请

US20150149704A1 Transaction Private Log Buffering for High Performance of Transaction Processing 有权
标题翻译：事务处理的高性能的事务私有日志缓冲
公开(公告)号：US20150149704A1
公开(公告)日：2015-05-28
申请号：US14244686
申请日：2014-04-03
申请人： Juchang Lee , Beomsoo Kim , Kyu Hwan Kim , Jaeyun Noh , Sang Kyun Cha
发明人： Juchang Lee , Beomsoo Kim , Kyu Hwan Kim , Jaeyun Noh , Sang Kyun Cha
IPC分类号： G06F3/06
CPC分类号： G06F17/30368 , G06F9/466 , G06F12/08 , G06F2206/1014
摘要： For each data change occurring transaction created as part of a write operation initiated for one or more tables in a main-memory-based DBMS, a transaction log entry can be written to a private log buffer corresponding to the transaction. All transaction log entries in the private log buffer can be flushed to a global log buffer upon completion of the transaction to which the private log buffer corresponds.
摘要翻译：对于作为在基于主内存的DBMS中的一个或多个表启动的写入操作的一部分而创建的每个数据更改发生的事务，事务日志条目可以写入对应于事务的专用日志缓冲区。专用日志缓冲区中的所有事务日志条目可以在私有日志缓冲区对应的事务完成后刷新到全局日志缓冲区。

13. 发明申请

US20150074082A1 Hybrid Database Table Stored as Both Row and Column Store 审中-公开
标题翻译：混合数据库表存储为行和列存储
公开(公告)号：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.
摘要翻译：混合数据库表存储为行和列存储。可以单独使用或组合使用一种或多种技术，以通过调节处理密集型列存储数据的访问和/或大小来增强混合表的性能。例如，在插入操作期间，只有在考虑了某些过滤和/或边界条件之后，才能搜索列存储数据以获得唯一性违规。在另一技术中，混合表管理器可以基于诸如访问频率或基础业务逻辑等考虑来控制数据到列存储的移动。在另一种技术中，对混合表的查询可以仅在行存储数据的初始搜索不能返回结果之后才能搜索列存储数据。

14. 发明申请

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

15. 发明授权

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

16. 发明申请

US20140304219A1 Hybrid Database Table Stored as Both Row and Column Store 有权
标题翻译：混合数据库表存储为行和列存储
公开(公告)号：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.
摘要翻译：混合数据库表存储为行和列存储。可以单独使用或组合使用一种或多种技术，以通过调节处理密集型列存储数据的访问和/或大小来增强混合表的性能。例如，在插入操作期间，只有在考虑了某些过滤和/或边界条件之后，才能搜索列存储数据以获得唯一性违规。在另一技术中，混合表管理器可以基于诸如访问频率或基础业务逻辑等考虑来控制数据到列存储的移动。在另一种技术中，对混合表的查询可以仅在行存储数据的初始搜索不能返回结果之后才能搜索列存储数据。

17. 发明授权

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

18. 发明授权

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.

19. 发明申请

US20130275550A1 UPDATE PROTOCOL FOR CLIENT-SIDE ROUTING INFORMATION 有权
标题翻译：用于客户端路由信息的更新协议
公开(公告)号：US20130275550A1
公开(公告)日：2013-10-17
申请号：US13449081
申请日：2012-04-17
申请人： Juchang Lee , Jaeyun Noh , Chulwon Lee , Michael Muehle , Alexander Schroeder , Marco Paskamp , Sang Kyun Cha
发明人： Juchang Lee , Jaeyun Noh , Chulwon Lee , Michael Muehle , Alexander Schroeder , Marco Paskamp , Sang Kyun Cha
IPC分类号： G06F15/16 , G06F17/30
CPC分类号： G06F17/30545
摘要： A system includes reception of a first query from a client device at a first database node of a database instance, determination of routing information associated with the first query, compilation of the first query at the first database node to generate first compiled code, transmission of the first compiled code and the routing information to the client device, reception of the compiled code from the client device at a second database node, determination, at the second database node, that data associated with the compiled query is associated with a third database node, transmission of the compiled code from the second database node to the third database node, reception of query results at the second database node from the third database node, and transmission of the query results and an indication to update the routing information from the second database node to the client device.
摘要翻译：系统包括在数据库实例的第一数据库节点处从客户端设备接收第一查询，确定与第一查询相关联的路由信息，在第一数据库节点处编译第一查询以生成第一编译代码，传输第一编译代码和到客户端设备的路由信息，在第二数据库节点从客户端设备接收编译代码，在第二数据库节点确定与编译查询相关联的数据与第三数据库节点将编译代码从第二数据库节点传输到第三数据库节点，从第三数据库节点接收第二数据库节点处的查询结果，以及发送查询结果以及从第二数据库更新路由信息的指示节点到客户端设备。

20. 发明申请

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.

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式