Databases
StackOverflow2013
Postsdbo
POImplementing search on medical link list/table that allows for synonyms/abbreviations- and importing such a thing
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POImplementing search on medical link list/table that allows for synonyms/abbreviations- and importing such a thing
    primarykey
    data
    text
    <p>I'm making a simple searchable list which will end up containing about 100,000 links on various medical topics- mostly medical conditions/diseases. Now on the surface of things this sounds easy... in fact I've set my tables up in the following way:</p> <ul> <li>Links: id, url, name, topic</li> <li>Topics (eg cardiology, paediatrics etc): id, name</li> <li>Conditions (eg asthma, influenza etc): id, name, aliases</li> </ul> <p>And possibly another table:</p> <ul> <li>Link &amp; condition (since 1 link can pertain to multiple conditions): link id, condition id</li> </ul> <p>So basically since doctors (including myself) are super fussy, I want to make it so that if you're searching for a condition- whether it be an abbreviation, british or american english, or an alternative ancient name- you get relevant results (eg "angiooedema", "angioedema", "Quincke's edema" etc would give you the same results; similarly with "gastroesophageal reflux" "gastro-oesophageal reflux disease", GERD, GORD, GOR). Additionally, at the top of the results it would be good to group together links for a diagnosis that matches the search string, then have matches to link name, then finally matches to the topic.</p> <p>My main problem is that there are thousands if not tens of thousands of conditions, each with up to 20 synonyms/spellings etc. One option is to get data from <a href="http://www.nlm.nih.gov/mesh/filelist.html" rel="nofollow">MeSH</a> which happens to be a sort of medical thesaurus (but in american english only so there would have to be a way of converting from british english). The trouble being that the XML they provide is INSANE and about 250mb. To help they have got a guide to what the data elements are.</p> <p>Honestly, I am at a loss as to how to tackle this most effectively as I've just started programming and working with databases and most of the possibilities of what to do seem difficult/suboptimal.</p> <p>Was wondering if anyone could give me a hand? Happy to clarify anything that is unclear.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USTomcat
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload