format_quote Press Release

Teradata Delivers World’s Most Advanced Hybrid Row and Column Database

Share
May 7, 2015 | SAN DIEGO

Innovations allow customers to mix and match row and column technologies at will, without the trade-offs of purely columnar databases.

To help organizations achieve extreme query performance for operational and analytical workloads, Teradata (NYSE: TDC), the big data analytics and marketing applications company, today announced enhancements to the Teradata Database’s  hybrid row and column capabilities. The enhancements provide quicker access to data stored on columnar tables, which drive faster query performance for more agile business decisions.

Other relational database management systems store data tables in rows or columns, and each method offers unique benefits, depending on the application and type of data. However, they have been mutually exclusive. Teradata’s new hybrid row and column capabilities allow the best of both worlds. Teradata’s technical innovations have made it possible to pinpoint single-row data retrieval for fast tactical queries, which reduces unnecessary row scanning. In addition, the “update-in-place” technical capability allows data to be updated within the row, without the need to copy the updated information at the bottom of the table, as is common for columnar databases. These technical enhancements improve query performance and storage efficiency.
"Teradata developed the industry’s-first hybrid row and column database and has now enhanced it, setting a new standard for database functionality," said Dan Harrington, executive vice president, global consulting and support services, Teradata. "Teradata Database’s unmatched flexibility supports organizations grappling with massive volumes of data, more concurrent users, and increased demands for better intelligence. This new hybrid capability reduces the amount of data read in wide tables, while preserving pinpoint data access for real-time operational queries."
For example, telecommunications companies have very wide tables that capture all of the data about each network call in Call Detail Records. With Teradata hybrid row and column capabilities, these wide tables can support analytical queries on different columns for network quality and regional traffic volume analyses, while also offering direct access to a single row for a call center query for customer support.
This innovation will be available with Teradata Database 15.10, by the end of second quarter.
Relevant Links
Media Kit Learn More
Contact Us Learn More
About Teradata Learn More

Teradata GDPR

As a data and analytics leader, Teradata vows to only collect and use your personal data with your permission. As a steward of your data, we want you to fully understand and have complete control over how your personal data is used by our company.

Benefits of Sharing Your Data With Us

Your personal data allows us to create a better online experience for you. Depending on the level of access you grant us to your data, we can tailor content on the site to fit your needs. And we can provide you with related digital advertisements across multiple channels.

What Choices Do I Have?

Choose the solution that best describes your preference:

Personalize my online experience

My data will be stored by Teradata and as a result, I may receive experience customized content on Teradata.com and see digital ads that are targeted to my specific interests

Do not personalize my online experience

None of my personal data will be tracked, so content on Teradata.com will not be personalized for me and Teradata will not use my data to show me targeted digital ads

Updating Settings in the Future

To update your privacy settings in the future, click Privacy on the top right of any page on the site, or under company in the main site navigation or in the footer