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 out [...]
Entries Tagged as 'Databases'
Apache Lucene
May 25th, 2010 by Mark · No Comments
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 · No Comments
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 [...]
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