公开(公告)号：US5950186A

公开(公告)日：1999-09-07

申请号：US912036

申请日：1997-08-15

Applicant: Surajit Chaudhuri ,  Vivek Narasayya

Inventor： Surajit Chaudhuri ,  Vivek Narasayya

IPC: G06F17/30

CPC classification number: G06F17/30312 ,  Y10S707/99931 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99942 ,  Y10S707/99953 ,  Y10T156/1062

Abstract: 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.

Abstract translation: 索引选择工具有助于在选择索引配置或索引集时，在数据库服务器根据查询的工作量访问数据库时，减少时间和内存中的成本。 索引选择工具尝试减少要考虑的索引数量，要枚举的索引配置数量以及查询优化器在为工作负载选择索引配置时调用的次数。

公开(公告)号：US09594831B2

公开(公告)日：2017-03-14

申请号：US13531493

申请日：2012-06-22

Applicant: Chi Wang ,  Kaushik Chakrabarti ,  Tao Cheng ,  Surajit Chaudhuri

Inventor： Chi Wang ,  Kaushik Chakrabarti ,  Tao Cheng ,  Surajit Chaudhuri

IPC: G06F17/30 ,  G06F17/27

CPC classification number: G06F17/30687 ,  G06F17/278

Abstract: A targeted disambiguation system is described herein which determines true mentions of a list of named entities in a collection of documents. The list of named entities is homogenous in the sense that the entities pertain to the same subject matter domain. The system determines the true mentions by leveraging the homogeneity in the list, and, more specifically by applying a context similarity hypothesis, a co-mention hypothesis, and an interdependency hypothesis. In one implementation, the system executes its analysis using a graph-based model. The system can operate without the existence of additional information regarding the entities in the list; nevertheless, if such information is available, the system can integrate it into its analysis.

Abstract translation: 本文描述了一种有针对性的消歧系统，其确定了文档集合中真实提到的命名实体的列表。 在实体属于相同主题领域的意义上，命名实体的列表是同质的。 系统通过利用列表中的同质性来确定真实的提及，更具体地说，通过应用上下文相似性假设，共同提及假设和相互依赖性假设。 在一个实现中，系统使用基于图的模型来执行其分析。 该系统可以在没有关于列表中的实体的附加信息的情况下运行; 然而，如果这些信息可用，系统可以将其整合到其分析中。

公开(公告)号：US09311376B2

公开(公告)日：2016-04-12

申请号：US13461785

申请日：2012-05-02

Applicant: Vivek Ravindranath Narasayya ,  Feng Li ,  Surajit Chaudhuri

Inventor： Vivek Ravindranath Narasayya ,  Feng Li ,  Surajit Chaudhuri

IPC: G06F17/30 ,  H04L12/24 ,  G06F11/34

CPC classification number: G06F17/30575 ,  G06F11/3457 ,  H04L41/5003 ,  H04L41/5009

Abstract: Various technologies described herein pertain to evaluating service provider compliance with terms of a performance service level agreement (SLA) for a tenant in a multi-tenant database system. The terms of the performance SLA can set a performance criterion as though a level of a resource of hardware of the multi-tenant database system is dedicated to the tenant. An actual performance metric of the resource can be tracked for a workload of the tenant. Further, a baseline performance metric of the resource can be determined for the workload of the tenant. The baseline performance metric can be based on a simulation as though the level of the resource as set in the performance SLA is dedicated to the workload of the tenant. Moreover, the actual performance metric can be compared with the baseline performance metric to evaluate compliance with the performance SLA.

Abstract translation: 本文描述的各种技术涉及评估服务提供商遵守多租户数据库系统中租户的性能服务级别协议（SLA）的条款。 性能SLA的术语可以设置性能标准，就像多租户数据库系统的硬件资源的级别是专门用于租户一样。 可以为租户的工作负载跟踪资源的实际性能指标。 此外，可以为租户的工作量确定资源的基准绩效指标。 基准性能度量可以基于模拟，就像在性能SLA中设置的资源的级别专用于租户的工作量一样。 此外，可以将实际绩效指标与基准绩效指标进行比较，以评估是否符合绩效SLA。

公开(公告)号：US08930391B2

公开(公告)日：2015-01-06

申请号：US12981082

申请日：2010-12-29

Applicant: Kaushik Chakrabarti ,  Surajit Chaudhuri ,  Senjuti Basu Roy

Inventor： Kaushik Chakrabarti ,  Surajit Chaudhuri ,  Senjuti Basu Roy

IPC: G06F17/30 ,  G01C21/36

CPC classification number: G06F17/3053 ,  G01C21/3611 ,  G01C21/3679 ,  G06F17/30091 ,  G06F17/30241 ,  G06F17/30864

Abstract: A location associated with a user of a computing device and a prefix portion of an input string may be received as one or more successive characters of the input string are provided by the user via the computing device. A list of suggested items may be obtained based on a function of respective recommendation indicators and proximities of the items to the location in response to receiving the prefix portion, and based on partially traversing a character string search structure having a plurality of non-terminal nodes augmented with bound indicators associated with spatial regions. The list of suggested items and descriptive information associated with each suggested item may be returned to the user, in response to receiving the prefix portion, for rendering an image illustrating indicators associated with the list in a manner relative to the location, as the user provides each successive character of the input string.

Abstract translation: 当用户通过计算设备提供输入串的一个或多个连续字符时，可以接收与计算设备的用户和输入字符串的前缀部分相关联的位置。 可以基于各个推荐指标的功能和响应于接收前缀部分的到位置的项目的接近度，并且基于部分地遍历具有多个非终端节点的字符串搜索结构来获得所提出的项目的列表 增加与空间区域相关联的绑定指标。 与每个建议项目相关联的建议项目和描述性信息的列表可以响应于接收到前缀部分而被返回给用户，用于以用户提供的方式呈现以相对于位置的方式示出与列表相关联的指示符的图像 输入字符串的每个连续字符。

公开(公告)号：US20130346421A1

公开(公告)日：2013-12-26

申请号：US13531493

申请日：2012-06-22

Applicant: Chi Wang ,  Kaushik Chakrabarti ,  Tao Cheng ,  Surajit Chaudhuri

Inventor： Chi Wang ,  Kaushik Chakrabarti ,  Tao Cheng ,  Surajit Chaudhuri

IPC: G06F17/30

CPC classification number: G06F17/30687 ,  G06F17/278

Abstract: A targeted disambiguation system is described herein which determines true mentions of a list of named entities in a collection of documents. The list of named entities is homogenous in the sense that the entities pertain to the same subject matter domain. The system determines the true mentions by leveraging the homogeneity in the list, and, more specifically by applying a context similarity hypothesis, a co-mention hypothesis, and an interdependency hypothesis. In one implementation, the system executes its analysis using a graph-based model. The system can operate without the existence of additional information regarding the entities in the list; nevertheless, if such information is available, the system can integrate it into its analysis.

Abstract translation: 本文描述了一种有针对性的消歧系统，其确定了文档集合中真实提到的命名实体的列表。 在实体属于相同主题领域的意义上，命名实体的列表是同质的。 系统通过利用列表中的同质性来确定真实的提及，更具体地说，通过应用上下文相似性假设，共同提及假设和相互依赖性假设。 在一个实现中，系统使用基于图的模型来执行其分析。 该系统可以在没有关于列表中的实体的附加信息的情况下运行; 然而，如果这些信息可用，系统可以将其整合到其分析中。

公开(公告)号：US20130268552A1

公开(公告)日：2013-10-10

申请号：US13443573

申请日：2012-04-10

Applicant: John C. Platt ,  Surajit Chaudhuri ,  Lev Novik ,  Henricus Johannes Maria Meijer ,  Efim Hudis

Inventor： John C. Platt ,  Surajit Chaudhuri ,  Lev Novik ,  Henricus Johannes Maria Meijer ,  Efim Hudis

IPC: G06F17/30

CPC classification number: G06F21/6218

Abstract: A data broker observes datasets that are opened or created by a user. The data broker looks for related datasets in a data catalog. If a related dataset is found, the data broker asks the user if they want to access the related dataset. If the user is interested, then the data broker asks the data owner if they are willing to share access to the related dataset with the user. The data owner may deny access, allow access, or request the user's identity. If the user does not want to provide his or her identity, then access to the related dataset is denied. If the user does provide his or her identity, then the data owner determines whether or not to share the data with that user. Once the owner approves sharing the related dataset, then the dataset or a link to the dataset is sent to the user.

Abstract translation: 数据中介器观察由用户打开或创建的数据集。 数据中介查找数据目录中的相关数据集。 如果找到相关的数据集，数据中介会询问用户是否要访问相关的数据集。 如果用户感兴趣，则数据经纪人询问数据所有者是否愿意与用户共享对相关数据集的访问。 数据所有者可以拒绝访问，允许访问或请求用户的身份。 如果用户不想提供他或她的身份，则拒绝对相关数据集的访问。 如果用户提供他或她的身份，则数据所有者确定是否与该用户共享数据。 一旦业主批准共享相关的数据集，那么将数据集或数据集的链接发送给用户。

公开(公告)号：US08386529B2

公开(公告)日：2013-02-26

申请号：US12709508

申请日：2010-02-21

Applicant: Surajit Chaudhuri ,  Vivek R. Narasayya ,  Zhimin Chen

Inventor： Surajit Chaudhuri ,  Vivek R. Narasayya ,  Zhimin Chen

IPC: G06F17/30

CPC classification number: G06F17/30306

Abstract: 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.

Abstract translation: 本专利申请涉及外键检测。 一个实现获得一组数据表。 此实现将自动确定集合的不同表中的列的外键关系。

公开(公告)号：US08307343B2

公开(公告)日：2012-11-06

申请号：US11875616

申请日：2007-10-19

Applicant: Surajit Chaudhuri ,  Vivek R. Narasayya ,  Manoj A. Symala

Inventor： Surajit Chaudhuri ,  Vivek R. Narasayya ,  Manoj A. Symala

IPC: G06F9/44 ,  G06F7/00 ,  G06F17/30

CPC classification number: G06F17/30306 ,  G06F8/20 ,  G06F11/3476 ,  G06F11/366 ,  G06F17/3041 ,  G06F2201/86

Abstract: 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.

Abstract translation: 用于捕获和关联应用程序上下文和数据库上下文以进行调整，分析和调试任务的基础结构。 应用程序上下文可以包括诸如数据访问事件的事件，并且数据库上下文可以包括诸如数据库服务器事件的事件。 可以从服务器跟踪，数据访问层跟踪和/或应用程序跟踪获取事件，并将其写入相应的日志文件。 数据访问事件可以指示应用程序从DBMS查询返回的结果集中消耗了一行。 后处理步骤可以通过标记字符串和计算标记字符串之间的交集来关联应用程序和数据库上下文。 开发环境内的工具也可能建议基于相关上下文的数据库查询提示或应用程序的数据访问API。

公开(公告)号：US08214402B2

公开(公告)日：2012-07-03

申请号：US12484564

申请日：2009-06-15

Applicant: Nicolas Bruno ,  Surajit Chaudhuri

Inventor： Nicolas Bruno ,  Surajit Chaudhuri

IPC: G06F17/30

CPC classification number: G06F9/45512 ,  G06F17/30306

Abstract: An architecture for providing interactive sessions for physical database design is described, allowing users to readily try different options, identify problems, and obtain physical designs in a flexible way. Embodiments based on a .NET assembly and modifications to a database management system (DBMS) are also described.

Abstract translation: 描述了一种用于提供物理数据库设计的交互式会话的架构，允许用户以灵活的方式轻松尝试不同的选项，识别问题并获得物理设计。 还描述了基于.NET组件和对数据库管理系统（DBMS）的修改的实施例。

公开(公告)号：US08190595B2

公开(公告)日：2012-05-29

申请号：US12413544

申请日：2009-03-28

Applicant: Nicolas Bruno ,  Ravishankar Ramamurthy ,  Surajit Chaudhuri

Inventor： Nicolas Bruno ,  Ravishankar Ramamurthy ,  Surajit Chaudhuri

IPC: G06F17/30

CPC classification number: G06F17/30386

Abstract: A flexible query hints system and method for discovering and expressing query hints in a database management system. Embodiments of the flexible query hints system and method include a power hints (Phints) language that enables the specification of constraints to influence a query optimizer. Phints expressions are defined as tree patterns annotated with constraints. Embodiments of the flexible query hints system and method also include techniques to incorporate the power hints language expressions into an extended query optimizer. Theses techniques include computing a directed acyclic graph for Phints expression, deriving candidate matches using the Phints expression and the graph, computing candidate matches, and extracting a revised execution plan having a lowest cost and satisfying constraints of the Phints expression. Embodiments of the flexible query hints system and method include a flexible query hint user interface that allow users to interactively adjust query hints.

Abstract translation: 灵活的查询提示系统和方法，用于在数据库管理系统中发现和表达查询提示。 灵活查询提示系统和方法的实施例包括能够指定约束来影响查询优化器的功率提示（Phints）语言。 Phints表达式定义为使用约束注释的树模式。 灵活查询提示系统和方法的实施例还包括将功能提示语言表达式并入到扩展查询优化器中的技术。 这些技术包括计算用于Phints表达的有向非循环图，使用Phints表达式和图形导出候选匹配，计算候选匹配，以及提取具有最低成本并满足Phints表达式的约束的经修订的执行计划。 灵活查询提示系统和方法的实施例包括灵活的查询提示用户界面，允许用户交互地调整查询提示。