Web-enabled database access tools
View Patent ↗This description provides tools and techniques for Web-enabled database access tools. These tools may provide systems that include database access tools that provide at least one level of abstraction between external databases and users of the access tools. The systems may also include one or more internal databases maintained by the tool, with the internal database storing respective login information associated with the users. The login information may enable the users to access the tool without providing direct access to the external databases.
1. A non-transitory computer-readable storage medium having computer-executable instructions stored thereon which, when executed by a computer, cause the computer to perform a method comprising:
defining application types associated with applications supported by a database of a plurality of databases, the application types comprising tasks performed by the applications;
associating the application types with the database and other databases of the plurality of databases;
receiving a query associated with an application type of the application types from a first user;
storing the query for sharing with a plurality of users;
creating a link for accessing the query;
storing the link in a user profile associated with a second user;
receiving a first input from the second user selecting the link;
in response to receiving the first input selecting the link, directing the second user to the query;
receiving a second input from the second user for executing the query;
executing the query on the database and the other databases of the plurality of databases associated with the application type of the application types; and
providing a first result of the query to the second user.
2. The non-transitory computer-readable storage medium of claim 1 , further comprising instructions that cause the computer perform a method comprising:
receiving a third input selecting the query from a third user, wherein viewing privileges associated with the third user are different from viewing privileges associated with the second user;
executing the query on a portion of the database and the other databases of the plurality of databases based on the viewing privileges of the third user; and
providing a second result of the query to the third user.
3. The non-transitory computer-readable storage medium of claim 1 , wherein the instructions for providing the first result to the second user include instructions for providing, to the second user, metadata stored within the databases.
4. The non-transitory computer-readable storage medium of claim 1 , wherein the user profile specifies whether the second user is permitted to execute the query, and if the second user is permitted to execute the query, specifies a maximum number of rows that may be returned to the second user in response to executing the query.
5. The non-transitory computer-readable storage medium of claim 1 , further comprising instructions that cause the computer to perform a method comprising defining a user group record corresponding to a group of users that includes the second user, wherein the user group record specifies whether members of the group may execute the query.
6. The non-transitory computer-readable storage medium of claim 1 , further comprising instructions that cause the computer to perform a method comprising defining a query group record corresponding to a group of queries that includes the query, wherein the query group record specifies which users may execute queries within the group of queries.
7. A computer-implemented method comprising:
defining application types associated with applications supported by a database of a plurality of databases, the application types comprising tasks performed by the applications;
associating the application types with the database and other databases of the plurality of databases;
receiving a query associated with an application type of the application types from a first user;
storing the query for sharing with a plurality of users;
creating a link for accessing the query;
storing the link in a user profile associated with a second user;
receiving a first input from the second user selecting the link;
in response to receiving the first input selecting the link, directing the second user to the query;
receiving, from the second user, a second input for executing the query;
executing the query on the database and the other databases of the plurality of databases associated with the application type of the application types; and
providing a first result of the query to the second user.
8. The method of claim 7 , further comprising:
receiving a third input selecting the query from a third user, wherein viewing privileges associated with the third user are different from viewing privileges associated with the second user;
executing the query on a portion of the database and the other databases of the plurality of databases based on the viewing privileges of the third user; and
providing a second result of the query to the third user.