Medical Nerds Blog Logo

technology, stats and IT for medics


Entries Tagged as 'Databases'

Thinking about medications

April 1st, 2015 by Mark · No Comments

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.

[

Tags: Databases · Medical · Research

Apache Lucene

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 […]

[

Tags: Databases · Medical · WebObjects

Finding rows in one table not present in another table with PostgreSQL

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 […]

[

Tags: Databases

Recursive SQL with PostgreSQL 8.4

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 […]

[

Tags: Databases · Medical

Upgrading old Filemaker solutions

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.

[

Tags: Databases