ADV Slides: Analytic Platforms Should Be Columnar Orientation

By on

To view just the On-Demand Recording of this presentation, click HERE>>

This webinar is sponsored by:


About the Webinar

A columnar database is an implementation of the relational theory, but with a twist. The data storage layer does not contain records. It contains a grouping of columns.

Due to the variable column lengths within a row, a small column with low cardinality, or variability of values, may reside completely within one block while another column with high cardinality and longer length may take a thousand blocks. In columnar, all the same data — your data — is there. It’s just organized differently (automatically, by the DBMS).

The main reason why you would want to utilize a columnar approach is simply to speed up the native performance of analytic queries.

Learn about the columnar orientation and how it can be effective for your needs. This is the native orientation of many databases and several others that have optional column-oriented storage layers.

There is also the equivalent in the cloud storage world, which is open format Parquet.

About the Speaker

William McKnight

President, McKnight Consulting Group

William McKnight has advised many of the world’s best-known organizations. His strategies form the information management plan for leading companies in numerous industries. He is a prolific author and a popular keynote speaker and trainer. He has performed dozens of benchmarks on leading database, data lake, streaming, and data integration products. William is the #1 global influencer in data warehousing and master data management, and he leads McKnight Consulting Group, which has twice placed on the Inc. 5000 list.

This presentation is brought to you in partnership with:

Leave a Reply

We use technologies such as cookies to understand how you use our site and to provide a better user experience. This includes personalizing content, using analytics and improving site operations. We may share your information about your use of our site with third parties in accordance with our Privacy Policy. You can change your cookie settings as described here at any time, but parts of our site may not function correctly without them. By continuing to use our site, you agree that we can save cookies on your device, unless you have disabled cookies.
I Accept