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 [...]
Entries Tagged as 'Medical'
Recursive SQL with PostgreSQL 8.4
March 4th, 2010 by Mark · No Comments
More posts
March 4th, 2010 by Mark · 1 Comment
After a long hiatus while we both finish our theses (one of us [1] more successfully than the other) and obtain substantive posts (one of us [2] more successfully than the other), we are keen to restart regular nerdy medical technology posts.
Welcome back!
(1) Completed his MD in 2008
(2) This is not necessarily the same person
Encrypting a USB Key using TrueCrypt
October 26th, 2008 by James · 21 Comments
If you are a healthcare professional you have a duty to maintain the security of patient identifiable data. Within your job you sometimes need to use a USB key to transfer lists or letters between computers. If you lose your un-encrypted USB key with patient identifiable data then it may deemed negligent and you may [...]
Tags: Free · Medical · Open Source · Software
Producing Spaghetti Plots using R
April 6th, 2007 by James · 10 Comments
If you wish to analyse longitudinal data sometimes it is helpful to plot each experimental subject’s data at each timepoint to get a feel for the patterns or trends. You can often learn more from this raw data than a boxplot or line graph of the means. I am a habitual SPSS user but [...]
Tags: Graphics · Medical · Open Source · R statistical computing · Software
How to add a Free Medical Spell Checking Dictionary to Word/Firefox
February 26th, 2007 by James · 2 Comments
Spell checking medical documents can be a real pain. My spelling at the best of times is atrocoius atrocious. Luckily most software, even browsers now support spell checking. The problem is now getting hold of a good medical dictionary to use with your application. Now e-medtools.com a site which specialises in medical spell checking, [...]
Tags: Free · Medical · Open Source · Software
Pedigree drawing software
February 13th, 2007 by Mark · 2 Comments
Pedigrees are essential when documenting large complex families with inherited disease. I spend a lot of time looking after families with a variety of inherited neurological disease, and have spent a similar amount of time trying to find decent software to make this work easier!
I last did a systematic search for software last year. [...]
Tags: Medical · Open Source · Research · Software
Tracking Journal Articles with Google Reader
February 13th, 2007 by James · 1 Comment
Keeping up to date in your speciality is always a challenge, but this can become far easier by creating customised dynamic pubmed searches conviently summarised in Google Reader. In this article I will show you how to easily create a feed for your favourite subjects, journals and authors.
