Am investigating some db technologies for an application I'm working on and just came across Graph DBs (note I'm not a db guy). Just playing around a bit with neo4j's online REPL felt a little more natural to model out data. However, as I dig into it, people seem to take the stance of GDB being particularly well suited for certain applications but stick with Relational where possible. Is this mentality more about Relational being much more widely adopted in society today (and thus more tested, optimized, understood, etc.) as opposed to some deficiency in modelling problems with graphs (I'm inclined to make a comparison between functional language vs object oriented vs procedural programming languages where thinking in Graphs these days causes a bit of a mental shift and therefore dissuaded b/c it "feels" different -- much like going from C (procedural) to C++ (oo) and now C++ (oo) to F# (functional) )<p>For example, if we just take a simple case: Modelling out a Restaurant Menu that serves Breakfast, Brunch (on Weekends), Lunch, Dinner, Desserts, Drinks, I can see both GDB and Relational being able to solve the problem but why would I necessarily choose Relational over GDB (or vice/versa)?
Because graphdb are not good at listing/scanning single types e.g. Lunch, Dessert, Drinks, etc. Simple queries have similar complexity but there is no optimization for the mildly complex queries:<p>> SELECT COUNT(drink.id) FROM lunch, drink WHERE lunch.id == drink.lunch_id ORDER BY lunch.delivery_date, lunch.total_price<p>Everything that is not recursive is better served by RDBMS.<p>My understanding is that it's not that it's impossible to optimize the RDBMS usecase in graphdb implementation but that it's difficult in terms of query language to express both the traversal and scan. Arangodb want to be tackle that area through AQL.<p>You can also build somekind of graphdb schema, a specific graph topology that alleviate the need for specific optimization by basically denormalizing the schema.<p>> I'm inclined to make a comparison between functional language vs object oriented vs procedural programming languages<p>IMO tinkerpop and neo4j looks like Python (dynamic oo and functional language) vs Java (static typed and class based) which look like RDBMS. ArangoDB and OrientDB (multi-model) looks like Scheme Guile.<p>Even if graphdbs have weakness, like dynamic programming, they allow to build things more quickly.<p>> where thinking in Graphs these days causes a bit of a mental shift and therefore dissuaded b/c it "feels" different<p>Yes definitely. That said from my point of view, it's clear where a graphdb "is the right tool for the job" whereas functional programming is a writing style that can be applied to procedural or OO languages; It's not clear what's the pragramatic purpose of purely functional language.