Ali Maleki Tabar

US Patent:

8209361, Jun 26, 2012

Filed:

Jan 19, 2010

Appl. No.:

12/689729

Inventors:

Sam Idicula - Santa Clara CA, US
Asha Tarachandani - Newark CA, US
Sivasankaran Chandrasekar - Menlo Park CA, US
Vijay Medi - Sunnyvale CA, US
Ali Tabar - Stanford CA, US
Nipun Agarwal - Santa Clara CA, US

Assignee:

Oracle International Corporation - Redwood Shores CA

International Classification:

G06F 17/30

US Classification:

707803, 707796, 707801

Abstract:

Techniques are described herein for efficient and scalable processing of complex sets of XML schemas. The techniques described herein provide for reducing duplication of schema elements in volatile memory by building an XML schema in-memory model that stores repeating schema elements in in-memory data structures that are separate from in-memory data structures that store the parent schema elements which logically include or otherwise refer to the repeating schema elements. The techniques described herein also provide for faster generation of an in-memory model of an XML schema by pre-loading, in data structures on persistent storage, of schema elements from dependent XML schemas that are referenced and/or incorporated by the XML schema. The techniques described herein also provide for efficient processing of inter-dependent XML schemas by tracking all unresolved schema elements from dependent XML schemas and freeing the portions of volatile memory, which are used to process schema elements from the dependent XML schemas, as soon as the dependent schema elements being processed are stored in data structures on persistent storage.

US Patent:

20100235348, Sep 16, 2010

Filed:

Mar 10, 2009

Appl. No.:

12/401397

Inventors:

Thomas Baby - Maple Valley WA, US
Ali Maleki Tabar - Stanford CA, US
Sivasankaran Chandrasekar - Menlo Park CA, US

Assignee:

ORACLE INTERNATIONAL CORPORATION - Redwood Shores CA

International Classification:

G06F 17/30

US Classification:

707715, 707E17014, 707E17053

Abstract:

A database server provides a partitioned table with a corresponding locally partitioned index. When a request is made to load data into the table by an application, a table partition, along with a corresponding index partition, is created for the application. The corresponding index partition in marked as asynchronously maintained, allowing other index partitions to be used by the query optimizer in formulating query plans for other table partitions. Once the loading of data is complete, a synchronization operation is called with the result of conforming the data in the asynchronously maintained index partition with its corresponding table in which the data was loaded. Once the data in the corresponding table partition and the data in the asynchronously maintained index partition are synchronized, the asynchronously maintained index partition is marked as synchronously maintained.