We would like to create our own ERP solution for using in several different use-cases: CRM, remote mobile app management, e-commerce, advanced content management and more.
You might want to refer it as a "Line of business" AKA L.O.B type of apps.
Most of the apps that we are going to integrate inside are not that much of a "heavy relational schema".
Some have 4 JOINS in an extream use-case and some in the future might have 20+ joins.
Can NEO4J be used as a database for none GRAPH oriented type of schemas?
We want to create one infrastructure in JAVA to serve all, heavy and less heavy relational databases.
if neo4j is suitable with LOB apps, how is that performing when you just want to search for a customer entity.
where height > 1.96 and (language = 'en' or lang = 'es') and address like '%abc%'order by... group by...
or even more simple:
where id = 'some id' by... group by...
Will these type of queries be less effective then MONGO/MYSQL?
We definitely don't want to create an internal abstracted ORM that will be use-cases dependent, some time to use SQL some time to use BIG DATA and some time to use Graph, this would be impossible to maintain.
We would love to be coupled with the chosen database.
- would you say that neo4j can cover all the database use-cases I have raised here?