Empirical evidence for the usefulness of Armstrong tables in the acquisition of semantically meaningful SQL constraints

Autoren Van Bao Tran Le
Sebastian Link
Flavio Ferrarotti
Editoren
Titel Empirical evidence for the usefulness of Armstrong tables in the acquisition of semantically meaningful SQL constraints
Typ Artikel
Journal Data & Knowledge Engineering
Band 98
DOI 10.1016/j.datak.2015.07.006
Monat July
Jahr 2015
Seiten 74-103
SCCH ID# 1639
Abstract

SQL schema designs result from methodologies such asUML, Entity-Relationship models, description logics, or relational normalization. Independently of the methodology, sample data is promoted by academia and industry to consolidate the schema designs produced. SQL constraints are an abstract standard-compliant encoding of the designers' perception about the semantics of an application domain. Armstrong tables can visualize SQL constraints concisely, in the sense that they satisfy all constraints perceived meaningful and violate all constraints perceived meaningless. Using new empirical measures we investigate how Armstrong tables help design teams recognize domain semantics. Extensive experiments confirm that users of Armstrong tables are likely to recognize domain semantics they would overlook otherwise. Armstrong tables therefore complement existing schema design methodologies in producing quality schemata that process data efficiently.