公开(公告)号：US20060064400A1

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

申请号：US10946749

申请日：2004-09-21

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

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

IPC分类号： G06F17/30

CPC分类号： G06F16/27

摘要： 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.

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

公开(公告)号：US20050131879A1

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

申请号：US10901411

申请日：2004-07-27

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

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

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

CPC分类号： G06F17/30445 ,  Y10S707/99933 ,  Y10S707/99934

摘要： A cursor that is generated from an original database statement includes a master plan that is shared among the various participants involved in the parallel execution of the operations specified in the original statement. For participants that cannot share the same cursor, such as slave processes on remote servers, a remote cursor is generated. Signatures are generated for both the master plan and the remote plans, and compared to ensure that the remote plans are equivalent to the master plans. Various parameters and statistics are provided to remote servers to increase the likelihood that the remote plans will be equivalent to the master plan.

摘要翻译： 从原始数据库语句生成的游标包括在并行执行原始语句中指定的操作的各参与者之间共享的主计划。 对于无法共享相同光标的参与者（如远程服务器上的从属进程），将生成远程光标。 为主计划和远程计划生成签名，并进行比较，以确保远程计划等同于主计划。 向远程服务器提供了各种参数和统计信息，以增加远程计划与主计划相当的可能性。

公开(公告)号：US20050125427A1

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

申请号：US10936778

申请日：2004-09-07

申请人： Benoit Dageville ,  Mohamed Ziauddin ,  Khaled Yagoub ,  Mohamed Zait ,  Dinesh Das ,  Karl Dias ,  Mark Ramacher ,  Leng Tan

发明人： Benoit Dageville ,  Mohamed Ziauddin ,  Khaled Yagoub ,  Mohamed Zait ,  Dinesh Das ,  Karl Dias ,  Mark Ramacher ,  Leng Tan

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

CPC分类号： G06F17/30474 ,  G06F17/30306 ,  Y10S707/99932 ,  Y10S707/99934 ,  Y10S707/99944

摘要： A method for receiving a database query language statement and performance information about the statement at an optimizer and generating one or more tuning actions for the statement with the performance information is disclosed.

摘要翻译： 公开了一种用于在优化器处接收数据库查询语言语句和关于语句的性能信息的方法，并且针对具有性能信息的语句生成一个或多个调优操作。

公开(公告)号：US06687798B1

公开(公告)日：2004-02-03

申请号：US09873131

申请日：2001-05-31

申请人： Ashish Thusoo ,  Benoit Dageville ,  Allen H. Brumm

发明人： Ashish Thusoo ,  Benoit Dageville ,  Allen H. Brumm

IPC分类号： G06F1300

CPC分类号： G06F17/30339

摘要： Methods of inserting data in parallel into a partitioned data storage object are disclosed. Multiple processes are used to insert the data, and multiple processes may insert data into the same partition at the same time. Write conflicts are avoided through use of buffers and a brokering scheme to manage the data flows into the partitioned data storage object. Also disclosed are methods to optimize the size of the buffers to minimize bottlenecks.

摘要翻译： 公开了将数据并行插入分区数据存储对象的方法。 多个进程用于插入数据，多个进程可以同时将数据插入同一个分区。 通过使用缓冲区和代理方案来管理数据流到分区数据存储对象中避免写入冲突。 还公开了优化缓冲器的尺寸以最小化瓶颈的方法。

公开(公告)号：US06665684B2

公开(公告)日：2003-12-16

申请号：US09405980

申请日：1999-09-27

申请人： Mohamed Zait ,  Benoit Dageville ,  Andre Kruglikov ,  Gianfranco Putzolu

发明人： Mohamed Zait ,  Benoit Dageville ,  Andre Kruglikov ,  Gianfranco Putzolu

IPC分类号： G06F1700

CPC分类号： G06F17/3033 ,  G06F17/30333 ,  G06F17/30492 ,  Y10S707/99931 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99942 ,  Y10S707/99943

摘要： Techniques are disclosed for expanding the concept of partitioning in variety of ways. In particular techniques are provided for performing multiple-dimension partitioning. In multiple-dimension partitioning, a database object is divided into partitions based on one criteria, and each of those resulting partitions is divided into sub-partitions based on a second criteria. The process of partitioning partitions based on different criteria may be repeated across any number of dimensions. Entirely different partitioning techniques may be used for each level of partitioning. The database server takes advantage of partitions when processing queries by selectively accessing a subset of partitions on disk or reducing the number of internal join operations.

摘要翻译： 公开了以各种方式扩展划分概念的技术。 特别地，提供了用于执行多维分割的技术。 在多维分区中，基于一个条件将数据库对象划分为分区，并且根据第二准则将所生成的分区中的每一个划分为子分区。 可以跨任何数量的维度重复基于不同标准划分分区的过程。 完全不同的分区技术可用于每个级别的分区。 数据库服务器通过选择性地访问磁盘上的分区子集或减少内部联接操作的数量来处理查询时利用分区。

公开(公告)号：US06438562B1

公开(公告)日：2002-08-20

申请号：US09379625

申请日：1999-08-24

申请人： Shivani Gupta ,  William H. Waddington ,  Benoit Dageville

发明人： Shivani Gupta ,  William H. Waddington ,  Benoit Dageville

IPC分类号： G06F1730

CPC分类号： G06F17/30336 ,  Y10S707/99952 ,  Y10S707/99953

摘要： A method, system and product for coordinating a parallel update for a global index of an indexed table involves a coordinator process and slave processes. The coordinator process receives index maintenance records from data manipulation slaves for an indexed table. Each index maintenance record includes a value for an index key of a global index of the table. The coordinator process computes index key value ranges and sends each range to an index update slave. Each slave updates the global index using just the index maintenance records with key values in its respective range, thus avoiding contention among the slaves and increasing clustering so that scaleable parallelism may be more closely attained. Techniques are also described for deferring the maintenance of global indexes relative to the time when the table on which they are built is changed.

摘要翻译： 用于协调索引表的全局索引的并行更新的方法，系统和产品涉及协调程序进程和从属进程。 协调器进程从索引表的数据操作从站接收索引维护记录。 每个索引维护记录包括表的全局索引的索引关键字的值。 协调器进程计算索引键值范围，并将每个范围发送到索引更新从站。 每个从站使用仅具有相应范围内的关键值的索引维护记录来更新全局索引，从而避免了从站之间的竞争并增加了聚类，从而可以更加可靠地实现可扩展的并行性。 还描述了相对于更改其构建表的时间推迟全局索引的维护的技术。

公开(公告)号：US08983934B2

公开(公告)日：2015-03-17

申请号：US10936468

申请日：2004-09-07

申请人： Mark Ramacher ,  Sreenath Bodagala ,  Benoit Dageville ,  Alex Tsukerman ,  Stephen J. Vivian ,  Mohamed Ziauddin

发明人： Mark Ramacher ,  Sreenath Bodagala ,  Benoit Dageville ,  Alex Tsukerman ,  Stephen J. Vivian ,  Mohamed Ziauddin

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

CPC分类号： G06F17/30474 ,  G06F17/30306 ,  Y10S707/99932 ,  Y10S707/99934 ,  Y10S707/99944

摘要： A computer readable medium storing a database query language statement tuning base in a tuning base memory location is disclosed. The tuning base includes tuning information for one or more query language statements. The tuning information for each statement includes one or more tuning actions for the statement, and a signature to allow an optimizer to identify the one or more tuning actions for the statement.

摘要翻译： 公开了一种在调谐基础存储器位置中存储数据库查询语言调整基座的计算机可读介质。 调优基础包括一个或多个查询语言语句的调整信息。 每个语句的调整信息包括语句的一个或多个调优操作，以及允许优化器识别语句的一个或多个调优操作的签名。

公开(公告)号：US08380665B2

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

申请号：US13076313

申请日：2011-03-30

申请人： Efstratios Papadomanolakis ,  Zhongtang Cai ,  Romain Colle ,  Benoit Dageville ,  Karl Dias ,  Leonidas Galanis ,  Rodney Graham ,  Bo Gong ,  Qinghui H. Altmar ,  Jae Young Yoon ,  Mehmet Fidanboylu ,  Tom Hsu

发明人： Efstratios Papadomanolakis ,  Zhongtang Cai ,  Romain Colle ,  Benoit Dageville ,  Karl Dias ,  Leonidas Galanis ,  Rodney Graham ,  Bo Gong ,  Qinghui H. Altmar ,  Jae Young Yoon ,  Mehmet Fidanboylu ,  Tom Hsu

IPC分类号： G06F17/00

CPC分类号： G06F11/3688

摘要： An application workload capture and replay system with a transactionally consistent application workload replay feature is provided. More particularly, the feature includes capture-phase components for capturing and recording a real application workload submitted to a production web application system and includes replay-phase components for replaying the captured application workload against a test web application system in a transactionally consistent manner. The feature provides guarantees about the order of database transactions that are caused when the workload is replayed such that there is a consistency between the replay-phase order of the database transactions and the order of those transactions that occurred when the workload was captured. These consistency guarantees facilitate a faithful reproduction of database changes observed in the production web application system in the test web application system using a captured real application workload. Significantly, this faithful reproduction may be accomplished without having to create a synthetic application workload that approximates or emulates the transactional behavior of the real application workload. Instead, a real application workload may be used as or substantially as it is captured.

摘要翻译： 提供了具有事务一致的应用程序工作负载重放功能的应用程序工作负载捕获和重放系统。 更具体地，该特征包括用于捕获和记录提交到生产web应用系统的真实应用工作负载的捕获相组件，并且包括用于以事务一致的方式针对测试web应用系统重放所捕获的应用工作负载的重放阶段组件。 该功能提供了关于在重放工作负载时引起的数据库事务的顺序的保证，使得数据库事务的重放阶段顺序与捕获工作负载时发生的那些事务的顺序之间存在一致性。 这些一致性保证有助于在测试Web应用系统中使用捕获的实际应用程序工作负载忠实地再现在生产Web应用系统中观察到的数据库更改。 重要的是，可以实现这种忠实的再现，而无需创建近似或模拟实际应用程序工作负载的事务行为的综合应用程序工作负载。 相反，真正的应用程序工作负载可以被使用或基本上被捕获。

公开(公告)号：US08380664B2

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

申请号：US13034526

申请日：2011-02-24

申请人： Efstratios Papadomanolakis ,  Zhongtang Cai ,  Romain Colle ,  Benoit Dageville ,  Karl Dias ,  Leonidas Galanis ,  Rodney Graham ,  Bo Gong ,  Qinghui H. Altmar ,  Jae Young Yoon ,  Mehmet Fidanboylu ,  Tom Hsu

发明人： Efstratios Papadomanolakis ,  Zhongtang Cai ,  Romain Colle ,  Benoit Dageville ,  Karl Dias ,  Leonidas Galanis ,  Rodney Graham ,  Bo Gong ,  Qinghui H. Altmar ,  Jae Young Yoon ,  Mehmet Fidanboylu ,  Tom Hsu

IPC分类号： G06F17/00

CPC分类号： G06F17/30557

摘要： A database system providing transactionally consistent replay of application workloads. In a database system, a method providing transactionally consistent replay of application workloads comprises the steps of: during a replay phase in which a plurality of application requests that were previously submitted to an application server system during a capture phase are being replayed, receiving, at a database server, a database request to execute a database command against a database. The database request specifies an application request identifier that identifies a particular application request of the plurality of application requests. The particular application request caused the database command to be executed previously during the capture phase. In response to receiving the database request, determining, based on the application request identifier in the database request, whether to delay execution of the database command at least until a particular replay-phase database transaction has been committed.

摘要翻译： 数据库系统提供事务性一致的应用程序工作负载重播。 在数据库系统中，提供事务性地一致地重放应用工作负载的方法包括以下步骤：在重放阶段，其中在捕获阶段期间先前提交给应用服务器系统的多个应用请求正在被重播， 数据库服务器，针对数据库执行数据库命令的数据库请求。 数据库请求指定标识多个应用请求的特定应用请求的应用请求标识符。 特定的应用程序请求导致数据库命令在捕获阶段之前执行。 响应于接收到数据库请求，基于数据库请求中的应用请求标识确定是否延迟数据库命令的执行至少直到特定的重放阶段数据库事务被提交。

公开(公告)号：US08326816B2

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

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

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