Some property graph databases do not have a fixed schema, which can result in data type inconsistencies for properties on nodes and relationships, especially when importing data into a running database. Here we present a tool which can rapidly produce a detailed report on every property in the graph. When executed on a large knowledge graph, it allowed us to debug a complex ETL process and enforce 100% data type consistency.
@article{arxiv.2302.04106,
title = {Detecting Data Type Inconsistencies in a Property Graph Database},
author = {Joshua R. Porter and Michael N. Young and Aleks Y. M. Ontman},
journal= {arXiv preprint arXiv:2302.04106},
year = {2023}
}
Comments
5 pages, 3 figures, general approach applied to production databases