F3vgqtjc 1392865931

The new technologies needed for dealing with big data

MongoDB co-founder and chairman Dwight Merriman still writes code. TechCrunch/Flickr, CC BY-NC

The new technologies needed for dealing with big data

MongoDB co-founder and chairman Dwight Merriman still writes code. TechCrunch/Flickr, CC BY-NC

While much focus and discussion of the so-called “Big Data revolution” has been on the data itself and the exciting new applications it is enabling — from Google’s self-driving cars through to CSIRO and University of Tasmania’s better information systems for oyster farmers — less focus has been on the underpinning technologies and the talent driving these technologies.

At the heart of the Big Data movement is a range of next generation database technologies that enable data to be amassed and analysed on a scale and speed hitherto unseen.

Global online services such as Google, Amazon and Facebook that serve billions of people around the world in real time have been made possible due to new technologies that divide tasks and files across banks of thousands of distributed computers.

Storing the data

Traditional database technologies are built around many tables of information like spreadsheets with rows and columns and a way of asking questions of these tables in a structured way.

The structured way of asking a question of these data collections was originally named SEQUEL (Structured English Query Language), later shortened to SQL. This is the technology that Oracle pioneered in the 1970s and it has served them well to become the undisputed king of database technology ever since.

If you are familiar with Excel, you’d be familiar with the type of information this kind of technology is suited to representing. Company accounts, marketing and sales figures over time are of course perfect.

But there are other types of data that isn’t so easily stored in this way such as storing the relationships in a social network (Facebook), or index of documents stored on the web (Google), or for large collections of digital music and video (Netflix).

Fortunately there are other ways to store information other than in tables such as in trees, graphs, or in lists with an index. And some of these approaches are much better suited for humungous data sets and for data sets that don’t naturally fit into a series of tables.

The growing demand to store and analyse very large bodies of information, and information that is not readily suited to storing in tables (unstructured data), has led to a rapid growth in the popularity of these alternative types of database technologies.

Rising Tide. Google Trends.

Collectively they’ve become known as NoSQL technologies. Many of the leading technologies in this category are not developed by one company, such as Oracle or Microsoft, but instead are open source - developed by an open network of companies and independent developers and contributors akin to the way Wikipedia or Linux is developed.

Next-generation database technology

There are five key types of next-generation NoSQL data technologies. They are:

  1. Document Store — suitable for storing large collections of documents
  2. Wide Column Store — for very rapid access to structured or semi structured data
  3. Search Engine — suitable for full text indexing of documents
  4. Key-Value Store – suitable for rapid access to unstructured data
  5. Graph Database – suitable for storing graph type data such as social networks.
New data intensive applications are being made possible with a new generation of database technologies. James Ruffer holding up a Neo4j sticker at TechCamp Memphis. Flickr/Jeremy Kendell

And the leading technologies in each of these categories respectively are:

Note Apache Hadoop, which is also a leading technology, is not included in this list as it is a framework and file system and not a database technology (but can support many of these).

Leading NoSQL Database technologies in each of top 5 categories. DB-Engines.com

Where there’s talent there’s fire

By looking at the companies around the world who have the most employees with skills in each of these these frontier technologies, we can get a unique insight into organisations at the forefront of next generation big data applications.

Based on more extensive study, below is a map covering 40 leading global organisations that have the greatest number of specialists in each of the top five next-gen database technologies.

The Conversation

Click here to open in new window or republish.

The more detailed country-by-country analysis has revealed some organisations such as Sky in the London, Goldman Sachs in NYC are leaders in the number people they have with skills in these emerging areas.

Found this article useful? A tax-deductible gift of $30/month helps deliver knowledge-based, ethical journalism.