Keys in relational databases with nulls and bounded domains
Missing data value is an extensive problem in both research and industrial developers. Two
general approaches are there to deal with the problem of missing values in databases, they …
general approaches are there to deal with the problem of missing values in databases, they …
[PDF][PDF] Armstrong databases: validation, communication and consolidation of conceptual models with perfect test data
S Link - Proceedings of the Eighth Asia-Pacific …, 2012 - crpit.scem.westernsydney.edu.au
Conceptual models are relational database schemata that result from conceptual data
modeling. Conceptual models usually capture the semantics of the underlying application …
modeling. Conceptual models usually capture the semantics of the underlying application …
Effective recognition and visualization of semantic requirements by perfect SQL samples
VBT Le, S Link, F Ferrarotti - … Conference, ER 2013, Hong-Kong, China …, 2013 - Springer
SQL designs result from methodologies such as UML or Entity-Relationship models,
description logics, or relational normalization. Independently of the methodology, sample …
description logics, or relational normalization. Independently of the methodology, sample …
Empirical evidence for the usefulness of Armstrong tables in the acquisition of semantically meaningful SQL constraints
V Le, S Link, F Ferrarotti - Data & Knowledge Engineering, 2015 - Elsevier
SQL schema designs result from methodologies such as UML, Entity-Relationship models,
description logics, or relational normalization. Independently of the methodology, sample …
description logics, or relational normalization. Independently of the methodology, sample …
Possible Keys and Functional Dependencies
We study the combined class of possible keys and functional dependencies over Codd
tables under NOT NULL constraints. These constraints can express significant application …
tables under NOT NULL constraints. These constraints can express significant application …
SQL-sampler: A tool to visualize and consolidate domain semantics by perfect SQL sample data
VTB Le, S Link, F Ferrarotti - Proceedings of the Tenth Asia-Pacific …, 2014 - dl.acm.org
SQL database designs can result from methodologies such as UML or Entity-Relationship
modeling, Description Logic specifications, or relational normalization. Independently from …
modeling, Description Logic specifications, or relational normalization. Independently from …
On the Discovery of Semantically Meaningful SQL Constraints from Armstrong Samples: Foundations, Implementation, and Evaluation
VTB Le - 2014 - openaccess.wgtn.ac.nz
A database is said to be C-Armstrong for a finite set Σ of data dependencies in a class C if
the database satisfies all data dependencies in Σ and violates all data dependencies in C …
the database satisfies all data dependencies in Σ and violates all data dependencies in C …
[引用][C] Effective Recognition and Visualization of Semantic Requirements by Perfect SQL Samples
VB Tran Le, S Link, F Ferrarotti - 2013 - Department of Computer Science …