Detecting Violations of Conditional Functional Dependencies in Distributed Database

This paper develops a technique for detecting violations of conditional functional dependencies in distributed database systems. For a given database that has a set of functional dependencies as a data quality rule, we want to identify tuples in the database that violate these rules. When the provided database is a centralized database, there have been simple SQL-based techniques available for finding violations of the conditional functional dependencies for this particular database. However, it is more challenging to detect violations in distributed databases. Numerous works already published concentrate on functional dependency error estimation in centralized settings where data are kept in a single place, with the aim of reducing the time and space requirements of the estimation methods. With the design and execution of the heuristic algorithm, a remedy for breaches of conditional functional dependencies in the distributed database is suggested. Our key goal for the distributed data is to solve the shipment issue. To assess the efficacy of our plan and algorithm, a series of experiments are created and carried out.