Click here to close now.


Java IoT Authors: Pat Romanski, Liz McMillan, Elizabeth White, Betty Zakheim, Steve Watts

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
Growth hacking is common for startups to make unheard-of progress in building their business. Career Hacks can help Geek Girls and those who support them (yes, that's you too, Dad!) to excel in this typically male-dominated world. Get ready to learn the facts: Is there a bias against women in the tech / developer communities? Why are women 50% of the workforce, but hold only 24% of the STEM or IT positions? Some beginnings of what to do about it! In her Day 2 Keynote at 17th Cloud Expo, Sandy Carter, IBM General Manager Cloud Ecosystem and Developers, and a Social Business Evangelist, wil...
PubNub has announced the release of BLOCKS, a set of customizable microservices that give developers a simple way to add code and deploy features for realtime apps.PubNub BLOCKS executes business logic directly on the data streaming through PubNub’s network without splitting it off to an intermediary server controlled by the customer. This revolutionary approach streamlines app development, reduces endpoint-to-endpoint latency, and allows apps to better leverage the enormous scalability of PubNub’s Data Stream Network.
Apps and devices shouldn't stop working when there's limited or no network connectivity. Learn how to bring data stored in a cloud database to the edge of the network (and back again) whenever an Internet connection is available. In his session at 17th Cloud Expo, Ben Perlmutter, a Sales Engineer with IBM Cloudant, demonstrated techniques for replicating cloud databases with devices in order to build offline-first mobile or Internet of Things (IoT) apps that can provide a better, faster user experience, both offline and online. The focus of this talk was on IBM Cloudant, Apache CouchDB, and ...
I recently attended and was a speaker at the 4th International Internet of @ThingsExpo at the Santa Clara Convention Center. I also had the opportunity to attend this event last year and I wrote a blog from that show talking about how the “Enterprise Impact of IoT” was a key theme of last year’s show. I was curious to see if the same theme would still resonate 365 days later and what, if any, changes I would see in the content presented.
Cloud computing delivers on-demand resources that provide businesses with flexibility and cost-savings. The challenge in moving workloads to the cloud has been the cost and complexity of ensuring the initial and ongoing security and regulatory (PCI, HIPAA, FFIEC) compliance across private and public clouds. Manual security compliance is slow, prone to human error, and represents over 50% of the cost of managing cloud applications. Determining how to automate cloud security compliance is critical to maintaining positive ROI. Raxak Protect is an automated security compliance SaaS platform and ma...
Most of the IoT Gateway scenarios involve collecting data from machines/processing and pushing data upstream to cloud for further analytics. The gateway hardware varies from Raspberry Pi to Industrial PCs. The document states the process of allowing deploying polyglot data pipelining software with the clear notion of supporting immutability. In his session at @ThingsExpo, Shashank Jain, a development architect for SAP Labs, discussed the objective, which is to automate the IoT deployment process from development to production scenarios using Docker containers.
Countless business models have spawned from the IaaS industry – resell Web hosting, blogs, public cloud, and on and on. With the overwhelming amount of tools available to us, it's sometimes easy to overlook that many of them are just new skins of resources we've had for a long time. In his general session at 17th Cloud Expo, Harold Hannon, Sr. Software Architect at SoftLayer, an IBM Company, broke down what we have to work with, discussed the benefits and pitfalls and how we can best use them to design hosted applications.
We all know that data growth is exploding and storage budgets are shrinking. Instead of showing you charts on about how much data there is, in his General Session at 17th Cloud Expo, Scott Cleland, Senior Director of Product Marketing at HGST, showed how to capture all of your data in one place. After you have your data under control, you can then analyze it in one place, saving time and resources.
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....
Just over a week ago I received a long and loud sustained applause for a presentation I delivered at this year’s Cloud Expo in Santa Clara. I was extremely pleased with the turnout and had some very good conversations with many of the attendees. Over the next few days I had many more meaningful conversations and was not only happy with the results but also learned a few new things. Here is everything I learned in those three days distilled into three short points.
DevOps is about increasing efficiency, but nothing is more inefficient than building the same application twice. However, this is a routine occurrence with enterprise applications that need both a rich desktop web interface and strong mobile support. With recent technological advances from Isomorphic Software and others, rich desktop and tuned mobile experiences can now be created with a single codebase – without compromising functionality, performance or usability. In his session at DevOps Summit, Charles Kendrick, CTO and Chief Architect at Isomorphic Software, demonstrated examples of com...
As organizations realize the scope of the Internet of Things, gaining key insights from Big Data, through the use of advanced analytics, becomes crucial. However, IoT also creates the need for petabyte scale storage of data from millions of devices. A new type of Storage is required which seamlessly integrates robust data analytics with massive scale. These storage systems will act as “smart systems” provide in-place analytics that speed discovery and enable businesses to quickly derive meaningful and actionable insights. In his session at @ThingsExpo, Paul Turner, Chief Marketing Officer at...
In his keynote at @ThingsExpo, Chris Matthieu, Director of IoT Engineering at Citrix and co-founder and CTO of Octoblu, focused on building an IoT platform and company. He provided a behind-the-scenes look at Octoblu’s platform, business, and pivots along the way (including the Citrix acquisition of Octoblu).
In his General Session at 17th Cloud Expo, Bruce Swann, Senior Product Marketing Manager for Adobe Campaign, explored the key ingredients of cross-channel marketing in a digital world. Learn how the Adobe Marketing Cloud can help marketers embrace opportunities for personalized, relevant and real-time customer engagement across offline (direct mail, point of sale, call center) and digital (email, website, SMS, mobile apps, social networks, connected objects).
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, exploreed the current state of IoT connectivity and review key trends and technology requirements that will drive the Internet of Things from hype to reality.
Two weeks ago (November 3-5), I attended the Cloud Expo Silicon Valley as a speaker, where I presented on the security and privacy due diligence requirements for cloud solutions. Cloud security is a topical issue for every CIO, CISO, and technology buyer. Decision-makers are always looking for insights on how to mitigate the security risks of implementing and using cloud solutions. Based on the presentation topics covered at the conference, as well as the general discussions heard between sessions, I wanted to share some of my observations on emerging trends. As cyber security serves as a fou...
With all the incredible momentum behind the Internet of Things (IoT) industry, it is easy to forget that not a single CEO wakes up and wonders if “my IoT is broken.” What they wonder is if they are making the right decisions to do all they can to increase revenue, decrease costs, and improve customer experience – effectively the same challenges they have always had in growing their business. The exciting thing about the IoT industry is now these decisions can be better, faster, and smarter. Now all corporate assets – people, objects, and spaces – can share information about themselves and thei...
The cloud. Like a comic book superhero, there seems to be no problem it can’t fix or cost it can’t slash. Yet making the transition is not always easy and production environments are still largely on premise. Taking some practical and sensible steps to reduce risk can also help provide a basis for a successful cloud transition. A plethora of surveys from the likes of IDG and Gartner show that more than 70 percent of enterprises have deployed at least one or more cloud application or workload. Yet a closer inspection at the data reveals less than half of these cloud projects involve production...
Discussions of cloud computing have evolved in recent years from a focus on specific types of cloud, to a world of hybrid cloud, and to a world dominated by the APIs that make today's multi-cloud environments and hybrid clouds possible. In this Power Panel at 17th Cloud Expo, moderated by Conference Chair Roger Strukhoff, panelists addressed the importance of customers being able to use the specific technologies they need, through environments and ecosystems that expose their APIs to make true change and transformation possible.
Microservices are a very exciting architectural approach that many organizations are looking to as a way to accelerate innovation. Microservices promise to allow teams to move away from monolithic "ball of mud" systems, but the reality is that, in the vast majority of organizations, different projects and technologies will continue to be developed at different speeds. How to handle the dependencies between these disparate systems with different iteration cycles? Consider the "canoncial problem" in this scenario: microservice A (releases daily) depends on a couple of additions to backend B (re...