Workload balancing in a distributed database
US9542429B2 · kind B2 · utility
Assignee
Inventors
Key dates
| Filing date | Feb 3, 2014 |
| Grant date | Jan 10, 2017 |
| Priority date | — |
| Expiry date | Jul 12, 2034 |
Classification
- Technology area (CPC G)Physics
- CPC primaryG06F16/27
- WIPO fieldComputer technology
- WIPO sectorElectrical engineering
Abstract
A distributed database management system balances the load on query boundaries and to achieve a more evenly balanced load. The system includes two or more query processors with a common data source. A database client manages a transaction including two or more queries. A transaction analyzer checks if a transaction can be processed by more than one query processor. A query processor optimizer locates the optimum query processor for each query in the transaction based on workload of each query processor, while a workload balancer directs each query to the optimum query processor if the transaction can be processed by more than one query processor. This approach is particularly well suited to a clustered database environment that includes query processor nodes that work off a shared disk to provide database access to clients that connect to the node.
Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.