Patents by Inventor Abhyudaya Agrawal
Abhyudaya Agrawal 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: 9367642Abstract: A database server determines, on an element-level of granularity, what form of VARRAY storage to map collections of elements defined by a XML schema. A collection element may be mapped to an in-line VARRAY or an out-of-line VARRAY. The determination may based on a variety of factors, including the database type mapped to the collection element, database limitations that limit the form storage for certain database types, and annotations (“mapping annotations”) embedded within that XML schema that specifying a database type for database representation of a collection element or a form of VARRAY storage.Type: GrantFiled: October 7, 2005Date of Patent: June 14, 2016Assignee: ORACLE INTERNATIONAL CORPORATIONInventors: Abhyudaya Agrawal, Sivasankaran Chandrasekar, Ravi Murthy, Nipun Agarwal, Eric Sedlar
-
Patent number: 9069878Abstract: A database server determines, on an element-level of granularity, what form of VARRAY storage to map collections of elements defined by a XML schema. A collection element may be mapped to an in-line VARRAY or an out-of-line VARRAY. The determination may based on a variety of factors, including the database type mapped to the collection element, database limitations that limit the form storage for certain database types, and annotations (“mapping annotations”) embedded within that XML schema that specifying a database type for database representation of a collection element or a form of VARRAY storage.Type: GrantFiled: October 7, 2005Date of Patent: June 30, 2015Assignee: ORACLE INTERNATIONAL CORPORATIONInventors: Abhyudaya Agrawal, Sivasankaran Chandrasekar, Ravi Murthy, Nipun Agarwal, Eric Sedlar
-
Patent number: 8554789Abstract: A database system automatically detects a cyclic construct in a XML schema, determines a database representation for the cyclic construct, and maps the XML schema and elements involved in the cyclic construct to the database representation.Type: GrantFiled: October 7, 2005Date of Patent: October 8, 2013Assignee: Oracle International CorporationInventors: Abhyudaya Agrawal, Ravi Murthy, Nipun Agarwal, Sivasankaran Chandrasekar, Eric Sedlar
-
Patent number: 8346725Abstract: XML schema evolutions can be performed on an XML-type database using partial data copy techniques. The partial data copy techniques provide mechanisms to identify a minimal set of data in the database that needs be copied out in order for schema evolution operations to occur. Identifying the minimal set of data involves comparing an existing XML schema to a new XML schema and determining the differences between the two schemas. Based on those differences, a minimal set of data can be determined. That data can then be copied to a temporary storage location, while the XML schema and its associated database structure are updated to conform to the new XML schema. Then, the minimal set of data is copied back into the modified database structure.Type: GrantFiled: September 15, 2006Date of Patent: January 1, 2013Assignee: Oracle International CorporationInventors: Thomas Baby, Abhyudaya Agrawal, Sam Idicula, Nipun Agarwal
-
Patent number: 7870163Abstract: In-place XML schema evolution occurs by evaluating an existing XML schema in a database system to see if it is compatible with a new XML schema. To determine if the old schema is compatible with the new schema, a lock-step traversal is performed on the two schemas. Each instruction in the old schema is compared to instructions in the new schema. Detected differences between the two schemas are evaluated to determine if existing XML documents are still compatible with the new schema. If they are, then an in-place schema evolution operation can take place. The in-place schema operation basically, involves appending the updated object information to the underlying object type and preserving the order of elements in a document by storing element mapping information on disk.Type: GrantFiled: September 28, 2006Date of Patent: January 11, 2011Assignee: Oracle International CorporationInventors: Abhyudaya Agrawal, Thomas Baby, Nipun Agarwal, Sam Idicula, Ravi Murthy, Eric Sedlar
-
Patent number: 7849106Abstract: A method and apparatus for facilitating the management of metadata is disclosed, specifically by associating metadata with an XML schema. The database system provides a method that allows end users to maintain additional information describing resources. User-defined metadata attributes are associated as an XML schema which in turn is mapped to a table, referred to as the user metadata table. The XML schema contains user-defined information specifying the metadata that the end-user wants the system to store and maintain. Additionally, a reference is created between an entry in the user metadata table and its corresponding resource entry in the resource table. The resources are accessed directly or by issuing queries against the user metadata table. The querying of the user metadata table gains the benefit of fast and efficient query results and access time.Type: GrantFiled: December 3, 2004Date of Patent: December 7, 2010Assignee: Oracle International CorporationInventors: Abhyudaya Agrawal, Ravi Murthy, Nipun Agarwal, Eric Sedlar
-
Patent number: 7761479Abstract: Techniques manage the presence of repeated constructs within a complex type at the time of schema registration. At registration, techniques detect repeated elements in the XML schema and analyze whether the repeated elements are from the same complex type. If so, techniques perform additional analysis to determine a minimal common ancestor. Within the context of a minimal common ancestor, techniques determine the maximum number of times an element may occur in the schema. In a choice content model, the largest maximum occurrence value is selected. In other content models, the maximum occurrence value is determined by adding together the occurrence values for the repeated elements. Then, when an object relational table is generated for the XML schema, the maximum number of times that an element appears in the schema is this value. Techniques retain the advantages of object relational storage, even after a schema evolution.Type: GrantFiled: September 11, 2006Date of Patent: July 20, 2010Assignee: Oracle International CorporationInventors: Abhyudaya Agrawal, Thomas Baby, Ravi Murthy, Nipun Agarwal
-
Patent number: 7523131Abstract: To associate XML data objects (“child objects”), stored in rows of relational or object-relational tables, with the appropriate XML data objects (“parent objects”) from which the child objects descend, tables that contain child objects (“out-of-line” tables) are constructed with an additional column. In one embodiment, this column stores values that identify the root objects, in the appropriate table, from which the respective child objects descend. Hence, the root object from which any given object descends is traceable by following the respective value back to the corresponding root object. In one embodiment, this column stores values that identify the complete XML hierarchical path, through multiple tables, back to the root object from which the respective child objects descend. Consequently, XML query language queries against XML documents stored in such tables can be rewritten as SQL queries against the data in the tables, even in the presence of cyclic constructs.Type: GrantFiled: February 10, 2005Date of Patent: April 21, 2009Assignee: Oracle International CorporationInventors: James W. Warner, Abhyudaya Agrawal, Hui Zhang, Muralidhar Krishnaprasad, Ravi Murthy, Zhen Hua Liu, Nipun Agarwal, Vikas Arora, Susan M. Kotsovolos, Anand Manikutty, Rohan Angrish
-
Patent number: 7406478Abstract: A database server registers an XML schema and determines a database representation for the XML schema and mapping information, determining what database types should be used to represent an XML schema and/or how instances of the XML schema are stored by a database system. The mapping information indicates the mapping between the constructs declared in the XML schema and the constructs included in the appropriate database representation. The XML schema may contain annotations that describe one or more properties of a database representation of an XML date-time type. Based on the annotations, the database determines an appropriate database representation and generates mapping information mapping the declaration of the XML date-time type of the XML schema to the constructs of the database representation.Type: GrantFiled: August 11, 2005Date of Patent: July 29, 2008Assignee: Oracle International CorporationInventors: Abhyudaya Agrawal, Ravi Murthy, Sivasankaran Chandrasekar, Nipun Agarwal, Eric Sedlar
-
Publication number: 20080082560Abstract: In-place XML schema evolution occurs by evaluating an existing XML schema in a database system to see if it is compatible with a new XML schema. To determine if the old schema is compatible with the new schema, a lock-step traversal is performed on the two schemas. Each instruction in the old schema is compared to instructions in the new schema. Detected differences between the two schemas are evaluated to determine if existing XML documents are still compatible with the new schema. If they are, then an in-place schema evolution operation can take place. The in-place schema operation basically, involves appending the updated object information to the underlying object type and preserving the order of elements in a document by storing element mapping information on disk.Type: ApplicationFiled: September 28, 2006Publication date: April 3, 2008Applicant: Oracle International CorporationInventors: Abhyudaya Agrawal, Thomas Baby, Nipun Agarwal, Sam Idicula, Ravi Murthy, Eric Sedlar
-
Publication number: 20080071812Abstract: XML schema evolutions can be performed on an XML-type database using partial data copy techniques. The partial data copy techniques provide mechanisms to identify a minimal set of data in the database that needs be copied out in order for schema evolution operations to occur. Identifying the minimal set of data involves comparing an existing XML schema to a new XML schema and determining the differences between the two schemas. Based on those differences, a minimal set of data can be determined. That data can then be copied to a temporary storage location, while the XML schema and its associated database structure are updated to conform to the new XML schema. Then, the minimal set of data is copied back into the modified database structure.Type: ApplicationFiled: September 15, 2006Publication date: March 20, 2008Applicant: Oracle International CorporationInventors: Thomas Baby, Abhyudaya Agrawal, Sam Idicula, Nipun Agarwal
-
Publication number: 20080065654Abstract: Techniques manage the presence of repeated constructs within a complex type at the time of schema registration. At registration, techniques detect repeated elements in the XML schema and analyze whether the repeated elements are from the same complex type. If so, techniques perform additional analysis to determine a minimal common ancestor. Within the context of a minimal common ancestor, techniques determine the maximum number of times an element may occur in the schema. In a choice content model, the largest maximum occurrence value is selected. In other content models, the maximum occurrence value is determined by adding together the occurrence values for the repeated elements. Then, when an object relational table is generated for the XML schema, the maximum number of times that an element appears in the schema is this value. Techniques retain the advantages of object relational storage, even after a schema evolution.Type: ApplicationFiled: September 11, 2006Publication date: March 13, 2008Applicant: Oracle International CorporationInventors: Abhyudaya Agrawal, Thomas Baby, Ravi Murthy, Nipun Agarwal
-
Publication number: 20070083529Abstract: A database system automatically detects a cyclic construct in a XML schema, determines a database representation for the cyclic construct, and maps the XML schema and elements involved in the cyclic construct to the database representation.Type: ApplicationFiled: October 7, 2005Publication date: April 12, 2007Applicant: ORACLE INTERNATIONAL CORPORATIONInventors: Abhyudaya Agrawal, Ravi Murthy, Nipun Agarwal, Sivasankaran Chandrasekar, Eric Sedlar
-
Publication number: 20070083542Abstract: A database server determines, on an element-level of granularity, what form of VARRAY storage to map collections of elements defined by a XML schema. A collection element may be mapped to an in-line VARRAY or an out-of-line VARRAY. The determination may based on a variety of factors, including the database type mapped to the collection element, database limitations that limit the form storage for certain database types, and annotations (“mapping annotations”) embedded within that XML schema that specifying a database type for database representation of a collection element or a form of VARRAY storage.Type: ApplicationFiled: October 7, 2005Publication date: April 12, 2007Inventors: Abhyudaya Agrawal, Sivasankaran Chandrasekar, Ravi Murthy, Nipun Agarwal, Eric Sedlar
-
Publication number: 20070038649Abstract: A database server registers an XML schema and determines a database representation for the XML schema and mapping information, determining what database types should be used to represent an XML schema and/or how instances of the XML schema are stored by a database system. The mapping information indicates the mapping between the constructs declared in the XML schema and the constructs included in the appropriate database representation. The XML schema may contain annotations that describe one or more properties of a database representation of an XML date-time type. Based on the annotations, the database determines an appropriate database representation and generates mapping information mapping the declaration of the XML date-time type of the XML schema to the constructs of the database representation.Type: ApplicationFiled: August 11, 2005Publication date: February 15, 2007Inventors: Abhyudaya Agrawal, Ravi Murthy, Sivasankaran Chandrasekar, Nipun Agarwal, Eric Sedlar
-
Publication number: 20060179068Abstract: To associate XML data objects (“child objects”), stored in rows of relational or object-relational tables, with the appropriate XML data objects (“parent objects”) from which the child objects descend, tables that contain child objects (“out-of-line” tables) are constructed with an additional column. In one embodiment, this column stores values that identify the root objects, in the appropriate table, from which the respective child objects descend. Hence, the root object from which any given object descends is traceable by following the respective value back to the corresponding root object. In one embodiment, this column stores values that identify the complete XML hierarchical path, through multiple tables, back to the root object from which the respective child objects descend. Consequently, XML query language queries against XML documents stored in such tables can be rewritten as SQL queries against the data in the tables, even in the presence of cyclic constructs.Type: ApplicationFiled: February 10, 2005Publication date: August 10, 2006Inventors: James Warner, Abhyudaya Agrawal, Hui Zhang, Muralidhar Krishnaprasad, Ravi Murthy, Zhen Liu, Nipun Agarwal, Vikas Arora, Susan Kotsovolos, Anand Manikutty, Rohan Angrish