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

1. 发明授权

US08112414B2 Apparatus and system for reducing locking in materialized query tables 失效
标题翻译：用于减少物化查询表中锁定的装置和系统
公开(公告)号：US08112414B2
公开(公告)日：2012-02-07
申请号：US12200674
申请日：2008-08-28
申请人： James P. Bates , Jonathan Sloan , Calisto P. Zuzarte
发明人： James P. Bates , Jonathan Sloan , Calisto P. Zuzarte
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30362 , G06F17/30377
摘要： Disclosed is an apparatus and system for reducing locking in materialized query tables (MQT) for distributive functions. The apparatus includes an insert module that inserts into an MQT table a child record when a new record is inserted into a base table associated with the MQT. The child record includes values associated with the insert operation. Also included is a delete module that inserts into the MQT a child record that includes measure values that are the negative of the measure values in the base table row that is the subject of the delete operation. An update module inserts two child rows into the MQT, one negating the affected record and the other adding the values of the update operation. Each inserted child row includes a unique identifier that relates the inserted row to a parent row. An execution module generates responses using the values indicated by the cumulative records in a family.
摘要翻译：公开了用于减少用于分配功能的物化查询表（MQT）中的锁定的装置和系统。该装置包括插入模块，当将新记录插入到与MQT相关联的基表中时，插入到MQT表中的子记录。子记录包括与插入操作相关联的值。还包括一个删除模块，将删除模块插入到包含测量值的子记录中，该测量值是作为删除操作主题的基表行中度量值的负值。更新模块将两个子行插入到MQT中，一个对待受影响的记录，另一个添加更新操作的值。每个插入的子行包含将插入的行与父行相关联的唯一标识符。执行模块使用家庭中累积记录指示的值生成响应。

2. 发明授权

US07680821B2 Method and system for index sampled tablescan 失效
标题翻译：索引采样表的方法和系统
公开(公告)号：US07680821B2
公开(公告)日：2010-03-16
申请号：US10215073
申请日：2002-08-07
申请人： Ian R. Finlay , Calisto P. Zuzarte
发明人： Ian R. Finlay , Calisto P. Zuzarte
IPC分类号： G06F17/00
CPC分类号： G06F17/30321 , G06F17/30463
摘要： An optimized query processing system and method for a database system. The database system includes a table of data and an index correlated to both the query and to the table. The optimized query processing system includes an index accessing module adapted to access the index to determine if the table contains an entry satisfying a query predicate; and a tablescan module for scanning substantially the entire table and retrieving data satisfying the query. A method is also disclosed for generating database diagnostic data.
摘要翻译：一种用于数据库系统的优化查询处理系统和方法。数据库系统包括数据表和与查询和表相关的索引。所述优化查询处理系统包括适于访问所述索引的索引访问模块，以确定所述表是否包含满足查询谓词的条目; 以及用于基本扫描整个表并检索满足查询的数据的桌面模块。还公开了一种用于生成数据库诊断数据的方法。

3. 发明授权

US07275056B2 System and method for transforming queries using window aggregation 有权
标题翻译：使用窗口聚合转换查询的系统和方法
公开(公告)号：US07275056B2
公开(公告)日：2007-09-25
申请号：US10425343
申请日：2003-04-29
申请人： Qi Cheng , Linqi Liu , Wenbin Ma , Mir Hamid Pirahesh , Calisto P. Zuzarte
发明人： Qi Cheng , Linqi Liu , Wenbin Ma , Mir Hamid Pirahesh , Calisto P. Zuzarte
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30451 , Y10S707/99934 , Y10S707/99935
摘要： A system and method transform queries with subqueries, using window aggregation. An optimizer in a relational database management system transforms queries to optimize their efficiency and speed. The method transforms queries that have a subquery, replacing the subquery with a window aggregation function. In the case of a correlated subquery, the window aggregation function is partitioned by a correlated column of a correlated table. All data in the main select clause, or outer block, of the query that was obtained through references to the correlated table is instead obtained through the new window aggregation subquery. By using window aggregation, the aggregation is performed at the same time as the selection of relevant data from the correlated table, thereby compiling all needed data in a single pass through the table or view. Reducing the number of times that tables or views are accessed reduces the computational demands of a query.
摘要翻译：系统和方法使用子查询转换查询，使用窗口聚合。关系数据库管理系统中的优化器可以转换查询以优化其效率和速度。该方法转换具有子查询的查询，使用窗口聚合函数替换子查询。在相关子查询的情况下，窗口聚合函数由相关表的相关列划分。通过引用相关表获得的查询的main select子句或外部块中的所有数据都是通过新的窗口聚合子查询得到的。通过使用窗口聚合，在从相关表中选择相关数据的同时进行聚合，从而在通过表或视图的单次传递中编译所有需要的数据。降低访问表或视图的次数减少了查询的计算需求。

4. 发明申请

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.
摘要翻译：公开了用于在数据库系统中生成统计视图的技术。在一个实施例中，接收到执行数据库工作负载的请求。检索与执行数据库工作负载有关的一个或多个约束。评估数据库工作负载以生成多个统计视图候选。基于一个或多个约束来改进统计视图候选。然后，基于精细的统计视图候选来生成一个或多个统计视图。

5. 发明申请

US20130198164A1 Executing CASE Expressions Containing Subqueries 有权
标题翻译：执行包含子查询的CASE表达式
公开(公告)号：US20130198164A1
公开(公告)日：2013-08-01
申请号：US13358779
申请日：2012-01-26
申请人： Qi Cheng , John F. Hornibrook , Jose A. Saborit , David C. Sharpe , Calisto P. Zuzarte
发明人： Qi Cheng , John F. Hornibrook , Jose A. Saborit , David C. Sharpe , Calisto P. Zuzarte
IPC分类号： G06F17/30
CPC分类号： G06F17/30483
摘要： Methods and apparatus, including computer program products, implementing and using techniques for executing a query in a computer to retrieve data from a relational database stored on a data storage device. A query is received that contains a CASE expression having one or more subqueries. A query execution plan is generated. The query execution plan uses a parameterized union all operator to keep the semantics of the CASE expression, and a nested loop join operator to drive data across the section of the query execution plan that executes the CASE expression without performing any join operations. The generated query execution plan is executed in the computer to retrieve data from the relational database.
摘要翻译：方法和装置，包括计算机程序产品，用于在计算机中执行查询以从存储在数据存储设备上的关系数据库中检索数据的实现和使用技术。接收到包含具有一个或多个子查询的CASE表达式的查询。生成查询执行计划。查询执行计划使用参数化的联合所有运算符来保留CASE表达式的语义，以及嵌套循环连接运算符来驱动执行CASE表达式的查询执行计划部分中的数据，而不执行任何连接操作。生成的查询执行计划在计算机中执行以从关系数据库检索数据。

6. 发明授权

US07512625B2 Method, system and program for joining source table rows with target table rows 失效
标题翻译：将源表行与目标表行连接的方法，系统和程序
公开(公告)号：US07512625B2
公开(公告)日：2009-03-31
申请号：US11095619
申请日：2005-04-01
申请人： Josep L. Lariba-Pey , Victor Muntés-Mulero , Hebert W. Pereyra , Josep Aguilar-Saborit , Calisto P. Zuzarte
发明人： Josep L. Lariba-Pey , Victor Muntés-Mulero , Hebert W. Pereyra , Josep Aguilar-Saborit , Calisto P. Zuzarte
IPC分类号： G06F17/30
CPC分类号： G06F17/30466 , G06F17/30498 , Y10S707/99931 , Y10S707/99933 , Y10S707/99943
摘要： Disclosed is a data processing system implemented method, a data processing system, and an article of manufacturing for use with the data processing system. The data processing system implemented method is used for directing the data processing system to join rows associated with a column of a source table with rows associated with a column of a target table. The data processing system includes a source node containing the source table and including a target node containing the target table. The method includes generating a reduced representation of selected rows associated with the column of the source table, and generating a representation of the column of the target table, filtering the generated reduced representation of selected rows associated with the column of the source table through the generated representation of the column of the target table, the filtered generated reduced representation of selected rows identifying source table rows that do not have to be joined with the target table, and joining, to the rows associated with the column of the target table, the rows associated with the column of the source table minus the filtered generated reduced representation of selected rows.
摘要翻译：公开了一种与数据处理系统一起使用的数据处理系统实现方法，数据处理系统和制造物品。数据处理系统实现的方法用于指导数据处理系统连接与源表的列相关联的行，该行与目标表的列相关联。数据处理系统包括包含源表并包括目标表的目标节点的源节点。该方法包括生成与源表的列相关联的所选行的缩小表示，以及生成目标表的列的表示，通过生成的对源表的列相关联的所选行的过滤生成的缩小表示目标表的列的表示，被筛选的生成的缩小表示，标识不必与目标表连接的源表行，并且将与加入目标表的列相关联的行加入到行中与源表的列减去所筛选的生成的所选行的缩小表示相关联。

7. 发明授权

US07454416B2 Method for aggregation subquery join elimination 失效
标题翻译：聚合子查询连接消除方法
公开(公告)号：US07454416B2
公开(公告)日：2008-11-18
申请号：US10428263
申请日：2003-04-30
申请人： Calisto P Zuzarte , Qi Cheng , Wenbin Ma
发明人： Calisto P Zuzarte , Qi Cheng , Wenbin Ma
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30979 , Y10S707/99933 , Y10S707/99934
摘要： A method for use with an information retrieval system, in which the method is used for transforming a database statement containing a first subquery and a second subquery joined together, the first subquery including a group by operation over a child subquery, the method comprising removing the first subquery from the database statement thereby removing the join between the first subquery and the second subquery.
摘要翻译：一种与信息检索系统一起使用的方法，其中所述方法用于变换包含连接在一起的第一子查询和第二子查询的数据库语句，所述第一子查询包括通过在子子查询上的操作的组，所述方法包括：数据库语句中的第一个子查询，从而删除第一个子查询和第二个子查询之间的连接。

8. 发明授权

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.

9. 发明授权

US06778976B2 Selectivity estimation for processing SQL queries containing having clauses 失效
标题翻译：用于处理包含有子句的SQL查询的选择性估计
公开(公告)号：US06778976B2
公开(公告)日：2004-08-17
申请号：US09757434
申请日：2001-01-10
申请人： Peter J. Haas , John E. Lumby , Calisto P. Zuzarte
发明人： Peter J. Haas , John E. Lumby , Calisto P. Zuzarte
IPC分类号： G06F1730
CPC分类号： G06F17/30595 , G06F17/30469 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934
摘要： The estimate of the selectivity of a HAVING clause in an SQL query is carried out within a specified time constraint by determining a selectivity estimate for each member in a sample set of group sizes for the HAVING clause using a probabilistic model based on an assumed value distribution. The selectivity estimates for the groups in the sample set are used to interpolate estimates for all possible group sizes and the estimates are combined based on an assumed known group size distribution to provide an estimation of the selectivity for the HAVING clause. Different selectivity estimating approaches are used for each group size based on available time for estimating and on the estimated time to complete the estimate using different techniques.
摘要翻译：通过使用基于假定值分布的概率模型，通过确定HAVING子句的组大小的样本集合中每个成员的选择性估计，在指定时间约束内执行SQL查询中HAVING子句的选择性估计。样本集中的组的选择性估计用于内插所有可能组大小的估计，并且基于假设的已知组大小分布来组合估计，以提供对HAVING子句的选择性的估计。基于可用的估计时间和使用不同技术完成估计的估计时间，对于每个组大小使用不同的选择性估计方法。

10. 发明授权

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.

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式