Apparatus, system, and method for defining a metadata schema to facilitate passing data between an extensible markup language document and a hierarchical database

• US 7,822,786 B2
• Filed: 11/30/2007
• Issued: 10/26/2010
• Est. Priority Date: 01/16/2004
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Hembry, Douglas M. F., Wiedenmann, Carol M., Charlet, Kyle J., Holtz, Christopher M.
• Primary Examiner(s): ALAM, SHAHID AL
• Application Number:
  US11/948,839
• Publication Number:
  US 20080091710A1
• Time in Patent Office: 1,061 Days
• Field of Search: 707/10, 707/102, 707/803, 707/809, 715/210, 709/247
• US Class Current: 707/809
• 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

An apparatus, system, and method are 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. An apparatus for defining a metadata schema to facilitate passing data between an eXtensible Markup Language (XML) document and a hierarchical database, the apparatus comprising:

a database accessor configured to access a database schema indicative of database field names and a hierarchical structure for a hierarchical database;

a document accessor configured to access 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

an association module configured to relate 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 apparatus of claim 1, wherein the document schema comprises an XML schema that complies with an industry standard for XML schemas.

3. The apparatus 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 apparatus 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 apparatus 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 apparatus of claim 5, 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 apparatus of claim 1, wherein the hierarchical database comprises an Information Management System (IMS) database.

8. 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;

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; and

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.

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

10. The article of manufacture of claim 9, wherein the industry standard for XML schemas comprises version 1.0 as set forth by the World Wide Web Consortium.

11. The method of claim 8, 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.

12. The method of claim 8, wherein the database schema comprises a database field type identifier and the document schema comprises 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.

13. The method of claim 8, 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.

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

15. An article of manufacture comprising a program storage medium readable by a processor and embodying one or more instructions executable by a processor to perform 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;

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; and

wherein the database schema comprises a database field type identifier and the document schema comprises 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.

16. The article of manufacture of claim 15, wherein the document schema comprises an XML schema that complies with an industry standard for XML schemas.

17. The article of manufacture of claim 16, wherein the industry standard for XML schemas comprises version 1.0 as set forth by the World Wide Web Consortium.

18. The article of manufacture of claim 15, 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.