公开(公告)号：US08688700B2

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

申请号：US12251685

申请日：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分类号： G06F7/00 ,  G06F17/30

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

摘要： Techniques that enable a user or customer at a system site to review and, if desired, modify data identified at the system site for transmission to a diagnosis site prior to the transmission. The identified diagnostic data may be modified such that data that the user does not want to be sent to the diagnosis site (e.g., sensitive data) is excluded from the data communicated to the diagnosis site. The data may be modified by removing or excluding the sensitive data from the data that is communicated to the diagnosis site or replacing the sensitive data with non-sensitive data. The modified data may then be communicated from the system site to the diagnosis site in the form of a package.

摘要翻译： 允许系统站点上的用户或客户审查技术，并且如果需要，修改在系统现场识别的数据，以便在传输之前传送到诊断位置。 所识别的诊断数据可以被修改，使得用户不希望将其发送到诊断位点的数据（例如敏感数据）被排除在传送到诊断位点的数据中。 可以通过从传送到诊断站点的数据中删除或排除敏感数据或用非敏感数据替换敏感数据来修改数据。 然后可以以包的形式将修改的数据从系统站点传送到诊断站点。

公开(公告)号：US08239167B2

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

申请号：US12251731

申请日：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/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.

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

公开(公告)号：US07774312B2

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

申请号：US10934771

申请日：2004-09-03

申请人： Gary Ngai ,  Michael Feng ,  Alex Tsukerman ,  Benoit Dageville ,  Mark Ramacher ,  Karl Dias ,  Graham S. Wood ,  Leng Leng Tan ,  Richard Sarwal ,  Sushil Kumar

发明人： Gary Ngai ,  Michael Feng ,  Alex Tsukerman ,  Benoit Dageville ,  Mark Ramacher ,  Karl Dias ,  Graham S. Wood ,  Leng Leng Tan ,  Richard Sarwal ,  Sushil Kumar

IPC分类号： G06F17/30

CPC分类号： G06F17/30306

摘要： A self-managing workload repository (AWR) infrastructure useful for a database server to collect and manage selected sets of important system performance statistics. Based on a schedule, the AWR runs automatically to collect data about the operation of the database system, and stores the data that it captures into the database. The AWR is advantageously designed to be lightweight and to self manage its use of storage space so as to avoid ending up with a repository of performance data that is larger than the database that it is capturing data about. 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. Both the frequency of the statistics data capture and length of time for which data is kept is adjustable. Manual snapshots and purging may also be performed. The AWR captured data allows for both system level and user level analysis to be automatically performed without unduly impacting system performance, e.g., by eliminating or reducing the requirement to repeat the workload in order to diagnose problems.

摘要翻译： 自管理工作负载存储库（AWR）基础架构可用于数据库服务器收集和管理所选的重要系统性能统计信息。 根据计划，AWR自动运行以收集有关数据库系统操作的数据，并将其捕获的数据存储到数据库中。 AWR有利地被设计为轻量级并且自我管理其对存储空间的使用，以避免最终获得比它正在捕获数据的数据库更大的性能数据库。 AWR配置为定期自动捕获统计数据的快照，并定期清除过期数据。 统计数据捕获的频率和保存数据的时间长短都是可调的。 也可以执行手动快照和清除。 AWR捕获的数据允许自动执行系统级别和用户级别分析，而不会不必要地影响系统性能，例如通过消除或减少重复工作负载以便诊断问题的要求。

公开(公告)号：US07685095B2

公开(公告)日：2010-03-23

申请号：US10944175

申请日：2004-09-16

申请人： Bhaskar Ghosh ,  Thierry Cruanes ,  Benoit Dageville

发明人： Bhaskar Ghosh ,  Thierry Cruanes ,  Benoit Dageville

IPC分类号： G06F17/30

CPC分类号： G06F17/30445 ,  Y10S707/99932

摘要： Techniques are provided for executing database statements, or portions thereof, in parallel without using slave SQL to communicate to each slave the operations to be performed by the slave. Techniques are provided for incorporating within a shared cursor the code fragments that govern both sides of the interaction between a query coordinator (QC) and remotely-located slaves. Further, techniques are provided for the QC to communicate with each slave on how and which portions of the execution plan to execute and when. A state-transition engine for slave execution under the control of the query-coordinator is also provided.

摘要翻译： 提供了用于并行地执行数据库语句或其部分的技术，而不使用从属SQL向从属单元通信由从属单元执行的操作。 提供了在共享游标中并入管理查询协调器（QC）和远程定位的从站之间的交互的两侧的代码片段的技术。 此外，提供了用于QC的技术以与每个从属单元通信以执行执行计划以及何时执行计划的哪些部分。 还提供了在查询协调器的控制下从属执行的状态转换引擎。

公开(公告)号：US20090106262A1

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

申请号：US12251685

申请日：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分类号： G06F17/30

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

摘要： Techniques that enable a user or customer at a system site to review and, if desired, modify data identified at the system site for transmission to a diagnosis site prior to the transmission. The identified diagnostic data may be modified such that data that the user does not want to be sent to the diagnosis site (e.g., sensitive data) is excluded from the data communicated to the diagnosis site. The data may be modified by removing or excluding the sensitive data from the data that is communicated to the diagnosis site or replacing the sensitive data with non-sensitive data. The modified data may then be communicated from the system site to the diagnosis site in the form of a package.

摘要翻译： 允许系统站点上的用户或客户审查技术，并且如果需要，修改在系统现场识别的数据，以便在传输之前传送到诊断位置。 所识别的诊断数据可以被修改，使得用户不希望将其发送到诊断位点的数据（例如敏感数据）被排除在传送到诊断位点的数据中。 可以通过从传送到诊断站点的数据中删除或排除敏感数据或用非敏感数据替换敏感数据来修改数据。 然后可以以包的形式将修改的数据从系统站点传送到诊断站点。

公开(公告)号：US20090105989A1

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

申请号：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分类号： G21C17/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.

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

公开(公告)号：US07469241B2

公开(公告)日：2008-12-23

申请号：US11156068

申请日：2005-06-17

申请人： Srikanth Bellamkonda ,  Benoit Dageville

发明人： Srikanth Bellamkonda ,  Benoit Dageville

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

CPC分类号： G06F17/30489 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99942

摘要： Hash aggregation operates in two phases. In the first phase, data read from underlying row source is partitioned on GROUP BY keys with on-the-fly aggregation. It is determined into which partition an entry corresponding to the incoming record should be grouped, and whether a matching entry is already present in the partition, using a hash function and a hash table built for the partition. For aggregation operations, if a match is found, then a measure value from the incoming record is aggregated with a measure value for the entry existing in the partition. If there is not enough system volatile memory to complete the first phase, then a partition is selected for storing persistently. Thus, only one partition at a time is stored persistently, as necessary. In the second phase, one persistently stored partition is processed at a time, whereby aggregation of the data in that partition is completed and results are returned.

摘要翻译： 哈希聚合分为两个阶段。 在第一阶段，从基础行源读取的数据在具有即时聚合的GROUP BY密钥上进行分区。 确定哪个分区对应于输入记录的条目应该被分组，以及使用为该分区构建的散列函数和哈希表是否已经存在分区中的匹配条目。 对于聚合操作，如果找到匹配项，则来自记录的度量值将与分区中存在的条目的度量值进行聚合。 如果没有足够的系统易失性存储器来完成第一阶段，则选择一个分区来持久存储。 因此，必要时，一次只能存储一个分区。 在第二阶段，一次处理一个持久存储的分区，从而完成该分区中的数据的聚合，并返回结果。

公开(公告)号：US07155446B2

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

申请号：US10867923

申请日：2004-06-14

申请人： Thierry Cruanes ,  Wei Li ,  Ari Mozes ,  Benoit Dageville

发明人： Thierry Cruanes ,  Wei Li ,  Ari Mozes ,  Benoit Dageville

IPC分类号： G06F17/00

CPC分类号： G06F17/3056 ,  G06F17/30513 ,  Y10S707/99942

摘要： A method and apparatus for performing recursive database operations is provided. According to one aspect, a plurality of first-stage slaves and a plurality of second-stage slaves are established in a database server. During one or more iterations of a recursive database operation, the first-stage slaves concurrently process data items stored in a data repository and send results to the second-stage slaves. The second-stage slaves receive the results and concurrently process those results. The second-stage slaves store the results of the second-stage slaves' processing in the data repository. Subsequent iterations of the recursive database operation proceed in this manner until the recursive database operation has been completed. In each iteration, the first-stage slaves consume the product of the second-stage slaves' previous iteration's processing, and the second-stage slaves consume the product of the first-stage slaves' current iteration's processing.

摘要翻译： 提供了一种用于执行递归数据库操作的方法和装置。 根据一个方面，在数据库服务器中建立多个第一级从站和多个第二级从站。 在递归数据库操作的一个或多个迭代期间，第一级从站同时处理存储在数据存储库中的数据项，并将结果发送到第二级从站。 第二阶段的奴隶收到结果并同时处理这些结果。 第二级从站将数据存储库中的第二级从站处理的结果存储起来。 递归数据库操作的后续迭代以这种方式进行，直到递归数据库操作完成。 在每次迭代中，第一级从站消耗第二级从站先前迭代处理的乘积，第二级从站消耗第一级从站当前迭代处理的乘积。

公开(公告)号：US20060116989A1

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

申请号：US11156068

申请日：2005-06-17

申请人： Srikanth Bellamkonda ,  Benoit Dageville

发明人： Srikanth Bellamkonda ,  Benoit Dageville

IPC分类号： G06F17/30

CPC分类号： G06F17/30489 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99942

摘要： Hash aggregation operates in two phases. In the first phase, data read from underlying row source is partitioned on GROUP BY keys with on-the-fly aggregation. It is determined into which partition an entry corresponding to the incoming record should be grouped, and whether a matching entry is already present in the partition, using a hash function and a hash table built for the partition. For aggregation operations, if a match is found, then a measure value from the incoming record is aggregated with a measure value for the entry existing in the partition. If there is not enough system volatile memory to complete the first phase, then a partition is selected for storing persistently. Thus, only one partition at a time is stored persistently, as necessary. In the second phase, one persistently stored partition is processed at a time, whereby aggregation of the data in that partition is completed and results are returned.

摘要翻译： 哈希聚合分为两个阶段。 在第一阶段，从基础行源读取的数据在具有即时聚合的GROUP BY密钥上进行分区。 确定哪个分区对应于输入记录的条目应该被分组，以及使用为该分区构建的散列函数和哈希表是否已经存在分区中的匹配条目。 对于聚合操作，如果找到匹配项，则来自记录的度量值将与分区中存在的条目的度量值进行聚合。 如果没有足够的系统易失性存储器来完成第一阶段，则选择一个分区来持久存储。 因此，必要时，一次只能存储一个分区。 在第二阶段，一次处理一个持久存储的分区，从而完成该分区中的数据的聚合，并返回结果。

公开(公告)号：US07051034B1

公开(公告)日：2006-05-23

申请号：US10325782

申请日：2002-12-18

申请人： Bhaskar Ghosh ,  Thierry Cruanes ,  Benoit Dageville

发明人： Bhaskar Ghosh ,  Thierry Cruanes ,  Benoit Dageville

IPC分类号： G06F17/30

CPC分类号： G06F17/30625 ,  G06F17/30979 ,  Y10S707/99942 ,  Y10S707/99945

摘要： Execution of a restartable sub-tree of a query execution plan comprises determining whether use of parallel processes is a preferred or optimal mode of executing the sub-tree. The determination is based, at least in part, on how long it takes to restart the sub-tree using two or more parallel processes and/or how long it takes to probe the sub-tree, i.e., to fetch a row that meets one or more conditions or correlations associated with the sub-query, using the two or more parallel processes. Thus, a dynamic computational cost-based operation is described, which determines at query runtime whether to execute the restartable sub-tree using a single server process or multiple parallel server processes.

摘要翻译： 执行查询执行计划的可重新开始的子树包括确定并行进程的使用是否是执行子树的优选或最佳模式。 该决定至少部分地基于使用两个或更多个并行进程重新启动子树所需的时间和/或探测子树需要多长时间，即，获取满足一个 或更多与子查询相关联的条件或相关性，使用两个或多个并行进程。 因此，描述了基于动态计算成本的操作，其在查询运行时确定是否使用单个服务器进程或多个并行服务器进程来执行可重新启动的子树。