METHOD, DEVICE AND SYSTEM FOR RETRIEVING DATA FROM A VERY LARGE DATA STORE

1 . A method of deploying data from an operational database with multi-version-concurrency-control, the method comprising:

a processor executing instructions stored in a non-transitory computer memory for deriving a single SQL query statement for retrieving large amounts of related, heterogeneous data as output where the large amounts of data are internally self-consistent;

transforming and decorating the single SQL query output to obtain deployment data; and

transferring the deployment data to the deployment target.

2 . The method of claim 1 , further comprising: verifying the correctness of the SQL statement output and further transforming and decorating the SQL statement output based on the verification.

3 . The method of claim 1 , further comprising:

optimizing performance of execution of the single SQL query statement by iteratively modifying at least one of:

the order of columns in rows of data returned by the SQL statement; and

the ordering of the rows of data returned by the SQL statement.

4 . The method of claim 1 , where the database can be undergoing updates during the time the deployment occurs.

5 . The method of claim 1 , wherein deriving a single SQL statement further comprises:

determining an output specification of a SQL Select set using a processor executing computer readable instructions stored in a non-transitory computer readable medium, the SQL Select set comprising:

at least one homogeneous tuple wherein all tuples in each SQL Select set have an identical schema of column names and column meanings; and

an ordering parameter per tuple;

performing a UNION of the tuples; and

ordering an output specification first by an order parameter in a first column and then by other columns.

6 . A computer-based system for deploying data comprising:

an operational database with Multi-Version-Concurrency-Control stored on at least one server;

a tool for deriving a single SQL query statement for retrieving large amounts of related, heterogeneous data where the large amounts of data are internally self-consistent;

a process for executing the single SQL query statement for retrieving large amounts of related, heterogeneous data as output;

a process for transforming and decorating the single SQL query output to obtain deployment data; and

a process for transferring the deployment data to the deployment target.

7 . A computer program product for iteratively deriving a single SQL query statement for retrieving large amounts of related, heterogeneous data from an operational database with Multi-Version-Concurrency-Control where the large amounts of data are internally self-consistent, the tool comprising:

computer readable instructions stored on a non-transitory computer readable memory and executable by a processor, comprising:

a user interface for inputting and editing sets of select clauses, tables, conditions and ordering;

compiling a single SQL statement;

querying the operational database;

displaying the database output on a visual medium;

translating the database output;

displaying the translated output on a visual medium;

storing the single SQL statement to a non-transitory computer readable medium.

8 . The computer program product of claim 7 , further comprising transferring the translated output to a deployment target.