Apparatus and method for performing table comparisons
A computer readable storage medium includes executable instructions to analyze sort options associated with an input table and a comparison table. It is determined whether a consistent sort can be performed by a first database associated with the input table and a second database associated with the comparison table. A first sort operation is performed on the input table at the first database and a second sort operation is performed on the comparison table at the second database when a consistent sort can be achieved. Sort operations on the input table and the comparison table are executed at a common sort engine when a consistent sort cannot be performed by the first database and the second database.
1. A non-transitory computer readable storage medium, comprising executable instructions to:
analyze sort options associated with an input table and a comparison table;
determine whether a consistent sort can be performed by a first database associated with the input table and a second database associated with the comparison table;
perform a first sort operation on the input table at the first database and a second sort operation on the comparison table at the second database when the consistent sort can be performed; and
execute sort operations on the input table and the comparison table at a common sort engine when the consistent sort cannot be performed.
2. The non-transitory computer readable storage medium of claim 1 further comprising executable instructions to perform a table comparison of sorted values from the input table and the comparison table.
3. The non-transitory computer readable storage medium of claim 1 wherein the executable instructions to analyze the sort options include executable instructions to analyze numeric sort information associated with the first database and the second database.
4. The non-transitory computer readable storage medium of claim 1 wherein the executable instructions to analyze the sort options include executable instructions to analyze code page data associated with the first database and the second database.
5. The non-transitory computer readable storage medium of claim 1 wherein the executable instructions to analyze the sort options include executable instructions to analyze national language support data associated with the first database and the second database.
6. The non-transitory computer readable storage medium of claim 1 wherein the executable instructions to analyze the sort options include executable instructions to analyze character size encoding data associated with the first database and the second database.
7. The non-transitory computer readable storage medium of claim 1 wherein the executable instructions to analyze the sort options include executable instructions to analyze case sensitivity data associated with the first database and the second database.
8. The non-transitory computer readable storage medium of claim 1 wherein the executable instructions to analyze the sort options include executable instructions to analyze customization options associated with the first database and the second database.
9. The non-transitory computer readable storage medium of claim 1 wherein the executable instructions to analyze the sort options include executable instructions to analyze primary keys associated with the input table and the comparison table.
10. The non-transitory computer readable storage medium of claim 1 further comprising executable instructions to divide the sort operations between the common sort engine and one of the first database and the second database when the consistent sort cannot be performed.