Patent ID: 9626444
Date: 2017-04-18
CPC Classifications: G06F,H04L

Claim:
1. A method for continuously blocking query result data for a remote query comprising: opening a first connection, using a communications network, between a database server and a client; opening one or more secondary connections, using the communications network, between the database server and the client, based on the database server supporting a continuous block fetch protocol, wherein each of the one or more secondary connections corresponds to a separate cursor-based fetch query, and wherein the one or more secondary connections and the first connection belong to a same transaction, share session data of the same transaction, and comprises a single session between the database server and the client; for each of the one or more secondary connections, receiving, by the database server, the corresponding separate cursor-based fetch query; in response to the received separate cursor-based fetch query, sending, by the database server, to the client, continuous blocks of result data using the secondary connection corresponding to the separate cursor-based fetch query until the separate cursor-based fetch query is exhausted, and wherein the database server adheres to network congestion protocols in pacing the sending the continuous blocks of result data; and closing the secondary connection corresponding to the separate cursor-based fetch query when the continuous blocks of result data is exhausted.