Today, I posted up on Cerner’s internal customer site, twenty page document describing how to extract the compressed notes from Cerner into a Microsoft SQL Server database that has SQL File Table and Full Text Search enabled. I will not post the document here out of respect for Cerner’s intellectual property since I show queries that would reveal a small fraction of their data schema. However, I hope to continue to discuss some of the enabling technologies as I have in previous posts about the SQL File Table and using LZW to compress and decompress.
For our internal project, I added some great “eye candy” using the NCI Thesaurus. Specifically, for the search terms, I used the Thesaurus for search autocomplete:
And also for a useful way to pull up definitions from inside the clinical note. By simply highlighting a word or term and pressing the Define button, a quick definition pops up from the NCI Thesaurus.