Querying Data and an Associated Ontology in a Database Management System
AssigneeInternational Business Machines Corporation
InventorsLipyeow Lim, Haixun Wang, Min Wang
Life of this patent
Estimating the term…
Abstract
A method, apparatus, and computer program for querying data and an associated ontology in a database. An ontology is associated with data in database. Responsive to receiving a query from a requestor, relational data in the database is identified using the query to form identified relational data. Ontological knowledge in the ontology is identified using the identified relational data and the ontology. A result is returned to the requestor.
Claims22
A computer implemented method for querying relational data and semi-structured ontology data in a database, the computer implemented method comprising:
- associating ontological data in an ontology with relational data in a database;
- creating a virtual view comprising actual columns and virtual columns, wherein values in the actual columns comprise the associated relational data from the database and values in the virtual columns comprise the associated ontological data from the ontology, wherein the associated ontological data in the virtual columns is not materialized and only inferred when a query is made that requires that values be derived;
- receiving a query from a requestor requiring an inference of virtual view data in the virtual columns;
- and
- returning a result of the query, wherein the result comprises relational data and materialized values derived in real time from the virtual view data in the virtual columns.
A database management system for querying relational data and semi-structured ontology data in a database, the database management system comprising:
- a bus;
- a storage device connected to the bus, wherein the storage device contains computer usable code and the data;
- a communications unit connected to the bus;
- and
- a processing unit connected to the bus for executing the computer usable code, wherein the processing unit executes the computer usable code to associate ontological data in an ontology is with relational data in a database;
- create a virtual view comprising actual columns and virtual columns, wherein values in the actual columns comprise the associated relational data from the database and values in the virtual columns comprise the associated ontological data from the ontology, wherein the associated ontological data in the virtual columns is not materialized and only inferred when a query is made that requires that values be derived;
- receiving a query from a requestor requiring an inference of virtual view data in the virtual columns;
- and return a result of the query, wherein the result comprises relational data and materialized values derived in real time from the virtual view data in the virtual columns.
(canceled)
A computer program product comprising a computer usable medium including computer usable program code for querying relational data and semi-structured ontology data in a database, the computer program product comprising:
- computer usable code for associating ontological data in an ontology with relational data in a database;
- computer usable code for creating a virtual view comprising actual columns and virtual columns, wherein values in the actual columns comprise the associated relational data from the database and values in the virtual columns comprise the associated ontological data from the ontology, wherein the associated ontological data in the virtual columns is not materialized and only inferred when a query is made that requires that values be derived;
- computer usable code for receiving a query from a requestor requiring an inference of virtual view data in the virtual columns;
- and
- computer usable code for returning a result of the query, wherein the result comprises relational data and materialized values derived in real time from the virtual view data in the virtual columns.
(canceled)
Dependencies are inferred from the claim text.