APPLICATION QUERY CONTROL WITH COST PREDICTION

• US 20120066554A1
• Filed: 09/09/2010
• Published: 03/15/2012
• Est. Priority Date: 09/09/2010
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Ruiz, Marcelo Lopez
• Application Number:
  US12/878,291
• Publication Number:
  US 20120066554A1
• Time in Patent Office: Days
• US Class Current: 714/48
• CPC Class Codes: G06F 11/0709 in a distributed system consisting of a plurality of standalone computer nodes, e.g. clusters, client-server systems
• CPC Class Codes: G06F 11/0754 by exceeding limits
• CPC Class Codes: G06F 11/3409 for performance assessment
• CPC Class Codes: G06F 2209/504 Resource capping
• CPC Class Codes: G06F 9/5027 the resource being a machine, e.g. CPUs, Servers, Terminals
• CPC Class Codes: Y02D 10/00 Energy efficient computing, e.g. low power processors, power management or thermal management

Abstract

Determining if access should be granted to a data source. A method includes determining resource usage cost of performing an operation on a data source. The method further includes determining if the resource usage cost exceeds a predetermined threshold. When the resource usage cost exceeds a predetermined threshold, the operation is rejected.

Claims

1. In a computing environment, a method of determining if access should be granted to a data source, the method comprising:

determining resource usage cost of performing an operation on a data source;

determining if the resource usage cost of performing the operation exceeds a predetermined threshold; and

when the resource usage cost exceeds a predetermined threshold rejecting the operation.

2. The method of claim 1, wherein determining resource usage cost of performing an operation on a data source comprises using existing cost estimation framework of data storage tiers.

3. The method of claim 1, wherein rejecting the operations includes preventing a request from being sent from a client to a data store.

4. The method of claim 1, wherein rejecting the operation includes causing an error to be emitted.

5. The method of claim 4, wherein emitting an error comprises throwing an exception.

6. The method of claim 1, wherein the resource usage cost is based on usage of at least one of estimated disk I/O operations, CPU operations, number of database rows, network resource utilization or memory utilization.

7. The method of claim 1, wherein the threshold is a static threshold for each resource.

8. The method of claim 1, wherein the threshold is a dynamic or formulaic threshold dependant at least on different usages of different resources.

9. The method of claim 1, wherein the threshold varies according to a privilege level of a user sending a request.

10. The method of claim 1, wherein the threshold varies according to time, including at least one of time of day, week, or year.

11. The method of claim 1, wherein the threshold varies according to load on a system.

12. In a computing environment, a method of determining if access should be granted to a data source, the method comprising:

receiving a request to perform an operation on a data source;

using a cost estimator, determining resource usage cost of performing the operation on the data source, without actually performing the operation on the data source;

sending the resource usage cost to a cost enforcer; and

when the resource usage cost is below a predetermined threshold receiving instructions to perform the operation.

13. The method of claim 12, wherein determining resource usage cost of performing an operation on a data source comprises using existing cost estimation framework of data storage tiers.

14. The method of claim 12, wherein the resource usage cost is based on usage of at least one of estimated disk I/O operations, CPU operations, number of database rows, network resource utilization or memory utilization.

15. The method of claim 12, wherein the threshold is a static threshold for each resource.

16. The method of claim 12, wherein the threshold is a dynamic or formulaic threshold dependant at least on different usages of different resources.

17. The method of claim 12, wherein the threshold varies according to a privilege level of a user sending a request.

18. The method of claim 12, wherein the threshold varies according to time, including at least one of time of day, week, or year.

19. The method of claim 12, wherein the threshold varies according to load on a system.

20. A system for determining if access should be granted to a data source, the system comprising:

a database system configured to receive queries from a client application;

a client system configured to send database queries to the database through a middle tier;

a cost estimator, wherein the cost estimator is configured to determine the cost of performing an operation on a data source, without actually executing the operation, including cost in terms of estimated disk I/O operations, CPU operations or cycles, number of database rows that would be accessed by the operation, network resource utilization, and memory utilization; and

a cost enforcer module at a middle tier system between the database system and the client system, wherein the cost enforcer module is configured to determine, based on a cost provided by the cost estimator and a predetermined threshold, whether an operation should be executed by the database system.