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

1. 发明授权

US07085751B2 Query execution in query processing systems 失效
标题翻译：在查询处理系统中查询执行
公开(公告)号：US07085751B2
公开(公告)日：2006-08-01
申请号：US09757427
申请日：2001-01-10
申请人： Ian R. Finlay , Bruce G. Lindsay , Guy M. Lohman , David C. Sharpe , Daniel C. Zilio
发明人： Ian R. Finlay , Bruce G. Lindsay , Guy M. Lohman , David C. Sharpe , Daniel C. Zilio
IPC分类号： G06F7/00 , G06F17/00
CPC分类号： G06F17/30477 , Y10S707/954 , Y10S707/99931 , Y10S707/99933 , Y10S707/99943
摘要： A query processing system having a data manager, and a query manager also includes a buffer. The query manager calls the data manager to access data based on a query. Where there is no predicate check or consumption operation on the record accessed, the data manager will notionally return the record to the query manager. However, the data manager accomplishes the return by writing the relevant portions of the record to a buffer. The data manager maintains stabilization of the page containing the record while the buffer is being written to. The data manager continues to access records on the stabilized page and to write such records to the buffer where appropriate. The query manager retrieves the records from the buffer after the data manager has completed its operation resulting from the query manager call.
摘要翻译：具有数据管理器和查询管理器的查询处理系统还包括缓冲器。查询管理器根据查询调用数据管理器访问数据。在访问记录上没有谓词检查或消费操作的情况下，数据管理器将会将记录返回给查询管理器。然而，数据管理器通过将记录的相关部分写入缓冲器来完成返回。在缓冲区被写入时，数据管理器维护包含记录的页面的稳定性。数据管理器继续访问稳定页面上的记录，并在适当时将此类记录写入缓冲区。在数据管理器完成由查询管理器调用产生的操作之后，查询管理器从缓冲区中检索记录。

2. 发明授权

US07007006B2 Method for recommending indexes and materialized views for a database workload 失效
公开(公告)号：US07007006B2
公开(公告)日：2006-02-28
申请号：US10177007
申请日：2002-06-21
申请人： Daniel C. Zilio , Gary G. Valentin , Guy M. Lohman , Calisto P. Zuzarte , Roberta J. Cochrane , Hamid Pirahesh , Markos Zaharioudakis , Kit Man Cheung , Kevin S. Beyer , David E. Simmen , Ting Y. Leung , Samuel S. Lightstone
发明人： Daniel C. Zilio , Gary G. Valentin , Guy M. Lohman , Calisto P. Zuzarte , Roberta J. Cochrane , Hamid Pirahesh , Markos Zaharioudakis , Kit Man Cheung , Kevin S. Beyer , David E. Simmen , Ting Y. Leung , Samuel S. Lightstone
IPC分类号： G06F17/30
CPC分类号： G06F17/30312 , Y10S707/99932 , Y10S707/99934 , Y10S707/99935
摘要： The invention herein provides method and apparatus, including software for determining a set of materialized views or indices of the contents or a subset of the contents of a database in a data processing system to be created for one or more users of the database. The method and apparatus provide method and means for evaluating a workload presented by a user to the database; evaluating the data processing system characteristics; evaluating the database characteristics; and, using the above evaluations for recommending a set of suitable materialized views or indices to the user. Another aspect of the invention, which may be used for a workload presented by a user of a database in a data processing system, provides method and apparatus, including software for determining a set of materialized views or indices of the contents or a subset of the contents of the database, by: generating a plurality of materialized view candidates from evaluation of the workload, data processing system characteristics and database characteristics; estimating statistics for the materialized view candidates such as the number of rows, row size, and column statistics; generating a plurality of potential index candidates by evaluating the workload, data processing system characteristics, database characteristics and the materialized view candidates; and, from the materialized view candidates and index candidates selecting a set of suitable materialized views and/or indices for submission to the user.

3. 发明授权

US07752160B2 Method for unordered relational database retrieval returning distinct values 有权
标题翻译：无序关系数据库检索返回不同值的方法
公开(公告)号：US07752160B2
公开(公告)日：2010-07-06
申请号：US10188569
申请日：2002-07-02
申请人： Ian R. Finlay , Tony Wen Hsun Lai , Daniel C. Zilio , Calisto Paul Zuzarte
发明人： Ian R. Finlay , Tony Wen Hsun Lai , Daniel C. Zilio , Calisto Paul Zuzarte
IPC分类号： G06F17/30
CPC分类号： G06F17/30486 , Y10S707/99933
摘要： The retrieval of distinct tuples in a relational database management system. In response to a request from a consumer process for distinct tuples in a relational database table matching a defined criteria, a distinct operator component sequentially requests tuples from a source component. The source component access the database table and returns a tuple in the sequence to the distinct operator component. The distinct operator component passes each tuple in the sequence to an auxiliary logger. The auxiliary component receives a tuples from the distinct component and determines if it is distinct from other previously received tuples in the sequence to verify its uniqueness to the distinct operator. Tuples that are verified as unique by the auxiliary logger are returned to the consumer process by the distinct operator upon verification.
摘要翻译：在关系数据库管理系统中检索不同的元组。响应于来自消费者进程的针对匹配定义的标准的关系数据库表中的不同元组的请求，不同的运营商组件从源组件顺序地请求元组。源组件访问数据库表，并将序列中的元组返回到不同的运算符组件。不同的运算符组件将序列中的每个元组传递给辅助记录器。辅助组件从不同组件接收元组，并确定它是否与序列中其他先前接收的元组不同，以验证其与不同运算符的唯一性。通过辅助记录器验证为唯一的元组在验证时由不同的运算符返回给消费者进程。

4. 发明申请

US20080263017A1 SYSTEM FOR UNORDERED RELATIONAL DATABASE RETRIEVAL RETURNING DISTINCT VALUES 审中-公开
标题翻译：不相关数据库检索返回值的系统
公开(公告)号：US20080263017A1
公开(公告)日：2008-10-23
申请号：US12166289
申请日：2008-07-01
申请人： Ian R. Finlay , Tony Wen Hsun Lai , Daniel C. Zilio , Calisto Paul Zuzarte
发明人： Ian R. Finlay , Tony Wen Hsun Lai , Daniel C. Zilio , Calisto Paul Zuzarte
IPC分类号： G06F7/06 , G06F17/30
CPC分类号： G06F16/24554 , Y10S707/99933
摘要： The retrieval of distinct tuples in a relational database management system. In response to a request from a consumer process for distinct tuples in a relational database table matching a defined criteria, a distinct operator component sequentially requests tuples from a source component. The source component access the database table and returns a tuple in the sequence to the distinct operator component. The distinct operator component passes each tuple in the sequence to an auxiliary logger. The auxiliary component receives a tuples from the distinct component and determines if it is distinct from other previously received tuples in the sequence to verify its uniqueness to the distinct operator. Tuples that are verified as unique by the auxiliary logger are returned to the consumer process by the distinct operator upon verification.
摘要翻译：在关系数据库管理系统中检索不同的元组。响应于来自消费者进程的针对匹配定义的标准的关系数据库表中的不同元组的请求，不同的运营商组件从源组件顺序地请求元组。源组件访问数据库表，并将序列中的元组返回到不同的运算符组件。不同的运算符组件将序列中的每个元组传递给辅助记录器。辅助组件从不同组件接收元组，并确定它是否与序列中其他先前接收的元组不同，以验证其与不同运算符的唯一性。通过辅助记录器验证为唯一的元组在验证时由不同的运算符返回给消费者进程。

5. 发明授权

US06879977B2 Execution of database queries including filtering 有权
公开(公告)号：US06879977B2
公开(公告)日：2005-04-12
申请号：US09757428
申请日：2001-01-10
申请人： Paul C. Huffman , Kathy A. McKnight , David C. Sharpe , Daniel C. Zilio
发明人： Paul C. Huffman , Kathy A. McKnight , David C. Sharpe , Daniel C. Zilio
IPC分类号： G06F12/00 , G06F17/30
CPC分类号： G06F17/30486 , G06F17/30492 , Y10S707/99932 , Y10S707/99933 , Y10S707/99935 , Y10S707/99943 , Y10S707/99945
摘要： A query processing system has a query processor and a data manager. The query processor calls the data manager to carry out data access for a query including a filtering operation. The data manager accesses the data in a set of data and before returning the data, initiates a callback to the query processor to determine if the located data meets the filtering criteria. Where the data does not satisfy the filtering criteria, the data manager seeks additional data in the set of data, without having to return the first located data to the query processor.

6. 发明授权

US08825616B2 Execution of database queries including filtering 有权
标题翻译：执行数据库查询，包括过滤
公开(公告)号：US08825616B2
公开(公告)日：2014-09-02
申请号：US11780777
申请日：2007-07-20
申请人： Paul C. Huffman , Kathy A. McKnight , David C. Sharpe , Daniel C. Zilio
发明人： Paul C. Huffman , Kathy A. McKnight , David C. Sharpe , Daniel C. Zilio
IPC分类号： G06F17/30
CPC分类号： G06F17/30486 , G06F17/30492 , Y10S707/99932 , Y10S707/99933 , Y10S707/99935 , Y10S707/99943 , Y10S707/99945
摘要： A query processing system has a query processor and a data manager. The query processor calls the data manager to carry out data access for a query including a filtering operation. The data manager accesses the data in a set of data and before returning the data, initiates a callback to the query processor to determine if the located data meets the filtering criteria. Where the data does not satisfy the filtering criteria, the data manager seeks additional data in the set of data, without having to return the first located data to the query processor.
摘要翻译：查询处理系统具有查询处理器和数据管理器。查询处理器调用数据管理器对包括过滤操作的查询执行数据访问。数据管理器访问一组数据中的数据，并在返回数据之前，向查询处理器发起回调，以确定所查找的数据是否满足过滤条件。在数据不满足过滤标准的情况下，数据管理器在数据集中寻求附加数据，而不必将第一定位数据返回给查询处理器。

7. 发明授权

US06961835B2 System and method for autonomically reallocating memory among buffer pools 失效
标题翻译：在缓冲池中自动重新分配内存的系统和方法
公开(公告)号：US06961835B2
公开(公告)日：2005-11-01
申请号：US10391686
申请日：2003-03-19
申请人： Sam S. Lightstone , Adam J. Storm , Gary Valentin , Daniel C. Zilio
发明人： Sam S. Lightstone , Adam J. Storm , Gary Valentin , Daniel C. Zilio
IPC分类号： G06F9/50 , G06F12/02 , G06F12/0866 , G06F12/00
CPC分类号： G06F12/12 , G06F9/5016 , G06F12/0866 , G06F12/123
摘要： A system and method autonomically reallocate memory among buffer pools to permit quick access to data. A simulated buffer pool extension (SBPX) is created for each buffer pool in a set of buffer pools. Data victimized from a buffer pool is represented in the associated SBPX. Requests for data that is not resident in a buffer pool but is represented in the associated SBPX are tallied. Periodically, an expected efficiency benefit of increasing the capacity of each buffer pool is determined from the tallies. Memory is reallocated from the buffer pool with the lowest expected efficiency benefit having remaining reallocatable memory to the buffer pool with the highest expected efficiency benefit having remaining reallocatable memory, until either one or both of the buffer pools exhausts its reallocatable memory. This process is repeated until all reallocatable memory has been reallocated, until only one buffer pool with reallocatable memory remains, or until all buffer pools with remaining reallocatable memory have substantially the same expected efficiency benefit.
摘要翻译：系统和方法在缓冲池中自动重新分配内存，以便快速访问数据。为一组缓冲池中的每个缓冲池创建模拟缓冲池扩展（SBPX）。从缓冲池中受害的数据在关联的SBPX中表示。对不驻留在缓冲池中但在关联的SBPX中表示的数据的请求进行计数。定期地，从提示中确定增加每个缓冲池容量的预期效率效益。从缓冲池中重新分配内存，将预留效率最低的优点在于具有剩余可重新分配内存到具有剩余可重新分配内存的最高预期效率优势的缓冲池，直到缓冲池中的一个或两者都耗尽其可重新分配的内存。重复此过程，直到所有可重新分配的内存已重新分配，直到只有一个具有可重新分配内存的缓冲池保留，或者直到具有剩余可重新分配内存的所有缓冲池具有基本相同的预期效率优势。

8. 发明授权

US09727608B2 Generating statistical views in a database system 有权
公开(公告)号：US09727608B2
公开(公告)日：2017-08-08
申请号：US13361800
申请日：2012-01-30
申请人： Qi Cheng , John F. Hornibrook , Ting Y. Leung , Xin Wu , Daniel C. Zilio , Calisto P. Zuzarte
发明人： Qi Cheng , John F. Hornibrook , Ting Y. Leung , Xin Wu , Daniel C. Zilio , Calisto P. Zuzarte
IPC分类号： G06F17/00 , G06F17/30
CPC分类号： G06F17/30463 , G06F17/30289
摘要： Techniques are disclosed for generating statistical views in a database system. In one embodiment, a request is received to execute a database workload. One or more constraints pertaining to executing the database workload is retrieved. The database workload is evaluated to generate multiple statistical view candidates. The statistical view candidates are refined based on the one or more constraints. One or more statistical views are then generated based on the refined statistical view candidates.

9. 发明申请

US20130198165A1 GENERATING STATISTICAL VIEWS IN A DATABASE SYSTEM 有权
标题翻译：在数据库系统中生成统计视图
公开(公告)号：US20130198165A1
公开(公告)日：2013-08-01
申请号：US13361800
申请日：2012-01-30
申请人： Qi Cheng , John F. Hornibrook , Ting Y. Leung , Xin Wu , Daniel C. Zilio , Calisto P. Zuzarte
发明人： Qi Cheng , John F. Hornibrook , Ting Y. Leung , Xin Wu , Daniel C. Zilio , Calisto P. Zuzarte
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F17/30463 , G06F17/30289
摘要： Techniques are disclosed for generating statistical views in a database system. In one embodiment, a request is received to execute a database workload. One or more constraints pertaining to executing the database workload is retrieved. The database workload is evaluated to generate multiple statistical view candidates. The statistical view candidates are refined based on the one or more constraints. One or more statistical views are then generated based on the refined statistical view candidates.
摘要翻译：公开了用于在数据库系统中生成统计视图的技术。在一个实施例中，接收到执行数据库工作负载的请求。检索与执行数据库工作负载有关的一个或多个约束。评估数据库工作负载以生成多个统计视图候选。基于一个或多个约束来改进统计视图候选。然后，基于精细的统计视图候选来生成一个或多个统计视图。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式