Method for defining a metadata schema to facilitate passing data between an extensible markup language document and a hierarchical database

• US 7,418,456 B2
• Filed: 01/16/2004
• Issued: 08/26/2008
• Est. Priority Date: 01/16/2004
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Wiedenmann, Carol M., Holtz, Christopher M., Charlet, Kyle Jeffrey, Hembry, Douglas Michael Frederick
• Primary Examiner(s): ALAM, SHAHID AL
• Application Number:
  US10/758,890
• Publication Number:
  US 20050160110A1
• Time in Patent Office: 1,684 Days
• Field of Search: 707/102, 707/103.R, 707/104.1, 715/502, 715/513, 715/211, 715/234
• US Class Current: 1/1
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

A method is provided for defining a metadata schema to facilitate passing data between an XML document and a hierarchical database. The invention includes a database accessor, a document accessor, and an association module. The database accessor accesses a database schema indicative of database field names and a hierarchical structure for a hierarchical database. The document accessor accesses a document schema that defines the hierarchical structure, content data syntax, and semantics of valid, well-formed, XML documents that can be passed into and out of the hierarchical database. The document schema also includes at least one XML element name that maps to a corresponding database field name in the database schema. The association module associates the database schema and the document schema to provide a metadata schema that enables data to be passed between an XML document and the hierarchical database.

Claims

1. A method for defining a metadata schema to facilitate passing data between an extensible Markup Language (XML) document and a hierarchical database, the method comprising:

accessing a database schema indicative of database field names and a hierarchical structure for a hierarchical database;

accessing a document schema that defines the hierarchical structure, content data syntax, and semantics of valid, well-formed, XML documents that can be passed into and out of the hierarchical database,

the document schema including an XML element name that maps to a database field name in the database schema; and

relating the database schema and the document schema to provide a metadata schema that enables data to be passed between an XML document and the hierarchical database,

the database schema comprising a database field type identifier and the document schema comprising an XML element data type identifier that maps to the database field type identifier to facilitate converting content data between the XML element data type and the database field type based on the database field type identifier and the XML element data type identifier.

2. The method of claim 1, wherein the document schema comprises an XML schema that complies with an industry standard for XML schemas.

3. The method of claim 2, wherein the industry standard for XML schemas comprises version 1.0 as set forth by the World Wide Web Consortium.

4. The method of claim 1, wherein the database schema comprises a predefined database schema comprising a set of java classes representative of one or more nodes and one or more fields of the hierarchical database.

5. The method of claim 1, wherein the document schema comprises at least one directive metadata element configured to not interfere with third-party applications using the document schema and to facilitate passing data between the XML document and the hierarchical database.

6. The method of claim 1, wherein the at least one directive metadata element is selected from the group of directives consisting of a storage and retrieval directive, an index directive, and a hierarchical database indicator directive.

7. The method of claim 1, wherein the hierarchical database comprises an Information Management System (IMS) database.