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 universal data management interface (UDMI) system comprising:
a network interface configured to communicate with a memory, wherein, the memory is configured to communicate with a processor for universal data management and the processor, in response to executing a computer program, performs operations comprising:
maintaining, by the processor, a database that is exposed for network access,
wherein the database represents a plurality of virtual databases, and the plurality of virtual databases respectively reside in different database management systems that are accessible to the UDMI system remotely via a network,
wherein a client program establishes a link via the database to a virtual database of the plurality of virtual databases,
wherein the virtual database is accessible remotely from the client program across the network,
wherein the client program is installed on a client device, and
wherein a virtual database of the plurality of virtual databases comprises a plurality of tables;
enabling, by the processor and via the link, access to the virtual database by the client device; and
generating a unique sequential number to attach to a name of a table of the plurality of tables;
wherein the client device is configured to:
request data via the link from the virtual database;
receive the data via the link from the virtual database;
manipulate the data to create processed data; and
present the processed data on an interface of the client device.
2. The universal data management interface system of claim 1 , wherein the memory comprises a table domain that associates tables with identification information of one or more users.
3. The universal data management interface system of claim 1 , wherein the establishing the link further comprises configuring the link to receive and to send the data via the link.
4. The universal data management interface system of claim 1 , wherein a virtual database of the plurality of virtual databases are configured as at least one 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.
5. The universal data management interface system of claim 1 , the operations further comprising creating at least one virtual database of the plurality of virtual databases with a single instruction.
6. The universal data management interface system of claim 1 , the operations further comprising synchronizing the UDMI with an underlying database.
7. The universal data management interface system of claim 1 , wherein maintaining the database comprises using a database management language.
8. The universal data management interface system of claim 1 , the operations further comprising receiving, via a visual interface, access information to pass an initial access procedure.
9. The universal data management interface system of claim 1 , the operations further comprising enabling access to the plurality of virtual databases through a visual interface.
10. The universal data management interface system of claim 1 , the operations further comprising:
performing an automatic import method to detect import parameters of a source data structure and
importing a subset of the source data structure based on the import parameters.
11. The universal data management interface system of claim 1 , wherein the client device accesses the plurality of virtual databases.
12. The universal data management interface system of claim 11 , wherein the client device includes at least one of a computer, a personal digital assistant, or a cellular telephone.
13. The universal data management interface system claim 1 , the operations further comprising enabling one or more users to sign-up to access the plurality of virtual databases.
14. The universal data management interface system of claim 1 , the operations further comprising performing an automatic export method that includes exporting a virtual database of the plurality of virtual databases in a format compatible with a reading process.
15. The universal data management interface system of claim 1 , the operations further comprising configuring the plurality of virtual databases for access via software that operates over the network.
16. The universal data management interface system of claim 1 , the operations further comprising automatically calculating cells in the tables based on one or more users' settings.
17. The universal data management interface system of claim 1 , the operations further comprising enabling access for one or more users to access the plurality of virtual databases over the network.
18. The universal data management interface system of claim 1 , the operations further comprising connecting to at least one of an internet, an intranet, or an extranet to access the plurality of databases.
19. The universal data management interface system of claim 1 , wherein the client device manages data directly from the plurality of virtual databases over the link.
20. The universal data management interface system of claim 1 , wherein the client device manipulates data directly from the plurality of virtual databases over the link.
21. The universal data management interface system of claim 1 , wherein each virtual database of the plurality of virtual databases are remote from each other.