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
TitelEmpirical evidence for the usefulness of Armstrong tables in the acquisition of semantically meaningful SQL constraints
TypArtikel
JournalData & Knowledge Engineering
Band98
DOI10.1016/j.datak.2015.07.006
MonatJuly
Jahr2015
Seiten74-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.