Answer the question
In order to leave comments, you need to log in
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
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question