I want to create a database for myself. The data has complex grouping. I don't know which system to use to create my database. The data is in groups and sub-group forms, it almost has 5-6 layers of subgroups. I tried SQL but such complex sub-groups are not possible in it.

I really need to create the database. Hope for some good advice. enter image description here

This is the type of grouping I want to do and I am searching for a kind of system that can save such data in a way that when I want to filter the data to find something I can get the results.

EG: if I search for high toughness properties of a material then MS and high carbon steel should appear.

Hope this helps.

  • 2
    Thanks for updating your question. It is the weekend now, which is typically a quieter time, but while you're waiting for a specific answer, you might like to review answers in the "subtypes" category (click on the tag I added) like this answer for example.
    – Paul White
    Aug 22 '15 at 12:42
  • 1
    What database are you using? Your scenario doesn't look that complex to me. I don't see why you can't use SQL. Depending upon volume of data and performance required you could do it with a single table. Aug 26 '15 at 4:39

You can use PostgreSQL's inheritance feature.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.