Relational databases and free-form data

Posted on Tuesday 18 March 2008

The Death of the Relational Database argues that relational databases aren’t good for applications that may add various additional relationships with new features, because the tables store not just the “objects” but the relationships between them.

In the early days at Mosuki, Jonathan implemented a table to store “certifications,” which are essentially directed, labeled edges connecting arbitrary rows, or objects. These edges can connect any two rows in any of several different database tables. And this power lets us implement major features that we didn’t plan for originally, like adding iCalendar feeds, discussion forums, scenes, places, and a myriad of object-specific user preferences to the site, with a minimum of schema restructuring. Often we can add whole features without touching the schema.

This table is also the largest, and most problematic speed-wise as it requires two joins instead of one (although Ross has got it pretty much under control now), which I think speaks to the original article’s point that relational databases aren’t the best choice for more free-form applications.


No comments have been added to this post yet.

Leave a comment

(required)

(required)


Information for comment users
Line and paragraph breaks are implemented automatically. Your e-mail address is never displayed. Please consider what you're posting.

Use the buttons below to customise your comment.


RSS feed for comments on this post | TrackBack URI