Teradata Database 15 adds JSON, addresses internet of things

Teradata has added JSON to its data warehouse. Teradata Database 15 is said to fill out the logical data warehouse, much vaunted in the industry in recent years

Teradata has added JavaScript Object Notation (JSON) to its data warehouse as part of a slew of product announcements at its Universe event in Prague.

Teradata Database 15 is said to fill out the logical data warehouse, encompassing a range of an organisation’s data sources, much vaunted in the industry in recent years.

The supplier has also announced Teradata QueryGrid software, which it claimed optimises analytics “across the enterprise”.

Teradata also announced other enhancements to its active enterprise data warehouse 6750, as well as support in the core database for scripting languages Perl, Ruby, Python and R. 

It said its Teradata Database 15, with QueryGrid, offers bi-directional data movement and push-down processing to open source Hadoop, and that the announcements develop its unified data architecture approach to bridging the relational and non-relational technologies in the database market.

JSON inside

The supplier’s support for JSON is directed at the so-called internet of things – the world of sensors and embedded microprocessors.

Scott Gnau, president of Teradata Labs, said: “Users can now orchestrate analytic queries across multiple systems, integrate and consume JSON data, write and run non-SQL languages in-database and leverage new analytics. Teradata Database 15 delivers on the unified data architecture promise of enabling users to look access all data to get new, powerful insights.”

Teradata chief technology officer Stephen Brobst (pictured) said the addition of JSON functionality touched on an aspect of the offer of suppliers in the NoSQL movement, such as MongoDB, Datastax Cassandra, Couchbase and Basho.

“In Silicon Valley there is a religious war going on between the SQL and NoSQL bigots. Eventually, rationality will win through. Doing everything in SQL is not a good idea, and doing nothing in SQL is also not a good idea," he said.

Now you can bring together the JSON data types with SQL to provide a broader set of real-time analytics

Chris Twogood, Teradata

“[On the NoSQL side] Mongo does a good job of adding ease of use for Java programmers. Cassandra is good for web logging. But what I believe will happen is a repeat of what happened with object databases in the 1990s. Back then, the cry was the ‘relational model is dead, it has had its 20-year reign’. But, essentially, relational database engineers stole all the good ideas, and brought in object capability, killing those pure object database players.

“Now, learning from history, what’s going to happen when the mainstream databases – Teradata’s, Oracle’s, [IBM’s] DB2, and so on – add JSON into the relational database? It is not a hard thing to do. So what will be the differentiation of [the NoSQL] databases? They won’t go away, but they will be niche,” said Brobst.

Chris Twogood, vice-president, product and services marketing, at Teradata, said: “Now you can bring together the JSON data types with SQL to provide a broader set of real-time analytics.”

Read more on Database management