1 / 9

Teradata Columnar: A new standard for Columnar databases

Teradata Columnar: A new standard for Columnar databases. Source: Teradata is thinking Big Stephen Swoyer Presented by: Deesha Phalak and Kaushiki Nag. Summary. Teradata Corporation introduced Teradata Columnar that integrates columnar and row-based tables.

shepry
Download Presentation

Teradata Columnar: A new standard for Columnar databases

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

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

More Related