Patents by Inventor Karl Dias

Karl Dias 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: 20200004860
    Abstract: Techniques for analyzing an execution of a query statement based on a random archive are disclosed. A plurality of query statements that are executed during a particular time period are identified. A random sampling function is executed to randomly select a set of query statements from the plurality of query statements. Execution plans and/or performance metrics associated with each execution of the randomly-selected query statements are stored into a random archive. Responsive to determining that a performance metric for a current execution of a particular query statement does not satisfy a performance criteria, information associated with the particular query statement from the random archive is analyzed. A model plan characteristic associated with an execution of the particular query statement stored in the random archive is determined. An execution plan associated with the model plan characteristic is determined for another execution of the particular query statement.
    Type: Application
    Filed: July 1, 2018
    Publication date: January 2, 2020
    Applicant: Oracle International Corporation
    Inventors: Arvind Kumar Maheshwari, Uri Shaft, Karl Dias, Vishwanath Karra, Stephen Wexler, Anil Kumar Kothuri
  • Publication number: 20190146966
    Abstract: Techniques for leveraging frequent patterns identified in a captured workload are provided. In one approach, multiple frequent patterns detected in a captured workload may be ordered by frequency to determine, for example, which patterns should be targeted for optimization. In another approach, a model of a captured workload is created, where the model comprises nodes that represent templates (which in turn correspond to requests) and edges that represent transitions between templates. The model is used to create an artificial workload, such as a workload that is twice as large as the originally-captured workload. The model may also be edited before creating the artificial workload. In another approach, workload models are compared to identify errors, regressions, or security issues. In another approach, an artificial workload is created for an application that is not yet deployed and then executed to determine whether the artificial workload or the originally-captured workload executed faster.
    Type: Application
    Filed: December 31, 2018
    Publication date: May 16, 2019
    Applicant: Oracle International Corporation
    Inventors: Konstantinos Morfonios, Leonidas Galanis, Kusumaharanadh Poduri, Jae Young Yoon, Zhongtang Cai, Karl Dias
  • Patent number: 10248683
    Abstract: Techniques for leveraging frequent patterns identified in a captured workload are provided. In one approach, multiple frequent patterns detected in a captured workload may be ordered by frequency to determine, for example, which patterns should be targeted for optimization. In another approach, a model of a captured workload is created, where the model comprises nodes that represent templates (which in turn correspond to requests) and edges that represent transitions between templates. The model is used to create an artificial workload, such as a workload that is twice as large as the originally-captured workload. The model may also be edited before creating the artificial workload. In another approach, workload models are compared to identify errors, regressions, or security issues. In another approach, an artificial workload is created for an application that is not yet deployed and then executed to determine whether the artificial workload or the originally-captured workload executed faster.
    Type: Grant
    Filed: April 10, 2014
    Date of Patent: April 2, 2019
    Assignee: Oracle International Corporation
    Inventors: Konstantinos Morfonios, Leonidas Galanis, Kusumaharanadh Poduri, Jae Young Yoon, Zhongtang Cai, Karl Dias
  • Patent number: 9983918
    Abstract: Systems, methods, and other embodiments associated with continuous capture of replayable workload for a database are described. In one embodiment, a method includes capturing workload units being executed on a production database and storing the captured workload units in a circular workload buffer. The circular workload buffer is configured to write newest captured workload units over oldest workload units in the workload buffer when the workload buffer becomes full. The method includes, in response to detecting an event, exporting contents of the workload buffer to offline memory. The exporting includes at least one I/O operation. In one embodiment, an advisor feature guides set up of the continuous capture feature by providing historical workload data and making recommendations regarding an amount of memory that should be allocated to the workload buffer.
    Type: Grant
    Filed: December 18, 2015
    Date of Patent: May 29, 2018
    Assignee: Oracle International Corporation
    Inventors: Prabhaker Gongloor, Yujun Wang, Mughees A. Minhas, Haranadh Poduri, Karl Dias, Leonidas Galanis
  • Patent number: 9720941
    Abstract: Techniques are provided for a fully-automated process for tuning database query language statements that selects database query language statements for tuning, tunes the database query language statements and generates tuning recommendations, tests the tuning recommendations, and determines whether to implement the tuning recommendations based on the test results. The fully-automated tuning process may also automatically implement certain tuning recommendations and monitor the performance of the database query language statements for which tuning recommendations have been implemented.
    Type: Grant
    Filed: November 20, 2014
    Date of Patent: August 1, 2017
    Assignee: Oracle International Corporation
    Inventors: Peter Belknap, Benoit Dageville, Karl Dias, Khaled Yagoub
  • Publication number: 20170123877
    Abstract: Systems, methods, and other embodiments associated with continuous capture of replayable workload for a database are described. In one embodiment, a method includes capturing workload units being executed on a production database and storing the captured workload units in a circular workload buffer. The circular workload buffer is configured to write newest captured workload units over oldest workload units in the workload buffer when the workload buffer becomes full. The method includes, in response to detecting an event, exporting contents of the workload buffer to offline memory. The exporting includes at least one I/O operation. In one embodiment, an advisor feature guides set up of the continuous capture feature by providing historical workload data and making recommendations regarding an amount of memory that should be allocated to the workload buffer.
    Type: Application
    Filed: December 18, 2015
    Publication date: May 4, 2017
    Inventors: Prabhaker GONGLOOR, Yujun WANG, Mughees A. MINHAS, Haranadh PODURI, Karl DIAS, Leonidas GALANIS
  • Patent number: 9524322
    Abstract: Techniques for generating and processing composite active reports are provided. An active report is a report that can be displayed and interacted with at a client device even though the client device is not connected to a database from which data for the report originates. A composite active report is an active report that includes multiple reports embedded in the same file. Each report in a composite active report may be separately compressed to allow a client device to decompress a report on demand. A composite active report may include, for each report indicated in the composite active report, executable identification data that is used to retrieve, from a remote source, an executable that is used to generate, based on report data of the report, display data, which is displayed on a computer display of a client device.
    Type: Grant
    Filed: September 27, 2013
    Date of Patent: December 20, 2016
    Assignee: Oracle International Corporation
    Inventors: Khaled Yagoub, Abdul Munir, Cecilia Gervasio Grant, Karl Dias, Benoit Dageville
  • Patent number: 9256642
    Abstract: Techniques for automatically recommending parallel execution of a SQL statement. In one set of embodiments, a first determination can be made regarding whether a SQL statement can be executed in parallel. Further, a second determination can be made regarding whether executing the SQL statement in parallel is faster than executing the statement in serial by a predetermined factor. If the first determination and second determination are positive (i.e., the statement can be executed in parallel and parallel execution is faster by the predetermined factor), a recommendation can be provided indicating that the SQL statement should be executed in parallel. In some embodiments, the recommendation can include a report specifying the degree of performance improvement gained from parallel execution, additional system resources consumed by parallel execution, and other statistics pertaining to the recommended parallel execution plan.
    Type: Grant
    Filed: June 30, 2010
    Date of Patent: February 9, 2016
    Assignee: Oracle International Corporation
    Inventors: Hailing Yu, Peter Belknap, Thierry Cruanes, Benoit Dageville, Karl Dias, Khaled Yagoub
  • Publication number: 20150293964
    Abstract: Techniques for leveraging frequent patterns identified in a captured workload are provided. In one approach, multiple frequent patterns detected in a captured workload may be ordered by frequency to determine, for example, which patterns should be targeted for optimization. In another approach, a model of a captured workload is created, where the model comprises nodes that represent templates (which in turn correspond to requests) and edges that represent transitions between templates. The model is used to create an artificial workload, such as a workload that is twice as large as the originally-captured workload. The model may also be edited before creating the artificial workload. In another approach, workload models are compared to identify errors, regressions, or security issues. In another approach, an artificial workload is created for an application that is not yet deployed and then executed to determine whether the artificial workload or the originally-captured workload executed faster.
    Type: Application
    Filed: April 10, 2014
    Publication date: October 15, 2015
    Applicant: Oracle International Corporation
    Inventors: Konstantinos Morfonios, Leonidas Galanis, Kusumaharanadh Poduri, Jae Young Yoon, Zhongtang Cai, Karl Dias
  • Publication number: 20150081669
    Abstract: Techniques are provided for a fully-automated process for tuning database query language statements that selects database query language statements for tuning, tunes the database query language statements and generates tuning recommendations, tests the tuning recommendations, and determines whether to implement the tuning recommendations based on the test results. The fully-automated tuning process may also automatically implement certain tuning recommendations and monitor the performance of the database query language statements for which tuning recommendations have been implemented.
    Type: Application
    Filed: November 20, 2014
    Publication date: March 19, 2015
    Inventors: PETER BELKNAP, BENOIT DAGEVILLE, KARL DIAS, KHALED YAGOUB
  • Patent number: 8954397
    Abstract: A method for replaying a simulation workload is provided. The simulation workload identifies a plurality of workload parts. Each workload part is at least a portion of a respective captured workload. In an embodiment, a first workload part is a portion of a first workload executed relative to a first capture database server and a second workload part is a portion of a second workload executed relative to a second capture database server. A portion of the first workload part and a portion of the second workload part may be replayed concurrently.
    Type: Grant
    Filed: June 29, 2012
    Date of Patent: February 10, 2015
    Assignee: Oracle International Corporation
    Inventors: Yujun Wang, Leonidas Galanis, Konstantinos Morfonios, Karl Dias, John Mark Beresniewicz
  • Publication number: 20150006511
    Abstract: Techniques for generating and processing composite active reports are provided. An active report is a report that can be displayed and interacted with at a client device even though the client device is not connected to a database from which data for the report originates. A composite active report is an active report that includes multiple reports embedded in the same file. Each report in a composite active report may be separately compressed to allow a client device to decompress a report on demand. A composite active report may include, for each report indicated in the composite active report, executable identification data that is used to retrieve, from a remote source, an executable that is used to generate, based on report data of the report, display data, which is displayed on a computer display of a client device.
    Type: Application
    Filed: September 27, 2013
    Publication date: January 1, 2015
    Applicant: Oracle International Corporation
    Inventors: Khaled Yagoub, Abdul Munir, Cecilia Gervasio Grant, Karl Dias, Benoit Dageville
  • Patent number: 8903801
    Abstract: Techniques are provided for a fully-automated process for tuning database query language statements that selects database query language statements for tuning, tunes the database query language statements and generates tuning recommendations, tests the tuning recommendations, and determines whether to implement the tuning recommendations based on the test results. The fully-automated tuning process may also automatically implement certain tuning recommendations and monitor the performance of the database query language statements for which tuning recommendations have been implemented.
    Type: Grant
    Filed: August 8, 2008
    Date of Patent: December 2, 2014
    Assignee: Oracle International Corporation
    Inventors: Peter Belknap, Benoit Dageville, Karl Dias, Khaled Yagoub
  • Patent number: 8892712
    Abstract: Techniques are described for upgrading systems that include a first set of agents for collecting target data from a plurality of targets and sending the target data to a first management server. In an embodiment, a second set of agents is pre-deployed. Each pre-deployed agent is configured to, upon activation, collect target data from a respective target of the plurality of targets and send the target data to a second management server. While the pre-deployed agent remains inactive, an agent from the first set of agents collects and sends the target data to the first management server. When a first batch of one or more pre-deployed agents is activated, each activated agent begins collecting target data and sending the target data to the second management server. For agents not in the first batch, the first set of agents continues to collect and send the target data.
    Type: Grant
    Filed: September 28, 2012
    Date of Patent: November 18, 2014
    Assignee: Oracle International Corporation
    Inventors: Balasubrahmanyam Kuchibhotla, Karl Dias, Matthew Stephen McKerley, Shachi Sanklecha, Anupama Vale, Sumankumar Pramanik, Sanjay Ediga, Jonathan D. Klein, Supratim Choudhury
  • Patent number: 8782219
    Abstract: Described herein are methods for determining patterns based on requests received by a server. Based on the determined patterns, insight into the types of requests received by the server can be gained. Additionally, performance statistics and query statistics can be aggregated in a useful way. For example, performance statistics may be summarized for each determined pattern. One technique for determining patterns includes determining a sequence of template identifiers identifying templates that correspond to sub-sequences of requests in a sequence of server requests. A model may be created based on the sequence of template identifiers. Based on the model, template patterns may be determined. Template patterns may further be grouped into pattern clusters.
    Type: Grant
    Filed: May 18, 2012
    Date of Patent: July 15, 2014
    Assignee: Oracle International Corporation
    Inventors: Konstantinos Morfonios, Leonidas Galanis, Neoklis Polyzotis, Karl Dias
  • Patent number: 8732126
    Abstract: 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.
    Type: Grant
    Filed: August 11, 2011
    Date of Patent: May 20, 2014
    Assignee: Oracle International Corporation
    Inventors: Karl Dias, Leonidas Galanis, Jonathan Klein, Venkateshwaran Venkataramani, Yujun Wang
  • 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
  • Publication number: 20140006358
    Abstract: A method for replaying a simulation workload is provided. The simulation workload identifies a plurality of workload parts. Each workload part is at least a portion of a respective captured workload. In an embodiment, a first workload part is a portion of a first workload executed relative to a first capture database server and a second workload part is a portion of a second workload executed relative to a second capture database server. A portion of the first workload part and a portion of the second workload part may be replayed concurrently.
    Type: Application
    Filed: June 29, 2012
    Publication date: January 2, 2014
    Inventors: Yujun Wang, Leonidas Galanis, Konstantinos Morfonios, Karl Dias, John Mark Beresniewicz
  • Publication number: 20130311642
    Abstract: Described herein are methods for determining patterns based on requests received by a server. Based on the determined patterns, insight into the types of requests received by the server can be gained. Additionally, performance statistics and query statistics can be aggregated in a useful way. For example, performance statistics may be summarized for each determined pattern. One technique for determining patterns includes determining a sequence of template identifiers identifying templates that correspond to sub-sequences of requests in a sequence of server requests. A model may be created based on the sequence of template identifiers. Based on the model, template patterns may be determined. Template patterns may further be grouped into pattern clusters.
    Type: Application
    Filed: May 18, 2012
    Publication date: November 21, 2013
    Applicant: ORACLE INTERNATIONAL CORPORATION
    Inventors: Konstantinos Morfonios, Leonidas Galanis, Neoklis Polyzotis, Karl Dias
  • Patent number: 8438144
    Abstract: A method, apparatus, and computer-readable medium is provided for replaying captured workload data in a database environment with connection pools. A replay system includes a dispatcher that manages a connection pool. In one aspect, the dispatcher selects available connections for sending database commands that are ready to be executed against a database, but prevents from being sent, or holds, commands that are not ready to be executed against the database. Commands may be stored at the dispatcher until the database advances to a state that allows the commands to be executed. In another aspect, the dispatcher may use an available connection to send a command to a database instance even though the command is not ready to be executed, as long as at least a threshold number or percentage of connections remains available.
    Type: Grant
    Filed: August 27, 2010
    Date of Patent: May 7, 2013
    Assignee: Oracle International Corporation
    Inventors: Romain Colle, Karl Dias, Leonidas Galanis, Supiti Buranawatanachoke, Jonathan Giloni, Efstratios Papadomanolakis, Yujun Wang