Teradata accelerates JSON data query performance for improved business agility

Business users can now take full advantage of additional data from web applications, sensors, and IoT-connected machines and integrate it with other business data

SAN DIEGO, June 1, 2015 /PRNewswire/ -- To enable business users to more quickly extract insights from Java Script Object Notation (JSON) data, Teradata (NYSE: TDC), the big data analytics and marketing applications company, today announced it is the first to allow customers to natively store three key JSON data formats in a single database providing faster querying performance. The enhancements to the Teradata Database allow business users to take full business advantage of JSON data from web applications, sensors, and Internet of Things (IoT)-connected machines.

Follow this link to view the news release on

Teradata now provides customers with a choice of three formats: JSON data stored in BSON format, which works best for data in various forms; UBJSON format, which is optimized for numeric data; or the previously announced JSON format for text data. Customers can seamlessly mix and match the three JSON storage formats based on business needs and data attributes to drive faster query performance. The peak performance enables the Teradata Database to be the IoT analytic hub, because of its power to analyze JSON data along with operational and historical business data.

"Faster query performance and the dynamic nature of JSON data dramatically improve our customers' business agility," said Dan Harrington, executive vice president, Global Consulting and Support Services, Teradata. "In addition, these enhancements provide tighter integration with MongoDB, which customers use as an operational repository of JSON data."

The tighter integration between Teradata and MongoDB means data can move back and forth effortlessly between the two databases. Data can move from MongoDB in its native BSON format and be loaded directly into Teradata, eliminating the overhead associated with data conversion and significantly improving analytic performance.

"We are pleased that Teradata now supports binary JSON data storage formats, including BSON," said Kelly Stirman, vice president of strategy, MongoDB. "Today's enterprise is building applications faster than ever before with MongoDB. By natively supporting these flexible data structures used in operational applications, Teradata opens the door to new classes of analytics and a comprehensive view of the enterprise."

For example, a printer manufacturer has been collecting basic sensor data from printers located at customer sites, which allows them to track service requirements. With the ability to store and analyze the sensor data in the Teradata Database, the printer manufacturer can greatly expand their analytic capability. By combining operational sensor data with customer account status, call center statistics, and marketing history, the company can improve its understanding of the business operations. In addition, it can accelerate initiatives that support new product offers for customers and improve manufacturing processes.

"The rapidly emerging IoT presents enormous opportunities for data warehousing and analytics. It also presents a number of challenges," said Dr. Barry Devlin, founder and principal. 9sight Consulting. By embedding JSON support in a true relational database product, Teradata offers its customers the opportunity to leverage those opportunities, while circumventing many of the challenges business users experience in finding, understanding, and analyzing data in pure JSON data stores alone.

This feature will be available in Teradata Database 15.10 by the end of second quarter.

Relevant Links 1. Barry Devlin, 9sight Consulting -

About Teradata

Teradata (NYSE: TDC) helps companies get more value from data than any other company. Teradata's leading portfolio of big data analytic solutions, integrated marketing applications, and services can help organizations gain a sustainable competitive advantage with data. Visit

Teradata and the Teradata logo are trademarks or registered trademarks of Teradata Corporation and/or its affiliates in the U.S. and worldwide.

SOURCE Teradata


Visit PR Newswire for Journalists, our free resources for releases, photos and customized feeds. You can also send a free ProfNet request for experts.

JSON (JavaScript Object Notation) is a lightweight data-interchange format. It is easy for humans to read and write. It is easy for machines to parse and generate.

DSS Home |  About Us |  Contact Us |  Site Index |  Subscribe | What's New
Please Tell 
Your Friends about DSSResources.COM Copyright © 1995-2021 by D. J. Power (see his home page). DSSResources.COMsm was maintained by Daniel J. Power. See disclaimer and privacy statement.