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 method comprising:
responsive to a query for one or more data items stored in a database, identifying at least one query operator uses data having a format that is different from a storage model format used at the database to store at least one of the one or more data items, wherein the format and the storage model format differ with respect to a row format and a column format; and
in response to the identifying, converting the format of the data used by the at least one query operator to the storage model format of the at least one of the one or more data items stored in the database.
2. The method of claim 1 further comprising: receiving a query and generating at least one query plan for the received query.
3. The method of claim 2 , wherein the identifying and the converting is performed based on the at least one query plan.
4. The method of claim 1 , wherein the at least one query operator comprises a select operator, a project operator, an aggregate operator, an insert operator, a delete operator, and/or an update operator.
5. The method of 1 , wherein the converting further comprises: converting the format of the data used by the at least one query operator to the column format.
6. The method of 1 , wherein the converting further comprises: converting the format of the data used by the at least one query operator to the row format.
7. The method of claim 1 , wherein the identifying and the converting are performed on a plurality of query plans for the query.
8. The method of claim 7 , further comprising: assessing the plurality of query plans based on a cost-based optimization and/or a syntax base optimization, the assessing including the at least one query operator undergoing the converting of the format of the data used by the at least one query operator to the storage model format of the at least one of the one or more data items stored in the database.
9. The method of claim 1 , wherein a database management system is coupled to the database, and wherein the database management system includes a query processor configured to at least receive the query and identify the at least one query operator using the data having the format that is different from the storage model format used at the database to store at least one of the one or more data items.
10. A system comprising:
at least one processor; and
at least one memory including code which when executed by the at least one processor causes operations comprising:
responsive to a query for one or more data items stored in a database, identifying at least one query operator uses data having a format that is different from a storage model format used at the database to store at least one of the one or more data items, wherein the format and the storage model format differ with respect to a row format and a column format; and
in response to the identifying, converting the format of the data used by the at least one query operator to the storage model format of the at least one of the one or more data items stored in the database.
11. The system of claim 10 further comprising: receiving a query and generating at least one query plan for the received query.
12. The system of claim 11 , wherein the identifying and the converting is performed based on the at least one query plan.
13. The system of claim 10 , wherein the at least one query operator comprises a select operator, a project operator, an aggregate operator, an insert operator, a delete operator, and/or an update operator.
14. The system of 10 , wherein the converting further comprises: converting the format of the data used by the at least one query operator to the column format.
15. The system of 10 , wherein the converting further comprises: converting the format of the data used by the at least one query operator to the row format.
16. The system of claim 10 , wherein the identifying and the converting are performed on a plurality of query plans for the query.
17. The system of claim 16 , further comprising: assessing the plurality of query plans based on a cost-based optimization and/or a syntax base optimization, the assessing including the at least one query operator undergoing the converting of the format of the data used by the at least one query operator to the storage model format of the at least one of the one or more data items stored in the database.
18. The system of claim 10 , wherein a database management system is coupled to the database, and wherein the database management system includes a query processor configured to at least receive the query and identify the at least one query operator using the data having the format that is different from the storage model format used at the database to store at least one of the one or more data items.
19. A non-transitory computer-readable storage medium including code which when executed by at least one processor causes operations comprising:
responsive to a query for one or more data items stored in a database, identifying at least one query operator uses data having a format that is different from a storage model format used at the database to store at least one of the one or more data items, wherein the format and the storage model format differ with respect to a row format and a column format; and
in response to the identifying, converting the format of the data used by the at least one query operator to the storage model format of the at least one of the one or more data items stored in the database.