IBM Cloud Authors: Zakia Bouachraoui, Pat Romanski, Carmen Gonzalez, Elizabeth White, 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
Every organization is facing their own Digital Transformation as they attempt to stay ahead of the competition, or worse, just keep up. Each new opportunity, whether embracing machine learning, IoT, or a cloud migration, seems to bring new development, deployment, and management models. The results are more diverse and federated computing models than any time in our history.
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...
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...
Dion Hinchcliffe is an internationally recognized digital expert, bestselling book author, frequent keynote speaker, analyst, futurist, and transformation expert based in Washington, DC. He is currently Chief Strategy Officer at the industry-leading digital strategy and online community solutions firm, 7Summits.
Digital Transformation is much more than a buzzword. The radical shift to digital mechanisms for almost every process is evident across all industries and verticals. This is often especially true in financial services, where the legacy environment is many times unable to keep up with the rapidly shifting demands of the consumer. The constant pressure to provide complete, omnichannel delivery of customer-facing solutions to meet both regulatory and customer demands is putting enormous pressure on...
IoT is rapidly becoming mainstream as more and more investments are made into the platforms and technology. As this movement continues to expand and gain momentum it creates a massive wall of noise that can be difficult to sift through. Unfortunately, this inevitably makes IoT less approachable for people to get started with and can hamper efforts to integrate this key technology into your own portfolio. There are so many connected products already in place today with many hundreds more on the h...
The standardization of container runtimes and images has sparked the creation of an almost overwhelming number of new open source projects that build on and otherwise work with these specifications. Of course, there's Kubernetes, which orchestrates and manages collections of containers. It was one of the first and best-known examples of projects that make containers truly useful for production use. However, more recently, the container ecosystem has truly exploded. A service mesh like Istio addr...
Digital Transformation: Preparing Cloud & IoT Security for the Age of Artificial Intelligence. As automation and artificial intelligence (AI) power solution development and delivery, many businesses need to build backend cloud capabilities. Well-poised organizations, marketing smart devices with AI and BlockChain capabilities prepare to refine compliance and regulatory capabilities in 2018. Volumes of health, financial, technical and privacy data, along with tightening compliance requirements by...
Charles Araujo is an industry analyst, internationally recognized authority on the Digital Enterprise and author of The Quantum Age of IT: Why Everything You Know About IT is About to Change. As Principal Analyst with Intellyx, he writes, speaks and advises organizations on how to navigate through this time of disruption. He is also the founder of The Institute for Digital Transformation and a sought after keynote speaker. He has been a regular contributor to both InformationWeek and CIO Insight...
Andrew Keys is Co-Founder of ConsenSys Enterprise. He comes to ConsenSys Enterprise with capital markets, technology and entrepreneurial experience. Previously, he worked for UBS investment bank in equities analysis. Later, he was responsible for the creation and distribution of life settlement products to hedge funds and investment banks. After, he co-founded a revenue cycle management company where he learned about Bitcoin and eventually Ethereal. Andrew's role at ConsenSys Enterprise is a mul...