Patent ID: 11971895
Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 10:
11. A computer program product, comprising:
a non-transitory computer readable storage medium having computer readable program code embodied therewith, where the computer readable program code when executed on a computer causes the computer to:
receive, by a local sub-system of a distributed database system, a local table definition defining a local table of data, the local table definition including information indicative of: (i) a plurality of local table element names, and (ii) for each local table element name of the plurality of local table element names, a respectively corresponding data type;
receive, by the local sub-system, from a remote requestor sub-system of the distributed database system, a database query that includes: (1) a query select statement including information indicative of requested data from the local table of data, and (2) a remote requestor table definition including information indicative of: (a) a plurality of remote requestor table element names, and (b) for each remote requestor table element name of the plurality of remote requestor table element names, a respectively corresponding data type;
determine that a first remote requestor table element name, included in the query select statement, corresponds to a first local table element name;
retrieve raw query response data from the local table of data, with the raw query response data being data that is responsive to the query select statement, and with the raw query response data including raw first element data corresponding to the first local table element name;
determine that a data type corresponding to the first local table element name does not match a data type corresponding to the first remote requestor table element name; and
responsive to the determination that the data type corresponding to the first local table element name does not match the data type corresponding to the first remote requestor table element name, convert the raw first element data, having the data type corresponding to first local table element name, to converted first element data, having the data type corresponding to the first remote requestor table element name.