Source Teradata is thinking Big Stephen Swoyer Presented by Deesha Phalak and Kaushiki Nag Summary Teradata Corporation introduced Teradata Columnar that integrates columnar and rowbased tables ID: 242657
Download Presentation The PPT/PDF document "Teradata Columnar: A new standard for Co..." is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Teradata Columnar: A new standard for Columnar databases
Source: Teradata is thinking Big
Stephen
Swoyer
Presented by:
Deesha
Phalak
and
Kaushiki
NagSlide2
SummaryTeradata
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.
H
igh
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. Slide3
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.Slide4
ClaimsIt
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.
Applications
get
access to both row and column structured data
allowing
flexibility and
performance.Slide5
Teradata Columnar AdvantagesSlide6
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.Slide7
Relationship with courseRelevant to the chapters of
Physical
model, Data
mining and Data
warehousing.Slide8
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/Slide9
Thank You