IBM Cloud Authors: Zakia Bouachraoui, Elizabeth White, Yeshim Deniz, Pat Romanski, Liz McMillan

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
There are many examples of disruption in consumer space – Uber disrupting the cab industry, Airbnb disrupting the hospitality industry and so on; but have you wondered who is disrupting support and operations? AISERA helps make businesses and customers successful by offering consumer-like user experience for support and operations. We have built the world’s first AI-driven IT / HR / Cloud / Customer Support and Operations solution.
Codete accelerates their clients growth through technological expertise and experience. Codite team works with organizations to meet the challenges that digitalization presents. Their clients include digital start-ups as well as established enterprises in the IT industry. To stay competitive in a highly innovative IT industry, strong R&D departments and bold spin-off initiatives is a must. Codete Data Science and Software Architects teams help corporate clients to stay up to date with the mod...
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...
Druva is the global leader in Cloud Data Protection and Management, delivering the industry's first data management-as-a-service solution that aggregates data from endpoints, servers and cloud applications and leverages the public cloud to offer a single pane of glass to enable data protection, governance and intelligence-dramatically increasing the availability and visibility of business critical information, while reducing the risk, cost and complexity of managing and protecting it. Druva's...
BMC has unmatched experience in IT management, supporting 92 of the Forbes Global 100, and earning recognition as an ITSM Gartner Magic Quadrant Leader for five years running. Our solutions offer speed, agility, and efficiency to tackle business challenges in the areas of service management, automation, operations, and the mainframe.
The Jevons Paradox suggests that when technological advances increase efficiency of a resource, it results in an overall increase in consumption. Writing on the increased use of coal as a result of technological improvements, 19th-century economist William Stanley Jevons found that these improvements led to the development of new ways to utilize coal. In his session at 19th Cloud Expo, Mark Thiele, Chief Strategy Officer for Apcera, compared the Jevons Paradox to modern-day enterprise IT, examin...
With 10 simultaneous tracks, keynotes, general sessions and targeted breakout classes, @CloudEXPO and DXWorldEXPO are two of the most important technology events of the year. Since its launch over eight years ago, @CloudEXPO and DXWorldEXPO have presented a rock star faculty as well as showcased hundreds of sponsors and exhibitors! In this blog post, we provide 7 tips on how, as part of our world-class faculty, you can deliver one of the most popular sessions at our events. But before reading...
DSR is a supplier of project management, consultancy services and IT solutions that increase effectiveness of a company's operations in the production sector. The company combines in-depth knowledge of international companies with expert knowledge utilising IT tools that support manufacturing and distribution processes. DSR ensures optimization and integration of internal processes which is necessary for companies to grow rapidly. The rapid growth is possible thanks, to specialized services an...
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...
Scala Hosting is trusted by 50 000 customers from 120 countries and hosting 700 000+ websites. The company has local presence in the United States and Europe and runs an internal R&D department which focuses on changing the status quo in the web hosting industry. Imagine every website owner running their online business on a fully managed cloud VPS platform at an affordable price that's very close to the price of shared hosting. The efforts of the R&D department in the last 3 years made that pos...