Heterogeneous system integration data integration guarantees

Issue title: Selected papers from the ISCA International Conference on Software Engineering and Data Engineering, and the ISCA International Conference on Computer Applications in Industry and Engineering, 2015, and Invited Papers

Guest editors: Takaaki Goto and Narayan C. Debnath

Article type: Research Article

Authors: Olmsted, Aspen

Affiliations: Department of Computer Science, College of Charleston, Charleston, SC 29401, USA. E-mail: [email protected]

Abstract: In this paper, I investigate the problem of providing guarantees for heterogeneous system integration. I propose a set of strong properties, FACD, which when held in the integration transaction will deliver correct results. The strong properties support an integration technique called CCETL (Continuous, Consistent, Extract, Translate, and Load). CCETL consumes UML class diagrams to identify transactional membership of the data elements that make up the integration. CCETL transforms the hierarchical relationships using a version of the topological sort. The sort maintains a navigation path from the original UML classes. The CCETL approach guarantees ACID properties up to the level of snapshot isolation between systems supporting a continuous integration.

Keywords: Data integration, distributed database, modeling, model semantics, consistency

DOI: 10.3233/JCM-160682

Journal: Journal of Computational Methods in Sciences and Engineering, vol. 17, no. S1, pp. S85-S94, 2017