Download
teradata columnar a new standard for columnar databases n.
Skip this Video
Loading SlideShow in 5 Seconds..
Teradata Columnar: A new standard for Columnar databases PowerPoint Presentation
Download Presentation
Teradata Columnar: A new standard for Columnar databases

Teradata Columnar: A new standard for Columnar databases

310 Vues Download Presentation
Télécharger la présentation

Teradata Columnar: A new standard for Columnar databases

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Teradata Columnar: A new standard for Columnar databases Source: Teradata is thinking Big Stephen Swoyer Presented by: DeeshaPhalak and Kaushiki Nag

  2. 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.

  3. 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.

  4. 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.

  5. Teradata Columnar Advantages

  6. 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.

  7. Relationship with course • Relevant to the chapters of Physical model, Data mining and Data warehousing.

  8. References • [1] http://www.marketwatch.com/story/teradata-establishes-new-standard-for-columnar-databases-2011-09-22 • [2] http://www.teradata.com/videos/Teradata-Columnar-A-Smarter-Way-To-Do-Analytics/ • [3 ] http://www.teradata.com/database/Teradata-Columnar/ •  [4] Paul Sinclair, Teradata Labs optimizer architect, 27 Sep 2011 http://developer.teradata.com/blog/paulsinclair/2011/09/teradata-columnar • [5] http://www.teradata.com/News-Releases/2011/Teradata-Establishes-New-Standard-for-Columnar-Databases/ • [6] Stephen Swoyer, tdwi.org, August 16, 2011 http://www.teradata.com/News-Releases/2011/Teradata-Establishes-New-Standard-for-Columnar-Databases/

  9. Thank You