Handling medications in clinical medicine is difficult. One of the easy wins for information technology in medicine is electronic prescribing. Our colleagues in general practice have had such systems for many years but those of us working in hospitals have lagged behind.
Entries Tagged as 'Databases'
April 1st, 2015 by Mark · No Comments
May 25th, 2010 by Mark · 1 Comment
A short post. Apache Lucene is amazing – I was faced with slow full text searches searching >1.6 million SNOMED CT descriptions using PostgreSQL’s built in full-text search. Apache Lucene performs these searches in microseconds – I rapidly turn the list of concept Ids into full enterprise objects and my work is done! Please check […]
March 6th, 2010 by Mark · 2 Comments
In implementing a comprehensive SNOMED CT browser as part of a research clinical information system, I cache the results of several processor and disk-intensive queries to speed up lookup and SNOMED CT navigation. I was finding some odd results and found that my caching was missing for several items. I needed a way of comparing […]
March 4th, 2010 by Mark · 1 Comment
Representing hierarchical data in a relational database is easy. For instance, modelling the contents of a filesystem with directories and subdirectories is straightforward using self-joins on a parent key. The root node(s) are represented as those without a parent. Such a model is useful for modelling other types of data – in particular, hierarchies in […]
February 13th, 2007 by Mark · No Comments
Q: What do we do with old Filemaker databases? There were massive changes in the way Filemaker works between version 6 and 7 (all of them good). You’ve got a number of options, mainly determined by the size and complexity of your existing solution. The main two options are upgrade or rewrite.