PROVIDING PARALLEL RESULT STREAMS FOR DATABASE QUERIES
First Claim
Patent Images
1. A method for receiving parallel result streams for database queries, comprising:
- in a client, establishing an initiator session with a database server;
sending a query from the initiator session to the database server;
receiving, at the initiator session, access to a plurality of top-level nodes in a query plan stored on the database server;
establishing a plurality of consumer sessions on the client;
receiving, at the consumer sessions, a plurality of parallel result streams from the top-level nodes, the parallel result streams including query results for the query; and
sending the query results to a plurality of destinations from the consumer sessions.
2 Assignments
0 Petitions
Accused Products
Abstract
A system and method for providing parallel result streams for database queries is provided. The system includes a network including a client, a server, and a database. The client executes an application and sends a query to the server. In response, the server compiles the query to produce a query plan, executes statements in the query plan and sends parallel result streams to the client.
-
Citations
15 Claims
-
1. A method for receiving parallel result streams for database queries, comprising:
-
in a client, establishing an initiator session with a database server; sending a query from the initiator session to the database server; receiving, at the initiator session, access to a plurality of top-level nodes in a query plan stored on the database server; establishing a plurality of consumer sessions on the client; receiving, at the consumer sessions, a plurality of parallel result streams from the top-level nodes, the parallel result streams including query results for the query; and sending the query results to a plurality of destinations from the consumer sessions. - View Dependent Claims (2, 3, 4)
-
-
5. A method for providing parallel result streams for database queries, comprising:
-
receiving a query from a client at a database server; generating a query plan on the database server in response to the query, the query plan including a root node and a plurality of top-level nodes; providing access to the top-level nodes in the query plan to the client; and sending a plurality of result streams from the top-level nodes to the client in parallel. - View Dependent Claims (6, 7)
-
-
8. A system for providing parallel result streams for database queries, comprising:
-
at least one client executing at least one application, the client including a client processor for executing the application and a client storage device for storing instructions for the application; a server in communication with the client over a network, the server including at least one storage device for storing at least one query plan and a processor for executing a plurality of statements in the query plan; and a database in communication with the server; wherein the client is configured to send a query to the server and, in response, the server is configured to compile the query to produce the query plan, to execute the statements in the query plan and to send a plurality of parallel result streams to the client. - View Dependent Claims (9, 10, 11, 12, 13, 14, 15)
-
Specification