Patents by Inventor Adiel Yoaz
Adiel Yoaz 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: 9146961Abstract: Techniques are provided to achieve performance improvements for path-based access to hierarchical data and for utilizing an extensible indexing framework. Extensible operators may be optimized by evaluating the operators using functions native to the database system instead of using functions defined through an extensible indexing mechanism. Furthermore, the database system may resolve a resource path of a query when the query is compiled, and may store the mapping of the resource path to one or more resources in a cursor for the query execution plan to avoid resolving the resource path each time the cursor is used to run the query. The cursor may be made dependent on the one or more resources to which the resource path refers at compile time. This takes advantage of the observation that the mapping of the resource path to particular resources rarely changes between evaluations of a particular query.Type: GrantFiled: November 13, 2009Date of Patent: September 29, 2015Assignee: ORACLE INTERNATIONAL CORPORATIONInventors: Asha Tarachandani, Bhushan Khaladkar, Sam Idicula, Adiel Yoaz, Nipun Agarwal
-
Patent number: 9043308Abstract: Techniques are provided to achieve performance improvements for path-based access to hierarchical data and for utilizing an extensible indexing framework. Extensible operators may be optimized by evaluating the operators using functions native to the database system instead of using functions defined through an extensible indexing mechanism. Furthermore, the database system may resolve a resource path of a query when the query is compiled, and may store the mapping of the resource path to one or more resources in a cursor for the query execution plan to avoid resolving the resource path each time the cursor is used to run the query. The cursor may be made dependent on the one or more resources to which the resource path refers at compile time. This takes advantage of the observation that the mapping of the resource path to particular resources rarely changes between evaluations of a particular query.Type: GrantFiled: January 17, 2012Date of Patent: May 26, 2015Assignee: Oracle International CorporationInventors: Asha Tarachandani, Bhushan Khaladkar, Sam Idicula, Adiel Yoaz, Nipun Agarwal
-
Publication number: 20120150865Abstract: Techniques are provided to achieve performance improvements for path-based access to hierarchical data and for utilizing an extensible indexing framework. Extensible operators may be optimized by evaluating the operators using functions native to the database system instead of using functions defined through an extensible indexing mechanism. Furthermore, the database system may resolve a resource path of a query when the query is compiled, and may store the mapping of the resource path to one or more resources in a cursor for the query execution plan to avoid resolving the resource path each time the cursor is used to run the query. The cursor may be made dependent on the one or more resources to which the resource path refers at compile time. This takes advantage of the observation that the mapping of the resource path to particular resources rarely changes between evaluations of a particular query.Type: ApplicationFiled: January 17, 2012Publication date: June 14, 2012Applicant: ORACLE INTERNATIONAL CORPORATIONInventors: Asha Tarachandani, Bhushan Khaladkar, Sam Idicula, Adiel Yoaz, Nipun Agarwal
-
Publication number: 20110119283Abstract: Techniques are provided to achieve performance improvements for path-based access to hierarchical data and for utilizing an extensible indexing framework. Extensible operators may be optimized by evaluating the operators using functions native to the database system instead of using functions defined through an extensible indexing mechanism. Furthermore, the database system may resolve a resource path of a query when the query is compiled, and may store the mapping of the resource path to one or more resources in a cursor for the query execution plan to avoid resolving the resource path each time the cursor is used to run the query. The cursor may be made dependent on the one or more resources to which the resource path refers at compile time. This takes advantage of the observation that the mapping of the resource path to particular resources rarely changes between evaluations of a particular query.Type: ApplicationFiled: November 13, 2009Publication date: May 19, 2011Applicant: ORACLE INTERNATIONAL XORPORATIONInventors: Asha Tarachandani, Bhushan Khaladkar, Sam Idicula, Adiel Yoaz, Nipun Agarwal
-
Patent number: 7908267Abstract: An approach for using functional indexes as a primary filter is provided. A database query that contains a reference to a column of a table, but does not contain any reference to a functional index based on that column, is received by a database server. The database server adds to the database query a reference to the functional index on the column. The database server determines if the database query should be executed using the functional index. If the database server determines that the database query should be executed using the functional index, then the database query is executed with the functional index. If the database server determines that the database query should not be executed using the functional index, then data that indicates that the functional index is not to be evaluated when the database query is executed is stored.Type: GrantFiled: August 26, 2004Date of Patent: March 15, 2011Assignee: Oracle International CorporationInventors: Robert J. Jenkins, Jr., Adiel Yoaz
-
Patent number: 7756889Abstract: Techniques for partitioning nested tables are provided. A parent table includes a column for collection items. A nested table is created for storing items that belong to the collection items. The nested table is partitioned to create a plurality of nested table partitions. Each nested table partition is a distinct, separately stored structure within a database. How the nested table is partitioned may, or may not, be based on how the parent table is partitioned. For example, a nested table may be partitioned based on the same criteria in which the parent table is partitioned. As another example, a nested table may be partitioned, whereas the parent table is not partitioned.Type: GrantFiled: February 16, 2007Date of Patent: July 13, 2010Assignee: Oracle International CorporationInventors: Qin Yu, Geeta Arora, Sriram Krishnamurthy, Adiel Yoaz
-
Patent number: 7689549Abstract: Techniques for executing flashback queries using domain indexes in a database system are provided. In one technique, a flashback parameter of the flashback query is not included in a call-out invocation of domain index routines that implement a domain index. A call-back query execution unit nonetheless retrieves, for call-back queries issued by the domain index routines, call-back query results that reflect the state of a database in the database system as of the time specified in the flashback parameter. In another technique, a call-out invocation of domain index routines includes the flashback parameter of a flashback query. The domain index routines issue call-back queries that require the retrieval of data which reflects the state of a database as of the time specified in the flashback parameter, which are executed by the call-back query execution unit.Type: GrantFiled: October 5, 2006Date of Patent: March 30, 2010Assignee: Oracle International CorporationInventors: Sriram Krishnamurthy, Adiel Yoaz
-
Publication number: 20090024570Abstract: A database statement contains a table function. The database statement is compiled by a database statement compiler. The database statement is rewritten by replacing the table function with a replacement database statement.Type: ApplicationFiled: July 20, 2007Publication date: January 22, 2009Applicant: ORACLE INTERNATONAL CORPORATIONInventors: Adiel Yoaz, Sriram Krishnamurthy, Qin Yu
-
Patent number: 7451133Abstract: Techniques are provided for processing a database statement that includes a table function capable of parallel execution, where the input of the table function is specified in a subquery. During compilation of the database statement, a global cursor is generated for the database statement. The global cursor includes a first plan component for executing the table function and a second plan component for generating input for the table function. A “dummy” cursor is then generated. When slaves execute the table function, they call the dummy cursor for input. When a slave calls the dummy cursor for input, the dummy cursor causes a context switch back to the global cursor, so that the second plan component within the first cursor generates the input for the slave.Type: GrantFiled: August 30, 2004Date of Patent: November 11, 2008Assignee: Oracle International CorporationInventors: Adiel Yoaz, Thierry Cruanes, Bhaskar Ghosh, Subramanian Muralidhar
-
Publication number: 20080201296Abstract: Techniques for partitioning nested tables are provided. A parent table includes a column for collection items. A nested table is created for storing items that belong to the collection items. The nested table is partitioned to create a plurality of nested table partitions. Each nested table partition is a distinct, separately stored structure within a database. How the nested table is partitioned may, or may not, be based on how the parent table is partitioned. For example, a nested table may be partitioned based on the same criteria in which the parent table is partitioned. As another example, a nested table may be partitioned, whereas the parent table is not partitioned.Type: ApplicationFiled: February 16, 2007Publication date: August 21, 2008Applicant: ORACLE INTERNATIONAL CORPORATIONInventors: Qin Yu, Geeta Arora, Sriram Krishnamurthy, Adiel Yoaz
-
Publication number: 20070198615Abstract: Techniques for executing flashback queries using domain indexes in a database system are provided. In one technique, a flashback parameter of the flashback query is not included in a call-out invocation of domain index routines that implement a domain index. A call-back query execution unit nonetheless retrieves, for call-back queries issued by the domain index routines, call-back query results that reflect the state of a database in the database system as of the time specified in the flashback parameter. In another technique, a call-out invocation of domain index routines includes the flashback parameter of a flashback query. The domain index routines issue call-back queries that require the retrieval of data which reflects the state of a database as of the time specified in the flashback parameter, which are executed by the call-back query execution unit.Type: ApplicationFiled: October 5, 2006Publication date: August 23, 2007Inventors: Sriram Krishnamurthy, Adiel Yoaz
-
Publication number: 20050256835Abstract: An approach for using functional indexes as a primary filter is provided. A database query that contains a reference to a column of a table, but does not contain any reference to a functional index based on that column, is received by a database server. The database server adds to the database query a reference to the functional index on the column. The database server determines if the database query should be executed using the functional index. If the database server determines that the database query should be executed using the functional index, then the database query is executed with the functional index. If the database server determines that the database query should not be executed using the functional index, then data that indicates that the functional index is not to be evaluated when the database query is executed is stored.Type: ApplicationFiled: August 26, 2004Publication date: November 17, 2005Inventors: Robert Jenkins, Adiel Yoaz
-
Publication number: 20050154714Abstract: A request to execute a query is received in a database system. In response, the database system determines that a collection of data elements to be returned by the query corresponds to a first data structure not defined within a type dictionary of the database system. The database system obtains attribute values that describe respective data fields within the first data structure, and records, within the type dictionary, a first data type definition that specifies the data fields described by the attribute values.Type: ApplicationFiled: January 29, 2004Publication date: July 14, 2005Applicant: Oracle International CorporationInventors: Qin Yu, Adiel Yoaz, Subramanian Muralidhar, Visar Nimani, Susan Kotsovolos
-
Publication number: 20050154715Abstract: Dynamic return type generation in a database system. A request is received to execute a first function. A second function is executed if the first function is defined to return data in a first type of data structure. When executed, the second function returns formatting information that indicates an arrangement of fields of data within the first type of data structure. The first function is executed to obtain a collection of data formatted according to the first type of data structure, and the collection of data is organized according to the formatting information returned by the second function.Type: ApplicationFiled: January 29, 2004Publication date: July 14, 2005Applicant: Oracle International CorporationInventors: Adiel Yoaz, Qin Yu, Ravi Murthy, Susan Kotsovolos
-
Publication number: 20050131880Abstract: Techniques are provided for processing a database statement that includes a table function capable of parallel execution, where the input of the table function is specified in a subquery. During compilation of the database statement, a global cursor is generated for the database statement. The global cursor includes a first plan component for executing the table function and a second plan component for generating input for the table function. A “dummy” cursor is then generated. When slaves execute the table function, they call the dummy cursor for input. When a slave calls the dummy cursor for input, the dummy cursor causes a context switch back to the global cursor, so that the second plan component within the first cursor generates the input for the slave.Type: ApplicationFiled: August 30, 2004Publication date: June 16, 2005Applicant: ORACLE INTERNATIONAL CORPORATIONInventors: Adiel Yoaz, Thierry Cruanes, Bhaskar Ghosh, Subramanian Muralidhar