Processing database queries using format conversion
Devices, methods and systems for processing database queries formatted differently than the database storage model being queried are disclosed. Processing database queries independent of the storage model of the queried database may be performed by receiving a query for one or more data items stored in a database, determining whether to use at least one query operator that uses data having a format different from the storage model format of at least one of one or more data items stored in the database and converting the format of the data used by the at least one query operator to a format that matches the storage model format of at least one of one or more data items stored in the database. Related systems, methods, and articles of manufacture are also described.
1. A computer program product, tangibly embodied in a non-transitory machine-readable medium, the computer program product containing instructions to configure a data processing apparatus to perform operations comprising:
in response to a query operator using data having a format different from a storage model format of one or more data items stored in a database, converting the format of the data used by the query operator to another format that matches the storage model format of the one or more data items, wherein a difference between the format and the storage model format before the converting is a row-format or a column-format.
2. The computer program product of claim 1 , further comprising:
receiving a query for the one or more data items stored in a database.
3. The computer program product of claim 1 , wherein the converting further comprises:
converting the format of the data used by a row query operator to the column format.
4. The computer program product of claim 1 , wherein the converting further comprises:
converting the format of the data used by a column query operator to the row format.
5. A system comprising:
a processor; and
a memory, the processor and the memory configured to provide operations comprising:
in response to a query operator using data having a format different from a storage model format of one or more data items stored in a database, converting the format of the data used by the query operator to another format that matches the storage model format of the one or more data items, wherein a difference between the format and the storage model format before the converting is a row-format or a column-format.
6. The system of claim 5 , further comprising:
receiving a query for the one or more data items stored in a database.
7. The system of claim 5 , wherein the converting further comprises:
converting the format of the data used by a row query operator to the column format.
8. The system of claim 5 , wherein the converting further comprises:
converting the format of the data used by a column query operator to the row format.
9. A computer implemented method comprising:
identifying a query operator using data having a format different from a storage model format of one or more data items stored in a database; and
in response to the query operator using data having the format different from the storage model format of the one or more data items stored in the database, converting, by at least one processor, the format of the data used by the query operator to another format that matches the storage model format of the one or more data items, wherein a difference between the format and the storage model format before the converting is a row-format or a column-format.
10. The computer implemented method of claim 9 , further comprising:
receiving a query for the one or more data items stored in a database.
11. The computer implemented method of claim 9 , wherein the converting further comprises:
converting the format of the data used by a row query operator to the column format.
12. The computer implemented method of claim 9 , wherein the converting further comprises:
converting the format of the data used by a column query operator to the row format.