10-21-13 5:30 AM EDT | Email Article

Teradata removes hurdles to combined analysis of data from global devices, operations, and historical business data

DALLAS, Oct.  21, 2013 /PRNewswire/ -- PARTNERS User Group Conference -- To help customers quickly respond to opportunities created by the evolvingInternet of Things,Teradata(NYSE: TDC), the leading analytic data platforms, applications and services company, today revealed that customers will be able to add Java Script Object Notation (JSON) data to their data warehouse. This is a significant advancement, because JSON is the primary language that powers the Internet of Things, a global collection of millions of sensors and embedded microprocessors. Current Online Transaction Processing (OLTP) technology allows for transactional processing of JSON data. However, the OLTP technology doesn't allow for scalable analytics on massive data volumes, which is provided by Teradata's parallel processing analytic engine.

(Logo:  http://photos.prnewswire.com/prnh/20130716/CL47933LOGO)

The inclusion of JSON data will establish the Teradata Data Warehouse as the analytic hub from which customers gain business value from the Internet of Things. Customers will be empowered to monetize the Internet of Things by aggregating and analyzing data from diverse machines joined to operational and historical business data. Customers will benefit from Teradata's scalable engine applied to JSON data with JSONPath, a data manipulation feature. In addition, the data will be a part of the Integrated Data Warehouse, which extends the value of operational analytics.

"The Internet of Things will drive the next wave of data growth and it has the potential to change the world, just as the Internet did. Teradata's customers will be the first to take advantage of this new technology and drive advanced analytics," said Scott Gnau, president, Teradata Labs. "And, our customers can apply all of Teradata Database's features and functionality to the analysis of JSON data. In addition, they will be able to use the bundled JSON data with JSONPath, without the need to build a separate, isolated platform."

"A third of organizations surveyed by IDC earlier this year reported that they have started incorporating new data sources in their big data and analytics solutions. A growing number are integrating two or more sources of data, such as social networks, sensors, mobile devices, and click streams," said Dan Vesset, program vice president, Business Analytics and Big Data IDC. "As data from the Internet of Things continues to grow, many organizations will have to accelerate their efforts to capture, integrate, and use it. Teradata's strategy that enables organizations to integrate JSON data into a data warehouse is an important step toward enabling customers to ensure they don't miss opportunities to improve or create new analytics based on new data sources."

JSON is the primary data exchange language that allows the Internet of Things to connect and communicate with millions of devices. Teradata enables customers to apply the power and performance of the Teradata Database to the massive amounts of data. The Teradata Database is agile and flexible and can capture, index, analyze, and manage JSON data, as if it were just another data element. A separate platform or application is not required. With the inclusion of JSON data in the data warehouse, all the complexity is removed and business users can apply all their favorite tools and techniques to the data. Teradata stores JSON data and its schema together to minimize the need for ongoing database design (schema) changes.

Some uses of JSON data by the Internet of Things are described below.

  • Municipal landscape sprinklers will send facts to city agencies for analysis leading to the conservation of water usage.   
  • Networks in homes and office facilities will constantly analyze and optimize energy use, ultimately sharing information with the utilities company and alerting consumers to failing appliances. 
  • Smart factories will evolve from improving quality to new levels of inventory control and supply chain optimization. 
  • RFID tags and smart sensors on shelves will enable analysis of sales and inventory in real time as well as how long a shopper lingers at a display. 

(Photo:  http://photos.prnewswire.com/prnh/20131021/CL00596-INFO)

Technical Innovation Drives Analytics

JSON is a freeform text document - sometimes called an object - that typically has rich information. Because JSON is a highly flexible way to represent data, it is easy for programmers and database administrators to use it. JSON documents can then be loaded into the data warehouse with little additional effort. From there, business intelligence tools allow the business user to run queries directly on JSON data.

Teradata stores the entire JSON object directly into a column in a table so it can be used in multiple ways. The uniqueness of Teradata's innovation makes JSON documents accessible to the business user. Database administrators will use the JSONPath dot.notation to name the columns in the table. The dot.notation is familiar to Java and C programmers and makes it easier for them to work with the SQL language. More important, it allows the Teradata Database to extract the useful values from the JSON object in real time. This makes it easier to use instead of asking programmers to learn yet another language. Other databases must use ETL processes to shred the JSON document into rows and columns, adding complexity and losing valuable data. 

In addition, JSON allows users to place multiple documents inside one big document. The big document has all the data on a topic such as location-based advertisements that are pushed to mobile phones based on the geospatial location of the phone owner. The JSON documents can contain a complete history of a consumer's locations, responses to geo-based ads, and activity before and after seeing the ads. From a single JSON document, analysis can increase click through rates, dropped calls, and provide insights for new services.

The JSON data capability will be available with the next release of the Teradata Database during the second quarter of 2014.

About Teradata

Teradata (NYSE: TDC), a global leader in analytic data platforms, marketing and analytic applications, and consulting services, helps organizations become more competitive by increasing the value of their data and customer relationships. 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.

SOURCE Teradata

Add a Comment

News   More...

Securities related to this article
TDC A/S View tdc Stock Quote
TDC SOFTWARE ENGINEERING Inc. View 4687 Stock Quote
Teradata Corporation View tdc Stock Quote
Tyhee Gold Corp View tdc Stock Quote
Teradata Corporation View tdc Stock Quote
 
Start Premium Trial Register For Free

P F Fund Financial Data (13,000+ funds)
P F Stock Financial Data (7,000+ stocks)
P F Stock and Fund Screeners (basic)
P F Investing Articles and Market Commentary
P F Articles Archive (>30 days)
P F Discuss (dozens of stock, fund, bond, and general bulletin boards)
P F Portfolio Manager (basic)
P F Morningstar Investment Classroom
P F Access Your Portfolio Anytime, Anywhere via Your Mobile Device
P   Morningstar Fund Analyst Reports (full research on 1,700 funds, ETFs, and CEFs)
P   Morningstar Stock Analyst Reports (full research on more than 1,100 stocks)
P   Portfolio Manager (advanced with 10 X-Ray analyses, including recommendations)
P   Portfolio Monitor (monthly and on-demand personalized portfolio statements)
P   Morningstar Proprietary Stock Information (stock star ratings, buy/sell prices, economic moat ratings, and more)
P   Morningstar 5-Star Stock and Fund Favorites & Red Flags eNewsletters
P   Premium Stock and Fund Screeners (advanced with nearly infinite ways to find the best securities for you)
P   Discounts on Morningstar newsletters, books, seminars, and more

Sign-up to Morningstar


Basic Access

Articles and Videos
Morningstar video reports, articles, data, and tools. Dig into our lineup of e-newsletters and investing classroom courses outlining sensible strategies for maximizing your investments.
Morningstar Discuss
Follow the buzz on individual stocks or fund families. Plus, read the latest posts from Morningstar members and analysts.
Portfolio Manager
Track your investments and watch lists with our Portfolio Manager. Customize your view with our comprehensive stock, fund, and ETF data.

Access these features and more when you sign up for Free Membership.
Join Morningstar today. It's Free.

Unlimited Access

Analyst Research
Gather in-depth, actionable insight on over 3,700 stock and mutual funds covered by Morningstar analysts. View our mutual fund Analyst Reports favored by professionals, savvy experienced investors, and new investors researching options for retirement savings, college plans, or other investment needs.
Portfolio X-Ray®
Ensure your portfolio is positioned exactly how you want with Morningstar's X-Ray Interpreter and Stock Intersection tools. A Barron's "Best of the Web" award winner for five years running, X-Ray Interpreter goes under the hood of your portfolio to provide a useful allocation, sector, and geographic analysis. And you can discover how much of a stock you really own, individually and through mutual funds, with Stock Intersection.
Investment Picks
Find new 5-star stocks (greatly undervalued companies) to consider daily. Our 5-star stock rating is a proven winner, consistently beating benchmarks like the S&P 500. Plus, browse our Fund Analyst Picks and Stewardship Grades to find shareholder-friendly mutual funds that are poised for outperformance.
Portfolio Monitor
Get a clear view of your investments with personalized reports about your portfolio. Receive monthly statements and generate reports on-demand to help you stay on track to meet your investment goals.

Access these features and more when you sign up for Premium Membership.
Start your free 14-day trial today online
Your subscription may be tax deductible. Please contact your tax advisor.

Content Partners
Morningstar - - Teradata Warehouse is the Analytic Hub to Monetize the Internet of Things
Name |  Ticker |  Star Rating |  Market Cap |  Stock Type |  Sector |  Industry Star Rating |  Investment Style |  Total Assets |  Category |  Top Holdings |  Top Sectors |  Symbol |  Title Star Rating |  Category |  Total Assets |  Top Holdings |  Top Sectors |  Symbol |  Name Topic |  Sector |  Key Indicators |  User Interest |  Market Cap |  Industry Name |  Ticker |  Star Rating |  Market Cap |  Stock Type |  Sector |  Industry Star Rating |  Investment Style |  Total Assets |  Category |  Top Holdings |  Top Sectors |  Symbol / Ticker |  Title Star Rating |  Category |  Total Assets |  Symbol / Ticker |  Name Title |  Date |  Author |  Collection |  Popularity |  Interest Title |  Date |  Company |  Symbol |  Interest |  Popularity Title |  Date |  Company |  Symbol |  Interest |  Popularity Title |  Date |  Author |  Collection |  Interest |  Popularity

Previous: Teradata Unleashes Full-Throttle Performance  |  Next: Teradata warns of shortfall; stock slides