IBM Cloud Authors: Elizabeth White, Pat Romanski, Liz McMillan, Yeshim Deniz, Stefan Bernbo

News Feed Item

Teradata Transforms Global Database Technology

The smartest database for the smartest business analytics

SAN DIEGO, Feb. 29, 2012 /PRNewswire/ -- Teradata (NYSE: TDC), the leading analytic data solutions company, today announced the global release of Teradata Database 14, with over 80 new features and 60 new built-in analytic functions, providing customers with transformational database technology to empower breakthrough business intelligence strategies.

(Logo: http://photos.prnewswire.com/prnh/20090909/TERADATALOGO )

Teradata Database 14 advances global database technology with integrated hybrid column and row technology, and market-leading innovations that enhance workload management, multi-temperature data usage, temporal data capability, security, and application portability.

Please follow this link to view the full social media version of this news release on Teradata.com

"The Teradata Database is the foundation for our valued customers who are making their organizations' business intelligence environment run faster, smarter, and far more intuitively," said Scott Gnau, president Teradata Labs, Teradata Corporation.

"Teradata's approach is to allow customers to exploit the right amount of memory and storage, both solid state and hard disk drives, which provides the best- performing data warehouse at the most competitive price."

Database Capable of Columnar and Row Analysis
Teradata has integrated columnar capability into the Teradata Database design for optimization with other robust database capabilities. By integrating columnar within the core architecture, all of these capabilities build on each other creating results that are impossible to achieve when the features are isolated. This integration offers users a hybrid row and column database with the most comprehensive approach to tackling the most diverse performance challenges. "Teradata Columnar capability allows our customers to deliver better, faster analytics to more people. This unmatched performance and flexibility supports organizations grappling with massive volumes of data, growing user populations, and demands for better intelligence - all inside of their existing platform," said Gnau.

Unlike relational database management systems, which only store data in rows, a columnar database stores data in columns. Working separately, each method offers unique benefits, depending on the application and type of data. However, the new columnar capability from Teradata provides customers with the benefits of both. Teradata Columnar enables the Teradata Database to run faster, deliver high compression rates and offer the most comprehensive ready-to-use environment for organizations.

Workload Management
Teradata's workload management supports companies as they strive to leverage and exploit diverse types of data from diverse sources, as well as specialized applications. The data is exploding in volume – from massive volumes of traditional data, and emerging types of big data generated by social media, web interactions, e-commerce, sensors, machines, and mobile devices.

Teradata's industry-leading workload management now includes virtual partitions that allocate the system resources between groups or business units within a company. Once user priorities have been set, the Teradata Database dynamically manages resources across the system to assure that workloads are supported appropriately.

For example, a marketing department's allocation of the system resources to power customized product offers on the website gets top priority and runs as a tactical workload. In contrast, the strategy marketing team working on customer segmentation analysis receives fewer resources because it has a lower priority. At the same time and on the other side of the company, the finance department may define a very different workload management scheme within its partition based on a combination of applications and the calendar, so that month-end and quarter-end closing of financial reports have top priority when needed.

Industry's Only Intelligent "Hot" - "Cold" Data Storage Solution
With big data becoming pervasive, there's a critical need for a database to be smart enough to dynamically judge how "hot" or "cold" data is for an organization. The Teradata Database has enhanced the use of hybrid storage to achieve more intelligent multi-temperature data management where the "hot" data is the most frequently used and "cold" data is least used. The hotter, more popular data needs to be located on the fastest storage devices, while less active, cooler data can be pushed onto slower, more economical storage.

The Teradata Database has the industry's only intelligent virtual storage solution that automatically migrates and compresses, or decompresses, cold data between drive types to achieve optimum performance and storage utilization. No staff intervention is required with Teradata's automated self-managing design. Cold data is compressed up to five times to keep disk storage costs to a minimum. In addition, Teradata Database 14 maximizes performance by keeping frequently used data in its natural decompressed format, avoiding repeated decompression processing.

With Teradata Columnar, data temperature measurements become even more targeted for the utmost system efficiency. By physically separating the storage for each column of data, the automated temperature tracking mechanism measures the temperature of each data field in a row separately and applies data placement and compression appropriately. For example, if the customer number and product SKU in a large sales table are used in most business intelligence queries, then these two columns of data will be stored on fast storage. At the same time, less frequently used data in the table will be automatically compressed and stored on slower storage.

First Temporal Capability Creates a Global Picture  
The Teradata Database is first to allow customers to create a full picture of an organization's business at any point in time. The temporal capability empowers customers to capture and track changes in their company as the business evolves over time. The Teradata Database temporal feature has been enhanced to create a global picture of the business, which takes advantage of the unique variations in global business calendars.

Security has been bolstered with new Teradata Row Level Security, permitting only those with proper authorization to access information at granular levels. The level of security can be customized and be as deep and as layered as necessary. For example, regional sales managers may be given access to other regions' aggregate sales figures, while withholding individual sales staff bookings and compensation. Concurrently, human resources or sales administrators could see only a ranking of individual sales staff for incentive programs, but not given any access to aggregate or regional data.

Application and Data Migration  
Teradata has expanded its ability to easily migrate applications and data from other less- performant platforms, and seamlessly manage emerging big data problems. New features in the Teradata Database make it even easier to migrate data and associated applications from competitive databases.

The Teradata Database is the high-performing analytical engine that powers all of the company's purpose-built platform family, including Teradata Active Enterprise Data Warehouse, Data Warehouse Appliance, Extreme Performance Appliance, Extreme Data Appliance, and the Data Mart Appliance. The Teradata Database 14 is also available as the software-only Data Mart Edition and Teradata Express for cloud computing solutions.

As a part of its data warehouse solution, Teradata partners with leading software vendors to serve its customers. These partners have tested and will support Teradata 14:  Ab Initio Software, Ataccama Corporation, Atanasoft, Attensity, IBM: InfoSphere Information Server, InfoSphere Change Data Capture, InfoSphere Optim, InfoSphere Guardium, and IBM Cognos Business Intelligence (validation testing completed and will support within 90 days of final release); Informatica Corp, Information Builders, KXEN, McAfee, Inc., Microsoft Corporation, MicroStrategy, Narus, OPNET Technologies, Inc., Protegrity, SAS (testing and certification in process), Tableau Software, Thomson Reuters, Voltage Security, Ward Analytics, and Wherescape.

Relevant links

1. Teradata Database 14 article, Teradata Magazine

2. Teradata Columnar, Teradata Magazine

3. B-Eye Network podcast on Teradata Database 14 and Teradata Columnar

4. Teradata Columnar white paper

5. Teradata Database brochure

About Teradata

Teradata (NYSE: TDC) is the world's leading analytic data solutions company focused on integrated data warehousing,  big data analytics, and business applications. Teradata's innovative products and services empower organizations to integrate, analyze and profit from data for competitive advantage.  Visit teradata.com for details.

Get to know Teradata.
Twitter: https://twitter.com/teradatanews  
Facebook: http://www.facebook.com/Teradata  
YouTube: http://www.youtube.com/user/teradata  
LinkedIn: http://www.linkedin.com/company/teradata/products  

Teradata is a trademark or registered trademark of Teradata Corporation in the United States and other countries

Twitter: Teradata provides customers with the smartest database for the smartest business analytics

SOURCE Teradata Corporation

More Stories By PR Newswire

Copyright © 2007 PR Newswire. All rights reserved. Republication or redistribution of PRNewswire content is expressly prohibited without the prior written consent of PRNewswire. PRNewswire shall not be liable for any errors or delays in the content, or for any actions taken in reliance thereon.

IoT & Smart Cities Stories
The graph represents a network of 1,329 Twitter users whose recent tweets contained "#DevOps", or who were replied to or mentioned in those tweets, taken from a data set limited to a maximum of 18,000 tweets. The network was obtained from Twitter on Thursday, 10 January 2019 at 23:50 UTC. The tweets in the network were tweeted over the 7-hour, 6-minute period from Thursday, 10 January 2019 at 16:29 UTC to Thursday, 10 January 2019 at 23:36 UTC. Additional tweets that were mentioned in this...
Artificial intelligence, machine learning, neural networks. We're in the midst of a wave of excitement around AI such as hasn't been seen for a few decades. But those previous periods of inflated expectations led to troughs of disappointment. This time is (mostly) different. Applications of AI such as predictive analytics are already decreasing costs and improving reliability of industrial machinery. Pattern recognition can equal or exceed the ability of human experts in some domains. It's devel...
The term "digital transformation" (DX) is being used by everyone for just about any company initiative that involves technology, the web, ecommerce, software, or even customer experience. While the term has certainly turned into a buzzword with a lot of hype, the transition to a more connected, digital world is real and comes with real challenges. In his opening keynote, Four Essentials To Become DX Hero Status Now, Jonathan Hoppe, Co-Founder and CTO of Total Uptime Technologies, shared that ...
The Japan External Trade Organization (JETRO) is a non-profit organization that provides business support services to companies expanding to Japan. With the support of JETRO's dedicated staff, clients can incorporate their business; receive visa, immigration, and HR support; find dedicated office space; identify local government subsidies; get tailored market studies; and more.
After years of investments and acquisitions, CloudBlue was created with the goal of building the world's only hyperscale digital platform with an increasingly infinite ecosystem and proven go-to-market services. The result? An unmatched platform that helps customers streamline cloud operations, save time and money, and revolutionize their businesses overnight. Today, the platform operates in more than 45 countries and powers more than 200 of the world's largest cloud marketplaces, managing mo...
At CloudEXPO Silicon Valley, June 24-26, 2019, Digital Transformation (DX) is a major focus with expanded DevOpsSUMMIT and FinTechEXPO programs within the DXWorldEXPO agenda. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term. A total of 88% of Fortune 500 companies from a generation ago are now out of business. Only 12% still survive. Similar percentages are found throug...
When Enterprises started adopting Hadoop-based Big Data environments over the last ten years, they were mainly on-premise deployments. Organizations would spin up and manage large Hadoop clusters, where they would funnel exabytes or petabytes of unstructured data.However, over the last few years the economics of maintaining this enormous infrastructure compared with the elastic scalability of viable cloud options has changed this equation. The growth of cloud storage, cloud-managed big data e...
Your applications have evolved, your computing needs are changing, and your servers have become more and more dense. But your data center hasn't changed so you can't get the benefits of cheaper, better, smaller, faster... until now. Colovore is Silicon Valley's premier provider of high-density colocation solutions that are a perfect fit for companies operating modern, high-performance hardware. No other Bay Area colo provider can match our density, operating efficiency, and ease of scalability.
At CloudEXPO Silicon Valley, June 24-26, 2019, Digital Transformation (DX) is a major focus with expanded DevOpsSUMMIT and FinTechEXPO programs within the DXWorldEXPO agenda. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term. A total of 88% of Fortune 500 companies from a generation ago are now out of business. Only 12% still survive. Similar percentages are found throug...
As you know, enterprise IT conversation over the past year have often centered upon the open-source Kubernetes container orchestration system. In fact, Kubernetes has emerged as the key technology -- and even primary platform -- of cloud migrations for a wide variety of organizations. Kubernetes is critical to forward-looking enterprises that continue to push their IT infrastructures toward maximum functionality, scalability, and flexibility. As they do so, IT professionals are also embr...