Transcript Oracle unveils plans for Big Data Appliance

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.
• 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.
• Applications get access to both row and column structured
data allowing flexibility and performance.
Teradata Columnar Advantages
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
• [1] http://www.marketwatch.com/story/teradata-establishes-newstandard-for-columnar-databases-2011-09-22
• [2] http://www.teradata.com/videos/Teradata-Columnar-A-Smarter-WayTo-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/teradatacolumnar
• [5] http://www.teradata.com/News-Releases/2011/Teradata-EstablishesNew-Standard-for-Columnar-Databases/
• [6] Stephen Swoyer, tdwi.org, August 16, 2011
http://www.teradata.com/News-Releases/2011/Teradata-EstablishesNew-Standard-for-Columnar-Databases/
Thank You