主权项 |
1. A medical diagnosis system, comprising:
one or more databases configured to store a plurality of relational tables within a relational data structure and a non-relational table within a non-relational data structure, wherein the plurality of relational tables comprise:
a symptom table configured to associates a plurality of symptoms having symptom name fields with a corresponding plurality of symptom identifier fields (Symptom ID);a cause table configured to associate a plurality of causes having caused name fields with a corresponding plurality of cause identifier fields (Cause ID);a symptom-cause relational table that is linked to the symptom table and the cause table to associate the plurality of cause identifier fields with the plurality of symptom identifier fields, wherein the plurality of symptom identifier fields comprise first foreign keys that link the symptom table to the symptom-cause relational table, and wherein the plurality of symptom identifier fields comprise second foreign keys that link the cause table to the symptom-cause relational table; and one or more processors that provide interfaces for receiving one or more symptom names and presenting one or more cause names based on associations of symptom names and cause names in the non-relational table, wherein the associations of symptom names and cause names in the non-relational table are derived from mapping the plurality of cause name fields in the cause table and the plurality of symptom name fields in the symptom table into the non-relational table, said mapping being based on the association of the plurality of cause identifier fields with the plurality of symptom identifier fields in the symptom-cause relational table. |