公开(公告)号：US08296104B2

公开(公告)日：2012-10-23

申请号：US12251648

申请日：2008-10-15

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

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

IPC分类号： G06F11/00 ,  G06F11/30

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.

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

公开(公告)号：US08255182B2

公开(公告)日：2012-08-28

申请号：US12251667

申请日：2008-10-15

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

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

IPC分类号： G06F11/30 ,  G06F19/00

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

摘要： Techniques for controlling collection of diagnostic data in a monitored system. A set of flood control rules are configured for the monitored system for controlling the gathering of diagnostic data in the monitored system. The set of flood control rules may include one or more default flood control rules. The set of flood control rules are user-configurable enabling the user of the monitored system to set policies for dynamically controlling gathering of diagnostic data for the monitored system. In one embodiment, diagnostic data gathering is controlled based upon a number of previous occurrences of a condition in some predefined or user-configured time frame that triggers diagnostic data gathering and/or a number of previous executions of an action performed in some predefined or user-configured time frame responsive to the condition in the monitored system.

摘要翻译： 用于控制监控系统中诊断数据收集的技术。 为监控系统配置了一组防洪规则，用于控制监控系统中诊断数据的收集。 防洪规则集可以包括一个或多个默认防洪规则。 一组防洪规则是用户可配置的，使受监控系统的用户能够设置动态控制监控系统诊断数据采集的策略。 在一个实施例中，诊断数据收集是基于在某些预定义或用户配置的时间帧中的先前事件的数量来控制的，该时间帧触发诊断数据收集和/或在某些预定义或用户中执行的动作的先前执行的数量 响应于受监视系统中的状况而配置的时间帧。

公开(公告)号：US08135988B2

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

申请号：US12251711

申请日：2008-10-15

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

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

IPC分类号： G06F11/00

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

摘要： Techniques for non-intrusive performance of diagnostic actions including actions that result in gathering of diagnostic data in response to a condition detected in a monitored system. In one embodiment, the diagnostic actions are performed asynchronously by processes or threads that are different from the failing process or thread that receives or detects the condition that triggers the diagnostic actions such that the failing process or thread can continue processing without being affected by the executions of the diagnostic actions. Multiple asynchronous processes or threads that are different from the failing process or thread may be spawned to perform multiple diagnostic actions in parallel. The asynchronous processes or threads may be monitored to ensure that they do not adversely impact the monitored system.

摘要翻译： 用于非侵入式执行诊断动作的技术，包括导致响应于在受监视系统中检测到的状况而收集诊断数据的动作。 在一个实施例中，诊断动作由与接收或检测触发诊断动作的状况不同的进程或线程不同的进程或线程异步执行，使得故障进程或线程可以继续处理而不受执行的影响 的诊断动作。 可能会产生与故障进程或线程不同的多个异步进程或线程，以并行执行多个诊断操作。 可以监视异步进程或线程，以确保它们不会对受监视的系统产生不利影响。

公开(公告)号：US20110276550A1

公开(公告)日：2011-11-10

申请号：US12775322

申请日：2010-05-06

申请人： Romain Colle ,  Benoit Dageville ,  Karl Dias ,  Leonidas Galanis ,  Supiti Buranawatanachoke ,  Jonathan Klein ,  Efstratios Papadomanolakis ,  Yujun Wang

发明人： Romain Colle ,  Benoit Dageville ,  Karl Dias ,  Leonidas Galanis ,  Supiti Buranawatanachoke ,  Jonathan Klein ,  Efstratios Papadomanolakis ,  Yujun Wang

IPC分类号： G06F17/30

CPC分类号： G06F17/3056 ,  G06F17/303

摘要： A method, apparatus, and computer readable medium for preserving data dependency during replay of database commands without strictly preserving a global ordering of the database commands is provided. A capture process captures a workload of database commands executed by a production system. The captured workload includes object identifiers that identify database objects that were referenced directly or indirectly during execution of the database commands by the production system. The captured workload also includes an indication of whether the database objects were potentially read or written during execution of the commands. The workload is processed to determine that an object accessed during execution of a command was previously modified during execution of one or more other commands. A replay process on a test database system prevents the command from being replayed until after the one or more other commands have been replayed to modify the object.

摘要翻译： 提供了一种用于在数据库命令重放期间保持数据依赖性而不严格保留数据库命令的全局排序的方法，装置和计算机可读介质。 捕获过程捕获生产系统执行的数据库命令的工作负载。 捕获的工作负载包括标识在生产系统执行数据库命令期间直接或间接引用的数据库对象的对象标识符。 捕获的工作负载还包括在执行命令期间是否可能读取或写入数据库对象的指示。 处理工作负载以确定在执行一个或多个其他命令期间先前修改了在执行命令期间访问的对象。 测试数据库系统上的重播过程可以防止在重播一个或多个其他命令以修改对象之后重播该命令。

公开(公告)号：US20110197122A1

公开(公告)日：2011-08-11

申请号：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分类号： G06F3/048 ,  G06F17/00

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代码的位置的链接。

公开(公告)号：US07979422B2

公开(公告)日：2011-07-12

申请号：US12221131

申请日：2008-07-30

申请人： Peter Belknap ,  Khaled Yagoub ,  Karl Dias ,  Benoit Dageville ,  Thierry Cruanes ,  Anupam Singh

发明人： Peter Belknap ,  Khaled Yagoub ,  Karl Dias ,  Benoit Dageville ,  Thierry Cruanes ,  Anupam Singh

IPC分类号： G06F17/30

CPC分类号： G06F17/30463 ,  G06F17/30306 ,  G06F17/30471

摘要： Systems, methods, and other embodiments associated with hybrid optimization strategies in automatic SQL tuning are described. One example method includes receiving a first (e.g., cost-based) execution plan for a user structured query language statement (User SQL) from a first (e.g., cost-based) optimizer. The example method may also include receiving a second (e.g., rules-based) execution plan for the User SQL from a second, different (e.g., rules-based) query optimizer. The method may include identifying a preferred execution plan based on data produced by test executing the execution plans in a reproduced execution environment that reproduces at least a portion of an execution environment in which the user SQL runs. The method may also include controlling a database to execute the User SQL using the preferred execution plan.

摘要翻译： 描述了与自动SQL调优中的混合优化策略相关联的系统，方法和其他实施例。 一个示例性方法包括从第一（例如基于成本的）优化器接收用户结构化查询语言语句（User SQL）的第一（例如基于成本的）执行计划。 示例性方法还可以包括从第二不同（例如，基于规则的）查询优化器接收针对用户SQL的第二（例如基于规则的）执行计划。 该方法可以包括基于在再现执行用户SQL运行的执行环境的至少一部分的再现执行环境中执行执行计划的测试产生的数据来识别优选执行计划。 该方法还可以包括控制数据库以使用优选的执行计划来执行User SQL。

公开(公告)号：US07853579B2

公开(公告)日：2010-12-14

申请号：US11739277

申请日：2007-04-24

申请人： Alex Tsukerman ,  Carol Lyndall Colrain ,  Graham Wood ,  Jane X. Chen ,  Luxi Chidambaran ,  Benoit Dageville ,  Gary Ngai ,  Mark Ramacher

发明人： Alex Tsukerman ,  Carol Lyndall Colrain ,  Graham Wood ,  Jane X. Chen ,  Luxi Chidambaran ,  Benoit Dageville ,  Gary Ngai ,  Mark Ramacher

IPC分类号： G06F17/00 ,  G06Q30/00

CPC分类号： G06F17/30575

摘要： Various embodiments of the invention provide solutions to allow more sophisticated management of the relationship between a database and its clients (which can be, inter alia, end users, business applications, etc.). Merely by way of example, some embodiments can facilitate the management of work requests in a database, as well as the management of the quality-of-service in a database system. In some embodiments, an identification handle may be assigned to a database work request. A database management application can use the identification handle to identify the work request, as well, perhaps, as any related work requests. The identification handle may also identify the database (and/or an instance thereof) and/or a clustered database node, and the identification handle may be transmitted to a mid-tier application, e.g., to notify the mid-tier about the processing of the work request, changes in quality-of service, server availability, etc.

摘要翻译： 本发明的各种实施例提供了解决方案，以允许数据库与其客户端之间的关系（其可以是最终用户，业务应用等）的更为复杂的管理。 仅仅作为示例，一些实施例可以促进对数据库中的工作请求的管理以及数据库系统中的服务质量的管理。 在一些实施例中，可以将识别句柄分配给数据库工作请求。 数据库管理应用程序可以使用识别句柄来识别工作请求，也可以是任何相关的工作请求。 识别句柄还可以识别数据库（和/或其实例）和/或集群数据库节点，并且识别句柄可以被发送到中间层应用，例如，向中层通知关于 工作请求，服务质量的变化，服务器可用性等。

公开(公告)号：US07779008B2

公开(公告)日：2010-08-17

申请号：US11060260

申请日：2005-02-16

申请人： Benoit Dageville ,  Bhaskar Ghosh ,  Rushan Chen ,  Thierry Cruanes ,  Mohamed Zait

发明人： Benoit Dageville ,  Bhaskar Ghosh ,  Rushan Chen ,  Thierry Cruanes ,  Mohamed Zait

IPC分类号： G06F17/30

CPC分类号： G06F9/4494

摘要： Techniques are provided for performing a parallel aggregation operation on data that resides in a container, such as a relational table. During generation of the execution plan for the operation, it is determined whether partition-wise aggregation should be performed, based on the grouping keys involved in the aggregation and the partition keys used to partition the container. If partition-wise aggregation is to be performed, then the assignments given to the slave processes that are assigned to scan a container are made on a partition-wise basis. The scan slaves themselves may perform full or partial aggregation (depending on whether they are the only scan slaves assigned to the partition). If the scan slaves perform no aggregation, or only partial aggregation, then the scan slaves redistribute the data items to aggregation slaves that are local to the scan slaves.

摘要翻译： 提供了用于对驻留在诸如关系表的容器中的数据执行并行聚合操作的技术。 在生成操作的执行计划时，基于聚合中涉及的分组密钥和用于分区容器的分区密钥，确定是否应该执行分区聚合。 如果要执行分区聚合，则分配给分配给扫描容器的从属进程的分配是以分区方式进行的。 扫描从站本身可以执行完全或部分聚合（取决于它们是否是分配给分区的唯一扫描从站）。 如果扫描从站不执行聚合或仅执行部分聚合，则扫描从站将数据项重新分配到扫描从站本地的聚合从站。

公开(公告)号：US07603340B2

公开(公告)日：2009-10-13

申请号：US10934344

申请日：2004-09-03

申请人： Gary Ngai ,  Mark Ramacher ,  Graham Wood ,  Connie Green ,  Venkateshwaran Venkatatamani ,  Karl Dias ,  Benoit Dageville ,  Michael Feng

发明人： Gary Ngai ,  Mark Ramacher ,  Graham Wood ,  Connie Green ,  Venkateshwaran Venkatatamani ,  Karl Dias ,  Benoit Dageville ,  Michael Feng

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

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

摘要： A self-managing workload repository infrastructure (or “AWR” for Automatic workload repository) which is useful for a database server to collect and manage useful system performance statistics. The AWR runs automatically to collect performance data about the operation of the database system, and stores the data that it captures into the database. The collection process is done inside the database, and the collection process is highly efficient as data is retrieved directly from the shared memory of the database kernel. The data captured allows both system level and user level analysis to be performed without unduly impacting system performance, e.g., by eliminating or reducing the requirement to repeat the workload in order to diagnose problems. The AWR is configured to automatically capture snapshots of statistics data on a periodic basis as well as purge stale data on a periodic basis. The captured performance data includes one or more of the top N (e.g., 20 or 30) statistics for activities involving a large set of objects, time-based statistics, cumulative statistics, sampled data and metrics and other data types.

摘要翻译： 自管理工作负载存储库基础架构（或自动工作负载存储库的“AWR”），可用于数据库服务器收集和管理有用的系统性能统计信息。 AWR自动运行以收集有关数据库系统操作的性能数据，并将其捕获的数据存储到数据库中。 收集过程在数据库内完成，并且收集过程非常有效，因为直接从数据库内核的共享内存中检索数据。 捕获的数据允许执行系统级别和用户级别分析，而不会不必要地影响系统性能，例如通过消除或减少重复工作负载以便诊断问题的要求。 AWR配置为定期自动捕获统计数据的快照，并定期清除过期数据。 捕获的性能数据包括涉及大量对象，基于时间的统计，累积统计，采样数据和度量以及其他数据类型的活动的前N（例如，20或30）统计信息中的一个或多个。

公开(公告)号：US20090248621A1

公开(公告)日：2009-10-01

申请号：US12060117

申请日：2008-03-31

申请人： Benoit DAGEVILLE ,  Venkateshwaran VENKATARAMANI

发明人： Benoit DAGEVILLE ,  Venkateshwaran VENKATARAMANI

IPC分类号： G06F7/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）。 该方法支持在查询语句的执行计划的每个步骤以及为满足近实时查询监视解决方案的要求而处理的每个行中监视的各种性能统计信息。 这样的统计数据包括定时信息加上一些杂项统计数据，如处理的行数，使用的内存量，溢出到磁盘的数据量等。