Query dispatch and execution architecture
First Claim
Patent Images
1. A computer data system having a query dispatch and execution architecture, the system comprising:
- one or more processors;
computer readable storage coupled to the one or more processors, the computer readable storage having stored thereon instructions that, when executed by the one or more processors, cause the one or more processors to perform operations including;
sending a request for a remote query processor from a client computer to a remote query dispatcher executing on a query server computer, wherein the request includes parameters for one or more of configuring the remote query processor or an operating environment for the remote query processor;
attempting, at the remote query dispatcher, to allocate the operating environment for the remote query processor and to start execution of the remote query processor on the query server computer;
when the remote query processor is started, performing operations including;
providing one of zero or more client classes to the remote query processor;
registering the remote query processor with the remote query dispatcher;
providing the client computer with an address assignment of one of the remote query processor or a proxy machine;
connecting from the client computer to the remote query processor;
transmitting a database query from the client computer to the remote query processor, the database query referencing a table in a database; and
receiving at the client computer a response to the database query from the remote query processor, wherein processing of the database query is executed partly by the client computer and partly by the remote query processor;
receiving, at the remote query dispatcher, a second request for a second remote query processor, wherein the second request includes second parameters for configuring the second remote query processor and a second operating environment for the second remote query processor, the second parameters including one or more of one or more override classes or one or more alternative classpaths;
attempting, at the remote query dispatcher, to allocate the second operating environment for the second remote query processor and to start execution of the second remote query processor on the query server computer, the remote query dispatcher specifying one or more of the one or more override classes or the one or more alternative classpaths to be used when starting the second remote query processor such that the second remote query processor runs a different code version than that run by the remote query processor.
2 Assignments
0 Petitions
Accused Products
Abstract
Described are methods, systems and computer readable media for providing a query dispatch and execution architecture.
-
Citations
24 Claims
-
1. A computer data system having a query dispatch and execution architecture, the system comprising:
-
one or more processors; computer readable storage coupled to the one or more processors, the computer readable storage having stored thereon instructions that, when executed by the one or more processors, cause the one or more processors to perform operations including; sending a request for a remote query processor from a client computer to a remote query dispatcher executing on a query server computer, wherein the request includes parameters for one or more of configuring the remote query processor or an operating environment for the remote query processor; attempting, at the remote query dispatcher, to allocate the operating environment for the remote query processor and to start execution of the remote query processor on the query server computer; when the remote query processor is started, performing operations including; providing one of zero or more client classes to the remote query processor; registering the remote query processor with the remote query dispatcher; providing the client computer with an address assignment of one of the remote query processor or a proxy machine; connecting from the client computer to the remote query processor; transmitting a database query from the client computer to the remote query processor, the database query referencing a table in a database; and receiving at the client computer a response to the database query from the remote query processor, wherein processing of the database query is executed partly by the client computer and partly by the remote query processor; receiving, at the remote query dispatcher, a second request for a second remote query processor, wherein the second request includes second parameters for configuring the second remote query processor and a second operating environment for the second remote query processor, the second parameters including one or more of one or more override classes or one or more alternative classpaths; attempting, at the remote query dispatcher, to allocate the second operating environment for the second remote query processor and to start execution of the second remote query processor on the query server computer, the remote query dispatcher specifying one or more of the one or more override classes or the one or more alternative classpaths to be used when starting the second remote query processor such that the second remote query processor runs a different code version than that run by the remote query processor. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A method for improving performance of a computer data system through control of a query dispatch and execution architecture, the method comprising:
-
sending a request for a remote query processor from a client computer to a remote query dispatcher executing on a query server computer, wherein the request includes parameters for configuring the remote query processor; attempting, at the remote query dispatcher, to allocate an operating environment for the remote query processor and to start execution of the remote query processor on the query server computer; when the remote query processor is started, performing operations including; providing one of zero or more client classes to the remote query processor; transmitting a database query to the remote query processor, the database query referencing a table in a database; and receiving a response to the database query from the remote query processor, wherein the remote query processor is configured to stream the response to a predetermined location; receiving, at the remote query dispatcher, a second request for a second remote query processor, wherein the second request includes second parameters for configuring the second remote query processor, the second parameters including one or more of one or more override classes or one or more alternative classpaths; and attempting, at the remote query dispatcher, to allocate a second operating environment for the second remote query processor, the remote query dispatcher specifying one or more of the one or more override classes or the one or more alternative classpaths to be used when starting the second remote query processor. - View Dependent Claims (10, 11, 12, 13, 14, 15, 16, 17)
-
-
18. A nontransitory computer readable medium having stored thereon software instructions that, when executed by one or more processors, cause the processors to perform operations including:
-
attempting, at a remote query dispatcher, to allocate an operating environment for a remote query processor and to start execution of a remote query processor on a query server computer; when the remote query processor is started, performing operations including; providing one of zero or more client classes to the remote query processor; transmitting a database query to the remote query processor, the database query referencing a table in a database; and receiving a response to the database query from the remote query processor, wherein the database query runs as a privileged user to access confidential data not visible to the client computer; receiving, at the remote query dispatcher, a second request for a second remote query processor, wherein the second request includes one or more of one or more override classes or one or more alternative classpaths; and attempting, at the remote query dispatcher, to allocate a second operating environment for the second remote query processor, the remote query dispatcher specifying one or more of the one or more override classes or the one or more alternative classpaths to be used when starting the second remote query processor such that the second remote query processor runs a different code version than that run by the remote query processor. - View Dependent Claims (19, 20, 21, 22, 23, 24)
-
Specification