dc.contributor.author |
Le, V |
en |
dc.contributor.author |
Link, Sebastian |
en |
dc.contributor.author |
Ferrarotti, F |
en |
dc.contributor.editor |
Grossmann, G |
en |
dc.contributor.editor |
Saeki, M |
en |
dc.coverage.spatial |
Auckland, New Zealand |
en |
dc.date.accessioned |
2015-03-25T00:24:09Z |
en |
dc.date.issued |
2014-01 |
en |
dc.identifier.citation |
Proceedings of the 10th Asia-Pacific Conference on Conceptual Modeling, 2014, 154 pp. 71 - 80 |
en |
dc.identifier.isbn |
978-1-921770-36-4 |
en |
dc.identifier.uri |
http://hdl.handle.net/2292/24939 |
en |
dc.description.abstract |
SQL database designs can result from methodologies such as UML or Entity-Relationship modeling, Description Logic specifications, or relational normalization. Independently from the methodology, the use of good sample data is promoted by academia and commercial database design tools to visualize, validate and consolidate the database designs produced. Unfortunately, advice on what constitutes good sample data, or support to create good sample data are hard to come by. Armstrong databases provide a right notion of sample data that perfectly represent the domain semantics encoded in the form of SQL constraints. We present a tool that computes Armstrong sample tables for different classes of SQL constraints, and different interpretations of null markers. Armstrong tables illustrate the perceptions of an SQL database design about the semantics of an application domain. The tool exemplifies the impact of various design choices on Armstrong tables. These include the expressiveness of the classes of SQL constraints considered, and the semantics of null markers. Armstrong tables complement existing database design methodologies. In particular, they provide data samples that guide the transfer from relational approximations of an application domain to an actual real-life SQL table design. |
en |
dc.publisher |
Conferences in Research and Practice in Information Technology, Australian Computer Science Society |
en |
dc.relation.ispartof |
APCCM |
en |
dc.relation.ispartofseries |
Proceedings of the 10th Asia-Pacific Conference on Conceptual Modeling |
en |
dc.rights |
Items in ResearchSpace are protected by copyright, with all rights reserved, unless otherwise indicated. Previously published items are made available in accordance with the copyright policy of the publisher. |
en |
dc.rights.uri |
https://researchspace.auckland.ac.nz/docs/uoa-docs/rights.htm |
en |
dc.title |
SQL-Sampler: A Tool to Visualize and Consolidate Domain Semantics by Perfect SQL Sample Data |
en |
dc.type |
Conference Item |
en |
pubs.begin-page |
71 |
en |
pubs.volume |
154 |
en |
dc.rights.holder |
Copyright:
Conferences in Research and Practice in Information Technology, Australian Computer Science Society |
en |
pubs.author-url |
http://crpit.com/confpapers/CRPITV154Le.pdf |
en |
pubs.end-page |
80 |
en |
pubs.finish-date |
2014-01-23 |
en |
pubs.start-date |
2014-01-20 |
en |
dc.rights.accessrights |
http://purl.org/eprint/accessRights/RestrictedAccess |
en |
pubs.subtype |
Conference Paper |
en |
pubs.elements-id |
464144 |
en |
pubs.org-id |
Science |
en |
pubs.org-id |
School of Computer Science |
en |
dc.identifier.eissn |
1445-1336 |
en |
pubs.record-created-at-source-date |
2014-11-28 |
en |