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 system comprising:
a processor; and
a memory that stores instructions that, when executed by the processor, cause the processor to perform operations comprising:
defining application types associated with applications supported by an external database of a plurality of external databases, the application types comprising tasks performed by the applications,
associating the application types with the external database and other external databases of the plurality of external databases,
executing a predefined query of the plurality of external databases in response to receiving a login from a user,
tracking how long the predefined query took to execute,
calculating a statistic based on how long the predefined query took to execute,
receiving, from the user, a query associated with an application type of the application types, and
executing the query on the database and the other databases of the plurality of databases associated with the application type of the application types.
2. The system of claim 1 , wherein the memory stores further instructions that, when executed by the processor, cause the processor to perform operations comprising storing a representation of a shared query created by the user for use by a further user.
3. The system of claim 1 , wherein the memory stores further instructions that, when executed by the processor, cause the processor to perform operations comprising storing a record associated with the user, the record associated with the user comprising permissions specifying shared queries created by other users that the user is authorized to use.
4. The system of claim 1 , wherein the memory stores further instructions that, when executed by the processor, cause the processor to perform operations comprising storing a user profile associated with the user, the user profile comprising viewing privileges specifying content stored in the plurality of external databases that is viewable by the user.
5. The system of claim 1 , wherein the memory stores further instructions that, when executed by the processor, cause the processor to perform operations comprising storing a user profile associated with the user, the user profile associated with the user comprising override information that specifies an upper limit on resources of the plurality of external databases allowed to the user.
6. The system of claim 1 , wherein the memory stores further instructions that, when executed by the processor, cause the processor to perform operations comprising:
tracking queries used by the user to execute on the plurality of external databases; and
utilizing the queries tracked to determine a particular query associated with a crash of an external database of the plurality of external databases.
7. The system of claim 1 , wherein the memory stores further instructions that, when executed by the processor, cause the processor to perform operations comprising storing a user profile associated with the user, the user profile associated with the user comprising types of operations associated with content stored in the plurality of external databases permitted to be performed by the user.
8. The system of claim 7 , wherein the types of operations associated with the content stored in the plurality of external databases permitted to be performed by the user are based on at least one of a role of the user, seniority of the user, or a skill level of the user.
9. A method comprising:
defining, by a processor, application types associated with applications supported by an external database of a plurality of external databases, the application types comprising tasks performed by the applications;
associating, by the processor, the application types with the external database and other external databases of the plurality of external databases;
executing, by the processor, a predefined query of the plurality of external databases in response to receiving a login from a user;
tracking, by the processor, how long the predefined query took to execute;
calculating, by the processor, a statistic based on how long the predefined query took to execute;
receiving, at the processor from the user, a query associated with an application type of the application types, and
executing, by the processor, the query on the database and the other databases of the plurality of databases associated with the application type of the application types.
10. The method of claim 9 , further comprising storing a representation of a shared query created by the user for use by a further user.
11. The method of claim 9 , further comprising storing a record associated with the user, the record associated with the user comprising permissions specifying shared queries created by other users that the user is authorized to use.
12. The method of claim 9 , further comprising:
tracking queries used by the user to execute on the plurality of external databases; and
utilizing the queries tracked to determine a particular query associated with a crash of an external database of the plurality of external databases.
13. The method of claim 9 , further comprising storing a user profile associated with the user, the user profile comprising viewing privileges specifying content stored in the plurality of external databases that is viewable by the user, types of operations associated with content stored in the plurality of external databases permitted to be performed by the user, and override information that specifies an upper limit on resources of the plurality of external databases allowed to the user.
14. The method of claim 13 , wherein the types of operations associated with the content stored in the plurality of external databases permitted to be performed by the user are based on at least one of a role of the user, seniority of the user, or a skill level of the user.
15. A non-transitory computer-readable storage medium having computer-executable instructions stored thereon which, when executed by a computer, cause the computer to perform operations comprising:
defining application types associated with applications supported by an external database of a plurality of external databases, the application types comprising tasks performed by the applications;
associating the application types with the external database and other external databases of the plurality of external databases;
executing a predefined query of the plurality of external databases in response to a receiving a login from a user;
tracking how long the predefined query took to execute;
calculating a statistic based on how long the predefined query took to execute;
receiving a query associated with an application type of the application types, and
executing the query on the database and the other databases of the plurality of databases associated with the application type of the application types.
16. The non-transitory computer-readable storage medium of claim 15 , having further computer-executable instructions stored thereon which, when executed by the computer, cause the computer to perform operations comprising storing a record associated with the user, the record associated with the user comprising permissions specifying shared queries created by other users that the user is authorized to use.
17. The non-transitory computer-readable storage medium of claim 15 , having further computer-executable instructions stored thereon which, when executed by the computer, cause the computer to perform operations comprising storing a user profile associated with the user, the user profile comprising viewing privileges specifying content stored in the plurality of external databases that is viewable by the user, types of operations associated with content stored in the plurality of external databases permitted to be performed by the user, and override information that specifies an upper limit on resources of the plurality of external databases allowed to the user.