Patents by Inventor Benoit Dageville

Benoit Dageville has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).

  • Publication number: 20140095453
    Abstract: A method for obtaining data items from an unresponsive database host. The method includes receiving an indication that the database host is unresponsive, receiving, from a management server via a diagnostic connection, a first request for a first organized data item, and sending a first query, using a first interface, to a memory for the first organized data item. The method further includes receiving, from the management server via a normal connection, a second request for a second organized data item, retrieving, from memory on the database host, a first data item in response to the first query, converting the first data item into the first organized data item, and sending the first organized data item to the management server, wherein the first organized data item is analyzed to determine a source causing the database host to be unresponsive.
    Type: Application
    Filed: December 20, 2012
    Publication date: April 3, 2014
    Applicant: ORACLE INTERNATIONAL CORPORATION
    Inventors: George An, Pete Belknap, Uri Shaft, Benoit Dageville, Ameet Kini
  • Patent number: 8688700
    Abstract: 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.
    Type: Grant
    Filed: October 15, 2008
    Date of Patent: April 1, 2014
    Assignee: Oracle International Corporation
    Inventors: Marcus Fallen, Benoit Dageville, Jonathan Klein, Ajith Kumar Mysorenagarajarao, Gary Ngai, Mark Ramacher, Yair Sarig
  • Patent number: 8688689
    Abstract: Techniques are provided for automatically recommending alternative execution plans for a SQL statement. Information pertaining to one or more execution plans for a SQL statement can be retrieved from a set of plan sources. The one or more execution plans can include the current execution plan for the statement and one or more historical execution plans. Based on the retrieved information, the performance of the one or more execution plans can be compared to each other. Based on the comparison, a recommendation can be provided to a user indicating that a particular execution plan (e.g., a historical execution plan) should be used in place of the current execution plan to execute the SQL statement.
    Type: Grant
    Filed: June 30, 2010
    Date of Patent: April 1, 2014
    Assignee: Oracle International Corporation
    Inventors: Hailing Yu, Peter Belknap, Benoit Dageville, Karl Dias, Khaled Yagoub
  • Patent number: 8606744
    Abstract: Embodiments of the invention enable data to be moved from one or more external sources into a database system. A plurality of processes are executed concurrently. Each of the processes are executable to move data from at least a portion of the one or more external sources into the database system, so that executing the plurality of processes concurrently moves data from different portions of the one or more external sources into the database system in parallel. Execution of the plurality of processes are coordinated from the database system.
    Type: Grant
    Filed: May 31, 2002
    Date of Patent: December 10, 2013
    Assignee: Oracle International Corporation
    Inventors: Benoit Dageville, Allen Brumm
  • Patent number: 8600977
    Abstract: 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.
    Type: Grant
    Filed: August 8, 2008
    Date of Patent: December 3, 2013
    Assignee: Oracle International Corporation
    Inventors: Benoit Dageville, Dinesh Das, Mohamed Ziauddin
  • Patent number: 8577871
    Abstract: 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.
    Type: Grant
    Filed: March 31, 2008
    Date of Patent: November 5, 2013
    Assignee: Oracle International Corporation
    Inventors: Benoit Dageville, Venkateshwaran Venkataramani
  • Patent number: 8429467
    Abstract: 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.
    Type: Grant
    Filed: October 15, 2008
    Date of Patent: April 23, 2013
    Assignee: Oracle International Corporation
    Inventors: Marcus Fallen, Benoit Dageville, Jonathan Klein, Ajith Kumar Mysorenagarajarao, Gary Ngai, Mark Ramacher, Yair Sarig
  • Patent number: 8380665
    Abstract: 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.
    Type: Grant
    Filed: March 30, 2011
    Date of Patent: February 19, 2013
    Assignee: Oracle International Corporation
    Inventors: 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
  • Patent number: 8380664
    Abstract: 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.
    Type: Grant
    Filed: February 24, 2011
    Date of Patent: February 19, 2013
    Assignee: Oracle International Corporation
    Inventors: 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
  • Patent number: 8341178
    Abstract: 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.
    Type: Grant
    Filed: August 8, 2008
    Date of Patent: December 25, 2012
    Assignee: Oracle International Corporation
    Inventors: Peter Belknap, Benoit Dageville, Karl Dias, Khaled Yagoub
  • Patent number: 8335767
    Abstract: 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.
    Type: Grant
    Filed: August 8, 2008
    Date of Patent: December 18, 2012
    Assignee: Oracle International Corporation
    Inventors: Dinesh Das, Yali Zhu, Mohamed Ziauddin, Benoit Dageville, Hong Su
  • Patent number: 8326816
    Abstract: 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.
    Type: Grant
    Filed: May 6, 2010
    Date of Patent: December 4, 2012
    Assignee: Oracle International Corporation
    Inventors: Romain Colle, Benoit Dageville, Karl Dias, Leonidas Galanis, Supiti Buranawatanachoke, Jonathan Klein, Efstratios Papadomanolakis, Yujun Wang
  • Patent number: 8296104
    Abstract: 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.
    Type: Grant
    Filed: October 15, 2008
    Date of Patent: October 23, 2012
    Assignee: Oracle International Corporation
    Inventors: Mark Ramacher, Gary Ngai, Benoit Dageville, Karl Dias, Yair Sarig, Marcus Fallen, Ajith Kumar Mysorenagarajarao
  • Patent number: 8260871
    Abstract: Techniques for intelligently identifying diagnostic data to be communicated from a product or system site (e.g., a customer site) to a diagnosis site (e.g., a vendor site). An appropriate amount of diagnostic data is identified to facilitate efficient and quick diagnosis and error resolution. Techniques are also provided that enable a customer to review the data identified for transmission to the diagnosis site prior to the transmission.
    Type: Grant
    Filed: October 15, 2008
    Date of Patent: September 4, 2012
    Assignee: Oracle International Corporation
    Inventors: Marcus Fallen, Benoit Dageville, Jonathan Klein, Ajith Kumar Mysorenagarajarao, Gary Ngai, Mark Ramacher, Yair Sarig
  • Publication number: 20120221519
    Abstract: 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.
    Type: Application
    Filed: March 30, 2011
    Publication date: August 30, 2012
    Applicant: ORACLE INTERNATIONAL CORPORATION
    Inventors: 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
  • Publication number: 20120221513
    Abstract: 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.
    Type: Application
    Filed: February 24, 2011
    Publication date: August 30, 2012
    Applicant: ORACLE INTERNATIONAL CORPORATION
    Inventors: 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
  • Patent number: 8255182
    Abstract: 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.
    Type: Grant
    Filed: October 15, 2008
    Date of Patent: August 28, 2012
    Assignee: Oracle International Corporation
    Inventors: Yair Sarig, Benoit Dageville, Marcus Fallen, Ajith Kumar Mysorenagarajarao, Karl Dias, Mark Ramacher, Gary Ngai
  • Patent number: 8239167
    Abstract: 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.
    Type: Grant
    Filed: October 15, 2008
    Date of Patent: August 7, 2012
    Assignee: Oracle International Corporation
    Inventors: Mark Ramacher, Gary Ngai, Benoit Dageville, Karl Dias, Yair Sarig, Marcus Fallen, Ajith Kumar Mysorenagarajarao
  • Patent number: 8145642
    Abstract: Techniques are described for combining pieces of information from two sources. The techniques may be used to improve the performance, for example, of hash join operations that are parallelized using slaves distributed across multiple nodes. According to one technique, bitmap filtering operations are performed by the probe-phase producer slaves, rather than the probe-phase consumer slaves. To avoid having to merge separately built bitmap filter chunks, the left-hand rows may be sent to every probe-phase consumer slave. Alternatively, the merge operation may be avoided by distributing the rows of one source based on how the other source has been statically partitioned.
    Type: Grant
    Filed: November 30, 2004
    Date of Patent: March 27, 2012
    Assignee: Oracle International Corporation
    Inventors: Thierry Cruanes, Benoit Dageville, William H. Waddington
  • Patent number: 8135995
    Abstract: Techniques for systematically gathering, organizing, and storing diagnostic data related to multiple monitored systems (e.g., multiple instances of a product or multiple products). A centralized repository is provided that is organized in a hierarchical manner to facilitate proper organization of the diagnostic data related to multiple monitored systems. In one embodiment, a root directory comprising one or more subdirectories is provided for storing diagnostic data collected for each monitored system. Multiple root directories may be provided under a common base directory for storing diagnostic data corresponding to multiple monitored systems. This enables correlation of diagnostic data across multiple monitored systems.
    Type: Grant
    Filed: October 15, 2008
    Date of Patent: March 13, 2012
    Assignee: Oracle International Corporation
    Inventors: Gary Ngai, Jonathan Klein, Mark Ramacher, Benoit Dageville, Hailing Yu, Mike Feng, Yair Sarig, Marcus Fallen, John Beresniewicz