Browse Prior Art Database

Leverage remote query servers for aggregate queries to reduce network bandwidth during data transmission and centralized processing load

IP.com Disclosure Number: IPCOM000236929D
Publication Date: 2014-May-22
Document File: 1 page(s) / 35K

Publishing Venue

The IP.com Prior Art Database

Abstract

Disclosed is a method that reduces the traffic over the network as well as the amount of Central Processing Unit (CPU) and disk resources required to process a large number of records for a single result set.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 100% of the total text.

Page 01 of 1

Leverage remote query servers for aggregate queries to reduce network bandwidth during data transmission and centralized processing load

Excessive use of network bandwidth, Central Processing Unit (CPU), and disk resources during query distributed database systems is a problem.

The novel contribution is a method to increase overall scalability of a distributed database architecture . The approach is to perform as much work as possible on distributed hosts reduce the centralized workload.

The method reduces the traffic over the network as well as the amount of CPU and disk resources required to process a large number of records for a single result set.

To implement the method in a preferred embodiment , a query is sent to the centralized query server (e.g., proxy server). The same query then sent to all connected remote query servers in distributed database system. As records are read from disk, the criteria are evaluated as per current methods. If it matches, then, instead of being sent back to the proxy server per current methods, the new method is to keep it locally in an in-memory cursor until it reaches a preconfigured "safe" threshold. Once said threshold is reached, the in-memory cursor is transmitted back to the proxy server in whole form to be reconciled with the other results.

1