-
1.发明授权Method and system for query processing by combining indexes of multilevel granularity or composition 有权通过组合多级粒度或组合指标进行查询处理的方法和系统公开(公告)号：US06925463B2
公开(公告)日：2005-08-02
申请号：US10122460
申请日：2002-04-15
申请人： Bishwaranjan Bhattacharjee , Leslie A. Cranston , Matthew A. Huras , Tony Wen Hsun Lai , Timothy R. Malkemus , Sriram K. Padmanabhan , Kaarel Truuvert
发明人： Bishwaranjan Bhattacharjee , Leslie A. Cranston , Matthew A. Huras , Tony Wen Hsun Lai , Timothy R. Malkemus , Sriram K. Padmanabhan , Kaarel Truuvert
CPC分类号： G06F17/30321 , Y10S707/99933
摘要： A method to process a query for information stored in a relational database using indexes which have different granularity and/or composition is provided. The method involves selecting indexes of various granularity and/or composition based on the query, ordering and combining them (if necessary) in order to subset the data from a relational table to be optimally scanned. The ability to combine indexes is very useful to answer ad hoc queries for which no specific index exists. This requirement may be met by using index ANDing and index ORing techniques.
摘要翻译： 提供了使用具有不同粒度和/或组合的索引来处理关系数据库中存储的信息的查询的方法。 该方法包括基于查询，排序和组合它们（如果需要）来选择各种粒度和/或组合的索引，以便从关系表中的数据进行子集以进行最佳扫描。 组合索引的能力对于回答不存在特定索引的即席查询非常有用。 通过使用索引ANDing和索引ORing技术可以满足此要求。
-
2.发明授权Multidimensional data clustering scheme for query processing and maintenance in relational databases 有权关系数据库中查询处理和维护的多维数据聚类方案公开(公告)号：US07080081B2
公开(公告)日：2006-07-18
申请号：US10122502
申请日：2002-04-15
申请人： Ramesh C. Agarwal , Bishwaranjan Bhattacharjee , Leslie A. Cranston , Matthew A. Huras , Tony Wen Hsun Lai , Timothy R. Malkemus , Sriram K. Padmanabhan
发明人： Ramesh C. Agarwal , Bishwaranjan Bhattacharjee , Leslie A. Cranston , Matthew A. Huras , Tony Wen Hsun Lai , Timothy R. Malkemus , Sriram K. Padmanabhan
IPC分类号： G06F7/00
CPC分类号： G06F17/30592 , Y10S707/954 , Y10S707/957
摘要： Multidimensional clustered tables are provided for efficient processing and management in a relational database management system. A multidimensional clustered table is one whose data is simultaneously clustered along one or more independent dimensions, or clustering keys, and physically organized into blocks or pages on disk. When such a table is created, one can specify one or more keys as dimensions along which to cluster the table's data. Each of the dimensions can consist of one or more columns. Further provided are efficient query processing and maintenance techniques for use in conjunction with multidimensional clustered tables.
摘要翻译： 提供了多维集群表，用于在关系数据库管理系统中进行有效的处理和管理。 一个多维集群表是一个数据同时沿着一个或多个独立维度或聚类键进行聚类，并在物理上组织成磁盘上的块或页面。 创建此类表时，可以将一个或多个键指定为将数据集合在一起的维度。 每个维度可以由一个或多个列组成。 还提供了与多维集群表一起使用的有效的查询处理和维护技术。
-
3.发明授权公开(公告)号：US07752160B2
公开(公告)日：2010-07-06
申请号：US10188569
申请日：2002-07-02
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
公开(公告)日：2008-10-23
申请号：US12166289
申请日：2008-07-01
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.发明授权公开(公告)号：US06549895B1
公开(公告)日：2003-04-15
申请号：US09609887
申请日：2000-07-05
申请人： Tony Wen Hsun Lai
发明人： Tony Wen Hsun Lai
IPC分类号： G06F1730
CPC分类号： G06F17/30442 , G06F17/30433 , Y10S707/99932 , Y10S707/99933 , Y10S707/99935 , Y10S707/99938
摘要： A method and computer program product for analyzing data retrieval using index scanning in a database management system. The method involves scanning an index associated with a table in the database management system and selecting pages in the index. For each of the selected pages, the index entries are extracted and ranked. A distance parameter is then determined for each of the ranked index entries. The number of page transfers is estimated based on the distance parameters and the number of consecutive index entries which can be stored in the buffer pool.
摘要翻译： 一种用于在数据库管理系统中使用索引扫描来分析数据检索的方法和计算机程序产品。 该方法包括扫描与数据库管理系统中的表相关联的索引，并选择索引中的页面。 对于每个所选页面，索引条目被提取和排名。 然后为每个排名的索引条目确定距离参数。 基于距离参数和可以存储在缓冲池中的连续索引条目的数量来估计页面传送的数量。
-
-
-
-
搜索结果
5 条记录 (耗时 0.04 秒)