Why not use Federated approach for Database Management

Why not use Federated approach for Database Management System (DBMS)? Yan Cui ITK 478 Position paper

Issues in enterprises �“…organizations merge or takeover since the existing systems have been designed for different corporate needs, the resulting enterprise will have to face information inconsistency, heterogeneity and incompatible overlap”. Wijegunartne, Fernandez and Vltoudis in [1] � “…a large modern enterprise, it is also inevitable that …use different database systems to store and search their critical data. Competition, evolving technology, mergers, acquisitions, geographic distribution, and … decentralization of growth…” Haas and Lin in [2]

Database system approaches �Compare two major database system approaches: �Federated database system approach �Distributed database system approach

Distributed database system �Fragmentation of OODBs �The Fragmentation Process in OODBs (horizontal fragmentation and vertical fragmentation) �Heuristics for the Fragmentation Process in OODBs �Allocation of OODBs

Federated database system �Characteristics of federated solution �Transparency �Heterogeneity �A high degree of function �Extensibility and openness of the federation �Autonomy for data sources �Optimized performance �Case study in Xperanto and Australian Gas & Light Company (AGL)

Federated database system (cont) �Case study in Xperanto �Xperanto architecture �Xperanto XML schema mapping �Xperanto query processing and XML documentation construction

Federated database system (cont) �Case study: Australian Gas & Light Company (AGL) �Federated architecture �The AGL Data integration

Conclusion: �Distributed database system has several disadvantages are complexity, economic, difficulty to maintain data integration, database access. �federated database system provides transparency, autonomy, optimized performance, accessibility, and query standard through multiple DBMSs.

Questions?

Reference: � [1] Inji Wijegunaratne, George Fernandez, John Valtoudis. 2000. “A Federated Architecture for Enterprise Data Integration”, 2000 Australian Software Engineering Conference. Retrieved September 12, 2007. (http: //portal. acm. org. proxy. lib. ilstu. edu: 2048/citation. cfm? id=787253&coll=Portal&dl=GUIDE&CFI D=5277637&CFTOKEN=95867344) � [2] Laura Haas, Eileen Lin, 2002 “IBM Federated Database Technology”, IBM, retrieved September 10, 2007 (http: //www. ibm. com/developerworks/db 2/library/techarticle/0203 haas. html) � [3] F. Baião, M. Mattoso, and G. Zaverucha, "A framework for the design of distributed databases. "in Proceedings in Informatics 14. Distributed Data & Structures 4 --Records of the 4 th International Meeting, W. Litwin, and G. Lévy (Eds. ), Carleton Scientific, 2002, pp. 29 -36. � [4] M. Özsu and P. Valduriez, Principles of Distributed Database Systems, 2 nd edition (1 st edition 1991), New Jersey, Prentice-Hall, 1999. � � [5] Michael J. Carey, Jerry Kiernan. 2000. “XPERANTO: Middleware for Publishing Object-Relational Data as XML Documents”, 26 th International Conference. Retrieved September 13, 2007. (http: //portal. acm. org. proxy. lib. ilstu. edu: 2048/citation. cfm? id=671862&coll=Portal&dl=GUIDE&CFI D=5277637&CFTOKEN=95867344) � [6] Fernanda Araujo Baião , Marta Mattoso , Gerson Zaverucha, Towards an Inductive Design of Distributed Object Oriented Databases, Proceedings of the 3 rd IFCIS International Conference on Cooperative Information Systems, p. 188 -197, August 20 -22, 1998. � [7] Ishfaq Ahmad , Kamalakar Karlapalem , Yu-Kwong Kwok , Siu-Kai So, Evolutionary Algorithms for Allocating Data in Distributed Database Systems, Distributed and Parallel Databases, v. 11 n. 1, p. 532, January 2002. � [8] Ishfaq Ahmad, Yu-kwong Kwok, Siu-kai So, Evolutionary Algorithms for Allocating Data in Distributed Database Systems, Distributed and Parallel Databases, 11, 5– 32, 2002.