Patents by Inventor Peter Belknap
Peter Belknap 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).
-
Patent number: 10235444Abstract: Providing a user with an interactive user interface that may fully enable interactions regardless of connectivity status may be provided. In some embodiments, one or more content items may be selected by a user of the user devices and may be queued for upload to a content management system. The content items may be organized into one or more collections of content items with other content items already stored in a user account on the content management system, such as images having similar geo-temporal characteristics. A set of interactivity features may be available to the user for interacting with the queued content item. This may provide the user with the seamless feeling as if the content items have been uploaded to the content management system and the user may be interacting with the content items on the content management system, even if the upload has not been completed.Type: GrantFiled: June 6, 2016Date of Patent: March 19, 2019Assignee: DROPBOX, INC.Inventors: Stephen Poletto, Peter Belknap, Thomas Kleinpeter
-
Patent number: 10229158Abstract: Approaches, techniques, and mechanisms are disclosed for ensuring that a database command is executed according to a query plan that has been verified to be actually optimal. Except in rare circumstances, a database server does not execute a query plan unless it is first verified by the database server. The database server receives a request to execute a database command. The database server determines an unverified plan is the best plan for satisfying the request. Rather than risk the unknown behavior of an unverified plan, the database server instead satisfies the request according to a verified plan. Subsequently—for example as part of a scheduled job—the database server executes the unverified plan to determine performance statistics. Based at least on the performance statistics, the database server determines whether or not to verify the unverified plan. Techniques for concurrent and optimistic verifications are also disclosed.Type: GrantFiled: April 11, 2014Date of Patent: March 12, 2019Assignee: Oracle International CorporationInventors: Peter Belknap, Benoit Dageville, Dinesh Das, Khaled Yagoub, Mohamed Zait, Mohamed Ziauddin
-
Patent number: 9720941Abstract: 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: GrantFiled: November 20, 2014Date of Patent: August 1, 2017Assignee: Oracle International CorporationInventors: Peter Belknap, Benoit Dageville, Karl Dias, Khaled Yagoub
-
Publication number: 20160314187Abstract: Providing a user with an interactive user interface that may fully enable interactions regardless of connectivity status may be provided. In some embodiments, one or more content items may be selected by a user of the user devices and may be queued for upload to a content management system. The content items may be organized into one or more collections of content items with other content items already stored in a user account on the content management system, such as images having similar geo-temporal characteristics. A set of interactivity features may be available to the user for interacting with the queued content item. This may provide the user with the seamless feeling as if the content items have been uploaded to the content management system and the user may be interacting with the content items on the content management system, even if the upload has not been completed.Type: ApplicationFiled: June 6, 2016Publication date: October 27, 2016Inventors: Stephen Poletto, Peter Belknap, Thomas Kleinpeter
-
Patent number: 9477692Abstract: Aspects of the present disclosure describe systems and methods for providing active session history data to users for use in database performance analysis. In various aspects, active session history data obtained from monitoring a database and/or database system over a period of time may be segmented into multiple dimensions. The segmented data may be subsequently provide and/or displayed on one or more interfaces, such as a graphical user interface, to users. The interface may visualize the dimensional ASH data in a variety of ways, such as through icons, graphs, charts, histograms, temporal delineations, treemaps, etc.Type: GrantFiled: January 31, 2013Date of Patent: October 25, 2016Inventors: John Beresniewicz, Stephen Wexler, Peter Belknap, Hsiao-Te Su, Ameet Kini
-
Patent number: 9462054Abstract: Providing a user with an interactive user interface that may fully enable interactions regardless of connectivity status may be provided. In some embodiments, one or more content items may be selected by a user of the user devices and may be queued for upload to a content management system. The content items may be organized into one or more collections of content items with other content items already stored in a user account on the content management system, such as images having similar geo-temporal characteristics. A set of interactivity features may be available to the user for interacting with the queued content item. This may provide the user with the seamless feeling as if the content items have been uploaded to the content management system and the user may be interacting with the content items on the content management system, even if the upload has not been completed.Type: GrantFiled: April 8, 2014Date of Patent: October 4, 2016Assignee: DROPBOX, INC.Inventors: Stephen Poletto, Peter Belknap, Thomas Kleinpeter
-
Patent number: 9256642Abstract: 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: GrantFiled: June 30, 2010Date of Patent: February 9, 2016Assignee: Oracle International CorporationInventors: Hailing Yu, Peter Belknap, Thierry Cruanes, Benoit Dageville, Karl Dias, Khaled Yagoub
-
Patent number: 9189522Abstract: Approaches, techniques, and mechanisms are disclosed for maintaining a set of baseline query plans for a database command. Except in rare circumstances, a database server may only execute a command according to a baseline plan, even if the database server predicts that a different plan has a lower cost. The set of baseline plans are plans that, for one reason or another, have been determined to provide acceptable actual performance in at least one execution context. When the database server receives a request to execute a particular command, the database server, if possible, always executes the command according to the lowest predicted cost baseline plan. The database server may evolve the plan baseline to include additional plans by generating and testing new plans in response to new requests to execute the database command, or as part of a query optimization or tuning process.Type: GrantFiled: August 8, 2008Date of Patent: November 17, 2015Assignee: ORACLE INTERNATIONAL CORPORATIONInventors: Dinesh Das, Cetin Ozbutun, Hong Su, Mohamed Zait, Yali Zhu, Mohamed Ziauddin, Peter Belknap, Khaled Yagoub
-
Publication number: 20150244794Abstract: Providing a user with an interactive user interface that may fully enable interactions regardless of connectivity status may be provided. In some embodiments, one or more content items may be selected by a user of the user devices and may be queued for upload to a content management system. The content items may be organized into one or more collections of content items with other content items already stored in a user account on the content management system, such as images having similar geo-temporal characteristics. A set of interactivity features may be available to the user for interacting with the queued content item. This may provide the user with the seamless feeling as if the content items have been uploaded to the content management system and the user may be interacting with the content items on the content management system, even if the upload has not been completed.Type: ApplicationFiled: April 8, 2014Publication date: August 27, 2015Applicant: Dropbox, Inc.Inventors: Stephen Poletto, Peter Belknap, Thomas Kleinpeter
-
Patent number: 9058356Abstract: Approaches, techniques, and mechanisms are disclosed for maintaining a set of baseline query plans for a database command. Except in rare circumstances, a database server may only execute a command according to a baseline plan, even if the database server predicts that a different plan has a lower cost. The set of baseline plans are plans that, for one reason or another, have been determined to provide acceptable actual performance in at least one execution context. When the database server receives a request to execute a particular command, the database server, if possible, always executes the command according to the lowest predicted cost baseline plan. The database server may evolve the plan baseline to include additional plans by generating and testing new plans in response to new requests to execute the database command, or as part of a query optimization or tuning process.Type: GrantFiled: August 8, 2008Date of Patent: June 16, 2015Assignee: ORACLE INTERNATIONAL CORPORATIONInventors: Dinesh Das, Cetin Ozbutun, Hong Su, Mohamed Zait, Yali Zhu, Mohamed Ziauddin, Peter Belknap, Khaled Yagoub
-
Publication number: 20150081669Abstract: 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: ApplicationFiled: November 20, 2014Publication date: March 19, 2015Inventors: PETER BELKNAP, BENOIT DAGEVILLE, KARL DIAS, KHALED YAGOUB
-
Patent number: 8903801Abstract: 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: GrantFiled: August 8, 2008Date of Patent: December 2, 2014Assignee: Oracle International CorporationInventors: Peter Belknap, Benoit Dageville, Karl Dias, Khaled Yagoub
-
Patent number: 8892536Abstract: A method for resolving a hang in a database system includes receiving a symbolic graph having a plurality of nodes, where each node represents a database session involved in the hang during a specified time interval. The blocking time associated with each node in the symbolic graph is recursively determined. The node that has the longest blocking time is output to a display for review by the database administrator. Alternatively, the database session represented by the node having the longest blocking time may be automatically eliminated.Type: GrantFiled: September 26, 2012Date of Patent: November 18, 2014Assignee: Oracle International CorporationInventors: Uri Shaft, Amirali Valiani, Peter Belknap
-
Publication number: 20140236921Abstract: Approaches, techniques, and mechanisms are disclosed for ensuring that a database command is executed according to a query plan that has been verified to be actually optimal. Except in rare circumstances, a database server does not execute a query plan unless it is first verified by the database server. The database server receives a request to execute a database command. The database server determines an unverified plan is the best plan for satisfying the request. Rather than risk the unknown behavior of an unverified plan, the database server instead satisfies the request according to a verified plan. Subsequently—for example as part of a scheduled job—the database server executes the unverified plan to determine performance statistics. Based at least on the performance statistics, the database server determines whether or not to verify the unverified plan. Techniques for concurrent and optimistic verifications are also disclosed.Type: ApplicationFiled: April 11, 2014Publication date: August 21, 2014Applicant: Oracle International CorporationInventors: Peter Belknap, Benoit Dageville, Dinesh Das, Khaled Yagoub, Mohamed Zait, Mohamed Ziauddin
-
Patent number: 8700608Abstract: Approaches, techniques, and mechanisms are disclosed for ensuring that a database command is executed according to a query plan that has been verified to be actually optimal. Except in rare circumstances, a database server does not execute a query plan unless it is first verified by the database server. The database server receives a request to execute a database command. The database server determines an unverified plan is the best plan for satisfying the request. Rather than risk the unknown behavior of an unverified plan, the database server instead satisfies the request according to a verified plan. Subsequently—for example as part of a scheduled job—the database server executes the unverified plan to determine performance statistics. Based at least on the performance statistics, the database server determines whether or not to verify the unverified plan. Techniques for concurrent and optimistic verifications are also disclosed.Type: GrantFiled: August 8, 2008Date of Patent: April 15, 2014Assignee: Oracle International CorporationInventors: Peter Belknap, Benoit Dageville, Dinesh Das, Khaled Yagoub, Mohamed Zait, Mohamed Ziauddin
-
Publication number: 20140095428Abstract: Aspects of the present disclosure describe systems and methods for providing active session history data to users for use in database performance analysis. In various aspects, active session history data obtained from monitoring a database and/or database system over a period of time may be segmented into multiple dimensions. The segmented data may be subsequently provide and/or displayed on one or more interfaces, such as a graphical user interface, to users. The interface may visualize the dimensional ASH data in a variety of ways, such as through icons, graphs, charts, histograms, temporal delineations, treemaps, etc.Type: ApplicationFiled: January 31, 2013Publication date: April 3, 2014Applicant: ORACLE INTERNATIONAL CORPORATIONInventors: John Beresniewicz, Stephen Wexler, Peter Belknap, Hsiao-Te Su, Ameet Kini
-
Patent number: 8688689Abstract: 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: GrantFiled: June 30, 2010Date of Patent: April 1, 2014Assignee: Oracle International CorporationInventors: Hailing Yu, Peter Belknap, Benoit Dageville, Karl Dias, Khaled Yagoub
-
Publication number: 20140089268Abstract: A method for resolving a hang in a database system includes receiving a symbolic graph having a plurality of nodes, where each node represents a database session involved in the hang during a specified time interval. The blocking time associated with each node in the symbolic graph is recursively determined. The node that has the longest blocking time is output to a display for review by the database administrator. Alternatively, the database session represented by the node having the longest blocking time may be automatically eliminated.Type: ApplicationFiled: September 26, 2012Publication date: March 27, 2014Applicant: Oracle International CorporationInventors: Uri Shaft, Amirali Valiani, Peter Belknap
-
Patent number: 8341178Abstract: 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: GrantFiled: August 8, 2008Date of Patent: December 25, 2012Assignee: Oracle International CorporationInventors: Peter Belknap, Benoit Dageville, Karl Dias, Khaled Yagoub
-
Publication number: 20120005189Abstract: Techniques for automatically recommending alternative execution plans for a SQL statement. In one set of embodiments, 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: ApplicationFiled: June 30, 2010Publication date: January 5, 2012Applicant: Oracle International CorporationInventors: Hailing Yu, Peter Belknap, Benoit Dageville, Karl Dias, Khaled Yagoub