M
M
Maxim2013-05-03 20:58:07
SQL
Maxim, 2013-05-03 20:58:07

Choosing a DBMS for a task

A DBMS is required that satisfies the following requirements (in short):
the user adds information about any objects (entities) using a graphical interface (house (house number, number of apartments ...), car (mass, maximum speed, price ...), washing machine (volume, power consumption, color...)), and then can work with these entities:
— add-edit instances (records, data);
- create links between entities (when information about a house is deleted, all information about washing machines installed in it is deleted);
- make queries to these entities, for example: "find all green washing machines in the apartments of houses with even numbers on the 5th floor" (using QBE, or, in special cases, using the built-in DBMS query language).

Those. something like Accessess, but lighter and simpler. Those. physical creation of relational tables for each user entity is not the best option. WEB-interface is planned.

I was already puzzled by this question and even settled on this solution - habrahabr.ru/post/164803/ (in short: store entity instances in one table in xml format, and make sql queries to them using xpath).
It seems that everything is not bad, but the implementation of relationships between entities is crooked (you have to use an auxiliary table to store the correspondences, or embed the keys in xml).

But recently I once again stumbled upon Neo4j and I'm thinking about using it.

Tell me, can she approach such a task?
What are the other options?

Answer the question

In order to leave comments, you need to log in

3 answer(s)
E
EugeneOZ, 2013-05-03
@EugeneOZ

MongoDB or Riak.

C
ch3sh1r3, 2013-05-04
@ch3sh1r3

Plus to MongoDB. Or postgresql

A
alex4zero, 2013-05-04
@alex4zero

In general, according to ThoughtWorks' Technology Radar, dated October 12th, they recommend Neo4j to be used immediately. In addition, if you have a desire to try Neo4j, then you won’t find a better option.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question