Swiss Insurance company

Normalising existing ontology and migrating to a new standardised ontology version

Challenge

• Existing Ontology too large, makes it hard to manage and analyse

Solution

• Normalised existing tables by splitting them into multiple units
• Built toolkits and ontology library to support development of new ontologies
• Conventions and development guidelines
• Performance optimisation and reporting

Impact

• Normalised 3 tables resulting in final ontology of 18 tables (approx. 2.3B rows)
• 30% reduction in total ontology build time
• 60% reduction in disk spillage