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. An apparatus comprising:
a memory configured to communicate with a computing device and having instructions stored thereon that, in response to execution by the computing device, cause the computing device to perform operations comprising:
generating a visual interface to manage data in a first database controlled by a first database management system (DBMS) and a second database controlled by a second DBMS;
connecting to a selected one of the first database or the second database in response to user instructions;
storing a copy of a table comprising the data stored in the connected database in an external file for management of the table by the user;
containing table relations domains in a table relation file,
wherein the table relations domains comprises a set of column pairs, in which a column pair includes a member from an originate table and a member from a conclude table.
2. The apparatus of claim 1 , further comprising managing relations between tables for a plurality of remote databases.
3. The apparatus of claim 2 , wherein a remote database of the plurality of remote databases corresponds to a database management language.
4. The apparatus of claim 2 , wherein the plurality of remote databases are individually compliant with one or more of:
an ORACLE system,
a MICROSOFT structured query language (MSS %) server,
a SYBASE system,
an INFORMIX system,
a DB2 based system,
a dBASE-based system,
a standard query language (SQL)-based system,
a mini structured query language (mSQL)-based system, or
a MYSQL-based system.
5. The apparatus of claim 1 , further comprising outputting the visual interface in a web browser.
6. The apparatus of claim 5 , further comprising implementing one or more markup languages to output the visual interface, the implemented markup language selected from: hypertext markup language (HTML), dynamic hypertext markup language (DHTML), standard generalized hypertext markup language (SGML), or extensible markup language (XML).
7. The apparatus of claim 1 , further comprising synchronizing the connected database with the external file.
8. The apparatus of claim 1 , wherein the table relations domains includes a domain for the table relation file.
9. The apparatus of claim 1 , further comprising specifying an owner to which a set of relations belong.
10. The apparatus of claim 1 , further comprising rewriting the table relation file in response to receiving a submit input.
11. The apparatus of claim 1 , wherein the table relation file is independent of management systems for a plurality of remote databases.
12. The apparatus of claim 1 , further comprising concurrently manipulating and accessing the data in the first database and the second database.
13. A computer-readable medium having stored thereon computer-executable instructions that, in response to execution by a computing device, cause the computing device to perform operations comprising:
generating a visual interface to manage data in a first database controlled by a first database management system (DBMS) and a second database controlled by a second DBMS;
connecting to a selected one of the first database or the second database in response to user instructions;
storing a copy of a table comprising the data stored in the connected database in an external file for management of the table by the user;
managing relations between the connected database and a table relation file separate from the DBMS for the connected database, in which the table relation file includes a set of column pairs that includes a member from an origin table and a member from a conclude table that are contained in the connected database; and
rewriting the table relation file in response to modification of the set of the column pairs.
14. The computer-readable medium as described in claim 13 , wherein the first database and the second database are virtualized databases.
15. The computer-readable medium as described in claim 13 , further comprising concurrently accessing and manipulating data in the first database and the second database.
16. The computer-readable medium as described in claim 13 , wherein the first database is controlled by a first DBMS selected from a first DBMS group, the first DBMS group consisting of:
an ORACLE system,
a MICROSOFT structured query language (MSSQL) server,
a SYBASE system,
an INFORMIX system,
a DB2-based system,
a dBASE-based system,
a standard query language (SQL)-based system,
a mini structured query language (mSQL)-based system, and
a MYSQL-based system; and
wherein the second database is controlled by a second DBMS selected from the group consisting of the first DBMS group excluding a DBMS that is the same as the first DBMS.