An SQL Data Summarization Tool for the Acquisition of Meaningful Cardinality Constraints and Functional Dependencies
Aniruddh Gandhi, Sven Hartmann, Henning Köehler, Sebastian Link · 2018
Cardinality constraints and functional dependencies can enforce complex business rules within database systems. As the interaction of these constraints is intricate on SQL data, data engineers and domain experts face the challenge of deciding which of the constraints are meaningful for the underlying application domain. We present a tool that computes data samples that perfectly summarize which of the constraints are currently perceived meaningful. It is demonstrated how the tool facilitates the interaction and understanding of data engineers and domain experts to help them separate meaningful from meaningless cardinality constraints and functional dependencies.