This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Sheet1 Page 1 How to Judge a Columnar Database By draab2 How to Judge a Columnar Database David M. Raab DM Review December 2007 Columnar databases are an idea whose time has come & again. First introduced in the 1970, s in (still available) prod As the name implies, columnar databases are organized by column rather than row: that is, all instances of a single da Columnar databases were largely eclipsed by relational systems in the 1980& s and 1990 s, when huge improvement Today9 s columnar systems combine the columnar structure with techniques including indexing, compression, and par- load time: how long does it take to convert source data into the columnar format? This is the most basic question of - incremental loads: once a set of data has been loaded, must everything be reloaded every time there is an update? - data compression: some columnar systems greatly compress the source data so the resulting files take a fraction of - structural limitations: columnar databases use different techniques to mimic a relational structure. - structural limitations: columnar databases use different techniques to mimic a relational structure....
View Full Document