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

1. 发明授权

US06182151B2 Method and apparatus for batch storage of objects in a client-server storage management system 失效
标题翻译：在客户机 - 服务器存储管理系统中批量存储对象的方法和装置
公开(公告)号：US06182151B2
公开(公告)日：2001-01-30
申请号：US08688272
申请日：1996-07-29
申请人： Hsiuying Cheng , Jung-hsin Hu , Kyung B. Lee
发明人： Hsiuying Cheng , Jung-hsin Hu , Kyung B. Lee
IPC分类号： G06F900
CPC分类号： H04L29/06 , H04L67/42
摘要： The present invention is directed to a storage management system. More particularly if relates to a client/server library system for storing objects in the library system in batches by avoiding storing those objects in an intermediary storage, such as in a client storage space or in a cache, before storing them in the library system. The invention includes a library server, object server and library client, in which an application program interacts with the library client for storing objects, or binary large objects (blobs), in the object server under control of the library server. The present invention provides for an application program to read in objects into a memory space allocated and managed by the application program, or into an application program memory space allocated and managed by the library client. When the library client stores the objects residing in the allocated memory space, copies of the objects are transferred directly from the allocated memory space to the object server without having another copy of the object first being made in the library client, such as in the library client storage space or in a client cache. Accordingly, batch storage of objects is accomplished more efficiently than in conventional library system.
摘要翻译：本发明涉及存储管理系统。更具体地说，涉及一种用于通过在将这些对象存储在库系统中之前将这些对象存储在诸如客户端存储空间或高速缓存中的中间存储中来批量存储库系统中的对象的客户端/服务器库系统。本发明包括库服务器，对象服务器和库客户机，其中应用程序与库客户端交互以在库服务器的控制下存储对象或二进制大对象（blob））。本发明提供一种应用程序，用于将对象读入由应用程序分配和管理的存储器空间，或由库客户机分配和管理的应用程序存储空间。当库客户端存储驻留在分配的存储空间中的对象时，对象的副本将直接从分配的内存空间传输到对象服务器，而不会在库客户端中首先创建对象的另一个副本，例如库中客户端存储空间或客户端缓存。因此，与传统的图书馆系统相比，物体的批量存储更有效率地实现。

2. 发明授权

US09535952B2 Dynamic selection of optimal grouping sequence at runtime for grouping sets, rollup and cube operations in SQL query processing 有权
标题翻译：运行时动态选择最佳分组序列，以便在SQL查询处理中进行分组，汇总和多维数据集操作
公开(公告)号：US09535952B2
公开(公告)日：2017-01-03
申请号：US13443997
申请日：2012-04-11
申请人： Guogen Zhang , Fen-Ling Lin , Jung-Hsin Hu , Yao-Ching S. Chen , Yun Wang , Glenn M. Yuki
发明人： Guogen Zhang , Fen-Ling Lin , Jung-Hsin Hu , Yao-Ching S. Chen , Yun Wang , Glenn M. Yuki
IPC分类号： G06F17/30
CPC分类号： G06F17/30454
摘要： A method, apparatus, and article of manufacture for optimizing a query in a computer system. Grouping operations are optimized during execution of the query in the computer system by: (1) translating the grouping operations into a plurality of levels, wherein each of the levels is comprised of one or more grouping sets with the same number of grouping expressions; (2) deriving the grouping sets on a level-by-level basis, wherein the grouping sets in a base level are obtained from the database and the grouping sets in a next one of the levels are derived by selecting as an input a smallest one of the grouping sets in a previous one of the levels with which it has a derivation relationship; and (3) combining the derived grouping sets into an output for the query.
摘要翻译：一种用于优化计算机系统中的查询的方法，装置和制品。在计算机系统中执行查询期间优化分组操作：（1）将分组操作转换成多个级别，其中每个级别由具有相同数目的分组表达式的一个或多个分组集合组成; （2）逐级导出分组集合，其中从数据库获得基本级别中的分组集合，并且通过选择作为输入的最小的一个来导出下一个级别中的分组集合的分组集合在与其具有派生关系的前一个级别中; 和（3）将导出的分组集合合成用于查询的输出。

3. 发明申请

US20050027690A1 Dynamic selection of optimal grouping sequence at runtime for grouping sets, rollup and cube operations in SQL query processing 审中-公开
标题翻译：运行时动态选择最佳分组序列，以便在SQL查询处理中进行分组，汇总和多维数据集操作
公开(公告)号：US20050027690A1
公开(公告)日：2005-02-03
申请号：US10629459
申请日：2003-07-29
申请人： Guogen Zhang , Fen-Ling Lin , Jung-Hsin Hu , Yao-Ching Chen , Yun Wang , Glenn Yuki
发明人： Guogen Zhang , Fen-Ling Lin , Jung-Hsin Hu , Yao-Ching Chen , Yun Wang , Glenn Yuki
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F16/24537
摘要： A method, apparatus, and article of manufacture for optimizing a query in a computer system. During compilation of the query, a GROUP BY clause with one or more GROUPING SETS, ROLLUP or CUBE operations is maintained in its original form until after query rewrite. The GROUP BY clause with the GROUPING SETS, ROLLUP or CUBE operations is then translated into a plurality of levels having one or more grouping sets. After compilation of the query, a grouping sets sequence is dynamically determined for the GROUP BY clause with the GROUPING SETS, ROLLUP or CUBE operations based on intermediate grouping sets, in order to optimize the grouping sets sequence. The execution of the grouping sets sequence is optimized by selecting a smallest grouping set from a previous one of the levels as an input to a grouping set on a next one of the levels. Finally, a UNION ALL operation is performed on the grouping sets.
摘要翻译：一种用于优化计算机系统中的查询的方法，装置和制品。在编译查询期间，具有一个或多个GROUPING SETS，ROLLUP或CUBE操作的GROUP BY子句将保持其原始格式，直到查询重写为止。然后将具有GROUPING SETS，ROLLUP或CUBE操作的GROUP BY子句转换为具有一个或多个分组集合的多个级别。在编译查询之后，基于中间分组集合的GROUP BY子句动态确定分组集序列，并使用GROUPING GROUP，ROLLUP或CUBE操作，以优化分组集序列。通过从先前的一个级别中选择最小的分组集作为在下一个级别上的分组集合的输入来优化分组集序列的执行。最后，对分组集执行UNION ALL操作。

4. 发明申请

US20120226693A1 DYNAMIC SELECTION OF OPTIMAL GROUPING SEQUENCE AT RUNTIME FOR GROUPING SETS, ROLLUP AND CUBE OPERATIONS IN SQL QUERY PROCESSING 审中-公开
标题翻译：在SQL查询处理中动态选择最佳分组序列，用于分组集合，滚动和CUBE操作
公开(公告)号：US20120226693A1
公开(公告)日：2012-09-06
申请号：US13443997
申请日：2012-04-11
申请人： Guogen Zhang , Fen-Ling Lin , Jung-Hsin Hu , Yao-Ching S. Chen , Yun Wang , Glenn M. Yuki
发明人： Guogen Zhang , Fen-Ling Lin , Jung-Hsin Hu , Yao-Ching S. Chen , Yun Wang , Glenn M. Yuki
IPC分类号： G06F17/30
CPC分类号： G06F17/30454
摘要： A method, apparatus, and article of manufacture for optimizing a query in a computer system. During compilation of the query, a GROUP BY clause with one or more GROUPING SETS, ROLLUP or CUBE operations is maintained in its original form until after query rewrite. The GROUP BY clause with the GROUPING SETS, ROLLUP or CUBE operations is then translated into a plurality of levels having one or more grouping sets. After compilation of the query, a grouping sets sequence is dynamically determined for the GROUP BY clause with the GROUPING SETS, ROLLUP or CUBE operations based on intermediate grouping sets, in order to optimize the grouping sets sequence. The execution of the grouping sets sequence is optimized by selecting a smallest grouping set from a previous one of the levels as an input to a grouping set on a next one of the levels. Finally, a UNION ALL operation is performed on the grouping sets.
摘要翻译：一种用于优化计算机系统中的查询的方法，装置和制品。在编译查询期间，具有一个或多个GROUPING SETS，ROLLUP或CUBE操作的GROUP BY子句将保持其原始格式，直到查询重写为止。然后将具有GROUPING SETS，ROLLUP或CUBE操作的GROUP BY子句转换为具有一个或多个分组集合的多个级别。在编译查询之后，基于中间分组集合的GROUP BY子句动态确定分组集序列，并使用GROUPING GROUP，ROLLUP或CUBE操作，以优化分组集序列。通过从先前的一个级别中选择最小的分组集作为在下一个级别上的分组集合的输入来优化分组集序列的执行。最后，对分组集执行UNION ALL操作。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式