Database interface method and system

1. A computer-implemented method for automatically constructing a database query that can be used for querying different database management systems, each database management system having a different query syntax, the method performed by a graphical database system including at least one processor coupled to at least one memory containing instructions which, when executed by the at least one processor, causes the graphical database system to perform the method comprising:

maintaining, in at least one memory, a data dictionary including meta-data that relates each of a plurality of logical objects with one or more corresponding database tables and keys;

providing a user interface allowing a user to select logical objects and properties of logical objects and to join two or more logical objects together using predefined joining logic within a graphical computer workspace to form a graphical query;

receiving a listing of the selected logical objects, the selected properties of the logical objects, and a representation of the joining logic between logical objects from the graphical query;

translating, using the data dictionary meta-data, the listing of the selected logical objects, the selected properties of the logical objects, and the representation of the joining logic into a tree structure of the underlying database tables, keys, and hierarchical relationship between the tables to produce, in the at least one memory, a representation of a database query that is agnostic of any of the different database management system query syntaxes and that can be translated into different query syntaxes for different database management systems; and

storing the agnostic database query in the at least one memory for later recall and translation into the query syntax of a selected database management system.

2. The method of claim 1 , wherein the data dictionary includes a plurality of levels including a physical level and a logical level, wherein the physical level associates database structures with a data dictionary structure and the logical level associates the data dictionary structure with logical objects that can be graphically selected by a user.

3. The method of claim 1 , further comprising:

translating the agnostic database query into the query syntax of a selected database management system.

4. The method of claim 3 , wherein the query syntax uses structured query language.

5. A graphical database system for automatically constructing a database query that can be used for querying different database management systems, each database management system having a different query syntax, the graphical database system comprising:

at least one processor coupled to at least one memory containing instructions which, when executed by the at least one processor, causes the graphical database system to perform computer processes comprising:

maintaining, in at least one memory, a data dictionary including meta-data that relates each of a plurality of logical objects with one or more corresponding database tables and keys;

providing a user interface allowing a user to select logical objects and properties of logical objects and to join two or more logical objects together using predefined joining logic within a graphical computer workspace to form a graphical query;

receiving a listing of the selected logical objects, the selected properties of the logical objects, and a representation of the joining logic between logical objects from the graphical query;

translating, using the data dictionary meta-data, the listing of the selected logical objects, the selected properties of the logical objects, and the representation of the joining logic into a tree structure of the underlying database tables, keys, and hierarchical relationship between the tables to produce, in the at least one memory, a representation of a database query that is agnostic of any of the different database management system query syntaxes and that can be translated into different query syntaxes for different database management systems; and

storing the agnostic database query in the at least one memory for later recall and translation into the query syntax of a selected database management system.

6. The system of claim 5 , wherein the data dictionary includes a plurality of levels including a physical level and a logical level, wherein the physical level associates database structures with a data dictionary structure and the logical level associates the data dictionary structure with logical objects that can be graphically selected by a user.

7. The system of claim 5 , wherein the computer processes further comprise:

translating the agnostic database query into the query syntax of a selected database management system.

8. The system of claim 7 , wherein the query syntax uses structured query language.

9. A computer program product comprising a tangible, non-transitory computer readable medium having embodied therein computer program instructions which, when executed by one or more processors of a graphical database system, causes the graphical database system to perform computer processes comprising:

maintaining, in at least one memory, a data dictionary including meta-data that relates each of a plurality of logical objects with one or more corresponding database tables and keys;

providing a user interface allowing a user to select logical objects and properties of logical objects and to join two or more logical objects together using predefined joining logic within a graphical computer workspace to form a graphical query;

receiving a listing of the selected logical objects, the selected properties of the logical objects, and a representation of the joining logic between logical objects from the graphical query;

translating, using the data dictionary meta-data, the listing of the selected logical objects, the selected properties of the logical objects, and the representation of the joining logic into a tree structure of the underlying database tables, keys, and hierarchical relationship between the tables to produce, in the at least one memory, a representation of a database query that is agnostic of any of the different database management system query syntaxes and that can be translated into different query syntaxes for different database management systems; and

storing the agnostic database query in the at least one memory for later recall and translation into the query syntax of a selected database management system.

10. The computer program product of claim 9 , wherein the data dictionary includes a plurality of levels including a physical level and a logical level, wherein the physical level associates database structures with a data dictionary structure and the logical level associates the data dictionary structure with logical objects that can be graphically selected by a user.

11. The computer program product of claim 9 , wherein the computer processes further comprise:

translating the agnostic database query into the query syntax of a selected database management system.

12. The computer program product of claim 11 , wherein the query syntax uses structured query language.