Query routing in distributed database system

A method, comprising

• receiving, at a second server of a first server type from a first server of a plurality of servers of the first server type, a query message or a transforming result based on at least part of data contained in the query message;
• concluding, based on the receipt of the query message or the transforming result, that a storage location of a respective second lookup table is at the second server,
• accessing the second lookup table at the second server of said first type,
• retrieving an indicator indicating a storage location of data requested by the query message from the second lookup table.

A server, comprising:

• a transformer configured to transform at least part of data contained in a query message to a transforming result;
• a processor configured to
• determine, based on the transforming result and a first lookup table, a storage location of a respective second lookup table at one of a plurality of servers of a first server type,
• access the second lookup table at the server if the processor determined that the storage location of the respective second lookup table is at the server, and to
• retrieve an indicator indicating a storage location of data requested by the query message from the second lookup table.

A server, comprising

• an interfacing unit configured to receive, from another server of a plurality of servers of a first server type, a query message or a transforming result based on at least part of data contained in the query message;
• a processor configured to
• conclude, based on the receipt of the query message or the transforming result that a storage location of a respective second lookup table is at the server,
• access the second lookup table at the server, and to
• retrieve an indicator indicating a storage location of data requested by the query message from the second lookup table.

A system comprising:

• a first server comprising:
• a transformer configured to transform at least part of data contained in a query message to a transforming result;
• a processor configured to
• determine, based on the transforming result and a first lookup table, a storage location of a respective second lookup table at one of a plurality of servers of a first server type,
• access the second lookup table at the server if the processor determined that the storage location of the respective second lookup table is at the server, and to
• retrieve an indicator indicating a storage location of data requested by the query message from the second lookup table;
• and
• a second server comprising:
• an interfacing unit configured to receive, from another server of a plurality of servers of a first server type, a query message or a transforming result based on at least part of data contained in the query message;
• a processor configured to
• conclude, based on the receipt of the query message or the transforming result that a storage location of a respective second lookup table is at the server,
• access the second lookup table at the server, and to
• retrieve an indicator indicating a storage location of data requested by the query message from the second lookup table.

A computer program product, embodied on a computer-readable medium, comprising processor implementable computer code for performing:

• receiving a query message at a first server of a plurality of servers of a first server type;
• transforming at least part of data contained in the query message to a transforming result;
• determining, based on the transforming result and a first lookup table at said first server, a storage location of a respective second lookup table at one of said plurality of servers of said first type,
• accessing the respective second lookup table at the determined storage location of the respective second lookup table at one of said plurality of servers of said first type, retrieving an indicator indicating a storage location of data requested by the query message from the respective second lookup table.

A computer program product, embodied on a computer-readable medium, comprising processor implementable computer code for performing:

• receiving, at a second server of a first server type from a first server of a plurality of servers of the first server type, a query message or a transforming result based on at least part of data contained in the query message;
• concluding, based on the receipt of the query message or the transforming result, that a storage location of a respective second lookup table is at the second server,
• accessing the second lookup table at the second server of said first type,
• retrieving an indicator indicating a storage location of data requested by the query message from the second lookup table.