Driver for mapping standard database queries and commands to markup language documents

• US 20040019589A1
• Filed: 07/25/2002
• Published: 01/29/2004
• Est. Priority Date: 07/25/2002
• Status: Abandoned Application

• Current Assignee: Sun Microsystems Incorporated (Oracle Corporation)
• Original Assignee: Sun Microsystems Incorporated (Oracle Corporation)
• Inventors: Basrur, Rajesh G.
• Application Number:
  US10/202,761
• Publication Number:
  US 20040019589A1
• Time in Patent Office: Days
• US Class Current: 707/3
• CPC Class Codes: G06F 16/80 of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML content-based retrieval of web data G06F16/95

Abstract

A computer-based method for accessing a markup language document. The method includes receiving a data access request from an application that is in form of a database language statement and indicates a markup language document. The data access request is processed to identify the markup language document, and a communication connection is provided to the markup language document. The markup language document is then accessed or processed based on the database language statement. A result set is generated and returned to the application. Typically, the result set is in tabular form with data from the markup language document provided in rows and columns. The method includes dynamically mapping the markup language document to a database structure or records based on the received database language statement. Common tag prefixes in the statement are identified, and the elements in the document are grouped into records.

Claims

1. A computer-based method for accessing a markup language document, comprising:

receiving a data access request from an application including an identifier for a markup language document and a database language statement;

processing the data access request to identify the markup language document;

providing a connection to the markup language document;

accessing the markup language document based on the database language statement; and

returning a result set to the application including data from the markup language document.

2. The method of claim 1, wherein the document is formatted in the eXtensible Markup Language (XML).

3. The method of claim 1, wherein the database language statement is a Structured Query Language (SQL) statement.

4. The method of claim 3, wherein the database language statement is selected from the group consisting of select, delete, update, and insert.

5. The method of claim 1, wherein the processing of the data access request includes identifying common prefixes for information elements in the markup language document and further including mapping the markup language document to a database structure having records corresponding to the identified common prefixes.

6. The method of claim 5, wherein the accessing includes locating a tag that matches one of the common prefixes in the markup language document and positioning a record pointer at the matched tag, whereby the record pointer is positioned at a start of one of the records.

7. The method of claim 5, wherein the result set is formatted in tabular form with columns corresponding to elements nested within the elements having identified common prefixes.

8. The method of claim 1, wherein the accessing of the markup language document includes parsing with a first or a second parser and further including selecting the first or the second parser based on the database language statement.

9. The method of claim 8, wherein the first parser comprises a Simple Application Programming Interface (API) for XML.

10. The method of claim 8, wherein the second parser comprises a Document Object Model API.

11. A data access driver for use by applications in accessing markup language documents, comprising:

a database connectivity interface receiving data access requests identifying a markup language document and having a database query format, providing connections to the markup language documents, and executing commands in the data access requests; and

a parser mechanism parsing the markup language documents based on the commands in the data access requests.

12. The method of claim 11, wherein the database connectivity interface is adapted for mapping the markup language documents to database structures having records comprising a group of elements in the markup language documents.

13. The method of claim 12, wherein the mapping includes processing the commands in the data access requests to determine common prefixes for elements in the markup language documents and wherein the groups of elements for the records are selected based on tags in the markup language document that match the common prefixes.

14. The system of claim 13, wherein the parser mechanism includes a first parser for parsing involving data retrieval from the markup language documents and a second parser for parsing involving modifying or creating the markup language documents.

15. The system of claim 14, wherein the first parser comprises a Simple Application Programming Interface (API) for XML and wherein the second parser comprises a Document Object Model API.

16. The system of claim 11, wherein the database query format is defined by Structured Query Language (SQL).

17. The system of claim 11, wherein the database connectivity interface further functions to generate and return result sets based on the parsing performed by the parser mechanism and including data in columns representing elements in the markup language documents.

18. The system of claim 11, wherein the markup language documents are extensible Markup Language (XML) documents.

19. A computer readable medium, comprising:

computer readable program code devices configured to cause a computer to effect receiving from an application a data access request identifying a markup language document and defining processing of the markup language with a database language statement;

computer readable program code devices configured to cause a computer to effect processing the data access request to provide a connection to the markup language document;

computer readable program code devices configured to cause a computer to effect parsing the markup language document based on the database language statement; and

computer readable program code devices configured to cause a computer to effect generating a result set to the data access request and transmitting the result set to the application.

20. The computer readable medium of claim 19, further including computer readable program code devices configured to cause a computer to effect mapping the markup language document to a database structure having records each containing a group of information elements from the markup language document.

21. The computer readable medium of claim 20, wherein the mapping includes processing the database language statement to identify one or more common prefixes and wherein one of the records of the database structure is provided for each of the common prefixes.

22. The computer readable medium of claim 21, wherein the common prefixes comprise two or more element labels separated by a character recognizable by the mapping code devices.

23. The computer readable medium of claim 20, wherein the parsing includes finding matches for the one or more common prefixes in the element tags in the markup language document and positioning a record pointer for the one of the records provided for the matched common prefix.

24. The computer readable medium of claim 19, wherein the database language statement is a SQL statement and the markup language document is an XML document.