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

• US 7,912,874 B2
• Filed: 05/06/2008
• Issued: 03/22/2011
• Est. Priority Date: 01/16/2004
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Hembrey, Douglas M. F., Wiedenmann, Carol M., Charlet, Kyle J., Holtz, Christopher M.
• Primary Examiner(s): ALAM, SHAHID AL
• Application Number:
  US12/116,028
• Publication Number:
  US 20080215527A1
• Time in Patent Office: 1,050 Days
• Field of Search: 707/601, 707/760, 707/803, 707/804, 707/809
• US Class Current: 707/804
• 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

The apparatus and system 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 storage device storing executable code;

a processor executing the executable code, the executable code comprising;

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

a document accessor 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 comprising an XML element name that maps to a database field name in the database schema, the document schema comprising at least one directive metadata element not interfering with third-party applications using the document schema and facilitating passing data between the XML document and the hierarchical database; and

an association module 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.

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

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. An article of manufacture comprising a storage device storing executable code, the executable code executed 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 comprising an XML element name that maps to a database field name in the database schema, the document schema comprising at least one directive metadata element not interfering with third-party applications using the document schema and facilitating passing data between the XML document and the hierarchical database; 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.

9. The article of manufacture 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 article of manufacture 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 article of manufacture 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. A method for defining a metadata schema, the method comprising:

accessing, by use of a processor, 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, eXtensible Markup Language (XML) documents that can be passed into and out of the hierarchical database, the document schema comprising an XML element name that maps to a database field name in the database schema, the document schema comprising at least one directive metadata element not interfering with third-party applications using the document schema and facilitating passing data between the XML document and the hierarchical database; 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.

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

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

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

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