Patents by Inventor Jonathan Giloni
Jonathan Giloni 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: 20240126785Abstract: Techniques are described for preserving the inflight sessions failing over from a primary database to the replicated logical database of the primary database. In an implementation, prior to failover, when the primary database server receives a commit for a transaction, the process stores a commit indication that the transaction has been committed by performing a corresponding SQL command. The commit indication is replicated to the logical replica database by virtue of the replication of the SQL command and its execution on the logical replica database. Accordingly, the standby database server in the failover session may successfully request for the outcome of the transaction. Techniques are also described for the client-side LOB references to be preserved when failing over to the logical replica database, for AS OF queries preserved, and for versioning of checksums, signatures and structures across logical replicas.Type: ApplicationFiled: October 13, 2023Publication date: April 18, 2024Inventors: Carol Lyndall Colrain, Xiaoli Qi, Kevin S. Neel, Stephen J. Vivian, Michael Cusson, Yunrui Li, Jonathan Giloni
-
Patent number: 11556500Abstract: Techniques are disclosed herein for identifying, recording and restoring the state of a database session and various aspects thereof. A session template data structure is generated that includes session attribute values describing various aspects of the session that is established between a client system and a database management system (DBMS and enables the client system to issue to the DBMS commands for execution. Based on the session attribute values, DBMS may generate a template identifier corresponding to the session template data structure. The template identifier may be stored in an association with the session state that it partially (or in whole) represents. In an embodiment, when another state of a session is captured, if the template identifier for the state is the same, then rather than storing the attribute-value pairs for the other state, the template identifier is further associated with the other state.Type: GrantFiled: September 28, 2018Date of Patent: January 17, 2023Assignee: ORACLE INTERNATIONAL CORPORATIONInventors: Jonathan Giloni, Kevin S. Neel, Carol L. Colrain, Douglas Surber, Ravi Thammaiah, Tong Zhou, Arturo Ismael Quinto, Manoj Dhanapal
-
Patent number: 11138215Abstract: Described is an improved approach to implement parallel queries where session states are saved for parallelization resources. When work needs to be performed in the parallel query system for a given session, a search can be performed to identify a resource (from among the pool of available resources) that had previously been used by that session, and which had saved a session state object for that previous connection to the session. Instead of incurring the entirety of setup costs each time workload is assigned to a resource, the saved session state can be used to re-set the context for the resource to the configuration requirements for that session.Type: GrantFiled: June 29, 2018Date of Patent: October 5, 2021Assignee: Oracle International CorporationInventors: Mehul D. Bastawala, Jonathan Giloni
-
Publication number: 20200004861Abstract: Described is an improved approach to implement parallel queries where session states are saved for parallelization resources. When work needs to be performed in the parallel query system for a given session, a search can be performed to identify a resource (from among the pool of available resources) that had previously been used by that session, and which had saved a session state object for that previous connection to the session. Instead of incurring the entirety of setup costs each time workload is assigned to a resource, the saved session state can be used to re-set the context for the resource to the configuration requirements for that session.Type: ApplicationFiled: June 29, 2018Publication date: January 2, 2020Applicant: Oracle International CorporationInventors: Mehul D. Bastawala, Jonathan Giloni
-
Publication number: 20190102401Abstract: Techniques are disclosed herein for identifying, recording and restoring the state of a database session and various aspects thereof. A session template data structure is generated that includes session attribute values describing various aspects of the session that is established between a client system and a database management system (DBMS and enables the client system to issue to the DBMS commands for execution. Based on the session attribute values, DBMS may generate a template identifier corresponding to the session template data structure. The template identifier may be stored in an association with the session state that it partially (or in whole) represents. In an embodiment, when another state of a session is captured, if the template identifier for the state is the same, then rather than storing the attribute-value pairs for the other state, the template identifier is further associated with the other state.Type: ApplicationFiled: September 28, 2018Publication date: April 4, 2019Inventors: KEVIN S. NEEL, CAROL L. COLRAIN, TONG ZHOU, ARTURO ISMAEL QUINTO, JONATHAN GILONI, DOUGLAS SURBER, RAVI THAMMAIAH
-
Publication number: 20190102267Abstract: Techniques are disclosed herein for identifying, recording and restoring the state of a database session and various aspects thereof. A session template data structure is generated that includes session attribute values describing various aspects of the session that is established between a client system and a database management system (DBMS and enables the client system to issue to the DBMS commands for execution. Based on the session attribute values, DBMS may generate a template identifier corresponding to the session template data structure. The template identifier may be stored in an association with the session state that it partially (or in whole) represents. In an embodiment, when another state of a session is captured, if the template identifier for the state is the same, then rather than storing the attribute-value pairs for the other state, the template identifier is further associated with the other state.Type: ApplicationFiled: September 28, 2018Publication date: April 4, 2019Inventors: JONATHAN GILONI, KEVIN S. NEEL, CAROL L. COLRAIN, DOUGLAS SURBER, RAVI THAMMAIAH, TONG ZHOU, ARTURO ISMAEL QUINTO, MANOJ DHANAPAL
-
Patent number: 10248471Abstract: Systems for managing shared computing resources. In a multi-process computing environment a concurrency object data structure pertaining to a shared resource is made available to be accessed by two or more processing entities. The concurrency object comprises a consecutive read count that tracks the number of consecutive read requests that have been received for shared read access to the shared resource. A shared concurrency access state is entered based on comparison of the consecutive read count to a threshold value. Entering the shared concurrency access state begins a period during which grant of further shared access requests do not require semaphore operations or other atomic operations that pertains to the shared resource.Type: GrantFiled: September 15, 2016Date of Patent: April 2, 2019Assignee: Oracle International CorporationInventors: Raunak Rungta, Jonathan Giloni, Ravi Shankar Thammaiah, Sumanta Kumar Chatterjee, Juan Loaiza
-
Patent number: 10241856Abstract: A method for memory quarantine comprises: in response to a memory error, determining an extent associated with the memory error, wherein the extent defines an amount of memory comprising a plurality of chunks; traversing, forward from a beginning chunk of the plurality chunks, the plurality of chunks until a first chunk is determined to be corrupt; traversing, in reverse from a last chunk of the plurality of chunks, the plurality of chunks until a second chunk is determine to be corrupt; flagging a subset of the plurality of chunks as quarantined, wherein the subset begins with the first chunk and ends with the second chunk, and wherein quarantine prevents the subset from being reallocated after being released.Type: GrantFiled: September 9, 2016Date of Patent: March 26, 2019Assignee: ORACLE INTERNATIONAL CORPORATIONInventors: Jonathan Giloni, William Habeck, Raunak Rungta, Ravi Thammaiah
-
Publication number: 20180074865Abstract: Systems for managing shared computing resources. In a multi-process computing environment a concurrency object data structure pertaining to a shared resource is made available to be accessed by two or more processing entities. The concurrency object comprises a consecutive read count that tracks the number of consecutive read requests that have been received for shared read access to the shared resource. A shared concurrency access state is entered based on comparison of the consecutive read count to a threshold value. Entering the shared concurrency access state begins a period during which grant of further shared access requests do not require semaphore operations or other atomic operations that pertains to the shared resource.Type: ApplicationFiled: September 15, 2016Publication date: March 15, 2018Applicant: Oracle International CorporationInventors: Raunak RUNGTA, Jonathan GILONI, Ravi Shankar THAMMAIAH, Sumanta Kumar CHATTERJEE, Juan LOAIZA
-
Publication number: 20180074885Abstract: A method for memory quarantine comprises: in response to a memory error, determining an extent associated with the memory error, wherein the extent defines an amount of memory comprising a plurality of chunks; traversing, forward from a beginning chunk of the plurality chunks, the plurality of chunks until a first chunk is determined to be corrupt; traversing, in reverse from a last chunk of the plurality of chunks, the plurality of chunks until a second chunk is determine to be corrupt; flagging a subset of the plurality of chunks as quarantined, wherein the subset begins with the first chunk and ends with the second chunk, and wherein quarantine prevents the subset from being reallocated after being released.Type: ApplicationFiled: September 9, 2016Publication date: March 15, 2018Inventors: Jonathan Giloni, William Habeck, Raunak Rungta, Ravi Thammaiah
-
Patent number: 8713186Abstract: A server side connection pool provides pooling of server connections. Thus, client side processes do not create groups of dedicated resources. Clients are provided the capability to communicate to a server side connection broker process to GET a pooled server connection comprising connection state plus a thread of execution for doing some work, whereby requesting the work can bypass the connection broker process and go directly to the assigned pooled connection. Once the client issues a RELEASE to release the pooled connection back to the pool, a completely different client process on potentially a different client middle tier machine can reuse the same pooled connection. The server-side connection pool can be logically partitioned into sub-pools that correspond to connection classes that typically correspond to respective applications. A client process can request a pooled connection having a particular state, where a stored procedure can be executed to generate such state.Type: GrantFiled: March 12, 2008Date of Patent: April 29, 2014Assignee: Oracle International CorporationInventors: Lakshminarayanan Chidambaran, Srinath Krishnaswamy, Krishna Mohan Itikarlapalli, Kevin Neel, Sreekumar K. Seshadri, Jonathan Giloni, Scot McKinley, Ravi Thammaiah
-
Patent number: 8438144Abstract: 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: GrantFiled: August 27, 2010Date of Patent: May 7, 2013Assignee: Oracle International CorporationInventors: Romain Colle, Karl Dias, Leonidas Galanis, Supiti Buranawatanachoke, Jonathan Giloni, Efstratios Papadomanolakis, Yujun Wang
-
Publication number: 20120054245Abstract: 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: ApplicationFiled: August 27, 2010Publication date: March 1, 2012Inventors: Romain COLLE, Karl Dias, Leonidas Galanis, Supiti Buranawatanachoke, Jonathan Giloni, Efstratios Papadomanolakis, Yujun Wang
-
Publication number: 20080228923Abstract: A server side connection pool provides pooling of server connections. Thus, client side processes do not create groups of dedicated resources. Clients are provided the capability to communicate to a server side connection broker process to GET a pooled server connection comprising connection state plus a thread of execution for doing some work, whereby requesting the work can bypass the connection broker process and go directly to the assigned pooled connection. Once the client issues a RELEASE to release the pooled connection back to the pool, a completely different client process on potentially a different client middle tier machine can reuse the same pooled connection. The server-side connection pool can be logically partitioned into sub-pools that correspond to connection classes that typically correspond to respective applications. A client process can request a pooled connection having a particular state, where a stored procedure can be executed to generate such state.Type: ApplicationFiled: March 12, 2008Publication date: September 18, 2008Applicant: ORACLE INTERNATIONAL CORPORATIONInventors: Lakshminarayanan Chidambaran, Srinath Krishnaswamy, Krishna Mohan Itikarlapalli, Kevin Neel, Sreekumar K. Seshadri, Jonathan Giloni, Scot McKinley, Ravi Thammaiah