Columnar Databases
Share this Session:
  William McKnight   William McKnight
President
McKnight Consulting Group
 


 

Wednesday, August 24, 2011
10:30 AM - 11:20 AM

Level:  Business / Non-Technical


A columnar DBMS 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. The columnar approach speeds up the native performance of analytic queries. There is no difference in the SQL or data access tool used to interface with the data or the logical data modeling. The columnar approach is not new, however its time has come as analytic processing becomes a business imperative. This is the orientation of vendors such as Vertica, ParAccel, Sybase IQ, InfoBright, Exasol, VectorWise, MonetDB and InfiniDB, as well as an optional layer in the 2010 release of Microsoft SQL Server. This presentation will discuss what columnar orientation is and how it can be effective for your needs.


William McKnight takes corporate information and turns it into a bottom-line producing asset. He’s worked with companies like Dong Energy, France Telecomm, Pfizer, Samba Bank, ScotiaBank, Teva Pharmaceuticals and Verizon -- 15 of the Global 2000 -- and many others. McKnight Consulting Group focuses on delivering business value and solving business problems utilizing proven, streamlined approaches in information management. His teams have won several best practice competitions for their implementations. He has been helping companies adopt big data solutions. William has hundreds of articles and 25 white papers in publication and is a prolific blogger. He is a frequent international keynote speaker and trainer. He provides clients with action plans, architectures, strategies, complete programs and vendor-neutral tool selection to manage information. An Ernst&Young Entrepreneur of the Year Finalist and frequent best practices judge, William is a former Fortune 50 technology executive and database engineer.


   
Close Window