Single system image via shell database
AssigneeMicrosoft Technology Licensing, LLC
InventorsEric R. Robinson, Alan D. Halverson, Rimma V. Nehme, Srinath Shankar
Life of this patent
Estimating the term…
Abstract
A single system image is provided for a parallel data warehouse system by exposing a shell database within a database management system comprising metadata and statistics regarding externally stored data. Further, functionality of the database management system can be exploited to perform pre-execution tasks. In one instance, one or more execution plans can be generated by the database management system for an input command and subsequently employed to generate a distributed execution plan.
Claims19
A computer-implemented method, comprising:
- providing a single system image with a shell database within a database management system, the shell database is devoid of user data and consists of metadata and statistics regarding the user data stored external to the shell database;
- and invoking, by a processor, functionality afforded by the database management system to perform one or more pre-execution tasks associated with a received input command including generating one or more single-node execution plans based on the input command and the metadata and statistics of the shell database.
A system, comprising:
- a first component configured to generate one or more single-node execution plans based on an input command and a shell database within a database management system, the shell database is devoid of user data and consists of metadata and statistics regarding user data stored external to the shell database;
- and
- a second component configured to generate a distributed execution plan based on the one or more single-node execution plans.
A computer-readable storage medium having instructions stored thereon that enable at least one processor to perform a method upon execution of the instructions, the method comprising:
- generating a plurality of single-node execution plans based on an input command and a shell database within a database management system, the shell database is devoid of user data and consists of metadata and statistics regarding the user data stored external to the shell database on a plurality of distributed compute nodes;
- generating a distributed execution plan outside the database management system based on the plurality of single-node execution plans;
- initiating execution of the distributed execution plan across at least a subset of the plurality of compute nodes;
- and
- returning one or more results of the execution.
Dependencies are inferred from the claim text.