System and method that applies relational and non-relational data structures to medical diagnosis

Abstract

A medical diagnosis system comprises 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. The plurality of relational tables comprise a symptom table configured to associate a plurality of symptoms having symptom name fields with a corresponding plurality of symptom identifier fields (Symptom ID). A cause table is 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 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. The plurality of symptom identifier fields comprise first foreign keys that link the symptom table to the symptom-cause relational table. The plurality of symptom identifier fields comprise second foreign keys that link the cause table to the symptom-cause relational table. One or more processors 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. 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. The 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.

Dependencies are inferred from the claim text.