Database search system and method
Methods and systems for searching multiple databases are presented. Search connectors are defined between a first and second database, including a search connector having a shared field of the first and second database. Edge connections are generated between the first and second database using the search connector. Each of the edge connections include one or more instances of the shared field in the first and second database. A search query is received from a user interface. The search query is mapped to one of the plurality of search connectors having a specific shared field. A specific instance of the specific shared field is returned, and may be one of the edge connections between the first and second database. In another example, a natural language search query is received, and is translated using the defined search connectors. In a further example, data corresponding to the view name is imported.
1. A method of searching a plurality of databases comprising at least a first database, a second database and a third database, the method comprising:
defining a plurality of search connectors between the first database, the second database and the third database, the plurality of search connectors comprising at least one first search connector having at least one shared field of the first database and the second database linking the first database and the second database together, at least one second search connector having at least one shared field of the first database and the third database linking the first database and the third database together, and at least one third search connector having at least one shared field of the second database and the third database linking the second database and the third database together;
generating a plurality of edge connections, wherein each of the plurality of edge connections is connected to one or more of the plurality of databases and combines information from said one or more of the plurality of databases by tracing commonly shared fields relative to each of the plurality of databases;
receiving a search query from a user interface;
mapping the search query to one of the plurality of search connectors having a specific shared field; and
returning a specific instance of the specific shared field, the specific instance being one of the one or more edge connections between two or more of the plurality of databases.
2. The method of claim 1 , wherein receiving the search query comprises receiving a natural language search query and mapping the search query comprises translating the natural language search query using the defined plurality of search connectors.
3. The method of claim 1 , wherein defining the plurality of search connectors comprises using a first database configuration file for the first database, the first database configuration file comprising a view name and a column list, and a second database configuration file for the second database, the second database configuration file comprising at least the view name.
4. The method of claim 3 , further comprising importing data corresponding to the view name of the first database configuration file and the second database configuration file.
5. The method of 1 , further comprising importing a first table from the first database and a second table from the second database.
6. The method of claim 1 , wherein one of the first database and the second database comprises a standard query language (SQL) database.
7. The method of claim 1 , wherein the first database is of a first database type and the second database is of a second database type, the first and second database types being different database types.
8. The method of claim 1 , wherein the first database operates on a first server and the second database operates on a second server.
9. A database search system comprising:
a computer;
a network connection to the computer providing user access to a plurality of databases comprising at least a first database, a second database and a third database;
a plurality of search connectors between the first database, the second database and the third database, the plurality of search connectors comprising at least one first search connector having at least one shared field of the first database and the second database linking the first database and the second database together, at least one second search connector having at least one shared field of the first database and the third database linking the first database and the third database together, and at least one third search connector having at least one shared field of the second database and the third database linking the second database and the third database together;
a plurality of edge connections, wherein each of the plurality of edge connections is connected to one or more of the plurality of databases and combines information from said one or more of the plurality of databases by tracing commonly shared fields relative to each of the plurality of databases; and
a user interface connected to the computer with which a user performs a search query, wherein the database search system maps the search query to one of the plurality of search connectors having a specific shared field and returns a specific instance of the specific shared field, the specific instance being one of the one or more edge connections between two or more of the plurality of databases.
10. The database search system of claim 9 , wherein the search query comprises a natural language search query and the database search system translates the natural language search query using the defined plurality of search connectors.
11. The database search system of claim 9 , wherein the database search system defines the plurality of search connectors comprises using a first database configuration file for the first database, the first database configuration file comprising a view name and a column list, and a second database configuration file for the second database, the second database configuration file comprising at least the view name.
12. The database search system of claim 11 , wherein the database search system imports data corresponding to the view name of the first database configuration file and the second database configuration file.
13. The database search system of claim 12 , wherein the database search system imports a first table from the first database and a second table from the second database.
14. The database search system of claim 9 , wherein one of the first database and the second database comprises a standard query language (SQL) database.
15. The database search system of claim 9 , wherein the first database is of a first database type and the second database is of a second database type, the first and second database types being different database types.
16. The database search system of claim 9 , wherein the first database operates on a first server and the second database operates on a second server.