Database Interface Method and System
AssigneeHexagon Technology Center GmbH
InventorDoron Goshen
Life of this patent
Estimating the term…
Abstract
An intuitive interface that allows a non-technical person to search a computer database without having to understand the underlining database software or its structure by assembling a graphical database query.
Claims22
1-20. (canceled)
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 comprising:
- 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;
- associating each logical object with one or more corresponding database tables in accordance with a data dictionary that relates logical objects with the database tables;
- and
- arranging the logical objects in a hierarchical order based on the selected properties for the logical objects using the data dictionary and joining the associated logical objects to form an agnostic database query that can be translated into different query syntaxes for different database management systems.
A 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 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 system to perform computer processes comprising:
- 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;
- associating each logical object with one or more corresponding database tables in accordance with a data dictionary that relates logical objects with the database tables;
- and
- arranging the logical objects in a hierarchical order based on the selected properties for the logical objects using the data dictionary and joining the associated logical objects to form an agnostic database query that can be translated into different query syntaxes for different database management systems.
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 system, causes the system to perform computer processes comprising:
- 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;
- associating each logical object with one or more corresponding database tables in accordance with a data dictionary that relates logical objects with the database tables;
- and
- arranging the logical objects in a hierarchical order based on the selected properties for the logical objects using the data dictionary and joining the associated logical objects to form an agnostic database query that can be translated into different query syntaxes for different database management systems.
Dependencies are inferred from the claim text.