Tagged markup language interface with document type definition to access data in object oriented database

• US 6,480,860 B1
• Filed: 02/11/1999
• Issued: 11/12/2002
• Est. Priority Date: 02/11/1999
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Monday, Paul Brian
• Primary Examiner(s): CHANNAVAJJALA, SRIRAMA T
• Application Number:
  US09/249,783
• Time in Patent Office: 1,370 Days
• Field of Search: 707/1-6, 707/100-104, 707/500.1, 707/501.1, 707/513, 707/531, 717/1-11, 717/111, 717/114-116, 717/147, 717/153, 717/167, 717/513, 709/201-202, 709/213, 709/217, 709/249, 709/223, 709/315, 709/331-332, 705/23, 705/26, 705/27
• US Class Current: 1/1
• CPC Class Codes: G06F 16/972 Access to data in other repository systems, e.g. legacy data or dynamic Web page generation
• CPC Class Codes: Y10S 707/99935 Query augmenting and refining, e.g. inexact access
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

An apparatus and method defines a markup language for accessing data in a database. The markup language is preferably defined in extensible markup language (XML) by creating suitable document type definitions (DTDs), which define the grammar for accessing data in the database using the markup language. A bridge interprets the data request from the client in markup language format, a suitable database query for the database is formulated, and the data is then placed within a document for delivery in markup language format to the user. As new data types are added to the database, corresponding document type definitions (DTDs) may be dynamically generated, allowing a user to access new kinds of data in a database with a software tool that has a user-friendly graphical user interface without having to manually update the software tool for each new data type that is added to the database.

Claims

1. A method for accessing data in a database, the method comprising the steps of:

requesting access to data in a database in a markup language format;

translating the request into a query to the database using a document type definition that corresponds to a data type of the request, the document type definition defining how to access data in the database;

creating a return document in markup language format;

submitting the query to the database;

inserting data retrieved from the database in response to the query into the return document; and

returning the return document.

3. The apparatus of claim 1 wherein the document type definition is defined in extensible markup language (XML).

4. The apparatus of claim 1 wherein the at least one document type definition corresponds to at least one data type in the database.

5. The apparatus of claim 4 wherein the document type definition is defined in extensible markup language (XML).

6. The apparatus of claim 4 wherein the markup language translator determines if a document type definition exists for a data type corresponding to the requested data, and if not, the markup language translator dynamically generates the document type definition for the requested data.

7. The apparatus of claim 1 further comprising a data access component residing in the memory that is invoked to access the data in the database.

8. The apparatus of claim 1 further comprising at least one data access component that receives the request to access the data in the database and that returns the requested data to the markup language interface.

9. The apparatus of claim 1 further comprising an association file that is used to correlate a data access component to an associated document type definition.

10. The apparatus of claim 1 wherein the document type definition defines a plurality of tags and a plurality of method calls on at least one data access component that may access the database, each of the plurality of tags having a corresponding method call for retrieving data from the database.

2. An apparatus comprising:

at least one processor;

a memory coupled to the at least one processor;

a markup language interface residing in the memory for requesting access to data in a database; and

a markup language translator residing in the memory for translating a request from the markup language interface into a query to the database, and for inserting data retrieved from the database in response to the query into a document that is formatted to be read by the markup language interface, wherein the markup language interface comprises at least one document type definition that defines how to access data in the database.

11. An apparatus comprising:

means for requesting access to data in a database in a markup language; and

means for translating a request from the means for requesting access into a query to the database, and for inserting data retrieved from the database in response to the query into a document that is formatted in the markup language; and

means for dynamically generating a document type definition for the requested data if no document type definition exists for a data type corresponding to the requested data.

12. A method for accessing data in a database, the method comprising the steps of:

requesting access to data in a database in a markup language format;

determining whether a document type definition exists for a data type of the request;

if no document type definition exists, dynamically generating a document type definition that corresponds to the data type of the request;

creating a return document in the markup language format defined by the document type definition;

submitting the query to the database;

inserting data retrieved from the database in response to the query into the return document; and

returning the return document.

13. A method for accessing data in a database, the method comprising the steps of:

requesting access to data in a database in a markup language format;

identifying and invoking at least one data access component corresponding to the request;

converting a plurality of element tags in the request to corresponding method calls on the at least one data access component;

invoking the method calls on the at least one data access component to retrieve the data from the database;

creating a return document in markup language format;

submitting the query to the database;

inserting data retrieved from the database in response to the query into the return document; and

returning the return document.

14. A method for accessing data in an object oriented database, the method comprising the steps of:

requesting access to data in the object oriented database in a markup language format;

determining whether a document type definition exists for a data type of the request;

if no document type definition exists, dynamically generating a document type definition that corresponds to the data type of the request;

identifying and invoking at least one data access component corresponding to the request;

converting a plurality of element tags in the request to corresponding method calls on the at least one data access component;

invoking the method calls on the at least one data access component to retrieve the data from the database;

creating a return document in markup language format defined by the document type definition;

inserting the data retrieved from the database into the return document; and

returning the return document.

15. An apparatus comprising:

at least one processor;

a memory coupled to the at least one processor;

an object oriented database residing in the memory;

at least one JavaBean residing in the memory and providing an interface for accessing data stored in the object oriented database;

an XML interface to a client browser residing in the memory, the XML interface including a first document type definition that defines at least one way to access data in the object oriented database;

an association file residing in the memory, the association file correlating at least one document type definition with an associated JavaBean;

a bridge residing in the memory and coupled to the XML interface and to the association file, the bridge routing at least one data request from a user via the XML interface to at least one JavaBean corresponding to at least one data type stored in the object oriented database, the bridge receiving the requested data from the at least one JavaBean and formatting the data into a return document with a format defined by a second document type definition.

16. The apparatus of claim 15 wherein the document type definition defines a plurality of tags and a plurality of method calls on at least one data access component that may access the database, each of the plurality of tags having a corresponding method call for retrieving data from the database.

17. A program product comprising:

a markup language interface for requesting access to data in a database, wherein the markup language interface comprises at least one document type definition that defines how to access data in the database;

a markup language translator for translating a request from the markup language interface into a query to the database, and that inserts data retrieved from the database in response to the query into a document that is formatted to be read by the markup language interface; and

signal bearing media bearing the markup language interface and the markup language translator.

18. The program product of claim 17 wherein the signal bearing media comprises recordable media.

19. The program product of claim 17 wherein the signal bearing media comprises transmission media.

20. The program product of claim 17 wherein the document type definition is defined in extensible markup language (XML).

21. The program product of claim 17 wherein the at least one document type definition corresponds to at least one data type in the database.

22. The program product of claim 21 wherein the markup language translator determines if a document type definition exists for a data type corresponding to the requested data, and if not, the markup language translator dynamically generates the document type definition for the requested data.

23. The program product of claim 21 wherein the document type definition is defined in extensible markup language (XML).

24. The program product of claim 17 further comprising a data access component that is invoked to access the data in the database.

25. The program product of claim 17 further comprising at least one data access component that receives the request to access the data in the database and that returns the requested data to the markup language interface.

26. The program product of claim 17 further comprising an association file that is used to correlate a data access component to an associated document type definition.

27. The program product of claim 17 wherein the document type definition defines a plurality of tags and a plurality of method calls on at least one data access component that may access the database, each of the plurality of tags having a corresponding method call for retrieving data from the database.