Click here to close now.


Java IoT Authors: Pat Romanski, Elizabeth White, Liz McMillan, SmartBear Blog, Gary Kaiser

News Feed Item

Teradata Warehouse is the Analytic Hub to Monetize the Internet of Things

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 evolving Internet 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.


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. 


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 for details.

Get to know Teradata:


Teradata is a trademark or registered trademark of Teradata Corporation in the United States and other countries.

SOURCE Teradata

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.

@ThingsExpo Stories
"Matrix is an ambitious open standard and implementation that's set up to break down the fragmentation problems that exist in IP messaging and VoIP communication," explained John Woolf, Technical Evangelist at Matrix, in this interview at @ThingsExpo, held Nov 4–6, 2014, at the Santa Clara Convention Center in Santa Clara, CA.
WebRTC has had a real tough three or four years, and so have those working with it. Only a few short years ago, the development world were excited about WebRTC and proclaiming how awesome it was. You might have played with the technology a couple of years ago, only to find the extra infrastructure requirements were painful to implement and poorly documented. This probably left a bitter taste in your mouth, especially when things went wrong.
Nowadays, a large number of sensors and devices are connected to the network. Leading-edge IoT technologies integrate various types of sensor data to create a new value for several business decision scenarios. The transparent cloud is a model of a new IoT emergence service platform. Many service providers store and access various types of sensor data in order to create and find out new business values by integrating such data.
The broad selection of hardware, the rapid evolution of operating systems and the time-to-market for mobile apps has been so rapid that new challenges for developers and engineers arise every day. Security, testing, hosting, and other metrics have to be considered through the process. In his session at Big Data Expo, Walter Maguire, Chief Field Technologist, HP Big Data Group, at Hewlett-Packard, will discuss the challenges faced by developers and a composite Big Data applications builder, focusing on how to help solve the problems that developers are continuously battling.
There are so many tools and techniques for data analytics that even for a data scientist the choices, possible systems, and even the types of data can be daunting. In his session at @ThingsExpo, Chris Harrold, Global CTO for Big Data Solutions for EMC Corporation, will show how to perform a simple, but meaningful analysis of social sentiment data using freely available tools that take only minutes to download and install. Participants will get the download information, scripts, and complete end-to-end walkthrough of the analysis from start to finish. Participants will also be given the pract...
WebRTC: together these advances have created a perfect storm of technologies that are disrupting and transforming classic communications models and ecosystems. In his session at WebRTC Summit, Cary Bran, VP of Innovation and New Ventures at Plantronics and PLT Labs, will provide an overview of this technological shift, including associated business and consumer communications impacts, and opportunities it may enable, complement or entirely transform.
SYS-CON Events announced today that Dyn, the worldwide leader in Internet Performance, will exhibit at SYS-CON's 17th International Cloud Expo®, which will take place on November 3-5, 2015, at the Santa Clara Convention Center in Santa Clara, CA. Dyn is a cloud-based Internet Performance company. Dyn helps companies monitor, control, and optimize online infrastructure for an exceptional end-user experience. Through a world-class network and unrivaled, objective intelligence into Internet conditions, Dyn ensures traffic gets delivered faster, safer, and more reliably than ever.
WebRTC services have already permeated corporate communications in the form of videoconferencing solutions. However, WebRTC has the potential of going beyond and catalyzing a new class of services providing more than calls with capabilities such as mass-scale real-time media broadcasting, enriched and augmented video, person-to-machine and machine-to-machine communications. In his session at @ThingsExpo, Luis Lopez, CEO of Kurento, will introduce the technologies required for implementing these ideas and some early experiments performed in the Kurento open source software community in areas ...
Too often with compelling new technologies market participants become overly enamored with that attractiveness of the technology and neglect underlying business drivers. This tendency, what some call the “newest shiny object syndrome,” is understandable given that virtually all of us are heavily engaged in technology. But it is also mistaken. Without concrete business cases driving its deployment, IoT, like many other technologies before it, will fade into obscurity.
Today air travel is a minefield of delays, hassles and customer disappointment. Airlines struggle to revitalize the experience. GE and M2Mi will demonstrate practical examples of how IoT solutions are helping airlines bring back personalization, reduce trip time and improve reliability. In their session at @ThingsExpo, Shyam Varan Nath, Principal Architect with GE, and Dr. Sarah Cooper, M2Mi's VP Business Development and Engineering, will explore the IoT cloud-based platform technologies driving this change including privacy controls, data transparency and integration of real time context w...
Who are you? How do you introduce yourself? Do you use a name, or do you greet a friend by the last four digits of his social security number? Assuming you don’t, why are we content to associate our identity with 10 random digits assigned by our phone company? Identity is an issue that affects everyone, but as individuals we don’t spend a lot of time thinking about it. In his session at @ThingsExpo, Ben Klang, Founder & President of Mojo Lingo, will discuss the impact of technology on identity. Should we federate, or not? How should identity be secured? Who owns the identity? How is identity ...
The IoT market is on track to hit $7.1 trillion in 2020. The reality is that only a handful of companies are ready for this massive demand. There are a lot of barriers, paint points, traps, and hidden roadblocks. How can we deal with these issues and challenges? The paradigm has changed. Old-style ad-hoc trial-and-error ways will certainly lead you to the dead end. What is mandatory is an overarching and adaptive approach to effectively handle the rapid changes and exponential growth.
The buzz continues for cloud, data analytics and the Internet of Things (IoT) and their collective impact across all industries. But a new conversation is emerging - how do companies use industry disruption and technology enablers to lead in markets undergoing change, uncertainty and ambiguity? Organizations of all sizes need to evolve and transform, often under massive pressure, as industry lines blur and merge and traditional business models are assaulted and turned upside down. In this new data-driven world, marketplaces reign supreme while interoperability, APIs and applications deliver un...
Electric power utilities face relentless pressure on their financial performance, and reducing distribution grid losses is one of the last untapped opportunities to meet their business goals. Combining IoT-enabled sensors and cloud-based data analytics, utilities now are able to find, quantify and reduce losses faster – and with a smaller IT footprint. Solutions exist using Internet-enabled sensors deployed temporarily at strategic locations within the distribution grid to measure actual line loads.
The Internet of Everything is re-shaping technology trends–moving away from “request/response” architecture to an “always-on” Streaming Web where data is in constant motion and secure, reliable communication is an absolute necessity. As more and more THINGS go online, the challenges that developers will need to address will only increase exponentially. In his session at @ThingsExpo, Todd Greene, Founder & CEO of PubNub, will explore the current state of IoT connectivity and review key trends and technology requirements that will drive the Internet of Things from hype to reality.
The Internet of Things (IoT) is growing rapidly by extending current technologies, products and networks. By 2020, Cisco estimates there will be 50 billion connected devices. Gartner has forecast revenues of over $300 billion, just to IoT suppliers. Now is the time to figure out how you’ll make money – not just create innovative products. With hundreds of new products and companies jumping into the IoT fray every month, there’s no shortage of innovation. Despite this, McKinsey/VisionMobile data shows "less than 10 percent of IoT developers are making enough to support a reasonably sized team....
You have your devices and your data, but what about the rest of your Internet of Things story? Two popular classes of technologies that nicely handle the Big Data analytics for Internet of Things are Apache Hadoop and NoSQL. Hadoop is designed for parallelizing analytical work across many servers and is ideal for the massive data volumes you create with IoT devices. NoSQL databases such as Apache HBase are ideal for storing and retrieving IoT data as “time series data.”
Today’s connected world is moving from devices towards things, what this means is that by using increasingly low cost sensors embedded in devices we can create many new use cases. These span across use cases in cities, vehicles, home, offices, factories, retail environments, worksites, health, logistics, and health. These use cases rely on ubiquitous connectivity and generate massive amounts of data at scale. These technologies enable new business opportunities, ways to optimize and automate, along with new ways to engage with users.
The IoT is upon us, but today’s databases, built on 30-year-old math, require multiple platforms to create a single solution. Data demands of the IoT require Big Data systems that can handle ingest, transactions and analytics concurrently adapting to varied situations as they occur, with speed at scale. In his session at @ThingsExpo, Chad Jones, chief strategy officer at Deep Information Sciences, will look differently at IoT data so enterprises can fully leverage their IoT potential. He’ll share tips on how to speed up business initiatives, harness Big Data and remain one step ahead by apply...
There will be 20 billion IoT devices connected to the Internet soon. What if we could control these devices with our voice, mind, or gestures? What if we could teach these devices how to talk to each other? What if these devices could learn how to interact with us (and each other) to make our lives better? What if Jarvis was real? How can I gain these super powers? In his session at 17th Cloud Expo, Chris Matthieu, co-founder and CTO of Octoblu, will show you!