Patents by Inventor Venkateshwaran Venkataramani
Venkateshwaran Venkataramani 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: 20110295801Abstract: 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: ApplicationFiled: August 11, 2011Publication date: December 1, 2011Applicant: ORACLE INTERNATIONAL CORPORATIONInventors: Karl DIAS, Leonidas GALANIS, Jonathan KLEIN, Venkateshwaran VENKATARAMANI, Yujun WANG
-
Patent number: 8024299Abstract: 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: GrantFiled: May 3, 2007Date of Patent: September 20, 2011Assignee: Oracle International CorporationInventors: Karl Dias, Leonidas Galanis, Jonathan Klein, Venkateshwaran Venkataramani, Yujun Wang
-
Patent number: 8024301Abstract: One or more usage models are provided for a database. Each usage model includes a set of rules that are used to analyze database performance. A usage model in one or more usage models is determined. Database information is determined based on the usage model. The database information is then analyzed based on rules associated with the usage model. One or more performance problems are determined based on the analysis.Type: GrantFiled: August 11, 2004Date of Patent: September 20, 2011Assignee: Oracle International CorporationInventors: Karl Dias, Graham S. Wood, Shivani Gupta, Sushil Kumar, Mark Ramacher, Uri Shaft, Leng Leng Tan, Venkateshwaran Venkataramani
-
Patent number: 7984015Abstract: 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: GrantFiled: May 3, 2007Date of Patent: July 19, 2011Assignee: Oracle International CorporationInventors: Karl Dias, Leonidas Galanis, Jonathan Klein, Venkateshwaran Venkataramani, Yujun Wang, Richard Sarwal, Leng Tan, Graham Wood, Benoit Dageville, Chao Liang, Sanjay Kaluskar
-
Patent number: 7937623Abstract: A diagnosability system for automatically collecting, storing, communicating, and analyzing diagnostic data for one or more monitored systems. The diagnosability system comprises several components configured for the collection, storage, communication, and analysis of diagnostic data for a condition detected in monitored system. The diagnosability system enables targeted dumping of diagnostic data so that only diagnostic data that is relevant for diagnosing the condition detected in the monitored system is collected and stored. This in turn enables first failure analysis thereby reducing the time needed to resolve the condition detected in the monitored system.Type: GrantFiled: October 15, 2008Date of Patent: May 3, 2011Assignee: Oracle International CorporationInventors: Mark Ramacher, Gary Ngai, Benoit Dageville, Karl Dias, Yair Sarig, Marcus Fallen, Ajith Kumar Mysorenagarajarao, John Beresniewicz, Mike Feng, Jonathan Klein, Hailing Yu, Leng Tan, Balasubrahmanya Kuchibhotla, Uri Shaft, Venkateshwaran Venkataramani, Amir Valiani
-
Patent number: 7890457Abstract: 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: GrantFiled: May 3, 2007Date of Patent: February 15, 2011Assignee: Oracle International CorporationInventors: Karl Dias, Leonidas Galanis, Jonathan Klein, Venkateshwaran Venkataramani, Yujun Wang
-
Patent number: 7890458Abstract: 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: GrantFiled: May 3, 2007Date of Patent: February 15, 2011Assignee: Oracle International CorporationInventors: Karl Dias, Leonidas Galanis, Jonathan Klein, Venkateshwaran Venkataramani, Yujun Wang
-
Patent number: 7673291Abstract: Techniques for self-diagnosing performance problems in a database are provided. The techniques include classifying one or more performance problems in a database system. One or more values for quantifying an impact of the one or more performance problems on the database system are then determined. The quantified values are determined based on the performance of operations in the database system. A performance problem based on the one or more quantified values is then determined. A solution for the performance problem is generated and may be outputted.Type: GrantFiled: February 9, 2004Date of Patent: March 2, 2010Assignee: Oracle International CorporationInventors: Karl Dias, Shivani Gupta, Mark Ramacher, Uri Shaft, Venkateshwaran Venkataramani, Graham S. Wood, Juan Loaiza
-
Publication number: 20090248621Abstract: 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: ApplicationFiled: March 31, 2008Publication date: October 1, 2009Inventors: Benoit DAGEVILLE, Venkateshwaran VENKATARAMANI
-
Publication number: 20090106278Abstract: A diagnosability system for automatically collecting, storing, communicating, and analyzing diagnostic data for one or more monitored systems. The diagnosability system comprises several components configured for the collection, storage, communication, and analysis of diagnostic data for a condition detected in monitored system. The diagnosability system enables targeted dumping of diagnostic data so that only diagnostic data that is relevant for diagnosing the condition detected in the monitored system is collected and stored. This in turn enables first failure analysis thereby reducing the time needed to resolve the condition detected in the monitored system.Type: ApplicationFiled: October 15, 2008Publication date: April 23, 2009Applicant: Oracle International CorporationInventors: Mark Ramacher, Gary Ngai, Benoit Dageville, Karl Dias, Yair Sarig, Marcus Fallen, Ajith Kumar Mysorenagarajarao, John Beresniewicz, Mike Feng, Jonathan Klein, Hailing Yu, Leng Tan, Balasubrahmanyam Kuchibhotla, Uri Shaft, Venkateshwaran Venkataramani, Amir Valiani
-
Publication number: 20080097960Abstract: 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: ApplicationFiled: May 3, 2007Publication date: April 24, 2008Inventors: Karl Dias, Leonidas Galanis, Jonathan Klein, Venkateshwaran Venkataramani, Yujun Wang
-
Publication number: 20080097996Abstract: 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: ApplicationFiled: May 3, 2007Publication date: April 24, 2008Applicant: Oracle International CorporationInventors: Karl Dias, Leonidas Galanis, Jonathan Klein, Venkateshwaran Venkataramani, Yujun Wang
-
Publication number: 20080097995Abstract: 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: ApplicationFiled: May 3, 2007Publication date: April 24, 2008Applicant: Oracle International CorporationInventors: Karl Dias, Leonidas Galanis, Jonathan Klein, Venkateshwaran Venkataramani, Yujun Wang, Richard Sarwal, Leng Tan, Graham Wood, Benoit Dageville, Chao Liang, Sanjay Kaluskar
-
Publication number: 20080098003Abstract: 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: ApplicationFiled: May 3, 2007Publication date: April 24, 2008Applicant: Oracle International CorporationInventors: Karl Dias, Leonidas Galanis, Jonathan Klein, Venkateshwaran Venkataramani, Yujun Wang
-
Publication number: 20080097961Abstract: 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: ApplicationFiled: May 3, 2007Publication date: April 24, 2008Applicant: Oracle International CorporationInventors: Karl Dias, Leonidas Galanis, Jonathan Klein, Venkateshwaran Venkataramani, Yujun Wang
-
Patent number: 7292961Abstract: Techniques for capturing samples of session activity in a database are provided. Session activity for active sessions is recorded at certain times over a time period. Accordingly, a sample of session activity is taken for sessions in a database.Type: GrantFiled: February 9, 2004Date of Patent: November 6, 2007Assignee: Oracle International CorporationInventors: Karl Dias, Venkateshwaran Venkataramani, Mark Ramacher, Graham S. Wood, Juan Loaiza
-
Publication number: 20050216490Abstract: One or more usage models are provided for a database. Each usage model includes a set of rules that are used to analyze database performance. A usage model in one or more usage models is determined. Database information is determined based on the usage model. The database information is then analyzed based on rules associated with the usage model. One or more performance problems are determined based on the analysis.Type: ApplicationFiled: August 11, 2004Publication date: September 29, 2005Applicant: Oracle International CorporationInventors: Karl Dias, Graham Wood, Shivani Gupta, Sushil Kumar, Mark Ramacher, Uri Shaft, Leng Leng Tan, Venkateshwaran Venkataramani
-
Publication number: 20050086242Abstract: 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.Type: ApplicationFiled: September 3, 2004Publication date: April 21, 2005Applicant: Oracle International CorporationInventors: Gary Ngai, Mark Ramacher, Graham Wood, Connie Green, Venkateshwaran Venkataramani, Karl Dias, Benoit Dageville, Michael Feng
-
Publication number: 20050055383Abstract: Techniques for capturing samples of session activity in a database are provided. Session activity for active sessions is recorded at certain times over a time period. Accordingly, a sample of session activity is taken for sessions in a database.Type: ApplicationFiled: February 9, 2004Publication date: March 10, 2005Applicant: Oracle International CorporationInventors: Karl Dias, Venkateshwaran Venkataramani, Mark Ramacher, Graham Wood, Juan Loaiza
-
Publication number: 20050055673Abstract: Techniques for self-diagnosing performance problems in a database are provided. The techniques include classifying one or more performance problems in a database system. One or more values for quantifying an impact of the one or more performance problems on the database system are then determined. The quantified values are determined based on the performance of operations in the database system. A performance problem based on the one or more quantified values is then determined. A solution for the performance problem is generated and may be outputted.Type: ApplicationFiled: February 9, 2004Publication date: March 10, 2005Applicant: Oracle International CorporationInventors: Karl Dias, Shivani Gupta, Mark Ramacher, Uri Shaft, Venkateshwaran Venkataramani, Graham Wood, Juan Loaiza