... CMLSA 2007International Workshop on Conceptual Modelling for Life Sciences Applications Work... more ... CMLSA 2007International Workshop on Conceptual Modelling for Life Sciences Applications Workshop Chairs Yi-Ping Phoebe Chen, Deakin ... David Hansen, Australia Peter Hunter, New Zealand Nikola Kasabov, New Zealand Dirk Labudde, Germany Sebastian Link, New ...
Proceedings 3rd IFCIS International Conference on Cooperative Information Systems (Cat No 98EX122) COOPIS-98, 1998
Accessing and managing data from several existing independent databases pose c omplex problems th... more Accessing and managing data from several existing independent databases pose c omplex problems that can b e c lassified into p latform, DMS, location and semantic levels. This paper describes a general architecture, a methodology and a CASE environment intended to add ress the problem of providing u sers and programmers with an abstract interface to independent heterogeneous and distributed
Object-Oriented and Entity-Relationship Modelling/International Conference on Conceptual Modeling / the Entity Relationship Approach, 1991
The paper is a contribution to the problem of semantics-preserving schema restructuring . First, ... more The paper is a contribution to the problem of semantics-preserving schema restructuring . First, the notion of schema transformation is precisely analysed, its properties of reversibility are stated and an adequate notation is proposed. Then, the paper develops a general family of entity-generating transformations, i.e. operations that add/remove entity types in a schema. This generic transformation is proved to be
The documentation of a database includes its conceptual schema, that formalizes the semantics of ... more The documentation of a database includes its conceptual schema, that formalizes the semantics of the data, and its logical schema that translates the former according to an operational database model. Important engineering processes such as database and program evolution rely on a complete and accurate database documentation. In many cases, however, these schemas are missing, or, at best, incomplete and
ABSTRACT Data schemas are primary artefacts for the development and maintenance of data intensive... more ABSTRACT Data schemas are primary artefacts for the development and maintenance of data intensive software systems. As for the application code, one way to improve the quality of the models is to ensure that they comply with best design practices. In this paper, we redefine the process of schema quality evaluation as the identification of specific schema constructs and their comparison with best practices. We provide an overview of a framework based on the use of semantics-preserving transformations as a way to identify, compare and suggest improvement for the most significant best design practices. The validation and the automation of the framework are discussed and some clarifying examples are provided.
Abstract. Data-intensive systems are subject to continuous evolution that translates ever-changin... more Abstract. Data-intensive systems are subject to continuous evolution that translates ever-changing business and technical requirements. Sys-tem evolution usually constitutes a highly complex, expensive and risky process. This holds, in particular, when the evolution ...
In the database engineering realm, the merits of transformational approaches, that can produce in... more In the database engineering realm, the merits of transformational approaches, that can produce in a systematic way correct, compilable and efficient database structures from abstract models, has long be recognized. Transformations that are proved to preserve the correctness of the source specifications have been proposed in virtually all the activities related to data structure engineering: schema normalization, logical design, schema
Abstract. The paper adresses the problem of consistency preservation in data intensive applicatio... more Abstract. The paper adresses the problem of consistency preservation in data intensive applications evolution. When the database structure evolves, the application programs must be changed to interface with the new schema. The latter modification can prove very complex, error ...
2008 15th Working Conference on Reverse Engineering, 2008
Analyzing SQL statements brings invaluable information that can be used in various applications s... more Analyzing SQL statements brings invaluable information that can be used in various applications such as program understanding and database reverse engineering. While static SQL statements are fairly easy to analyze, dynamic SQL statements most often require dynamic analysis techniques that may prove more difficult to implement. This paper addresses the problem of dynamic SQL query analysis in the context of
... CMLSA 2007International Workshop on Conceptual Modelling for Life Sciences Applications Work... more ... CMLSA 2007International Workshop on Conceptual Modelling for Life Sciences Applications Workshop Chairs Yi-Ping Phoebe Chen, Deakin ... David Hansen, Australia Peter Hunter, New Zealand Nikola Kasabov, New Zealand Dirk Labudde, Germany Sebastian Link, New ...
Proceedings 3rd IFCIS International Conference on Cooperative Information Systems (Cat No 98EX122) COOPIS-98, 1998
Accessing and managing data from several existing independent databases pose c omplex problems th... more Accessing and managing data from several existing independent databases pose c omplex problems that can b e c lassified into p latform, DMS, location and semantic levels. This paper describes a general architecture, a methodology and a CASE environment intended to add ress the problem of providing u sers and programmers with an abstract interface to independent heterogeneous and distributed
Object-Oriented and Entity-Relationship Modelling/International Conference on Conceptual Modeling / the Entity Relationship Approach, 1991
The paper is a contribution to the problem of semantics-preserving schema restructuring . First, ... more The paper is a contribution to the problem of semantics-preserving schema restructuring . First, the notion of schema transformation is precisely analysed, its properties of reversibility are stated and an adequate notation is proposed. Then, the paper develops a general family of entity-generating transformations, i.e. operations that add/remove entity types in a schema. This generic transformation is proved to be
The documentation of a database includes its conceptual schema, that formalizes the semantics of ... more The documentation of a database includes its conceptual schema, that formalizes the semantics of the data, and its logical schema that translates the former according to an operational database model. Important engineering processes such as database and program evolution rely on a complete and accurate database documentation. In many cases, however, these schemas are missing, or, at best, incomplete and
ABSTRACT Data schemas are primary artefacts for the development and maintenance of data intensive... more ABSTRACT Data schemas are primary artefacts for the development and maintenance of data intensive software systems. As for the application code, one way to improve the quality of the models is to ensure that they comply with best design practices. In this paper, we redefine the process of schema quality evaluation as the identification of specific schema constructs and their comparison with best practices. We provide an overview of a framework based on the use of semantics-preserving transformations as a way to identify, compare and suggest improvement for the most significant best design practices. The validation and the automation of the framework are discussed and some clarifying examples are provided.
Abstract. Data-intensive systems are subject to continuous evolution that translates ever-changin... more Abstract. Data-intensive systems are subject to continuous evolution that translates ever-changing business and technical requirements. Sys-tem evolution usually constitutes a highly complex, expensive and risky process. This holds, in particular, when the evolution ...
In the database engineering realm, the merits of transformational approaches, that can produce in... more In the database engineering realm, the merits of transformational approaches, that can produce in a systematic way correct, compilable and efficient database structures from abstract models, has long be recognized. Transformations that are proved to preserve the correctness of the source specifications have been proposed in virtually all the activities related to data structure engineering: schema normalization, logical design, schema
Abstract. The paper adresses the problem of consistency preservation in data intensive applicatio... more Abstract. The paper adresses the problem of consistency preservation in data intensive applications evolution. When the database structure evolves, the application programs must be changed to interface with the new schema. The latter modification can prove very complex, error ...
2008 15th Working Conference on Reverse Engineering, 2008
Analyzing SQL statements brings invaluable information that can be used in various applications s... more Analyzing SQL statements brings invaluable information that can be used in various applications such as program understanding and database reverse engineering. While static SQL statements are fairly easy to analyze, dynamic SQL statements most often require dynamic analysis techniques that may prove more difficult to implement. This paper addresses the problem of dynamic SQL query analysis in the context of
Uploads
Papers by Jean-luc Hainaut