judgeacolumn - Sheet1 Page 1 How to Judge a Columnar...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the 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

Page1 / 3

judgeacolumn - Sheet1 Page 1 How to Judge a Columnar...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online