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 non-transitory computer-readable medium storing executable instructions that, in response to being executed, cause a server to perform operations comprising:
generating a visual interface to enable network access to a database, wherein the database comprises a plurality of tables and is maintained remotely from the server;
establishing a network link between the database and a plurality of remote databases remote from the database;
enabling access to the database and execution of a data loading function through the visual interface;
requesting data from one or more of the plurality of remote databases, in response to the data loading function being executed;
receiving the data over the network link, in response to the request, from the one or more of the plurality of remote databases, wherein the data comprise parameters of a data structure; and
loading the data in the database in accordance with the data structure based, at least in part, on the parameters.
2. The non-transitory computer-readable medium of claim 1 , further comprising, instructions that, in response to being executed, cause the server to perform operations further comprising: manipulating the received data to create processed data.
3. The non-transitory computer-readable medium of claim 2 , further comprising, instructions that, in response to being executed, cause the server to perform operations further comprising: presenting the processed data in the visual interface.
4. The non-transitory computer-readable medium of claim 1 , further comprising, instructions that, in response to being executed, cause the server to perform operations further comprising: enabling a sign-in process for the server to access the database.
5. The non-transitory computer-readable medium of claim 1 , further comprising, instructions that, in response to being executed, cause the server to perform operations further comprising: receiving a subset of the database in a format compatible with a reading process.
6. The non-transitory computer-readable medium of claim 1 , further comprising, instructions that, in response to being executed, cause the server to perform operations further comprising: calculating cells in the plurality of tables based on one or more settings of the server.
7. The non-transitory computer-readable medium of claim 1 , further comprising, instructions that, in response to being executed, cause the server to perform operations further comprising: generating a unique sequential number to attach to a name of a table of the plurality of tables.
8. The non-transitory computer-readable medium of claim 1 , further comprising, instructions that, in response to being executed, cause the server to perform operations further comprising: enabling access to the plurality of remote databases via the network link.
9. The non-transitory computer-readable medium of claim 1 , further comprising, instructions that, in response to being executed, cause the server to perform operations further comprising:
enabling one or more users to access and modify the database over the network; and
sending a message indicating an occurrence of the modification of the database to the one or more users.
10. A method comprising:
generating, by a server, a visual interface to enable network access to a database, wherein the database comprises a plurality of tables and is maintained remotely from the server;
establishing, by the server, a network link between the database and a plurality of remote databases remote from the database;
enabling, by the server, access to the database and execution of a data loading function through the visual interface;
requesting, by the server, data from one or more of the plurality of remote databases, in response to the data loading function being executed;
receiving, by the server, the data over the network link, in response to the request, from the one or more of the plurality of remote databases, wherein the data comprise parameters of a data structure; and
loading, by the server, the data in the database in accordance with the data structure based, at least in part, on the parameters.
11. The method of claim 10 , further comprising, manipulating, by the server, the received data to create processed data.
12. The method of claim 11 , further comprising, presenting, by the server, the processed data in the visual interface.
13. The method of claim 10 , further comprising, enabling, by the server, a sign-in process for the server to access the database.
14. The method of claim 10 , further comprising, receiving, by the server, a subset of the database in a format compatible with a reading process.
15. The method of claim 10 , further comprising, calculating, by the server, cells in the plurality of tables based on one or more settings of the server.
16. The method of claim 10 , further comprising:
generating a unique sequential number to attach to a name of a table of the plurality of tables.
17. A server, comprising:
a memory; and
a processor coupled to the memory, the processor configured to:
generate a visual interface to enable network access to a database, wherein the database comprises a plurality of tables and is maintained remotely from the server;
establish a network link between the database and a plurality of remote databases remote from the database;
enable access to the database and execution of a data loading function through the visual interface;
request data from one or more of the plurality of remote databases, in response to the data loading function being executed;
receive the data over the network link, in response to the request, from the one or more of the plurality of remote databases, wherein the data comprise parameters of a data structure; and
load the data in the database in accordance with the data structure based, at least in part, on the parameters.
18. The server of claim 17 , wherein the processor is further configured to:
generate a unique sequential number to attach to a name of a table of the plurality of tables.
19. The server of claim 17 , wherein the processor is further configured to:
manipulate the received data to create processed data.
20. The server of claim 19 , wherein the processor is further configured to:
present the processed data in the visual interface.