Sage Journals: Discover world-class research

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

Get full access to this article

View all access options for this article.

References

``Certification Programs,'' United State Postal Service, [Online]. Available: https://www.usps.com/business/certification-programs.htm. [Accessed 5 May 2014].

United States Postal Service, [Online]. Available: https://www.usps.com/business/move-update.htm?. [Accessed 15 May 2014].

CIO Arts, Inc, [Online]. Available: http://www.cioarts.org/. [Accessed 15 May 2014].

Chen

and Hsu

, Data-Continuous SQL Process Model, in: On the Move to Meaningful Internet Systems: OTM 2008, Springer Berlin Heidelberg, 2008, pp. 175-192.

Hyde

, Data in flight, Communications of the ACM, January 2010, pp. 48-52.

Lin

, Kemme

, Patino Martiınez

and Jimenez-Peris

, Middleware based data replication providing snapshot isolation, in Proceedings of the 2005 ACM SIGMOD international conference on Management of data, ser. SIGMOD '05, New York, NY, 2005.

Jung

, Han

, Fekete

and Rhm

, Serializable snapshot isolation, PVLDB,2011, pp. 783-794.

Haerder

and Reuter

, Principles of Transaction-Oriented Database Recovery, Computing Survey15(4) (1983).

Olmsted

, Continuous Data Integration Guarantees, in Software Engineering and Data Engineering, 2014 International Conference for, New Orleans, 2014.

10.

Object Management Group, Unified Modeling Language: Superstructure, 05 02 2007. [Online]. Available: http://www. omg.org/spec/UML/2.1.1/. [Accessed 08 01 2013].

11.

Corp.

S.C.

, Oracle9iDS Forms II: Customize Internet Apps Vol B, Sideris Courseware Corp., 2003.

12.

Ozsu

M.T.

and Valduriez

, Principles of Distributed Database Systems, 3rd ed., Springer, 2011.

Heterogeneous system integration data integration guarantees

Abstract

Keywords

Get full access to this article

References