Method and system for performing conceptual joins across fields of a database

摘要

A method and system for performing a database join across a first field and a second field that represent a conceptual meaning, wherein the first field represents the conceptual meaning using a first value and the second field represents the conceptual meaning using a second value. The method and system includes mapping the first value and the second value to the conceptual meaning using a code-mapping table. After the code- mapping table is generated, the system receives a request that specifies a join operation between the first and second fields. The method and system further includes joining the first and second fields in response to identifying that the first and second fields map to the conceptual meaning in the code-mapping table.