Questions tagged [ontology]

Ontology deals with entities and how they can be categorized and organized according to their attributes. This includes how metadata is modelled and interpreted.

Ontology deals with questions concerning what entities exist or can be said to exist, and how such entities can be grouped, related within a hierarchy, and subdivided according to similarities and differences (see also Wikipedia). Ontology is the branch of metaphysics that studies the nature of existence or being as such.

In the context of databases, ontology deals with metadata and schemata. Questions with this tag deal with the proper modelling and interpretation of metadata.

3 questions
74
votes
5 answers

Is there a name for this database schema of key values?

We process a routine data feed from a client who just refactored their database from a form that seems familiar (one row per entity, one column per attribute) to one that seems unfamiliar to me (one row per entity per attribute): Before: one column…
prototype
  • 853
  • 1
  • 7
  • 6
6
votes
1 answer

EAV structure explained in Layman's terms

I've read several articles online that explain how EAV structures work, but there are different interpretations of them. Some articles mention that it's a representation of a data model metadata (or schema). Other articles describe an EAV…
JustBeingHelpful
  • 2,116
  • 18
  • 45
  • 61
-1
votes
2 answers

What is a single-table relational database

I searched Google for the definition of a single-table relational database and found nothing but redirection to other database models. What's up? Why is this concept confusing? Every relational database is also a single-table relational database.…