¹Information Systems Dept. Faculty of Computers and Informatics, Zagazig University, Egypt.
²Information Systems Dept. Faculty of Computers and Information, Menoufia University, Egypt.

---

Abstract—Today, every government is seeking to offer the best services to its citizens to improve competence, translucence, responsibility, access, and other services at low cost. Most governments are using communication technology and Web-based applications in most sectors to provide and ease the services between the state organizations and citizens. However, the government faces a variety of challenges towards delivering its e-services including data heterogeneity, data duplications, infrastructure scalability, IT budgets and costs, etc. These challenges always lead to failure of e-government projects. Currently, there is a strong direction for most applications to move onto the Web, particularly in the cloud. In this paper, we propose a cloud-based framework for integrating data from different data sources of government sector’s databases into a unified repository, which deployed into the Cloud. Therefore, the proposed framework delivers several e-services to the government, citizens, and business communities. The proposed framework tackles several challenges of delivering e-government services. Due to warehousing data, the framework enables business intelligence applications to provide several services both for supporting decision makers and provide daily routine services for citizens. Finally, the proposed framework is validated using syntactic operational data for different seven governmental sectors, such data are integrated and warehoused into galaxy schema. The data warehouse is deployed into Cloud and different OLAP queries are performed for checking the consistency and integrity of data.

Index Terms—Business intelligence (BI), data warehouse, data integration, DW architecture, e-government, cloud.

[PDF]

Cite: Rashed Salem, Samah Abd Elrahman, Mohammed Hassan, "A Cloud-Based Data Integration Framework for E-Government Service," Journal of Computers vol. 13, no. 8, pp. 913-923, 2018.