Columnar databases are surging with the NoSQL movement, but actually they play in both SQL and NoSQL camps. This white paper authored by William McKnight covers the fundamentals, then expands to explore key advanteages of columnar database technology such as saving on storage, speeding up important input/output-bound queries, speeding up scan operations, scaling beyond cubes, executing real-time analytics and concludes with a case study.