Hi Hasitha, This would be an interesting exploration. Have you tried out your idea with something like Neo4J? Have you come across any performance comparison articles/papers of Graph DBs such as Neo4J, FlockDB, InfiniteGraph with Column DBs such as Cassandra?
Shahani On Fri, Aug 17, 2012 at 8:24 PM, Hasitha Aravinda <[email protected]>wrote: > Hi Devs, > > In MetCat, it is a requirement to store relationships between data entities > and query about them. It might not be possible to achieve optimum > efficiency for query results since we are using non-relational database, > i.e. Cassandra. > > As an example take following entities A,B,C,D,E... etc. * If > A->C->B->D->E and B->F->G->K* > We might want to know whether there exists a relationship between A and F > (That is path between A and F) > > In real world there may be thousands of entities and relationships which > may degrade the query efficiency well if we used conventional databases to > address such requirements. These kind of requirements are hardly filled by > Cassandra but Graph databases. > > So for the above requirement, we might need to use graph database too. We'd > like to know your opinions on this. > > Thanks, > Hasitha. > -- *Shahani Markus Weerawarana, Ph.D.* *Computer Scientist* Visiting Lecturer, University of Moratuwa, Sri Lanka. Visiting Scientist, Indiana University, USA.
