Universal data management interface
A universal data management interface (UDMI) system includes a processing system generates a visual interface through which a user can access, manage, and manipulate data on plural different types of remote databases. The UDMI connects to multiple standard database management systems and to allow multiple users to access, manage, and manipulate data within each of the multiple standard database management systems. The UDMI also allows multiple virtual databases that reside in a single database to be available as a network service.
1. A computer-readable medium storing executable instructions that, when executed, cause a computer to perform operations comprising:
generating a visual interface to enable network access to a virtual database that is maintained locally on the computer;
establishing a link via the virtual database to a plurality of databases remote from the virtual data base,
wherein the virtual database, representing the plurality of databases accessible to the computer remotely via a network, is configured to obtain data from one or more of the plurality of databases in response to a request generated through interaction with the visual interface, and
wherein the virtual database comprises a plurality of tables;
generating a unique sequential number to attach to a name of a table of the plurality of tables; and
enabling access to the virtual database via the link by a client device.
2. The computer-readable medium of claim 1 , wherein the plurality of databases includes one or more of: a database management system, an Oracle system, a MSSQL Server, a SyBase system, an Informix system, a DB2-based system, a dBase-based system, a SQL-based system, a mSQL-based system, a flat file, a xml file, or a file directory.
3. The computer-readable medium of claim 1 , wherein the generating the virtual database includes creating the virtual database with a single instruction.
4. The computer-readable medium of claim 1 , further comprising:
detecting import parameters of a source data structure; and
importing the source data structure based on the detected import parameters.
5. The computer-readable medium of claim 1 , further comprising enabling a sign-in process for the client device to access the virtual database.
6. The computer-readable medium of claim 1 , further comprising exporting a subset of the virtual database in a format compatible with a reading process.
7. The computer-readable medium of claim 1 , further comprising configuring the virtual database for access via software that operates over the network.
8. The computer-readable medium of claim 1 , further comprising calculate cells in the plurality of tables based on one or more settings of the client device.
9. A method comprising:
generating a visual interface to enable network access to a virtual database that is maintained locally on a computer;
establishing a link via the virtual database to a plurality of databases remote from the virtual data base,
wherein the virtual database, representing the plurality of databases accessible to the computer via a network, is configured to obtain data from one or more of the plurality of databases in response to a request generated through interaction with the visual interface, and
wherein the virtual database comprises a plurality of tables;
generating a unique sequential number to attach to a name of a table of the plurality of tables; and
enabling access to the virtual database via the link by a client device.
10. The method claim 9 , wherein the plurality of databases includes one or more of: a database management system, an Oracle system, a MSSQL Server, a SyBase system, an Informix system, a DB2-based system, a dBase-based system, a SQL-based system, a mSQL-based system, a flat file, a xml file, or a file directory.
11. The method of claim 9 , wherein the generating the virtual database includes creating the virtual database with a single instruction.
12. The method of claim 9 , further comprising:
detecting import parameters of a source data structure; and
importing the source data structure based on the detected import parameters.
13. The method of claim 9 , further comprising enabling a sign-in process for the client device to access the virtual database.
14. The method of claim 9 , further comprising exporting a subset of the virtual database in a format compatible with a reading process.
15. The method of claim 9 , further comprising configuring the virtual database for access via software that operates over the network.
16. The method of claim 9 , further comprising calculating cells in the plurality of tables based on one or more settings of the client device.