The Role of Implicit Schema Constructs in Data Quality

Anthony Cleve; Jonathan Lemaitre; Jean-Luc Hainaut; Christophe Mouchet; Jean Henrard

The Role of Implicit Schema Constructs in Data Quality

Anthony Cleve, Jonathan Lemaitre, Jean-Luc Hainaut, Christophe Mouchet, Jean Henrard

Faculty of Computer Science

Research output: Contribution in Book/Catalog/Report/Conference proceeding › Conference contribution

Abstract

This paper presents a comprehensive approach to legacy data quality assessment and improvement. It is based on an initial database reverse engineering phase that allows to recover implicit constructs, that is, structures and constraints that have not been explicitly declared in the database schema, using program analysis techniques. These constructs then serve as a basis for detecting data inconsistencies, identifying unsafe program fragments, and proposing necessary improvements at both the database and program sides.

Original language	English
Title of host publication	Proceedings of the 6th International Workshop on Quality in Databases (QDB @VLDB 2008)
Editors	Ander de, Keijzer Maurice, van Keulen, Paolo Missier, Xuemin Lin
Place of Publication	Twente, The Netherlands
Publisher	Center for Telematics and Information Technology (CTIT)
Pages	33-40
Number of pages	8
Volume	WP 08-02
ISBN (Print)	ISSN 0929-0672
Publication status	Published - 2008

Access to Document

http://www.ctit.utwente.nl/library/proceedings/WP0802.doc/

Evolution: Evolution
Cleve, A.
1/01/10 → 31/01/10
Project: Research Axis

Cite this

Cleve, A., Lemaitre, J., Hainaut, J.-L., Mouchet, C., & Henrard, J. (2008). The Role of Implicit Schema Constructs in Data Quality. In A. de, K. Maurice, V. Keulen, P. Missier, & X. Lin (Eds.), Proceedings of the 6th International Workshop on Quality in Databases (QDB @VLDB 2008) (Vol. WP 08-02, pp. 33-40). Center for Telematics and Information Technology (CTIT). http://www.ctit.utwente.nl/library/proceedings/WP0802.doc/

Cleve, Anthony ; Lemaitre, Jonathan ; Hainaut, Jean-Luc et al. / The Role of Implicit Schema Constructs in Data Quality. Proceedings of the 6th International Workshop on Quality in Databases (QDB @VLDB 2008). editor / Ander de ; Keijzer Maurice ; van Keulen ; Paolo Missier ; Xuemin Lin. Vol. WP 08-02 Twente, The Netherlands : Center for Telematics and Information Technology (CTIT), 2008. pp. 33-40

@inproceedings{8df7de0c212a45de89cfa9f6dd87f0b6,

title = "The Role of Implicit Schema Constructs in Data Quality",

abstract = "This paper presents a comprehensive approach to legacy data quality assessment and improvement. It is based on an initial database reverse engineering phase that allows to recover implicit constructs, that is, structures and constraints that have not been explicitly declared in the database schema, using program analysis techniques. These constructs then serve as a basis for detecting data inconsistencies, identifying unsafe program fragments, and proposing necessary improvements at both the database and program sides. ",

author = "Anthony Cleve and Jonathan Lemaitre and Jean-Luc Hainaut and Christophe Mouchet and Jean Henrard",

note = "Publication editors : Ander de Keijzer, Maurice van Keulen, Paolo Missier and Xuemin Lin",

year = "2008",

language = "English",

isbn = "ISSN 0929-0672",

volume = "WP 08-02",

pages = "33--40",

editor = "Ander de and Keijzer Maurice and van Keulen and Paolo Missier and Xuemin Lin",

booktitle = "Proceedings of the 6th International Workshop on Quality in Databases (QDB @VLDB 2008)",

publisher = "Center for Telematics and Information Technology (CTIT)",

}

Cleve, A, Lemaitre, J, Hainaut, J-L, Mouchet, C & Henrard, J 2008, The Role of Implicit Schema Constructs in Data Quality. in A de, K Maurice, V Keulen, P Missier & X Lin (eds), Proceedings of the 6th International Workshop on Quality in Databases (QDB @VLDB 2008). vol. WP 08-02, Center for Telematics and Information Technology (CTIT), Twente, The Netherlands, pp. 33-40. <http://www.ctit.utwente.nl/library/proceedings/WP0802.doc/>

The Role of Implicit Schema Constructs in Data Quality. / Cleve, Anthony; Lemaitre, Jonathan; Hainaut, Jean-Luc et al.
Proceedings of the 6th International Workshop on Quality in Databases (QDB @VLDB 2008). ed. / Ander de; Keijzer Maurice; van Keulen; Paolo Missier; Xuemin Lin. Vol. WP 08-02 Twente, The Netherlands: Center for Telematics and Information Technology (CTIT), 2008. p. 33-40.

Research output: Contribution in Book/Catalog/Report/Conference proceeding › Conference contribution

TY - GEN

T1 - The Role of Implicit Schema Constructs in Data Quality

AU - Cleve, Anthony

AU - Lemaitre, Jonathan

AU - Hainaut, Jean-Luc

AU - Mouchet, Christophe

AU - Henrard, Jean

N1 - Publication editors : Ander de Keijzer, Maurice van Keulen, Paolo Missier and Xuemin Lin

PY - 2008

Y1 - 2008

N2 - This paper presents a comprehensive approach to legacy data quality assessment and improvement. It is based on an initial database reverse engineering phase that allows to recover implicit constructs, that is, structures and constraints that have not been explicitly declared in the database schema, using program analysis techniques. These constructs then serve as a basis for detecting data inconsistencies, identifying unsafe program fragments, and proposing necessary improvements at both the database and program sides.

AB - This paper presents a comprehensive approach to legacy data quality assessment and improvement. It is based on an initial database reverse engineering phase that allows to recover implicit constructs, that is, structures and constraints that have not been explicitly declared in the database schema, using program analysis techniques. These constructs then serve as a basis for detecting data inconsistencies, identifying unsafe program fragments, and proposing necessary improvements at both the database and program sides.

M3 - Conference contribution

SN - ISSN 0929-0672

VL - WP 08-02

SP - 33

EP - 40

BT - Proceedings of the 6th International Workshop on Quality in Databases (QDB @VLDB 2008)

A2 - de, Ander

A2 - Maurice, Keijzer

A2 - Keulen, van

A2 - Missier, Paolo

A2 - Lin, Xuemin

PB - Center for Telematics and Information Technology (CTIT)

CY - Twente, The Netherlands

ER -

The Role of Implicit Schema Constructs in Data Quality

Abstract

Access to Document

Fingerprint

Projects

Evolution: Evolution

Cite this