Automated data conversion and route tracking in distributed databases

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 logical table definition received within 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 the 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.

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.