On the application of model-driven engineering in data reengineering

作者：

Highlights：

• An MDE approach whose purpose is to improve the quality of the logical schema in a relational data migration scenario.

• Several data and code analysis strategies with which to detect foreign keys in a relational database are implemented.

• Database normalisation is automated by means of a MDE solution which automatically discovers functional dependencies.

• MDE techniques have proven useful in order to integrate an external tool in proposed solution.

• An assessment and a list of the main benefits and drawbacks of using MDE in data reengineering.

摘要

•An MDE approach whose purpose is to improve the quality of the logical schema in a relational data migration scenario.•Several data and code analysis strategies with which to detect foreign keys in a relational database are implemented.•Database normalisation is automated by means of a MDE solution which automatically discovers functional dependencies.•MDE techniques have proven useful in order to integrate an external tool in proposed solution.•An assessment and a list of the main benefits and drawbacks of using MDE in data reengineering.

论文关键词：Model-driven engineering,Data modernisation,Data reengineering

论文评审过程：Received 11 August 2015, Revised 3 July 2017, Accepted 15 October 2017, Available online 17 October 2017, Version of Record 1 November 2017.

论文官网地址：https://doi.org/10.1016/j.is.2017.10.004