IJMECS Vol. 9, No. 8, 8 Aug. 2017
Cover page and Table of Contents: PDF (size: 1206KB)
Full Text (PDF, 1206KB), PP.40-48
Views: 0 Downloads: 0
Census, Virtual enumeration, Data integration, Heterogeneous data, Data cleansing, Data mining
Population census is an enormous and challenging national exercise with many stakeholders whose participation is required at all levels of government or public administration. The problem of high cost in conducting the traditional census process imposes extra and unaffordable cost in most of the developing countries which resulted into ten-year defaulting for census enumerations. This challenge compels nations to seek for assistance mostly from various donors nations in every census enumerations exercise. Virtual Census enumerations play a vital role in demographic data enumerations since it does not require physical involvement in Enumeration Area as in traditional enumerations approach. In this paper the main focus is on data integration from different heterogeneous sources, addressing cleansing challenge for data integrated from data sources with no common key for integrations, building virtual data integration framework for enhancing virtual censuses enumeration process. The developed framework and algorithms can be used to guide design of any other data integration system that need to address similar challenges in related aspects. The outcome of this work is suitable and cheaper technique of demographic data enumeration as compared to traditional technique which involves a lot of manual works and processes.
Ramadhani A. Duma, "A Framework for Adaptation of Virtual Data Enumeration for Enhancing Census – Tanzania Case Study", International Journal of Modern Education and Computer Science(IJMECS), Vol.9, No.8, pp.40-48, 2017. DOI:10.5815/ijmecs.2017.08.06
[1]The United Republic of Tanzania.: Population Distribution by Age and Sex. Dar es Salaam, Tanzania (2013).
[2]UNFPA.: Counting the People Constraining Census Costs and Assessing Alternative Approaches. UNFPA (2003).
[3]Ngallaba, S., Kapiga, S. H., Ruyobya, I., & Boerma, J. T.: Tanzania Demographic and Health Survey. Bureau of Statistics, Planning Commission, Dar es Salaam, Tanzania and Macro International Inc., Columbia, MD, USA (1993).
[4]Gerards, E.: Dutch Virtual Census: Presentation at the International Seminar on Population and Housing Censuses Beyond the 2010 Round, The Netherlands [Video clip], retrieved on 20th January, 2013 from http://youtu.be/SLpDkcyenf0 (2012).
[5]Nordholt, E. S.: The Dutch virtual Census 2001, A new approach by combining different sources. Statistical Journal of the United Nations Economic Commission for Europe, Vol. 22, No. 1, 25-37 (2005).
[6]Ghulam, A. M., & Ghulam, M. M.: A Framework for Creating Global Schema Using Global Views from Distributed Heterogeneous Relational Databases in Multidatabase System. Global Journal of Computer Science and Technology, Vol. 10, Issue.1, pp. 31-35 (2010).
[7]Ali, M. G.: A framework for creating Global Schema using Proxy Tables from Distributed Heterogeneous Relational Databases in Multidatabase system. IJCEE, Singapore (2010).
[8]Sabri, M., & Rahal, S. A. APESS-A Service-Oriented Data Mining Platform: Application for Medical Sciences (2016).
[9]Rochlani, Y. R., & Itkikar, A. R.: Integrating Heterogeneous Data Sources Using XML Mediator. International Journal of Computer Science and Network, Vol.1, Issue 3 (2012).
[10]Mohammed, R. O., & Talab, S. A.: Clinical Data Warehouse Issues and Challenges. International Journal of u-and e-Service, Science and Technology, 7(5), 251-262 (2014).
[11]Fall, K. R. & Stevens, W. R.: TCP/IP Illustrated: The protocols. Vol 1 addison-Wesley (2011).
[12]Portier, B., & Budinsky, F.: Introduction to Service Data Objects. International Business Machines Corporation (2004).
[13]Digplanet.: XQuery API for Java, Retrieved December, 2015, from http://www.digplanet.com/ wiki/XQuery_ API_for_Java#cite_ note-QueryDataModel-1
[14]Melton, J., & Buxton, S.: Querying XML: XQuery, XPath, and SQL/XML in context. Morgan Kaufmann (2011).
[15]Shamin, O.: Development of a Web-based Demonstrator for an Approach to prevent Insider Attacks on DBMS (2014).