公开(公告)号：US20050086195A1

公开(公告)日：2005-04-21

申请号：US10934076

申请日：2004-09-03

申请人： Leng Leng Tan ,  Gianfranco Putzolu ,  Richard Sarwal ,  Alex Tsukerman ,  Gary Ngai ,  Graham Wood ,  Karl Dias ,  Mark Ramacher ,  Benoit Dageville ,  Mohamed Ziauddin ,  Tirthankar Lahiri ,  Sujatha Muthulingam ,  Vishwanath Karra ,  Francisco Sanchez ,  Hsiao-Te Su ,  Wanli Yang ,  Vasudha Krishnaswamy ,  Sushil Kumar

发明人： Leng Leng Tan ,  Gianfranco Putzolu ,  Richard Sarwal ,  Alex Tsukerman ,  Gary Ngai ,  Graham Wood ,  Karl Dias ,  Mark Ramacher ,  Benoit Dageville ,  Mohamed Ziauddin ,  Tirthankar Lahiri ,  Sujatha Muthulingam ,  Vishwanath Karra ,  Francisco Sanchez ,  Hsiao-Te Su ,  Wanli Yang ,  Vasudha Krishnaswamy ,  Sushil Kumar

IPC分类号： G06F7/00 ,  G06F17/00 ,  G06F17/30

CPC分类号： G06F17/30289 ,  Y10S707/99932 ,  Y10S707/99945

摘要： An intelligent database infrastructure wherein the management of all database components is performed by and within the database itself by integrating management of various components with a central management control. Each individual database component, as well as the central management control, is self-managing. A central management control module integrates and interacts with the various database components. The database is configured to automatically tune to varying workloads and configurations, correct or alert about bad conditions, and advise on ways to improve overall system performance.

摘要翻译： 智能数据库基础设施，其中所有数据库组件的管理由数据库本身和数据库本身进行管理，通过集中管理各种组件与中央管理控制。 每个单独的数据库组件以及中央管理控制都是自我管理的。 中央管理控制模块集成并与各种数据库组件进行交互。 数据库被配置为自动调整到不同的工作负载和配置，纠正或警告恶劣条件，并提供有关如何提高整体系统性能的建议。

公开(公告)号：US06882993B1

公开(公告)日：2005-04-19

申请号：US10059616

申请日：2002-01-28

申请人： Shilpa Lawande ,  Abhinav Gupta ,  Benoit Dageville

发明人： Shilpa Lawande ,  Abhinav Gupta ,  Benoit Dageville

IPC分类号： G06F17/30

CPC分类号： G06F17/30383 ,  Y10S707/99932 ,  Y10S707/99943

摘要： A method is provided for incrementally refreshing a materialized view after multiple operations on a row of a base table of the materialized view, by determining an equivalent operation for the multiple operations and refreshing the materialized view according to the equivalent operation. The method is applicable to a materialized view based on multiple base tables on which multiple operations have been performed. The step of determining the equivalent operation can include identifying rows for which an earliest operation is a DELETE operation, or rows for which a latest operation is an INSERT operation, or a combination of the two. The step of refreshing the materialized view includes performing an inverse operation of the equivalent operation to determine a pre-update state of the row, and refreshing the materialized view based on the pre-update state. Additional embodiments are provided which enhance the performance of materialized view refresh queries.

摘要翻译： 提供一种方法，用于通过确定多个操作的等效操作并根据等效操作刷新物化视图，在物化视图的基表的行上进行多次操作之后逐步刷新物化视图。 该方法适用于基于执行多个操作的多个基表的实例化视图。 确定等效操作的步骤可以包括识别最早操作是DELETE操作的行，或者最近的操作是INSERT操作的行或两者的组合。 刷新物化视图的步骤包括执行等效操作的反向操作以确定行的更新前状态，并且基于更新前状态来刷新物化视图。 提供了增强物化视图刷新查询的性能的另外的实施例。

公开(公告)号：US06820262B1

公开(公告)日：2004-11-16

申请号：US09360286

申请日：1999-07-22

申请人： Juan Tellez ,  Benoit Dageville

发明人： Juan Tellez ,  Benoit Dageville

IPC分类号： G06F946

CPC分类号： G06F9/5083 ,  G06F9/5066

摘要： A method and apparatus are provided for computing degrees of parallelism for parallel operations in a computer system. The degree of parallelism for a given parallel operation is computed based on a set of factors. The set of factors includes a target degree of parallelism that represents a desired total amount of parallelism in the computer system, a current workload and a requested degree of parallelism.

摘要翻译： 提供了一种用于计算计算机系统中的并行操作的并行度的方法和装置。 基于一组因素计算给定并行操作的并行度。 这些因素包括目标程度的并行度，其表示计算机系统中期望的并行度总​​和，当前工作负载和所要求的并行度。

公开(公告)号：US06549931B1

公开(公告)日：2003-04-15

申请号：US09415033

申请日：1999-10-07

申请人： Patrick A. Amor ,  Benoit Dageville

发明人： Patrick A. Amor ,  Benoit Dageville

IPC分类号： G06F1730

CPC分类号： G06F9/5066 ,  Y10S707/99952

摘要： A task is divided into work granules that require access to data objects. The work granules are distributed to slave processes in a manner that causes the data objects to be accessed in a balanced way, such that the difference in the number of slave processes accessing any object is not greater than one. Distributing the work granules in this manner decreases the likelihood that the resources required to access any particular data object will become a bottleneck in performing the task. For each data object in the set of data objects, a work granule list is maintained. The list of each data object identifies work granules requiring access to the data object. A slave process is assigned a work granule selected from a set of work granule lists. To select a work granule for a slave process, an initial list is picked at random. If the quantity of currently-assigned work granules from the selected work granule list is less than or equals a “threshold minimum”, then a work granule from the work granule list is assigned to the slave process. If the quantity of work granules is greater than the threshold minimum, then another work granule list is selected. The threshold minimum may be, for example, the minimum number of currently-assigned work granules from the work granule list.

摘要翻译： 任务分为需要访问数据对象的工作颗粒。 工作颗粒以以平衡的方式访问数据对象的方式分配给从属进程，从而访问任何对象的从属进程数量的差异不大于1。 以这种方式分配工作颗粒减少访问任何特定数据对象所需的资源将成为执行任务的瓶颈的可能性。 对于数据对象集合中的每个数据对象，维护工作粒子列表。 每个数据对象的列表标识需要访问数据对象的工作颗粒。 从属进程被分配从一组工作颗粒列表中选择的工作颗粒。 要为从属进程选择工作颗粒，将随机挑选一个初始列表。 如果来自所选择的工作颗粒列表的当前分配的工作颗粒的数量小于或等于“阈值最小值”，则将工作颗粒列表中的工作颗粒分配给从属过程。 如果工作颗粒的数量大于阈值最小值，则选择另一个工作颗粒列表。 阈值最小值可以是例如来自工作颗粒列表的当前分配的工作颗粒的最小数量。

公开(公告)号：US09208141B2

公开(公告)日：2015-12-08

申请号：US12701380

申请日：2010-02-05

申请人： Yuen Sheung Chan ,  Benoit Dageville ,  Hsiao-Te Su ,  Peter Clayton Belknap

发明人： Yuen Sheung Chan ,  Benoit Dageville ,  Hsiao-Te Su ,  Peter Clayton Belknap

IPC分类号： G06F17/00 ,  G06F17/24 ,  G06F17/22 ,  G06Q10/10 ,  G06F17/30

CPC分类号： G06F17/212 ,  G06F17/2247 ,  G06F17/248 ,  G06F17/30557 ,  G06F17/3089 ,  G06Q10/107

摘要： Embodiments of the present invention enable the generation and display of active reports. Applications of the present invention include its use in embodiments of a web-based product for managing an Information Technology (IT) infrastructure although the present invention is not limited to such applications. In embodiments, an active report is an active report file comprising report data and a user interface (UI) reference to a network location of code that defines an interactive UI comprising graphical user interface (GUI) components to be rendered when displaying the report data. In embodiments, the interactive UI is defined by UI code (such as an Adobe Flash Small Web Format (SWF) file) that also defines the UI of a rich internet application (RIA). In embodiments, the UI reference may be a link designating a location to the location of the UI code on a network, such as the Internet.

摘要翻译： 本发明的实施例能够生成和显示活动报告。 本发明的应用包括其在用于管理信息技术（IT）基础设施的基于web的产品的实施例中的应用，尽管本发明不限于这些应用。 在实施例中，活动报告是活动报告文件，其包括报告数据和用于定义包括在显示报告数据时要呈现的图形用户界面（GUI）组件的交互式UI的代码的网络位置的用户界面（UI）引用。 在实施例中，交互式UI由定义富互联网应用（RIA）的UI的UI代码（例如Adobe Flash Small Web Format（SWF）文件）定义）。 在实施例中，UI参考可以是指定位置到诸如因特网的网络上的UI代码的位置的链接。

公开(公告)号：US08700608B2

公开(公告)日：2014-04-15

申请号：US12188683

申请日：2008-08-08

申请人： Peter Belknap ,  Benoit Dageville ,  Dinesh Das ,  Khaled Yagoub ,  Mohamed Zait ,  Mohamed Ziauddin

发明人： Peter Belknap ,  Benoit Dageville ,  Dinesh Das ,  Khaled Yagoub ,  Mohamed Zait ,  Mohamed Ziauddin

IPC分类号： G06F7/00 ,  G06F17/00 ,  G06F17/30

CPC分类号： G06F17/30469 ,  G06F17/30463

摘要： Approaches, techniques, and mechanisms are disclosed for ensuring that a database command is executed according to a query plan that has been verified to be actually optimal. Except in rare circumstances, a database server does not execute a query plan unless it is first verified by the database server. The database server receives a request to execute a database command. The database server determines an unverified plan is the best plan for satisfying the request. Rather than risk the unknown behavior of an unverified plan, the database server instead satisfies the request according to a verified plan. Subsequently—for example as part of a scheduled job—the database server executes the unverified plan to determine performance statistics. Based at least on the performance statistics, the database server determines whether or not to verify the unverified plan. Techniques for concurrent and optimistic verifications are also disclosed.

摘要翻译： 公开了方法，技术和机制，以确保根据已被验证为实际最佳的查询计划来执行数据库命令。 除非在极少数情况下，数据库服务器不执行查询计划，除非数据库服务器首先进行了验证。 数据库服务器接收执行数据库命令的请求。 数据库服务器确定未验证的计划是满足请求的最佳方案。 而不是冒险未验证的计划的未知行为，数据库服务器而是根据验证的计划满足请求。 随后 - 例如作为计划作业的一部分 - 数据库服务器执行未验证的计划以确定性能统计信息。 至少基于性能统计信息，数据库服务器确定是否验证未验证的计划。 还公开了并发和乐观验证的技术。

公开(公告)号：US08600977B2

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

申请号：US12188662

申请日：2008-08-08

申请人： Benoit Dageville ,  Dinesh Das ,  Mohamed Ziauddin

发明人： Benoit Dageville ,  Dinesh Das ,  Mohamed Ziauddin

IPC分类号： G06F7/00 ,  G06F17/00 ,  G06F17/30

CPC分类号： G06F17/30469 ,  G06F17/30463

摘要： Approaches, techniques, and mechanisms are disclosed for capturing and utilizing information related to query plans exhibiting interesting characteristics. A database server receives a request to execute a command. The database server executes the command according to a query plan. In response to determining that the command matches one or more pre-defined criteria, the database server captures information related to the execution of the first command. The criteria may include, for example, whether or not the command is repeatable, the existence of bind variables, access of a particular object, high resource utilization, receipt from a particular user, client, or application, etc. The information recorded may include, for example, performance statistics collected during execution of the first plan, data indicating the execution context during execution of the first plan, and properties of the first plan. The recorded information may subsequently be utilized by the database server in executing other database other database commands.

摘要翻译： 公开了用于捕获和利用与显示有趣特征的查询计划相关的信息的方法，技术和机制。 数据库服务器接收执行命令的请求。 数据库服务器根据查询计划执行该命令。 响应于确定该命令匹配一个或多个预定义标准，数据库服务器捕获与执行第一命令有关的信息。 标准可以包括例如，命令是否可重复，绑定变量的存在，特定对象的访问，高资源利用率，来自特定用户，客户端或应用程序的接收等。所记录的信息可以包括 例如，在执行第一计划期间收集的性能统计数据，在执行第一计划期间指示执行上下文的数据以及第一计划的属性。 记录的信息随后可被数据库服务器用于执行其他数据库命令。

公开(公告)号：US08577871B2

公开(公告)日：2013-11-05

申请号：US12060117

申请日：2008-03-31

申请人： Benoit Dageville ,  Venkateshwaran Venkataramani

发明人： Benoit Dageville ,  Venkateshwaran Venkataramani

IPC分类号： G06F17/00

CPC分类号： G06F17/30306

摘要： Methods, systems, and computer program products for monitoring database queries and executions is disclosed. The query syntax may conform to the structured query language (SQL). The approach supports various performance statistics to be monitored at each step of the query statement's execution plan and for each row processed in order to meet requirements of a near real-time query monitoring solution. Such statistics include timing information plus some miscellaneous statistics like the number of rows processed, the amount of memory used, the amount of data spilled to disk, etc.

摘要翻译： 公开了用于监视数据库查询和执行的方法，系统和计算机程序产品。 查询语法可以符合结构化查询语言（SQL）。 该方法支持在查询语句的执行计划的每个步骤以及为满足近实时查询监视解决方案的要求而处理的每个行中监视的各种性能统计信息。 这样的统计数据包括定时信息加上一些杂项统计数据，如处理的行数，使用的内存量，溢出到磁盘的数据量等。

公开(公告)号：US08429467B2

公开(公告)日：2013-04-23

申请号：US12251743

申请日：2008-10-15

申请人： Marcus Fallen ,  Benoit Dageville ,  Jonathan Klein ,  Ajith Kumar Mysorenagarajarao ,  Gary Ngai ,  Mark Ramacher ,  Yair Sarig

发明人： Marcus Fallen ,  Benoit Dageville ,  Jonathan Klein ,  Ajith Kumar Mysorenagarajarao ,  Gary Ngai ,  Mark Ramacher ,  Yair Sarig

IPC分类号： G06F11/00

CPC分类号： G06F11/0778 ,  G06F11/0748 ,  G06F11/0781 ,  H04L41/0681 ,  H04L41/16

摘要： An infrastructure is provided for gathering diagnostic data that is relevant to an error or other conditions detected in a monitored system. A diagnosability framework is provided that automates the gathering of relevant diagnostic data upon occurrence of the condition in the monitored system. In one embodiment, context data is determined for the condition detected in the monitored system. A rule-based engine is provided that is configured to automatically determine one or more actions to be performed for the condition detected in the monitored system based on the determined context data. The actions may include performing tasks that gather diagnostic data that is relevant to the detected condition, store the gathered diagnostic data in a repository, recommend one or more diagnostic actions to a user, and other diagnostic related actions.

摘要翻译： 提供了一个基础设施，用于收集与受监视系统中检测到的错误或其他条件相关的诊断数据。 提供了一种诊断框架，可在受监控系统中发生状况时自动收集相关诊断数据。 在一个实施例中，为在所监视的系统中检测到的状况确定上下文数据。 提供了一种基于规则的引擎，其被配置为基于所确定的上下文数据来自动确定要在被监视系统中检测到的条件执行的一个或多个动作。 动作可以包括执行收集与检测到的条件相关的诊断数据的任务，将收集的诊断数据存储在存储库中，向用户推荐一个或多个诊断动作以及其他诊断相关的动作。

公开(公告)号：US08335767B2

公开(公告)日：2012-12-18

申请号：US12188673

申请日：2008-08-08

申请人： Dinesh Das ,  Yali Zhu ,  Mohamed Ziauddin ,  Benoit Dageville ,  Hong Su

发明人： Dinesh Das ,  Yali Zhu ,  Mohamed Ziauddin ,  Benoit Dageville ,  Hong Su

IPC分类号： G06F7/00 ,  G06F17/00 ,  G06F17/30

CPC分类号： G06F17/30469 ,  G06F17/30463

摘要： Approaches, techniques, and mechanisms are disclosed for maintaining a history of query plans executed for a database command, along with information related to each query plan. A database server receives a request to execute a particular command. The database server determines a plan for executing the particular command. The database server adds first information to a plan history associated with the particular command. The plan history comprises information related to a plurality of plans that have been generated for the particular command. The first information may include, for example, properties of the plan (including an outline of the plan) as well as statistics collected during execution of the plan. The database server may implement techniques for periodically refreshing information in a plan history. The database server may also implement techniques for purging old or less important plans.

摘要翻译： 公开了用于维护针对数据库命令执行的查询计划的历史以及与每个查询计划相关的信息的方法，技术和机制。 数据库服务器接收执行特定命令的请求。 数据库服务器确定执行特定命令的计划。 数据库服务器将第一个信息添加到与特定命令相关联的计划历史记录中。 计划历史包括与为特定命令生成的多个计划相关的信息。 第一个信息可以包括例如计划的属性（包括计划的纲要）以及执行计划期间收集的统计数据。 数据库服务器可以实现用于在计划历史中周期性地刷新信息的技术。 数据库服务器还可以实现用于清除旧的或不太重要的计划的技术。