Relational databases handle type hierarchies badly. A common workaround is a "type" column in a table, which flattens all subtypes into a single wide row and forces application code to pick which columns apply. Object-oriented code has classes, inheritance but Java struggles with multiple parents. Graph databases have something more profound. The relationship itself carries… Continue reading Inheritance in Graph Databases: How to Model a Type and Its Subtypes
Graph databases promise a natural fit for complex, relationship-heavy domains. But there's a successful implementation gap between a promising prototype and a production system that performs, scales, and survives organisational change. This article is based on my personal experience building three real-world graph ontologies in three different organisations. First was BT's network inventory (SRIMS), second… Continue reading Graph Ontologies Design from BT, Nature Metrics & NHS England