EERtoOWL2: A Tool for Transforming RDB Data to OWL2 for Data Validation

Abstract

Data validation is an important task in order to ensure data quality. When the database has a complex data structure and, in addition, the data is changed by constraints related to the business of the database user, data validation can be a difficult task. This paper proposes the tool EERtoOWL2. The tool supports data validation using ontology reasoning. The relational database data is transformed into ontological data represented by OWL2. The transformation process relies on the Enhanced-Entity Relationship model. The tool validates the data and reports invalid data to the users. From the tool development, the OWL2 language has rich syntax and hence transformation of the relational database data into OWL2 is convenient. With ontology reasoning, the data validation process is efficient in detecting invalid data that may violate database integrity constraints as well as business/domain constraints.