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

1. 发明申请

US20100262593A1 AUTOMATED FILTERED INDEX RECOMMENDATIONS 审中-公开
标题翻译：自动过滤索引建议
公开(公告)号：US20100262593A1
公开(公告)日：2010-10-14
申请号：US12420077
申请日：2009-04-08
申请人： Nicolas Bruno , Surajit Chaudhuri , Vivek R. Narasayya , Manoj A. Syamala
发明人： Nicolas Bruno , Surajit Chaudhuri , Vivek R. Narasayya , Manoj A. Syamala
IPC分类号： G06F17/30
CPC分类号： G06F16/284 , G06F16/22 , G06F16/2228
摘要： The described implementations relate to filtered index recommendations. In one case a filtered index recommendation (FIR) tool is configured to recommend a final set of filtered indexes to use with a workload. The final set is selected from a first set of candidate filtered indexes and a second set of merged filtered indexes.
摘要翻译：所描述的实现涉及过滤的索引建议。在一种情况下，过滤索引推荐（FIR）工具被配置为推荐与工作负载一起使用的最终过滤索引集。从第一组候选过滤索引和第二组合并的过滤索引中选择最终集合。

2. 发明申请

US20090094086A1 AUTOMATIC ASSIGNMENT FOR DOCUMENT REVIEWING 审中-公开
标题翻译：文件审查自动转让
公开(公告)号：US20090094086A1
公开(公告)日：2009-04-09
申请号：US11866417
申请日：2007-10-03
申请人： Nicolas Bruno , Vivek R. Narasayya , Surajit Chaudhuri
发明人： Nicolas Bruno , Vivek R. Narasayya , Surajit Chaudhuri
IPC分类号： G06Q10/00 , G06F3/00
CPC分类号： G06Q10/00 , G06Q10/06311
摘要： Assignment algorithm for automatically making assignments between documents and document reviewers for a review process. If the automated assignments need adjusting, a coordinator can manually refine the assignment(s). The assignment algorithm facilitates the automated assignment process based on inputs related to a constraint and/or a preference. The constraints and preferences include, but are not limited to, a conflict of interest, a minimum number of reviews, a maximum number of submissions, a partial assignment, bidding preferences, and health metrics. Once the assignments have been made, histograms can be generated that present an overview of certain health metrics, further allowing refinement of the assignment process.
摘要翻译：分配算法用于自动进行文档和文档审阅者之间的分配以进行审核。如果自动分配需要调整，协调员可以手动优化任务。分配算法有助于基于与约束和/或偏好相关的输入的自动分配过程。限制和偏好包括但不限于利益冲突，最小审查次数，最大提交数量，部分分配，出价偏好和健康度量。一旦作出了分配，就可以生成直方图，显示某些健康指标的概述，进一步允许改进分配过程。

3. 发明授权

US10032131B2 Data services for enterprises leveraging search system data assets 有权
公开(公告)号：US10032131B2
公开(公告)日：2018-07-24
申请号：US13527601
申请日：2012-06-20
申请人： Tao Cheng , Kris Ganjam , Kaushik Chakrabarti , Zhimin Chen , Vivek R. Narasayya , Surajit Chaudhuri
发明人： Tao Cheng , Kris Ganjam , Kaushik Chakrabarti , Zhimin Chen , Vivek R. Narasayya , Surajit Chaudhuri
IPC分类号： G06F13/00 , G06Q10/10
摘要： A data service system is described herein which processes raw data assets from at least one network-accessible system (such as a search system), to produce processed data assets. Enterprise applications can then leverage the processed data assets to perform various environment-specific tasks. In one implementation, the data service system can generate any of: synonym resources for use by an enterprise application in providing synonyms for specified terms associated with entities; augmentation resources for use by an enterprise application in providing supplemental information for specified seed information; and spelling-correction resources for use by an enterprise application in providing spelling information for specified terms, and so on.

4. 发明授权

US07363301B2 Database aggregation query result estimator 有权
标题翻译：数据库聚合查询结果估计器
公开(公告)号：US07363301B2
公开(公告)日：2008-04-22
申请号：US11246355
申请日：2005-10-07
申请人： Surajit Chaudhuri , Vivek R. Narasayya , Rajeev Motwani , Mayur D. Datar
发明人： Surajit Chaudhuri , Vivek R. Narasayya , Rajeev Motwani , Mayur D. Datar
IPC分类号： G06F17/30
CPC分类号： G06F17/30489 , G06F17/30536 , G06F2216/03 , Y10S707/957 , Y10S707/99932 , Y10S707/99933 , Y10S707/99935 , Y10S707/99942 , Y10S707/99943
摘要： Aggregation queries are performed by first identifying outlier values, aggregating the outlier values, and sampling the remaining data after pruning the outlier values. The sampled data is extrapolated and added to the aggregated outlier values to provide an estimate for each aggregation query. Outlier values are identified by selecting values outside of a selected sliding window of data having the lowest variance. An index is created for the outlier values. The outlier data is removed from the window of data, and separately aggregated. The remaining data without the outliers is then sampled to provide a statistically relevant sample that is then aggregated and extrapolated to provide an estimate for the remaining data. This sampled estimate is combined with the outlier aggregate to form an estimate for the entire set of data.
摘要翻译：通过首先识别异常值，聚合异常值和在修剪异常值之后对剩余数据进行采样来执行聚合查询。采样数据被外推并加到聚合异常值中，以提供每个聚合查询的估计。异常值通过选择具有最小方差的数据的所选滑动窗口之外的值来识别。为异常值创建索引。离群数据从数据窗口中移除，并单独汇总。然后对没有异常值的剩余数据进行采样，以提供统计学上相关的样本，然后对其进行聚合和外插，以提供剩余数据的估计。该采样估计与异常值聚合组合以形成整套数据的估计。

5. 发明授权

US06356890B1 Merging materialized view pairs for database workload materialized view selection 有权
标题翻译：为数据库工作负载物化视图选择合并物化视图对
公开(公告)号：US06356890B1
公开(公告)日：2002-03-12
申请号：US09629353
申请日：2000-08-01
申请人： Sanjay Agrawal , Surajit Chaudhuri , Vivek R. Narasayya
发明人： Sanjay Agrawal , Surajit Chaudhuri , Vivek R. Narasayya
IPC分类号： G06F1730
CPC分类号： G06F17/30321 , Y10S707/99932 , Y10S707/99933 , Y10S707/99935
摘要： An index and materialized view selection wizard produces a fast and reasonable recommendation for a configuration of indexes, materialized views, and indexes on materialized views which are beneficial given a specified workload for a given database and database server. Candidate materialized views and indexes are obtained, and a joint enumeration of the combined materialized views and indexes is performed to obtain a recommended configuration. The configuration includes indexes, materialized views and indexes on materialized views. Candidate materialized views are obtained by first determining subsets of tables are referenced in queries in the workload and then finding interesting table subsets. Next, interesting subsets are considered on a per query basis to determine which are syntactically relevant for a query. Materialized views which are likely to be used for the workload are then generated along with a set of merged materialized views. Clustered indexes and non-clustered indexes on materialized views are then generated. The indexes, materialized views and indexes on materialized views are then enumerated together to form the recommended configuration.
摘要翻译：索引和物化视图选择向导可以为物理视图的索引，物化视图和索引配置提供快速合理的建议，这对给定数据库和数据库服务器的指定工作负载是有益的。获取候选物化视图和索引，并执行组合实例化视图和索引的联合枚举，以获得推荐的配置。配置包括物化视图的索引，物化视图和索引。通过首先确定表中的子集在工作负载中的查询中引用并且然后找到有趣的表子集来获得候选物化视图。接下来，在每个查询的基础上考虑有趣的子集，以确定哪个在查询语法上相关。可能用于工作负载的物化视图随同一组合并物化视图一起生成。然后生成物化视图上的聚簇索引和非聚集索引。然后将物化视图的索引，物化视图和索引列在一起以形成推荐的配置。

6. 发明申请

US20110208748A1 Foreign-Key Detection 有权
标题翻译：外键检测
公开(公告)号：US20110208748A1
公开(公告)日：2011-08-25
申请号：US12709508
申请日：2010-02-21
申请人： Surajit Chaudhuri , Vivek R. Narasayya , Zhimin Chen
发明人： Surajit Chaudhuri , Vivek R. Narasayya , Zhimin Chen
IPC分类号： G06F17/30
CPC分类号： G06F17/30306
摘要： This patent application relates to foreign-key detection. One implementation obtains a set of data tables. This implementation automatically determines foreign-key relationships of columns from separate tables of the set.
摘要翻译：本专利申请涉及外键检测。一个实现获得一组数据表。此实现将自动确定集合的不同表中的列的外键关系。

7. 发明授权

US08386529B2 Foreign-key detection 有权
标题翻译：外键检测
公开(公告)号：US08386529B2
公开(公告)日：2013-02-26
申请号：US12709508
申请日：2010-02-21
申请人： Surajit Chaudhuri , Vivek R. Narasayya , Zhimin Chen
发明人： Surajit Chaudhuri , Vivek R. Narasayya , Zhimin Chen
IPC分类号： G06F17/30
CPC分类号： G06F17/30306
摘要： This patent application relates to foreign-key detection. One implementation obtains a set of data tables. This implementation automatically determines foreign-key relationships of columns from separate tables of the set.
摘要翻译：本专利申请涉及外键检测。一个实现获得一组数据表。此实现将自动确定集合的不同表中的列的外键关系。

8. 发明授权

US08307343B2 Application and database context correlation for database application developers 有权
标题翻译：数据库应用程序开发人员的应用程序和数据库上下文相关性
公开(公告)号：US08307343B2
公开(公告)日：2012-11-06
申请号：US11875616
申请日：2007-10-19
申请人： Surajit Chaudhuri , Vivek R. Narasayya , Manoj A. Symala
发明人： Surajit Chaudhuri , Vivek R. Narasayya , Manoj A. Symala
IPC分类号： G06F9/44 , G06F7/00 , G06F17/30
CPC分类号： G06F17/30306 , G06F8/20 , G06F11/3476 , G06F11/366 , G06F17/3041 , G06F2201/86
摘要： Infrastructure for capturing and correlating application context and database context for tuning, profiling and debugging tasks. The application context can include events such as data access events, and the database context can include events such as database server events. The events can be obtained from server tracing, data access layer tracing, and/or application tracing and written into respective log files. A data access event can indicate that an application consumed a row from a result set returned from a DBMS query. A post-processing step can correlate the application and database contexts by tokenizing strings and computing intersections between the tokenized strings. A tool inside a development environment may also suggest a query hint for the database or a data access API for the application based on the correlated context.
摘要翻译：用于捕获和关联应用程序上下文和数据库上下文以进行调整，分析和调试任务的基础结构。应用程序上下文可以包括诸如数据访问事件的事件，并且数据库上下文可以包括诸如数据库服务器事件的事件。可以从服务器跟踪，数据访问层跟踪和/或应用程序跟踪获取事件，并将其写入相应的日志文件。数据访问事件可以指示应用程序从DBMS查询返回的结果集中消耗了一行。后处理步骤可以通过标记字符串和计算标记字符串之间的交集来关联应用程序和数据库上下文。开发环境内的工具也可能建议基于相关上下文的数据库查询提示或应用程序的数据访问API。

9. 发明授权

US07493316B2 Sampling for queries 有权
标题翻译：查询抽样
公开(公告)号：US07493316B2
公开(公告)日：2009-02-17
申请号：US11296036
申请日：2005-12-07
申请人： Surajit Chaudhuri , Vivek R. Narasayya , Rajeev Motwani , Mayur D. Datar
发明人： Surajit Chaudhuri , Vivek R. Narasayya , Rajeev Motwani , Mayur D. Datar
IPC分类号： G06F17/30
CPC分类号： G06F17/30536 , G06F17/30489 , Y10S707/99931 , Y10S707/99932 , Y10S707/99933 , Y10S707/99942
摘要： A method of estimating results of a database query, the results 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. An aggregate is computed over values in each sampled tuple while multiplying by the inverses of the probabilities associated with each tuple sampled.
摘要翻译：一种估计数据库查询结果的方法，通过基于在执行工作负载中所需的元组的使用概率对数据库中的加权元组进行抽样来估计结果。每个元组采样的概率相关。根据每个采样元组中的值计算聚合，同时乘以与每个元组采样相关联的概率的反转。

10. 发明授权

US07483918B2 Dynamic physical database design 有权
标题翻译：动态物理数据库设计
公开(公告)号：US07483918B2
公开(公告)日：2009-01-27
申请号：US10914901
申请日：2004-08-10
申请人： Surajit Chaudhuri , Arnd Christian Konig , Vivek R. Narasayya
发明人： Surajit Chaudhuri , Arnd Christian Konig , Vivek R. Narasayya
IPC分类号： G06F7/00
CPC分类号： G06F17/30312 , Y10S707/99933 , Y10S707/99945 , Y10S707/99948
摘要： A monitoring component of a database server collects a subset of a query workload along with related statistics. A remote index tuning component uses the workload subset and related statistics to determine a physical design that minimizes the cost of executing queries in the workload subset while ensuring that queries omitted from the subset do not degrade in performance.
摘要翻译：数据库服务器的监视组件收集查询工作负载的一部分以及相关统计信息。远程索引调整组件使用工作负载子集和相关统计信息来确定最小化在工作负载子集中执行查询的成本的物理设计，同时确保从子集中省略的查询不会降低性能。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式