# US 2004/0083223 A1 · Global database management system integrating heterogeneous data resources

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2004/0083223 A1
- Document ID: US20040083223A1
- Status: Published application
- Kind: A1
- Application number: 10/472,232
- Filed: 2003-09-22
- Published: 2004-04-29
- Earliest claimed: 2001-03-30
- Inventors: Dean M Jones; Zhan Cui
- Web page: https://patentgrep.com/patent/US20040083223A1

## CPC

- G06F 16/2471: {Distributed queries}
- G06F 16/2452: Query translation
- G06F 16/25: Integrating or interfacing systems involving database management systems
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A database management systems is disclosed for solving distributed queries across a range of resources. In known systems, database retrieval from multiple sources suffers from problems of reconciliation of data between resources and resource or data incompatibility. The invention allows full database integration even in the case where a database includes a plurality of disparate database resources having differing ontologies (data structures). The system has an ontology server which is used to store the ontologies of various database resources and the query engine is designed to consult the server so that it can construct a query that will operate effectively across the disparate database resources.

## Claims

### Claim 1

A database management system comprising a database manager and a plurality of database resources, in which the manager includes an ontology server for storing respective ontologies for each database resource.

### Claim 2 (depends on 1)

A system as claimed in claim 1 in which the manager further includes a plurality of respective first stores each containing a mapping of a resource ontology to its respective resource contents.

### Claim 3 (depends on 1, 2)

A system as claimed in claim 1 or 2 in which the manager further includes a directory of the respective resource contents.

### Claim 4 (depends on 1, 2)

A system as claimed in claim 1 or 2 in which the manager further includes at least one second store containing mappings of the resource ontologies onto a pre-defined application ontology.

### Claim 5

A system as claimed in any preceding claim in which the database manager comprises a query engine.

### Claim 6

A method of managing a database comprising a database manager and a plurality of database resources comprising the steps of creating a resource ontology for each database resource and storing the resource ontology on the database manager.

### Claim 7 (depends on 6)

A method as claimed in claim 6 further including the step of creating a mapping of each resource ontology to its respective resource contents, and storing the mapping in a respective first store.

### Claim 8 (depends on 7)

A method as claimed in claim 7 further including the steps of generating queries to each of the first stores to obtain the respective resource contents and compiling therefrom a directory in the manager of the respective resource contents.

### Claim 9 (depends on 6, 7, 8)

A method as claimed in any of claims 6 to 8 further including the steps of creating mappings of the resource ontologies onto a pre-defined application ontology and storing the mapping in at least one second store.

### Claim 10 (depends on 1, 2, 3, 4, 5, 6, 7, 8, 9)

A computer readable medium comprising instructions for implementing a system as claimed in any of claims 1 to 5 and/or a method as claimed in any of claims 6 to 9.
