Database management system

Abstract

A method of querying a database system, the database system comprising at least one database populated with a plurality of unique, multi-character expressions associated with the data entities of the at least one database, the method comprising: providing a graphical user interface for receiving at least one input selection from a user defining a database query expression; scanning the at least one database with the database query expression to obtain a first set of results; parsing the first set of results with a user profile expression associated with the user to obtain a second set of results, the user profile expression comprising a unique, multi-character expression; and displaying the second set of results in the graphical user interface.

1 . A method of querying a database system, the database system comprising at least one database populated with a plurality of unique, multi-character expressions associated with the data entities of the at least one database, the method comprising:
 providing a graphical user interface for receiving at least one input selection from a user defining a database query expression;   scanning the at least one database with the database query expression to obtain a first set of results;   parsing the first set of results with a user profile expression associated with the user to obtain a second set of results, the user profile expression comprising a unique, multi-character expression; and   displaying the second set of results in the graphical user interface.   
     
     
         2 . The method of  claim 1  wherein the user profile expression defines a role of the user and associated permissions. 
     
     
         3 . The method of  claim 2  further comprising providing a display at the graphical user interface that presents the user with at least one role for selection. 
     
     
         4 . The method of  claim 3  further comprising creating a role associated with the user. 
     
     
         5 . The method of  claim 4  wherein creating a role comprising selecting permissions for the role at the graphical user interface which modifies bytes of the user profile expression to define the role associated with the user. 
     
     
         6 . The method of  claim 4  wherein creating the role comprising setting permission for the role such that the role has an associated base group and set permissions limit the user to viewing data on individuals in the base group. 
     
     
         7 . The method of  claim 1 , further comprising
 providing an interface database, the interface database populated with a plurality of unique, multi-character expressions associated with data of the at least one database.   
     
     
         8 . The method of  claim 7 , wherein a data query expression comprises characters which correspond to the expressions stored in the interface database, the characters of the data query expression including deterministic characters and non-deterministic characters. 
     
     
         9 . The method of  claim 8 , wherein performing a query comprises parsing the interface database using the data query expression to match the deterministic characters and ignore the other characters. 
     
     
         10 . The method of  claim 9 , wherein performing a progressive query comprises replacing at least one non-deterministic characters of the data query expression with a deterministic character and scanning a portion of the interface database identified by a result of a previous query using the modified data query expression. 
     
     
         11 . The method of  claim 1  wherein the at least one database comprises a plurality of databases. 
     
     
         12 . The method of  claim 11  wherein at least two of the plurality of databases differ in their database management system, each database management system defining a set of programs that enable a user to store, modify, and extract information from the respective database. 
     
     
         13 . The method of  claim 12  further comprising using the interface database to allow a user to access data stored in the plurality of databases without using the database management system specific to the plurality of databases. 
     
     
         14 . The method of  claim 12  wherein the database management systems are selected from one or more of those provided by Oracle, FoxPro, IBM DB2, Linter, Microsoft Access, Microsoft SQL Server, MySQL, PostgreSQL and SQLite. 
     
     
         15 . The method of  claim 7  further comprising converting the data stored in the at least one databases into unique, multi-character expressions for storage in the interface database. 
     
     
         16 . The method of  claim 15  comprising iteratively accessing data within the at least one database to convert data not already converted and stored as unique, multi-character expressions in the interface database to unique, multi-character expressions for storage in the interface database. 
     
     
         17 . The method of  claim 16  comprising updating the interface database on a determination that one of the plurality of databases has been updated. 
     
     
         18 . A database system comprising:
 at least one database populated with a plurality of unique, multi-character expressions associated with the data entities of the at least one database; and   a graphical user interface for receiving at least one input selection from a user defining a database query expression; wherein   the database system is configured to scan the at least one database with the database query expression to obtain a first set of results;   parse the first set of results with a user profile expression associated with the user to obtain a second set of results, the user profile expression comprising a unique, multi-character expression; and   display the second set of results in the graphical user interface.   
     
     
         19 . The database system of  claim 18  further configured to perform the steps of any one of  claims 2  to  17 .