Invention Grant
- Patent Title: System and method for SQL query load balancing
- Patent Title (中): 用于SQL查询负载平衡的系统和方法
-
Application No.: US12619540Application Date: 2009-11-16
-
Publication No.: US08176037B2Publication Date: 2012-05-08
- Inventor: Patrick Yu
- Applicant: Patrick Yu
- Applicant Address: US TX Round Rock
- Assignee: Dell Products L.P.
- Current Assignee: Dell Products L.P.
- Current Assignee Address: US TX Round Rock
- Agency: Baker Botts L.L.P.
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
Systems and methods for SQL query load balancing are disclosed. A method may include establishing a ranking scheme, assigning a rank to an SQL query from the ranking scheme based on a plurality of rank assignment parameters, determining a threshold rank based on a plurality of gathered operational characteristics, comparing the assigned rank to the threshold rank, and, if the assigned rank is greater than the threshold rank, executing the SQL query on a database server. Otherwise, if the assigned rank is not greater than the threshold rank, executing the SQL query on a centralized storage system.
Public/Granted literature
- US20110119251A1 System and Method for SQL Query Load Balancing Public/Granted day:2011-05-19
Information query