The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Aug. 23, 2016
Filed:
Oct. 30, 2009
Xpath-based creation of relational indexes and constraints over xml data stored in relational tables
Beda Christoph Hammerschmidt, San Carlos, CA (US);
Zhen Hua Liu, San Mateo, CA (US);
Thomas Baby, Maple Valley, WA (US);
Beda Christoph Hammerschmidt, San Carlos, CA (US);
Zhen Hua Liu, San Mateo, CA (US);
Thomas Baby, Maple Valley, WA (US);
Oracle International Corporation, Redwood Shores, CA (US);
Abstract
Techniques and approaches are provided for creating indexes and column constraints on structured XML data that is stored in a relational database. Data Definition Language (DDL) Create Index and Create Constraint commands have extended syntax that allows the specification of a path-based expression instead of requiring a column and table name. A mapping created by the system when an XML Schema is registered stores the correspondence of XML data elements to automatically-created database tables and columns that are given names only useful for the internal system. When a user provides a path-based expression in a DDL when creating an index or constraint, the path-based expression is translated to the underlying database constructs using the mapping. Issues are addressed for handling path-based expressions that evaluate to more than one element. Additional index optimization is described using data type information available in the XML schema to select the optimal index type.