System for parallel processing of complex read-only database queries using master and slave central processor complexes

A system for parallel processing of complex read-only queries comprising:

• a) a front-end processor comprising:
• i) an interface means for identifying said complex read-only queries and routing them to a query processor complex, said interface means routing queries not identified as complex read-only queries to a local database manager means;
• ii) said local database manager means for processing database queries and updating a database, said local database manager means comprising import/update function processor means for performing database import/update functions on said database non-concurrently with complex read-only queries of said database by said query processor complex;
• iii) at least two connection paths:
• a first path for transporting, to said query processor complex, said read-only complex queries identified by said interface means, and a second path for communication with said database by said import/update function means;
• iv) external operations command processor means for ensuring the integrity of said read-only complex queries in response to a command procedure issued by a system operator, wherein said command processor ensures the integrity of said read-only complex queries by disabling their execution by a query processor database manager means prior to enabling said database import/update functions;
• b) said query processor complex comprising:
• i) a multi-CPU processor (MP), connected to said front-end processor by said first path and connected to said database by a channel means;
• ii) splitter means, executable on said MP, for splitting one of said read-only complex queries into two or more query elements, said splitter means further comprising a reassembly means for reassembling a set of results of said two or more query elements into a combined final result;
• iii) scheduler means, executable on said MP, for scheduling each of said two or more query elements for processing by said MP;
• iv) said query processor database manager means, executable on said MP, for processing any of said two or more query elements;
• c) a data repository means for storing said database, said data repository means being connected to said MP by said channel means, and connected to said front-end processor by said second path.

A system for parallel processing of complex read-only queries comprising:

• a) a front-end processor comprising:
• i) an interface means for identifying said complex read-only queries and routing them to a query processor complex, said interface means routing queries not identified as complex read-only queries to a local database manager means;
• ii) said local database manager means for processing database queries and updating a database, said local database manager means comprising import/update function processor means for performing database import/update functions on said database non-concurrently with complex read-only queries of said database by said query processor complex;
• iii) a first path for transporting, to a master central processor complex (CPC), said read-only complex queries identified by said interface means, and a second path for communicating with said database by said import/update function means;
• iv) external operations command processor means for ensuring the integrity of said read-only complex queries in response to a command procedure issued by a system operator, wherein said command processor ensures the integrity of said read-only complex queries by disabling their execution by a slave processor database manager means prior to enabling said database import/update functions;
• b) said query processor complex comprising:
• i) said master CPC, controlled by an operating system and executing a database management system, said master CPC connected to said front-end processor by said first path, connected to one or more slave CPC's by a first master channel means, and connected to said database by a second master channel means;
• ii) splitter means executable on said master CPC for splitting one of said read only complex queries into two or more query elements, said splitter means further comprising a reassembly means for reassembling a set of results of said two or more query elements into a combined final result;
• iii) scheduler means, for scheduling each of said two or more query elements for processing by said one of one or more slave CPCs;
• iv) said one or more of said slave CPCs, each one of said slave CPCs controlled by an operating system and each one of said slave CPCs comprising first slave channel means for communicating with said master CPC, and second slave channel means for accessing any portion of said database;
• v) said slave processor database manager means, executable on each of said one or more of said slave CPCs, for processing any of said two or more query elements;
• c) a data repository means for storing said database, said data repository means being connected to said master CPC by said second master channel means, connected to said slave CPCs by said second slave channel means, and connected to said front-end processor by said second path.