Method of generating data servers for heterogeneous data sources

• US 7,660,805 B2
• Filed: 12/14/2004
• Issued: 02/09/2010
• Est. Priority Date: 12/23/2003
• Status: Expired due to Fees

• Current Assignee: Canon Kabushiki Kaisha (Canon Inc.)
• Original Assignee: Canon Kabushiki Kaisha (Canon Inc.)
• Inventors: Wu, Jing, Chan, Sammy, Lam, Nicole Ai Ling, Lennon, Alison Joan
• Primary Examiner(s): Wong; Don
• Assistant Examiner(s): Lie; Angela M
• Application Number:
  US11/010,303
• Publication Number:
  US 20050149552A1
• Time in Patent Office: 1,883 Days
• Field of Search: 707/1, 707/2, 707/3, 707/4, 707/10, 707100-102, 707/104.1, 707/201, 715/255
• US Class Current: 1/1
• CPC Class Codes: G06F 16/211 Schema design and management
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation

Abstract

A query system (1600) is formed by a wizard (1605) operating to form a data server (1610) arranged to serve data from a data source (1615) to a client application (1630), each of the wizard, the client application, the data server and the data source being linked by a communications network (1650). The data source has native data types and data arranged in a data structure. The wizard operates to firstly identify the data source over the network. The wizard further provides an application program for traversing and examining at least one of the data structure and data of the identified data source. The application program is operable to generate a representative schema (1614) comprising mapping data for converting the native data types to predetermined data types of a common data model. The wizard further operates to create a server application (1612) adapted to use the representative schema to convert the data from the native data types to the predetermined data types and to serve the data to the client application according to the common data model over the network. The representative schema and the server application thereby form the data server generated by the wizard. Once formed, the data server may receive and respond to queries from the client application, which may have no knowledge of the native data types, but which are directed to the data source.

Claims

1. A computer-implemented method of serving data between a database and a client application, wherein said database comprises data of a native data type which is arranged in a data structure, said method comprising the steps of:

examining said database;

generating a default schema, wherein the default schema comprises mapping data for converting said data of said native data type to a predetermined data type of a common data model, and wherein said default schema provides a plurality of representations of the data structure of the database;

displaying the generated default schema and the data of the native data type graphically;

adding an annotation to the default schema, wherein said annotation comprises a child element that identifies the database;

mapping at least one of a first element and a first attribute of the default schema to at least a respective one of a second element and a second attribute of a predetermined schema, wherein the mapping is responsive to a mapping instruction, and wherein said predetermined schema includes an annotation copied from the annotation of the default schema;

using a computer to create a server application to use said predetermined schema to convert said data of said native data type to data of said predetermined data type;

parsing, according to said server application, a query according to the common data model;

mapping said parsed query, using said server application, to form a data request of the data of said native data type to be sent to the database;

retrieving a required portion of the data from said database in response to said received query;

converting said response data according to said server application to form a response to said query according to said common data model; and

returning said response to said client application.

2. A method according to claim 1, further comprising the step of deploying said server application on a network to enable access to data on said database by said client application over the network.

3. A method according to claim 2 further comprising the step of accessing said deployed server application using a Uniform Resource Identifier (URI).

4. A method according to claim 1, wherein said default schema and the predetermined schema each respectively comprise an XML Schema, wherein said query comprises an XQuery, and wherein said response comprises an XML result.

5. A method according to claim 1 wherein said database is one of:

(a) a relational database; and

(b) an ODBC data source

(c) a hierarchical directory of files

(d) a Microsoft Exchange Server and Outlook mailbox

(e) a delimited text file;

(f) a native XML database; and

(g) a Lotus Notes database.

6. A method according to claim 1, wherein said default schema and the predetermined schema each respectively use a hierarchical data model.

7. A method according to claim 6 wherein said hierarchical data model is an XML Schema.

8. A method according to claim 1, wherein said default schema, said predetermined schema and said server application thereby form a data server for said database.

9. A computer-implemented method of serving data between a plurality of databases and a client application, wherein each of said databases respectively comprises data of a native data type which is arranged in a data structure, said method comprising the steps of:

examining at least one of the plurality of databases;

generating a corresponding default schema for said examined database, wherein said corresponding default schema comprises mapping data for converting said native data type to a predetermined data type of a common data model, and wherein said corresponding default schema provides a plurality of representations of the data structure of the database;

displaying the generated default schema and the data of the native data type graphically;

adding an annotation to the default schema, wherein said annotation comprises a child element that identifies the database;

mapping at least one of a first element and a first attribute of the default schema to at least a respective one of a second element and a second attribute of a predetermined schema, wherein the mapping is responsive to a mapping instruction, and wherein said predetermined schema includes an annotation copied from the annotation of the default schema;

using a computer to create a server application to use said corresponding predetermined schema to convert the data of said native data type in said examined database to data of said predetermined data type, and to serve said data according to said common data model over said network;

parsing, according to said server application, a query of said examined database according to said common data model;

mapping said parsed query, using said server application, to form a data request of the data of said native data type to be sent to the examined database;

retrieving a required portion of the data from said examined database in response to said received query;

converting said response data according to said server application to form a response to said query according to said common data model; and

returning said response to said client application.

10. A method according to claim 9 further comprising the step of deploying each server application created for a respective database on said network.

11. A method according to claim 10 further comprising the step of accessing one deployed server application using a Uniform Resource Identifier (URI).

12. A method according to claim 9, wherein said default schema and the predetermined schema each respectively comprise an XML Schema, wherein said query comprises an XQuery, and wherein said response comprises an XML result.

13. A method according to claim 9, wherein said mapping data indicates relationships between the data of the native data type in the database and provides a plurality of selectable views of the data in said database.

14. A method according to claim 9, wherein said response includes a view of said data from said examined database.

15. A computer readable storage medium having a computer application program recorded thereon executable to make a computer serve data between a plurality of databases and a client application, wherein each of said databases respectively comprises data of a native data type which is arranged in a data structure, said application program comprising:

code for examining at least one of the plurality of databases;

code for generating a corresponding default schema for said examined database, wherein said corresponding default schema comprises mapping data for converting said native data type of said examined database to a predetermined data type of a common data model, and wherein said corresponding default schema provides a plurality of representations of the data structure of the database;

code for displaying the generated default schema and the data of the native data type graphically;

code for adding an annotation to the default schema, wherein said annotation comprises a child element that identifies the database;

code for mapping at least one of a first element and a first attribute of the default schema to at least a respective one of a second element and a second attribute of a predetermined schema, wherein the mapping is responsive to a mapping instruction, and wherein said predetermined schema includes an annotation copied from the annotation of the default schema;

code for creating a server application to use said corresponding predetermined schema to convert said data of said native data type in said examined database to data of said predetermined data type, and to serve said data according to said common data model;

code for parsing, according to said server application, a query of said examined database according to said common data model;

code for mapping said parsed query, using said server application, to form a data request of the data of said native data type to be sent to the examined database;

code for retrieving a required portion of the data from said examined database in response to said received query;

code for converting said response data according to said server application to form a response to said query according to said common data model; and

code for returning said response to said client application.

16. A computer readable storage medium according to claim 15, wherein said representative schema and said server application thereby form a data server for said database.

17. A computer readable storage medium according to claim 16, wherein said server application is deliverable to a first computer and executable on said first computer to form at least one instance of said data server on a second computer, and wherein both said computers form part of a network.

18. A computer readable storage medium according to claim 17 wherein said client application is resident and operable from a third computer and at least one of said plurality of databases is resident on upon one of a fourth computer or said second computer.

19. A computer readable storage medium according to claim 15, wherein said application program further comprises code for executing each of said generating code, said examining code, said creating code, said displaying code, said adding code, said element and attribute mapping code, said parsing code, said query mapping code, said retrieving code, said converting code and said returning code over each of the plurality of databases.

20. A computer apparatus comprising a processor and a memory for storing an application program, wherein the application program is executable by the processor to control said apparatus to serve data between a plurality of databases and a client application, wherein each of said databases comprises data of a native data type which is arranged in a data structure, and wherein the execution of the application program thereby affords said apparatus:

means for examining at least one of the plurality of databases;

means for generating a corresponding default schema for said examined database, wherein said corresponding default schema comprises mapping data for converting said native data type of said database to a predetermined data type of a common data model, and wherein said corresponding default schema provides a plurality of representations of the data structure of the database;

means for displaying the generated default schema and the data of the native data type graphically;

means for adding an annotation to the default schema, wherein said annotations comprises a child element that identifies the database;

means for mapping at least one of a first element and a first attribute of the default schema to at least a respective one of a second element and a second attribute of a predetermined schema, wherein the mapping is responsive to a mapping instruction, and wherein said predetermined schema includes an annotation copied from the annotation of the default schema;

means for creating a server application to use said corresponding predetermined schema to convert said data from said native data type in said examined database to data of said predetermined data type, and to serve said data according to said common data model;

means for parsing, according to said server application, a query of said examined database according to said common data model;

means for mapping said parsed query, using said server application, to form a data request of the data of said native data type to be sent to the examined database;

means for retrieving a required portion of the data from said examined database in response to said received query;

means for converting said response data according to said server application to form a response to said query according to said common data model; and

means for returning said response to said client application.