Providing a unified query interface across multiple ontology-based databases
A system for providing a unified query interface across multiple ontology-based databases and related methods are disclosed. The system is programmed to receive calls to an application programming interface for querying an ontology, where ontology data is represented in different databases respectively in different forms. For each function being called, system is programmed to select a database from the different databases based on the function type and each ontology entity type being processed by the function. The system is further programmed to retrieve data from each selected database, merge the retrieval results as appropriate, and transform the final result to ontology data in response to the calls.
1 . A computer-implemented method of providing a unified query interface across multiple object databases, comprising:
receiving a set of calls of a set of functions in an application programming interface (API) for querying an ontology,
the ontology including a definition for each ontology entity type of a plurality of ontology entity types and a plurality of ontology entities instantiated from the plurality of ontology entity types,
each ontology entity type of the plurality of ontology entity types having one or more properties;
determining a set of properties of a first ontology entity type of the plurality of ontology entity types, the set of properties to be accessed in executing the set of functions;
identifying a first group of object databases associated with the first ontology entity type,
the first ontology entity type being represented in multiple forms separately in the first group of object databases;
selecting a specific object database from the first group of object databases based on functional information of the specific object database related to representation of the set of properties of the first ontology entity type;
executing the set of functions using the specific object database;
returning a result of the executing in response to the set of calls,
wherein the method is performed by one or more processors.
2 . The computer-implemented method of claim 1 , the set of functions including a filter that operates on an ontology entity type and returns a set of ontology entities of the ontology entity type.
3 . The computer-implemented method of claim 1 , the identifying being performed based on a certain mapping that associates the first ontology entity type with the first group of object databases and includes a transformation between the definition for the first ontology entity type and schemas for the first group of object databases.
4 . The computer-implemented method of claim 1 ,
a first object database of the first group of object databases being a relational database representing an ontology entity of the first ontology entity type as a row and properties of the ontology entity as columns,
a second object database of the first group of object databases being a graph database representing the ontology entity as a node and links connected to the ontology entity as edges.
5 . The computer-implemented method of claim 1 ,
a first object database of the first group of object databases representing a particular property of the set of properties of the first ontology entity type in uncompressed or indexed form,
a second object database of the first group of object databases representing the particular property in archived or encrypted form.
6 . The computer-implemented method of claim 1 ,
the selecting comprising matching the functional information of the specific object database with metadata of a particular function of the set of functions,
the functional information indicating that a column of the specific object database allows random and near real-time access,
the column corresponding to a property of the set of properties of the first ontology entity type.
7 . The computer-implemented method of claim 1 , the selecting comprising estimating a performance of each object database of the first group of object databases in serving a call to a particular function of the set of functions by limiting an amount of data to be returned from calling the particular function.
8 . The computer-implemented method of claim 1 , the selecting comprising confirming that the specific object database has a latest version of an ontology entity of the first ontology entity type that is available for querying.
9 . The computer-implemented method of claim 1 , the executing comprising:
accessing distinct object databases of the first group of object databases to access distinct properties of the first ontology entity type;
merging results of accessing the distinct object databases.
10 . The computer-implemented method of claim 1 , the executing comprising transforming data retrieved from the specific object database to data of the ontology.
11 . The computer-implemented method of claim 1 , further comprising:
identifying a user account associated with the set of calls;
verifying that the user account has permission to access the specific object database in executing the set of functions.
12 . The computer-implemented method of claim 1 , an ontology entity being an object or a link between two objects.
13 . A system for managing versioning of providing a unified query interface across multiple object databases, comprising:
a memory;
one or more processors coupled to the memory and configured to perform:
receiving a set of calls of a set of functions in an API for querying an ontology,
the ontology including a definition for each ontology entity type of a plurality of ontology entity types and a plurality of ontology entities instantiated from the plurality of ontology entity types,
each ontology entity type of the plurality of ontology entity types having one or more properties;
determining a set of properties of a first ontology entity type of the plurality of ontology entity types, the set of properties to be accessed in executing the set of functions;
identifying a first group of object databases associated with the first ontology entity type,
the first ontology entity type being represented in multiple forms separately in the first group of object databases;
selecting a specific object database from the first group of object databases based on functional information of the specific object database related to representation of the set of properties of the first ontology entity type;
executing the set of functions using the specific object database;
returning a result of the executing in response to the set of calls.
14 . The system of claim 13 ,
a first object database of the first group of object databases representing a particular property of the set of properties of the first ontology entity type in uncompressed or indexed form,
a second object database of the first group of object databases representing the particular property in archived or encrypted form.
15 . The system of claim 13 ,
the selecting comprising matching the functional information of the specific object database with metadata of a particular function of the set of functions,
the functional information indicating that a column of the specific object database allows random and near real-time access,
the column corresponding to a property of the set of properties of the first ontology entity type.
16 . The system of claim 13 , the selecting comprising estimating a performance of each object database of the first group of object databases in serving a call to a particular function of the set of functions by limiting an amount of data to be returned from calling the particular function.
17 . The system of claim 13 , the selecting comprising confirming that the specific object database has a latest version of an ontology entity of the first ontology entity type that is available for querying.
18 . The system of claim 13 , the executing comprising:
accessing distinct object databases of the first group of object databases to access distinct properties of the first ontology entity type;
merging results of accessing the distinct object databases.
19 . The system of claim 13 , the one or more processors further configured to perform:
identifying a user account associated with the set of calls;
verifying that the user account has permission to access the specific object database in executing the set of functions.
20 . A non-transitory, computer-readable storage medium storing one or more sequences of instructions which when executed cause one or more processors to perform:
receiving a set of calls of a set of functions in an API for querying an ontology,
the ontology including a definition for each ontology entity type of a plurality of ontology entity types and a plurality of ontology entities instantiated from the plurality of ontology entity types,
each ontology entity type of the plurality of ontology entity types having one or more properties;
determining a set of properties of a first ontology entity type of the plurality of ontology entity types, the set of properties to be accessed in executing the set of functions;
identifying a first group of object databases associated with the first ontology entity type,
the first ontology entity type being represented in multiple forms separately in the first group of object databases;
selecting a specific object database from the first group of object databases based on functional information of the specific object database related to representation of the set of properties of the first ontology entity type;
executing the set of functions using the specific object database;
returning a result of the executing in response to the set of calls.