{"id":267,"date":"2007-09-07T18:43:44","date_gmt":"2007-09-08T01:43:44","guid":{"rendered":"http:\/\/asistubc.wordpress.com\/2007\/09\/07\/are-relational-databases-obsolete\/"},"modified":"2011-01-03T20:12:02","modified_gmt":"2011-01-04T04:12:02","slug":"are-relational-databases-obsolete","status":"publish","type":"post","link":"https:\/\/blogs.ubc.ca\/asist\/2007\/09\/07\/are-relational-databases-obsolete\/","title":{"rendered":"Are relational databases … obsolete?"},"content":{"rendered":"

Just when we’re getting all cozy with relational database systems, one pioneer of the industry is saying that the relational database is going to go the way of the dodo bird<\/a>. Professor Michael Stonebraker (the prime mover behind industry standard relational databases Ingres and Postgres) has a vested interest – a startup to promote – but the idea is sounding very timely.<\/p>\n

Stonebraker’s new company, Vertica<\/a>, is based (as you might have guessed from the name already) on the notion of storing like data with like: in columns, if you will, of structurally similar data, rather than rows of structurally dissimilar, but related, data. As I understand it, this means you’d have a column of phone numbers, another column of names, another column of addresses, etc., each stored in a discrete data set, rather than a single table with phone numbers, names, and addresses all aggregated together into a table of addresses.<\/p>\n

In a way, it seems akin to the mashups<\/a> idea that’s creating so many great new web services – instead of pulling together massive amounts of data into a single physical\/hardware space, thinking in columns vastly opens up the possibilities of distributed data storage, bringing together disparate pieces of information on the fly into record “mashups”, in real time, as they are needed.<\/p>\n

That’s the best explanation that I can come up with on my own … if this intrigues you, take a look at Stonebraker’s blog site<\/a>, because I’d be curious to hear what others think.<\/p>\n

Update: I trolled around the Vertica website for a bit, and noticed a reference to RDF data management. Sure enough, there’s a whole page<\/a> on using Vertica for RDF-based Semantic Web<\/a> applications.<\/p>\n","protected":false},"excerpt":{"rendered":"

Just when we’re getting all cozy with relational database systems, one pioneer of the industry is saying that the relational…<\/p>\n","protected":false},"author":1560,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[155],"tags":[2763,4520],"class_list":["post-267","post","type-post","status-publish","format-standard","hentry","category-news","tag-databases","tag-mashups"],"_links":{"self":[{"href":"https:\/\/blogs.ubc.ca\/asist\/wp-json\/wp\/v2\/posts\/267","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.ubc.ca\/asist\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.ubc.ca\/asist\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.ubc.ca\/asist\/wp-json\/wp\/v2\/users\/1560"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.ubc.ca\/asist\/wp-json\/wp\/v2\/comments?post=267"}],"version-history":[{"count":1,"href":"https:\/\/blogs.ubc.ca\/asist\/wp-json\/wp\/v2\/posts\/267\/revisions"}],"predecessor-version":[{"id":388,"href":"https:\/\/blogs.ubc.ca\/asist\/wp-json\/wp\/v2\/posts\/267\/revisions\/388"}],"wp:attachment":[{"href":"https:\/\/blogs.ubc.ca\/asist\/wp-json\/wp\/v2\/media?parent=267"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.ubc.ca\/asist\/wp-json\/wp\/v2\/categories?post=267"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.ubc.ca\/asist\/wp-json\/wp\/v2\/tags?post=267"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}