Teradata Columnar: A new standard for Columnar databases Source: Teradata is thinking Big Stephen Swoyer Presented by: DeeshaPhalak and Kaushiki Nag
Summary • Teradata Corporation introduced Teradata Columnar that integrates columnar and row-based tables. • Columnar capability will be available in December, 2011 as a component of Teradata Database 14. • High performing analytical engine. • DBAs have an additional physical database design option to use column- or row-oriented storage. • Produces extreme query performance and decreases space usage. • Allows row, column or hybrid reads.
Features • Teradata Columnar embeds the automated, columnar storage option within the Teradata Database to provide: • Extreme performance - System I/O is reduced by reading only the data absolutely required for each query. • Dynamic compression – The wide variety of compression mechanisms employed adapt dynamically as the data evolves. • Ease of Use - The Teradata Database intelligently chooses row or column storage formats and the best compression method or methods for columnar data. • Integration – As part of the Teradata Database, Teradata Columnar works seamlessly with the Teradata optimizer, Partitioned Primary Index, secondary indexes, join indexes.
Claims • It will be able to support organizations handling massive data sets and enhance their performance. • It selects the best compression method and dynamically adapts the compression mechanism as data evolves over time. • Industries to benefit: Retail, Telecommunications, Financial Services. • Applicationsget access to both row and column structured data allowing flexibility and performance.
Teradata Columnar- A smarter way to do analytics. • Huge amount of data generation creates problems for data analysis. • Instead of reading the entire row extract only required information from the rows. • Teradata columnar promises to keep up with these new demands. • It helps to pinpoint data faster. • It improves performance by answering more questions faster.
Relationship with course • Relevant to the chapters of Physical model, Data mining and Data warehousing.
References •  http://www.marketwatch.com/story/teradata-establishes-new-standard-for-columnar-databases-2011-09-22 •  http://www.teradata.com/videos/Teradata-Columnar-A-Smarter-Way-To-Do-Analytics/ • [3 ] http://www.teradata.com/database/Teradata-Columnar/ •  Paul Sinclair, Teradata Labs optimizer architect, 27 Sep 2011 http://developer.teradata.com/blog/paulsinclair/2011/09/teradata-columnar •  http://www.teradata.com/News-Releases/2011/Teradata-Establishes-New-Standard-for-Columnar-Databases/ •  Stephen Swoyer, tdwi.org, August 16, 2011 http://www.teradata.com/News-Releases/2011/Teradata-Establishes-New-Standard-for-Columnar-Databases/