公开(公告)号：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）统计信息中的一个或多个。

公开(公告)号：US20090106595A1

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

申请号：US12251671

申请日：2008-10-15

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

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

IPC分类号： G06F11/07

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

摘要： Techniques for gathering information during runtime of a monitored system such that the information is available for facilitating diagnostics for the monitored system. In one embodiment, upon detection of a condition (such as an error condition) in the monitored system, a portion of the gathered information provides contextual information that facilitates gathering of diagnostic data that is relevant for the detected condition. This facilitates capturing of diagnostic data that is relevant for diagnosing the detected condition. The information gathered and stored during runtime may include information related to local variables, information related to tagged information (e.g., tagged functions/processes) executing in the monitored system, information related to potential impacts to the monitored system due to failures, metadata information, and other information.

摘要翻译： 用于在被监视系统的运行时间期间收集信息的技术，使得该信息可用于便于被监视系统的诊断。 在一个实施例中，在检测到所监视的系统中的状况（例如错误状况）时，所收集的信息的一部分提供有助于收集与检测到的条件相关的诊断数据的上下文信息。 这有助于捕获与诊断检测到的状况相关的诊断数据。 在运行时收集和存储的信息可以包括与局部变量相关的信息，与被监视系统中执行的标记信息（例如，标记的功能/过程）相关的信息，与故障对被监视系统的潜在影响有关的信息，元数据信息， 和其他信息。

公开(公告)号：US20090106321A1

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

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

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

公开(公告)号：US20090077017A1

公开(公告)日：2009-03-19

申请号：US12188981

申请日：2008-08-08

申请人： Peter Belknap ,  Benoit Dageville ,  Karl Dias ,  Khaled Yagoub

发明人： Peter Belknap ,  Benoit Dageville ,  Karl Dias ,  Khaled Yagoub

IPC分类号： G06F17/30

CPC分类号： G06F17/30306

摘要： Techniques are provided for analyzing performance differences for a set of database query language statements on two different database systems. The performance analysis is based on quantitative measurements and estimates of the execution of the set of database query language statements on the two different database systems. This performance analysis process may be used by database administrators to predict impacts to performance due to a change in a database system.

摘要翻译： 提供了用于分析两个不同数据库系统上的一组数据库查询语言语句的性能差异的技术。 性能分析基于对两个不同数据库系统上的数据库查询语言语句集的执行的定量测量和估计。 数据库管理员可以使用此性能分析过程来预测由于数据库系统发生变化而对性能的影响。

公开(公告)号：US07475056B2

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

申请号：US11202453

申请日：2005-08-11

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

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

IPC分类号： G06F17/30

CPC分类号： G06F17/30463 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99935 ,  Y10S707/99936

摘要： A database statement is processed in a multi-server system, in a manner to increase the possibility that slave server processes on remote nodes will generate execution plans that are equivalent to the corresponding execution plan generated by the query coordinator process. A set of hints is generated based on the same information on which the master plan is based. The set of hints is sent to remote nodes, where respective remote plans are generated based in part on the set of hints. Use of the hints in generation of the remote plan increases the possibility that the remote plan will be equivalent to the master plan and that the slaves on the other database server will be able to join in parallel processing of the database statement.

摘要翻译： 在多服务器系统中处理数据库语句，以增加从属服务器在远程节点上处理的可能性将生成与查询协调器进程生成的相应执行计划相等的执行计划。 基于主计划所基于的相同信息生成一组提示。 一组提示被发送到远程节点，其中基于一组提示部分地生成相应的远程计划。 使用提示生成远程计划会增加远程计划等同于主计划的可能性，并且其他数据库服务器上的从站将能够并行处理数据库语句。

公开(公告)号：US07386849B2

公开(公告)日：2008-06-10

申请号：US10802553

申请日：2004-03-16

申请人： Benoit Dageville ,  Patrick A. Amor

发明人： Benoit Dageville ,  Patrick A. Amor

IPC分类号： G06F9/46

CPC分类号： G06F9/5066 ,  Y10S707/99931 ,  Y10S707/99933 ,  Y10S707/99938 ,  Y10S707/99943

摘要： A method and apparatus are provided for managing work granules being executed in parallel. A task is evenly divided between a number of work granules. The number of work granules falls between a threshold minimum and a threshold maximum. The threshold minimum and maximum may be configured to balance a variety of efficiency factors affected by the number of work granules, including workload skew and overhead incurred in managing larger number of work granules. Work granules are distributed to processes on nodes according to which of the nodes, if any, may execute the work granule efficiently. A variety of factors may used to determine where a work granule may be performed efficiently, including whether data accessed during the execution of a work granule may be locally accessed by a node.

摘要翻译： 提供了一种用于管理并行执行的工作颗粒的方法和装置。 任务在一些工作颗粒之间被均匀分配。 工作颗粒的数量落在阈值最小值和阈值最大值之间。 阈值最小值和最大值可以被配置为平衡受工作颗粒数量影响的各种效率因子，包括工作量偏差和管理更大数量的工作颗粒物所产生的开销。 工作颗粒分配到节点上的过程，根据哪个节点（如果有的话）可以有效地执行工作颗粒。 可以使用各种因素来确定工作颗粒可以有效执行的位置，包括在工作颗粒的执行期间访问的数据是否可以由节点本地访问。

公开(公告)号：US20080097995A1

公开(公告)日：2008-04-24

申请号：US11800122

申请日：2007-05-03

申请人： Karl Dias ,  Leonidas Galanis ,  Jonathan Klein ,  Venkateshwaran Venkataramani ,  Yujun Wang ,  Richard Sarwal ,  Leng Tan ,  Graham Wood ,  Benoit Dageville ,  Chao Liang ,  Sanjay Kaluskar

发明人： Karl Dias ,  Leonidas Galanis ,  Jonathan Klein ,  Venkateshwaran Venkataramani ,  Yujun Wang ,  Richard Sarwal ,  Leng Tan ,  Graham Wood ,  Benoit Dageville ,  Chao Liang ,  Sanjay Kaluskar

IPC分类号： G06F17/30

CPC分类号： G06F17/30377

摘要： A method and apparatus for capturing database system workload and replaying that workload in a database system is provided. According to one aspect, in order to subject a test database system to the same workload to which the production database system actually would be subjected, a database server in the production system captures and records workload that the database server receives from external entities. This captured workload is processed. Processes external to a database server in the test database system send the processed workload to that database server. As a result, the test database system is subjected to the same workload to which the production database system originally was subjected. The foregoing technique permits a database administrator to determine how the production database system will fare if the difference that is present in the test database system is introduced into the production database system.

摘要翻译： 提供了一种用于捕获数据库系统工作负载并在数据库系统中重播该工作负载的方法和装置。 根据一个方面，为了使测试数据库系统处于生产数据库系统实际受到的相同工作负载，生产系统中的数据库服务器捕获并记录数据库服务器从外部实体接收的工作负载。 处理此捕获的工作负载。 测试数据库系统中数据库服务器外部的进程将处理的工作负载发送到该数据库服务器。 因此，测试数据库系统受到生产数据库系统最初遭受的相同工作量的影响。 如果将测试数据库系统中存在的差异引入到生产数据库系统中，则上述技术允许数据库管理员确定生产数据库系统将如何展示。

公开(公告)号：US20060004807A1

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

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

公开(公告)号：US06961865B1

公开(公告)日：2005-11-01

申请号：US09993855

申请日：2001-11-13

申请人： Amit Ganesh ,  Ekrem Soylemez ,  Benoit Dageville

发明人： Amit Ganesh ,  Ekrem Soylemez ,  Benoit Dageville

IPC分类号： G06R11/00

CPC分类号： G06F11/1474 ,  Y10S707/99953

摘要： Techniques for executing an atomic transaction include performing a first operation of a first set of operations. The atomic transaction involves the first set of operations for causing changes to a first set of data. A first error that prevents completion of the atomic transaction is detected. In response to detecting the first error, a second set of operations is performed for resolving the first error. It is then determined whether a resolution of the first error is obtained in response to performing the second set of operations. If the resolution is obtained, then execution of the first set of operations is resumed. These techniques allow atomic transactions to be resumed after resolving an error without undoing all the operations accomplished for the transaction at the time the error occurred.

摘要翻译： 用于执行原子事务的技术包括执行第一组操作的第一操作。 原子事务涉及用于引起对第一组数据的改变的第一组操作。 检测到阻止完成原子事务的第一个错误。 响应于检测到第一错误，执行第二组操作以解决第一错误。 然后确定响应于执行第二组操作是否获得第一错误的分辨率。 如果获得分辨率，则恢复第一组操作的执行。 这些技术允许在解决错误后恢复原子事务，而不会撤消在发生错误时为事务完成的所有操作。

公开(公告)号：US20050132383A1

公开(公告)日：2005-06-16

申请号：US10824887

申请日：2004-04-13

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

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

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

CPC分类号： G06F17/30445

摘要： Techniques are provided for executing query statements, or portions thereof, in parallel without using slave SQL to communicate to each slave the operations to be performed by the slave. Instead of generating one cursor for the query coordinator (QC) based on the original statement, and separate cursors for each DFO based on the slave SQL, the techniques involve sharing the cursor that is generated from the original statement among the various participants involved in the parallel execution of the operations specified in the original statement.

摘要翻译： 提供了用于并行执行查询语句或其部分的技术，而不使用从属SQL向从机通知由从机执行的操作。 基于原始语句而不是为查询协调器（QC）生成一个游标，并且基于从属SQL为每个DFO分别设置游标，这些技术涉及共享从原始语句生成的游标， 并行执行原始语句中指定的操作。