AUTOMATED DATA CONVERSION AND ROUTE TRACKING IN DISTRIBUTED DATABASES
First Claim
1. A method, comprising:
- determining whether a data type associated with a received logical table definition associated with a database query within a distributed database system differs from a data type associated with a local logical table definition;
performing a data conversion on data retrieved from a locally-stored physical table referenced by the local logical table definition in response to determining that the data type associated with the received logical table definition differs from the data type associated with a local logical table definition;
creating local data conversion information identifying the data conversion performed on the retrieved data in response to performing the data conversion; and
forwarding at least one of the retrieved data and the converted data with the created local data conversion information to at least one of a distributed database node and an application-level module.
1 Assignment
0 Petitions
Accused Products
Abstract
A determination is made as to whether a data type associated with a received logical table definition associated with a database query within a distributed database system differs from a data type associated with a local logical table definition. A data conversion is performed on data retrieved from a locally-stored physical table referenced by the local logical table definition in response to determining that the data types differ. Local data conversion information is created identifying the data conversion performed on the retrieved data in response to performing the data conversion. At least one of the retrieved data and the converted data with the created local data conversion information is forwarded to at least one of a distributed database node and an application-level module. This abstract is not to be considered limiting, since other embodiments may deviate from the features described in this abstract.
69 Citations
20 Claims
-
1. A method, comprising:
-
determining whether a data type associated with a received logical table definition associated with a database query within a distributed database system differs from a data type associated with a local logical table definition; performing a data conversion on data retrieved from a locally-stored physical table referenced by the local logical table definition in response to determining that the data type associated with the received logical table definition differs from the data type associated with a local logical table definition; creating local data conversion information identifying the data conversion performed on the retrieved data in response to performing the data conversion; and forwarding at least one of the retrieved data and the converted data with the created local data conversion information to at least one of a distributed database node and an application-level module. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A system, comprising:
-
a memory adapted to store data conversion and route tracking information; and a processor programmed to; determine whether a data type associated with a received logical table definition associated with a database query within a distributed database system differs from a data type associated with a local logical table definition; perform a data conversion on data retrieved from a locally-stored physical table referenced by the local logical table definition in response to determining that the data type associated with the received logical table definition differs from the data type associated with a local logical table definition; create local data conversion information identifying the data conversion performed on the retrieved data in response to performing the data conversion; store the local data conversion information to the memory; and forward at least one of the retrieved data and the converted data with the created local data conversion information to at least one of a distributed database node and an application-level module. - View Dependent Claims (12, 13, 14, 15, 16, 17, 18, 19)
-
-
20. A system comprising:
-
a memory adapted to store data conversion and route tracking information; and a processor programmed to; determine whether a data type associated with a received logical table definition associated with a database query within a distributed database system differs from a data type associated with a local logical table definition; perform a data conversion on data retrieved from a locally-stored physical table referenced by the local logical table definition in response to determining that the data type associated with the received logical table definition differs from the data type associated with a local logical table definition; create local data conversion information identifying the data conversion performed on the retrieved data in response to performing the data conversion; add a node identifier to the local data conversion information; determine whether the data conversion performed on the retrieved data results in a loss of precision associated with the converted data; add local conversion precision loss tracking information to the local data conversion information in response to determining that the data conversion performed on the retrieved data results in a loss of precision associated with the converted data; store the local data conversion information to the memory; and forward at least one of the retrieved data and the converted data with the created local data conversion information to at least one of a distributed database node and an application-level module.
-
Specification