An overview of data warehousing and OLAP technology
ACM SIGMOD Record
Tools and approaches for developing data-intensive Web applications: a survey
ACM Computing Surveys (CSUR)
Patterns of Enterprise Application Architecture
Patterns of Enterprise Application Architecture
A survey of approaches to automatic schema matching
The VLDB Journal — The International Journal on Very Large Data Bases
The Butterfly Methodology: A Gateway-free Approach for Migrating Legacy Information Systems
ICECCS '97 Proceedings of the Third IEEE International Conference on Engineering of Complex Computer Systems
Efficient development of data migration transformations
SIGMOD '04 Proceedings of the 2004 ACM SIGMOD international conference on Management of data
Practical Data Migration
Managing the evolution and customization of database schemas in information system ecosystems
CAiSE'13 Proceedings of the 25th international conference on Advanced Information Systems Engineering
| Hi-index | 0.00 |
When a bank replaces its core-banking information system, the bank must migrate data like accounts from the old into the new system. Migrating data is necessary but not a catalyst for new business opportunities. The consequence is cost pressure to be addressed by an efficient software development process together with an industrialization of the development. Industrialization requires defining the deliverables. Therefore, our data migration architecture extends the ETL process by migration objectives to be reached in each step. Industrialization also means standardizing the implementation, e.g. with patterns. We present data migration patterns describing the typical transformations found in the data migration application domain. Finally, testing is an important issue because test-case based testing cannot guarantee that not a single customer gets lost. Reconciliation can do so by checking whether each object in the old and new system has a counterpart in the other system.