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 method implemented using a universal data management interface (UDMI) system, the method comprising:
a processing system that executes instructions to generate a visual interface through which multiple users can concurrently connect to multiple databases; and
the multiple users can concurrently access data within each of the multiple databases, the processing system comprising:
a table manager configured to manage and manipulate data included in the multiple databases;
a report manager configured to manage and manipulate reports generated based on the data included in the multiple databases;
an administrator's area configured to manage and manipulate access to the multiple databases; and
a relation manager configured to manage and manipulate relations among the tables included in the multiple databases.
2. The method of claim 1 , wherein executing instructions to connect to multiple database comprises establishing a link to the databases; and receiving and sending information via the link.
3. The method of claim 1 , wherein executing instructions includes executing instructions using a database management language.
4. The method of claim 1 , wherein the database comprises one of: a database management system, an Oracle system, a MSSQL Server, a SyBase system, a Informix system, DB2-based system, dBase-based system, SQL-based system, mSQL-based system, mySQL-based system a flat file, xml file, and file directory.
5. The method of claim 1 , wherein the database comprises one of a remote database and a local database.
6. The method of claim 1 , wherein: the database includes one or more databases.
7. The method of claim 6 , wherein the method for the multiple users to access data comprises a method for the multiple users to access one or more of the databases.
8. The method of claim 1 , further comprising synchronizing the UDMI with the database.
9. The method of claim 1 , wherein the method for the multiple users to access data includes a method for the multiple users to access data using the database management language.
10. The method of claim 1 , wherein the method for the multiple users to access data includes providing user access information; and passing an initial access procedure.
11. The method of claim 10 , wherein the database is accessed through a database interface.
12. The method of claim 1 , wherein the method for the multiple users to access data comprises a method for the multiple users to access data via a network enabled device.
13. The method of claim 12 , wherein the network enabled device includes a computer, personal digital assistant, and cellular telephone.
14. The method of claim 1 , further comprising a sign-up process to allow users to sign-up to access the database.
15. The method of claim 1 , further comprising at least one of managing and manipulating data in the database subsequent to the multiple users accessing the data.
16. The method of claim 15 , wherein managing and manipulating comprise at least one of viewing and modifying data in the database.
17. The method of claim 15 , wherein managing and manipulating comprises managing and manipulating using the database management language.
18. The method of claim 15 , wherein managing and manipulating comprises managing and manipulating via software that operates over a network.
19. The method of claim 15 , wherein managing and manipulating comprise managing and manipulating data in the multiple database.
20. The method of claim 1 , further comprising a method for the multiple users to access the database over a network.
21. The method of claim 20 , wherein the network comprises one of internet, intranet and extranet.
22. The method of claim 1 , wherein
the table manager comprises creating a table, deleting a table, accessing a table, updating data cells; creating rows and columns; deleting rows and columns; renaming, resizing and reordering columns; searching, sorting, importing and exporting data;
the report manager comprises creating a report, deleting a report, accessing a report, creating and deleting columns; changing report parameters; renaming, resizing and reordering columns; sorting and exporting report data;
the administrator's area comprises creating, updating and deleting users and access privileges; and
the relation manager comprises creating, updating and deleting relations.
23. An apparatus comprising:
a processor configured to:
execute instructions to generate a visual interface through which multiple users can concurrently connect to multiple databases; and the multiple users can concurrently access data within each of the multiple databases; the processing system comprising:
a table manager configured to manage and manipulate data included in the multiple databases;
a report manager configured to manage and manipulate reports generated based on the data included in the multiple databases;
an administrator's area configured to manage and manipulate access to the multiple databases; and
a relation manager configured to manage and manipulate relations among the tables included in the multiple databases.
24. The apparatus of claim 23 , wherein
the table manager is further configured to create a table, delete a table, access a table, update data cells; create rows and columns; delete rows and columns; rename, resize and reorder columns; search sort, import and export data;
the report manager is further configured to create a report, delete a report, access a report, create and delete columns; change report parameters; rename, resize and reorder columns; sort and export report data;
the administrator's area is further configured to create, update and delete users and access privileges; and
the relation manager is further configured to create, update and delete relations.
25. A universal data management interface (UDMI) system, the UMDI configured to: execute instructions to generate a visual interface through which multiple users can concurrently connect to multiple databases; and the multiple users can concurrently access data within each of the multiple databases; the universal data management interface system comprising:
a table manager configured to manage and manipulate data included in the multiple databases;
a report manager configured to manage and manipulate reports generated based on the data included in the multiple databases;
an administrator's area configured to manage and manipulate access to the multiple databases, and
a relation manager configured to manage and manipulate relations among the tables included in the multiple databases.
26. The universal data management interface (UDMI) system of claim 25 , wherein
the table manager is further configured to create a table, delete a table, access a table, update data cells; create rows and columns; delete rows and columns; rename, resize and reorder columns; search, sort, import and export data;
the report manager is further configured to create a report, delete a report, access a report, create and delete columns; change report parameters; rename, resize and reorder columns; sort and export report data;
the administrator's area is further configured to create, update and delete users and access privileges; and
the relation manager is further configured to create, update and delete relations.