Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2006-07-04
2006-07-04
Corrielus, Jean M. (Department: 2162)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000
Reexamination Certificate
active
07072896
ABSTRACT:
A system and a method are provided for generating (28) a schema (22) for a relational database corresponding to a document having a document-type definition (18) and data complying with the document-type definition (18). The document-type definition (19) has content particles representative of the structure of the document data including one or more of the following content particles: elements, attributes of elements, nesting relationships between elements, grouping relationships between elements, schema (22) ordering indicators, existence indicators, occurrence indicators and element ID referencing indicators. The system and method described herein also contemplates loading the data into the relational database in a manner consistent with the relational schema (22). Metadata is extracted from the document-type definition (18) representative of the document-type definition (18). The schema (22) for the relational database is generated from the metadata, wherein at least one table is thereby defined in the relational database corresponding to at least one content particle of the document-type definition (18) via the metadata (34). The data is then loaded into the at least one table of the relational dataset according to the relational schema (22) in a manner driven by the metadata (34).
REFERENCES:
patent: 5499371 (1996-03-01), Henninger et al.
patent: 5548749 (1996-08-01), Kroenke et al.
patent: 5764978 (1998-06-01), Masumoto
patent: 5915259 (1999-06-01), Murata
patent: 5995969 (1999-11-01), Lee et al.
patent: 6163776 (2000-12-01), Periwal
patent: 6209124 (2001-03-01), Vermeire et al.
patent: 6311194 (2001-10-01), Sheth et al.
patent: 6339841 (2002-01-01), Merrick et al.
patent: 6366934 (2002-04-01), Cheng et al.
patent: 6381743 (2002-04-01), Mutschler, III
patent: 6418448 (2002-07-01), Sarkar
patent: 6421656 (2002-07-01), Cheng et al.
patent: 6424979 (2002-07-01), Livingston et al.
patent: 6480860 (2002-11-01), Monday
patent: 6480865 (2002-11-01), Lee et al.
patent: 6519597 (2003-02-01), Cheng et al.
patent: 6523036 (2003-02-01), Hickman et al.
patent: 6549922 (2003-04-01), Srivastava et al.
patent: 6560633 (2003-05-01), Roberts et al.
patent: 6563518 (2003-05-01), Gipalo
patent: 6584459 (2003-06-01), Chang et al.
patent: 6587124 (2003-07-01), Slaby
patent: 6601071 (2003-07-01), Bowker et al.
patent: 6604100 (2003-08-01), Fernandez et al.
patent: 6615204 (2003-09-01), Menon
patent: 6631519 (2003-10-01), Nicholson et al.
patent: 6643633 (2003-11-01), Chau et al.
patent: 6701321 (2004-03-01), Tsai
patent: 6785673 (2004-08-01), Fernandez et al.
patent: 2002/0133484 (2002-09-01), Chau et al.
patent: 1 225 516 (2001-01-01), None
Dongwon Lee, Wesley W. Chu, Constraints-Preserving Transformation from XML Document Type Definition to Relational Schema, Proc. Of ER2000, Salt Lake City, UT, 10/9-12,00, pp. 323-338, (1-22), http://dblp.uni-trier.de/db/conf/er/er2000.html.
Gerti Kappel, Elisabeth Kapsammer, S. Rausch-Schott, Werner Retschitzegger: X-Ray—Towards Integrating XML and Relational Database Systems, Proc. Of ER2000, Salt Lake City, UT, 10/9-12,00, pp. 339-353, http://dblp.uni-trier.de/db/conf/er/er2000.html (15 pages).
Tim Bray, Jean Paoli, C.M. Sperberg-McQueen, and Eve Maler, Extensible Markup Language (XML) 1.0 (Second Edition) W3C Recommendation Oct. 6, 2000, http://www.w3.org/TR/2000/REC-xml-20001006, (41 pages).
Alin Deutsch, Mary F. Fernandez, and Dan Suciu, Storing Semistructured Data with Stored, Sigmod 1999, Proc. ACM Sigmod Intl. Conf. On Management of Data, Jun. 1-3, 1999, pp. 431-442 (12 pages).
G.E. Blake, M.P. Consens, P. Kilpelinen, P.-A. Larson, T. Snider, and F.W. Tompa, Text/Relational Database Management Systems: Harmonizing sql and sgml., Proc. Applications of Databases (ADB-94), Jun. 21-23, 1994, pp. 267-280 (14 pages).
J. Shanmugasundaram, G. He, K. Tufte, C. Zhang, D. DeWitt, and J. Naughton, Relational Databases for Querying XML Documents: Limitations and Opportunities, Proc. Of 25thIntl. Conf. On Very Large Data Bases (VLDB′ 99), Sep. 1999, pp. 302-314 (13 Pages).
J. Widom, Data Management for XML—Research Directions, IEEE Data Engineering Bulletin, Special Issue on XML, 22(3), 1999, pp. 1-10.
Alin Deutsch, Mary Fernandez, Daniela Florescu, Alon Levy, and Dan Suciu, A Query Language for XML, Proc. Of the Eighth Intl. World Wide Web Conf. (WWW-8), 1999.
Richard Hackathorn, WebFarming Newsletter—Aug. 1999, http://webfarming.com
ew/NL199908a.html (2 pages).
Daniela Florescu and Donald Kossmann, Storing and Querying XML Data Using an rdbms, Bulletin of the Technical Committee on Data Engineering, Sep. 1999, pp. 27-34, (1-8).
Giansalvatore Mecca, Paolo Merialdo, and Paolo Atzeni, Araneus in the Era of XML, Bulletin of the Technical Committee on Data Engineering, Sep. 1999, pp. 19-26 (1-8).
Oracle Technologies Network, Using XML in Oracle Database Applications, http://technet.oracle.com/tech/xml/info/htdocs/otnwp/about—oracle—xml—products.htm, Nov. 1999, (25 pages).
Oracle, Oracle XML sql utility for java, http://technet.oracle.com/tech/xml/oracle—xsu/, 1999 (58 pages) .
J. McHugh, S. Abiteboul, R. Goldman, D. Quass, and J. Widom, Lore: A Database Management System for Semistructured Data, SIGMOD Record, 26(3), Sep. 1997, pp. 54-66 (13 pages).
Ronald Bourret, XML and Databases, http://www.informatik.ty-darmstadt.de/DVS1/staff/bourret/xml/XMLAndDatabases.htm, Sep. 1999 (15 pages) .
Lee Wang-Chien
Mitchell Gail Anne
Zhang Xin
Corrielus Jean M.
Ly Anh
Palmieri, Esq. Joseph R
Rader & Fishman & Grauer, PLLC
Suchyta, Esq. Leonard C.
LandOfFree
System and method for automatic loading of an XML document... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with System and method for automatic loading of an XML document..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for automatic loading of an XML document... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3552975