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:
receiving a query for data items stored in a database, wherein the query is associated with a query plan; forming a query operator including data having an operator format different from a storage format of at least one of the data items stored in the database; and converting the operator format the storage, wherein a difference between the operator format and the storage format is a row-format or a column-format.