Max Neunhöffer from ArangoDB shows an use case for multi-model NoSQL databases on Strata + Hadoop World 2015 in London. Join his Session on 6th of May.
We describe a case study in aircraft fleet management, where we needed a database that would store data about all the different parts and subunits of an aircraft. A single aircraft already contains some 6,000,000 parts, not counting components.
The particular structure of the queries arising naturally from day-to-day processes quickly led to the insight that no single data model was sufficient to ensure satisfactory performance. Whichever data model we tried, there was always at least one important query that would either take ages to complete or be unbearably complicated, or indeed both.
After a lot of frustration, the happy end could be achieved by using a multi-model database, which is a document store, a graph database, and a key/value store – all in one engine – held together by a common and flexible query language. Suddenly, all pieces fell into place and all required queries could be performed not only quickly, but also conveniently!
In this approach, parts and subunits are represented by JSON documents, which are the vertices of a graph, and the edges of the graph describe the containment. In this way, using graph queries, one can quickly find out, for example, what the smallest replaceable component containing a certain broken part is. As a further example, using document queries and secondary indexes, one can quickly find all documents corresponding to parts or subunits that need maintenance in the next week.
In this talk we tell the story of this case study, and explain why it was a real eye-opener that taught us a lesson about data modeling in general as well as database engines in particular, that will help us in a large class of other use cases.
Max Neunhöffer (ArangoDB GmbH)
11:45–12:25 Wednesday, 6/05/2015
Location: St. James / Regents