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

1. 发明授权

US08332388B2 Transformation rule profiling for a query optimizer 有权
标题翻译：用于查询优化器的转换规则概要分析
公开(公告)号：US08332388B2
公开(公告)日：2012-12-11
申请号：US12818237
申请日：2010-06-18
申请人： Surajit Chaudhuri , Leo Giakoumakis , Vivek Narasayya , Ravi Ramamurthy
发明人： Surajit Chaudhuri , Leo Giakoumakis , Vivek Narasayya , Ravi Ramamurthy
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30463
摘要： Technology is described for transformation rule profiling for a query optimizer. The method can include obtaining a database query configured to be optimized by the query optimizer of a database system. An optimized query plan for the database query can be found using a host set of transformation rules. One transformation rule can be removed and checked at a time. Each transformation rule can be checked to determine whether the transformation rule affects an optimal query plan output. A test query plan can be generated after each transformation rule has been removed. The query optimizer can determine whether the test query plan is different than the optimized query plan in the absence of the removed transformation rule. An equivalent set of transformation rules can be created that includes transformation rules where the test query plan generated from the equivalent set of transformation rules is equivalent to the optimized plan.
摘要翻译：描述技术用于查询优化器的转换规则剖析。该方法可以包括获得配置为由数据库系统的查询优化器优化的数据库查询。可以使用主机转换规则集查找数据库查询的优化查询计划。一次可以删除和检查一个转换规则。可以检查每个变换规则以确定变换规则是否影响最优查询计划输出。每个转换规则已被删除后，可以生成测试查询计划。在没有删除的转换规则的情况下，查询优化器可以确定测试查询计划是否与优化的查询计划不同。可以创建一组等效的转换规则，其中包括转换规则，其中从等效转换规则集生成的测试查询计划等同于优化的计划。

2. 发明申请

US20110314000A1 TRANSFORMATION RULE PROFILING FOR A QUERY OPTIMIZER 有权
标题翻译：用于查询优化器的变换规则轮廓
公开(公告)号：US20110314000A1
公开(公告)日：2011-12-22
申请号：US12818237
申请日：2010-06-18
申请人： Surajit Chaudhuri , Leo Giakoumakis , Vivek Narasayya , Ravi Ramamurthy
发明人： Surajit Chaudhuri , Leo Giakoumakis , Vivek Narasayya , Ravi Ramamurthy
IPC分类号： G06F17/30
CPC分类号： G06F17/30463
摘要： Technology is described for transformation rule profiling for a query optimizer. The method can include obtaining a database query configured to be optimized by the query optimizer of a database system. An optimized query plan for the database query can be found using a host set of transformation rules. One transformation rule can be removed and checked at a time. Each transformation rule can be checked to determine whether the transformation rule affects an optimal query plan output. A test query plan can be generated after each transformation rule has been removed. The query optimizer can determine whether the test query plan is different than the optimized query plan in the absence of the removed transformation rule. An equivalent set of transformation rules can be created that includes transformation rules where the test query plan generated from the equivalent set of transformation rules is equivalent to the optimized plan.
摘要翻译：描述技术用于查询优化器的转换规则剖析。该方法可以包括获得配置为由数据库系统的查询优化器优化的数据库查询。可以使用主机转换规则集查找数据库查询的优化查询计划。一次可以删除和检查一个转换规则。可以检查每个变换规则以确定变换规则是否影响最优查询计划输出。每个转换规则已被删除后，可以生成测试查询计划。在没有删除的转换规则的情况下，查询优化器可以确定测试查询计划是否与优化的查询计划不同。可以创建一组等效的转换规则，其中包括转换规则，其中从等效转换规则集生成的测试查询计划等同于优化的计划。

3. 发明申请

US20100235347A1 TECHNIQUES FOR EXACT CARDINALITY QUERY OPTIMIZATION 有权
标题翻译：精确的CARDINALITY QUERY优化技术
公开(公告)号：US20100235347A1
公开(公告)日：2010-09-16
申请号：US12404284
申请日：2009-03-14
申请人： Surajit Chaudhuri , Vivek Narasayya , Ravishankar Ramamurthy
发明人： Surajit Chaudhuri , Vivek Narasayya , Ravishankar Ramamurthy
IPC分类号： G06F17/30
CPC分类号： G06F17/30463
摘要： An exact cardinality query optimization system and method for optimizing a query having a plurality of expressions to obtain a cardinality-optimal query execution plan for the query. Embodiments of the system and method use various techniques to shorten the time necessary to obtain the cardinality-optimal query execution plan, which contains the query execution plan when all cardinalities are exact. Embodiments of the system and method include a covering queries technique that leverages query execution feedback to obtain an unordered subset of relevant expressions for the query, an early termination technique that bounds the cardinality to determine whether the processing can be terminate before each of the expressions are executed, and an expressions ordering technique that finds an ordering of expressions that yields the greatest reduction in time to obtain the cardinality-optimal query execution plan.
摘要翻译：一种精确的基数查询优化系统和方法，用于优化具有多个表达式的查询，以获得查询的基数最优查询执行计划。系统和方法的实施例使用各种技术来缩短获得基数优化查询执行计划所需的时间，当所有基数是精确的时，其包含查询执行计划。该系统和方法的实施例包括利用查询执行反馈来获取查询的相关表达式的无序子集的覆盖查询技术，限制基数以确定处理是否可以在每个表达式之前终止的提前终止技术是以及表达式排序技术，其找到产生最大时间缩短以获得基数优化查询执行计划的表达式的排序。

4. 发明授权

US07299220B2 Constructing database object workload summaries 有权
标题翻译：构建数据库对象工作量摘要
公开(公告)号：US07299220B2
公开(公告)日：2007-11-20
申请号：US10815061
申请日：2004-03-31
申请人： Surajit Chaudhuri , Vivek Narasayya , Prasanna Ganesan
发明人： Surajit Chaudhuri , Vivek Narasayya , Prasanna Ganesan
IPC分类号： G06F17/30
CPC分类号： G06F17/30489 , G06F17/30306 , Y10S707/99932 , Y10S707/99934 , Y10S707/99935
摘要： A database object summarization tool is provided that selects a subset of database objects subject to filtering constraints such as a partial order or optimization of some attribute. A dominance primitive filters out tuples that are dominated according to a partial order constraint by another tuple. A representation primitive selects a representative subset of tuples such than an optimization criteria is met.
摘要翻译：提供了一种数据库对象摘要工具，该工具选择受过滤约束（如某些属性的部分顺序或优化）的数据库对象的子集。优势原语过滤掉由另一个元组根据部分顺序约束所主导的元组。表示基元选择满足优化标准的元组的代表性子集。

5. 发明申请

US20060085484A1 Database tuning advisor 审中-公开
标题翻译：数据库调优顾问
公开(公告)号：US20060085484A1
公开(公告)日：2006-04-20
申请号：US10966563
申请日：2004-10-15
申请人： Alexander Raizman , Arunprasad Marathe , Djana Milton , Dmitry Sonkin , Lubor Kollar , Maciej Sarnowicz , Manoj Syamala , Raja Duddupudi , Sanjay Agrawal , Surajit Chaudhuri , Vivek Narasayya
发明人： Alexander Raizman , Arunprasad Marathe , Djana Milton , Dmitry Sonkin , Lubor Kollar , Maciej Sarnowicz , Manoj Syamala , Raja Duddupudi , Sanjay Agrawal , Surajit Chaudhuri , Vivek Narasayya
IPC分类号： G06F17/30
CPC分类号： G06F16/2282 , G06F16/2272
摘要： An automated physical database design tool may provide an integrated physical design recommendation for horizontal partitioning, indexes and indexed views, all three features being tuned together (in concert). Manageability requirements may be specified when optimizing for performance. User-specified configuration may enable the specification of a partial physical design without materialization of the physical design. The tuning process may be performed for a production server but may be conducted substantially on a test server. Secondary indexes may be suggested for XML columns. Tuning of a database may be invoked by any owner of a database. Usage of objects may be evaluated and a recommendation for dropping unused objects may be issued. Reports may be provided concerning the count and percentage of queries in the workload that reference a particular database, and/or the count and percentage of queries in the workload that reference a particular table or column. A feature may be provided whereby a weight may be associated with each statement in the workload, enabling relative importance of particular statements to be specified. An in-row length for a column may be specified. If a value for the column exceeds the specified in-row length for that column, the portion of the value not exceeding the specified in-row length may be stored in the row while the portion of the value exceeding the specified in-row length may be stored in an overflow area. Rebuild and reorganization recommendations may be generated.
摘要翻译：自动化物理数据库设计工具可以为水平划分，索引和索引视图提供集成的物理设计建议，所有这三个特征被一起调谐（一致）。在优化性能时可以指定可管理性要求。用户指定的配置可以实现部分物理设计的规范，而不会实现物理设计。可以对生产服务器执行调整过程，但是可以基本上在测试服务器上进行。可以针对XML列建议辅助索引。数据库的任何拥有者都可以调用数据库。可以评估对象的使用，并且可以发出用于丢弃未使用对象的建议。可以提供关于引用特定数据库的工作负载中的查询的计数和百分比的报告，和/或引用特定表或列的工作负载中的查询的计数和百分比。可以提供特征，其中权重可以与工作负载中的每个语句相关联，使得能够指定特定语句的相对重要性。可以指定列的行内长度。如果列的值超过该列的指定行内长度，则不超过指定行内长度的部分可能存储在行中，而超出指定行内长度的值的部分可能会存储在溢出区域。可能会生成重建和重组建议。

6. 发明申请

US20060085410A1 Sampling for queries 有权
标题翻译：查询抽样
公开(公告)号：US20060085410A1
公开(公告)日：2006-04-20
申请号：US11296036
申请日：2005-12-07
申请人： Surajit Chaudhuri , Vivek Narasayya , Rajeev Motwani , Mayur Datar
发明人： Surajit Chaudhuri , Vivek Narasayya , Rajeev Motwani , Mayur Datar
IPC分类号： G06F17/30
CPC分类号： G06F17/30536 , G06F17/30489 , Y10S707/99931 , Y10S707/99932 , Y10S707/99933 , Y10S707/99942
摘要： A method of estimating the Results of a database query are estimated by performing a sampling of weighted tuples in a database based on a probability of usage of tuples required in executing a workload. A probability is associated with each tuple sampled. And, can aggregate is computed over values in each sampled tuple while multiplying by the inverses of the probabilities associated with each tuple sampled.
摘要翻译：通过基于执行工作负载所需的元组的使用概率，对数据库中的加权元组进行抽样来估计估计数据库查询结果的方法。每个元组采样的概率相关。并且，可以在每个采样的元组中的值上计算可以聚合，同时乘以与每个元组采样相关联的概率的逆。

7. 发明申请

US20050033739A1 Optimization based method for estimating the results of aggregate queries 有权
公开(公告)号：US20050033739A1
公开(公告)日：2005-02-10
申请号：US10935800
申请日：2004-09-08
申请人： Surajit Chaudhuri , Vivek Narasayya , Gantam Das
发明人： Surajit Chaudhuri , Vivek Narasayya , Gantam Das
IPC分类号： G06F17/30
CPC分类号： G06F17/30536 , G06F17/30489 , Y10S707/99933 , Y10S707/99934 , Y10S707/99936 , Y10S707/99937 , Y10S707/99943 , Y10S707/99945
摘要： A method for estimating the result of a query on a database having data records arranged in tables. The database has an expected workload that includes a set of queries that can be executed on the database. An expected workload is derived comprising a set of queries that can be executed on the database. A sample is constructed by selecting data records for inclusion in the sample in a manner that minimizes an estimation error when the data records are acted upon by a query in the expected workload to provide an expected workload to provide an expected result. The query accesses the sample and is executed on the sample, returning an estimated query result. The expected workload can be constructed by specifying a degree of overlap between records selected by queries in the given workload and records selected by queries in the expected workload.

8. 发明授权

US5950186A Database system index selection using cost evaluation of a workload for multiple candidate index configurations 失效
标题翻译：数据库系统索引选择使用多个候选索引配置的工作负载成本评估
公开(公告)号：US5950186A
公开(公告)日：1999-09-07
申请号：US912036
申请日：1997-08-15
申请人： Surajit Chaudhuri , Vivek Narasayya
发明人： Surajit Chaudhuri , Vivek Narasayya
IPC分类号： G06F17/30
CPC分类号： G06F17/30312 , Y10S707/99931 , Y10S707/99932 , Y10S707/99933 , Y10S707/99942 , Y10S707/99953 , Y10T156/1062
摘要： An index selection tool helps reduce costs in time and memory in selecting an index configuration or set of indexes for use by a database server in accessing a database in accordance with a workload of queries. The index selection tool attempts to reduce the number of indexes to be considered, the number of index configurations to be enumerated, and the number of invocations of a query optimizer in selecting an index configuration for the workload.
摘要翻译：索引选择工具有助于在选择索引配置或索引集时，在数据库服务器根据查询的工作量访问数据库时，减少时间和内存中的成本。索引选择工具尝试减少要考虑的索引数量，要枚举的索引配置数量以及查询优化器在为工作负载选择索引配置时调用的次数。

9. 发明授权

US07493337B2 Query progress estimation 有权
标题翻译：查询进度估计
公开(公告)号：US07493337B2
公开(公告)日：2009-02-17
申请号：US10813963
申请日：2004-03-31
申请人： Surajit Chaudhuri , Vivek Narasayya , Ravishankar Ramamurthy
发明人： Surajit Chaudhuri , Vivek Narasayya , Ravishankar Ramamurthy
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30522 , G06F17/30306 , Y10S707/99932 , Y10S707/99945 , Y10S707/99948
摘要： A query progress indicator that provides an indication to a user of the progress of a query being executed on a database. The indication of the progress of the query allows the user to decide whether the query should be allowed to complete or should be aborted. One method that may be used to estimate the progress of a query that is being executed on a database defines a model of work performed during execution of a query. The total amount of work that will be performed during execution of the query is estimated according to the model. The amount of work performed at a given point during execution of the query is estimated according to the model. The progress of the query is estimated using the estimated amount of work at the given point in time and the estimated total amount of work. This estimated progress of query execution may be provided to the user.
摘要翻译：查询进度指示符，向用户提供在数据库上执行的查询的进度的指示。查询进度的指示允许用户决定是否允许查询完成或应该被中止。可用于估计在数据库上执行的查询的进度的一种方法定义了在查询执行过程中执行的工作模型。根据模型估计执行查询期间执行的总工作量。在执行查询期间在给定点执行的工作量根据模型进行估计。查询的进度使用在给定时间点的估计工作量和估计的总工作量来估计。可以向用户提供该估计的查询执行进度。

10. 发明授权

US07293036B2 Compressing database workloads 有权
标题翻译：压缩数据库工作负载
公开(公告)号：US07293036B2
公开(公告)日：2007-11-06
申请号：US11008335
申请日：2004-12-08
申请人： Surajit Chaudhuri , Ashish Kumar Gupta , Vivek Narasayya
发明人： Surajit Chaudhuri , Ashish Kumar Gupta , Vivek Narasayya
IPC分类号： G06F17/30
CPC分类号： G06F17/30536 , G06F17/30306 , G06F17/30312 , Y10S706/917 , Y10S707/99932 , Y10S707/99942 , Y10S707/99945
摘要： Relational database applications such as index selection, histogram tuning, approximate query processing, and statistics selection have recognized the importance of leveraging workloads. Often these applications are presented with large workloads, i.e., a set of SQL DML statements, as input. A key factor affecting the scalability of such applications is the size of the workload. The invention concerns workload compression which helps improve the scalability of such applications. The exemplary embodiment is broadly applicable to a variety of workload-driven applications, while allowing for incorporation of application specific knowledge. The process is described in detail in the context of two workload-driven applications: index selection and approximate query processing.
摘要翻译：诸如索引选择，直方图调整，近似查询处理和统计选择等关系数据库应用程序已经认识到利用工作负载的重要性。通常，这些应用程序具有大的工作负载，即一组SQL DML语句作为输入。影响这些应用程序可扩展性的关键因素是工作负载的大小。本发明涉及工作负载压缩，这有助于提高这种应用的可扩展性。该示例性实施例广泛地适用于各种工作负载驱动的应用，同时允许结合应用特定的知识。该过程在两个工作负载驱动的应用程序的上下文中进行了详细描述：索引选择和近似查询处理。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式