e-Governance refers to the delivery of government information and services using Information and Communications Technology (ICT) to citizens or businesses or government. Census is a government activity of citizen socio-economic data collection process for the preparation of the citizen database. Census data is used for various activities planning like increasing literacy rate, removal of unemployment and healthcare issues etc. The aim of the paper is to present web based spatial dimensional modeling of the job seekers for assisting in taking high level decisions for government institutions like National Institution for Transforming India (NITI) Aayog and State Governments etc. The proposed system employs Online Analytical Processing (OLAP) and Data mining techniques for finding the job seeker population correlations among multiple fields like gender, the age structure of the population, geographical area and educational qualification in census database. OLAP techniques like roll-up, drill-down, slice and dice are implemented for dimensional modeling of the proposed system. Microsoft Visual Studio is used as an integrated environment for prototype development of a web based application with c# as the programming language. Microsoft SQL server is used as a backend relational database management system. It is concluded that the census database can be effective and efficient in achieving sustainable development goals of government as it can provide accurate and timely information within a reasonable amount of time.

Unemployment, Dimensional modeling, Census, e-Governance

[1] Ljubljana, Slovenia, “Multi-relational data mining: an introduction,” ACM SIGKDD Explore, Vol. 5, pp. 1–16, 2003. DOI: http://doi.acm.org/10.1145/959242.959245,.
[2] A. Dutta and M. S. Devi, “E-Governance Status in India,” International Journal of Computer Sciences and Engineering, Vol 3, Issue-7, pp. 27–31, 2015.
[3] R. Rupnik and M. Kukar, “Data Mining Based Decision Support System to Support Association Rules,” Electro Technical, Vol. 74, pp. 195–200, 2007.
[4] M. H. Peyravi, “A Schema Selection Framework for Data Warehouse Design,” International Journal of Machine Learning and Computing, Vol. 2, No. 3, June 2012.
[5] T. Abdellatif, M. Abo Elsoud, and H. Arafat Ali, “Comparing Online Analytical Processing and Data Mining Tasks In Enterprise Resource Planning Systems,” International Journal of Computer Science Issues, Vol. 8, Issue 6, No 2, pp 161-174, November 2011.
[6] Al-Hashmi and A. Darem, , “Understanding phases of E-government project,” Emerg. Technol. E-Government, pp. 152–157, 2008.
[7] N. Padhy and R. Panigrahi, “Multi Relational Data Mining Approaches : A Data Mining Technique International Journal of Computer Applications,Vol 57, No.17, pp. 23–32, November 2012.
[8] O. C. Okeke and C. Boniface, “Using Data-Mining Technique for Census Analysis to Give Geo- Spatial Distribution of Nigeria .,” Journal of Computer Engineering, Vol. 14, no. 2, pp. 1–5, 2013.
[9] J. Choi and S. A. Chun, “SecureGov: secure data sharing for government services”, Proceedings of the 14th Annual International Conference on Digital Government Research, pp. 127–135, June 2013, DOI 10.1145/2479724.2479745
[10] V. R. Rao, “A Framework for e-Government Data Mining Applications ( eGDMA ) for Effective Citizen Services ” -An Indian Perspective,” International Journal of Computer Science and Information Technology Research, Vol. 2, no. 4, pp. 209–225, Dec 2014.
[11] J. Hareesh and V. V. Kumari, “Decision Tree Based Information System for Improving School Facilities,” International Journal of Science and Research, Vol. 4, no. 10, pp. 2013–2016, Oct 2015.
[12] Siriginidi Subba Rao, "Achieving millennium development goals: Role of ICTS innovations in India", Telematics and Informatics 26, Vol 26, Issue 2, pp 127-143, February 2008
[13] A. Vijayaraj and C.-T. Nadu, “Design and Implementation of Census Data Collection System using PDA,” vol. 9, no. 9, pp. 28–32, 2010.
[14] S. Mahendra Dev and M. Venkatanarayana, “Youth employment and unemployment in India,” International Journal of Accounts, Economics & Business Management, Vol. 1 No. 1, pp 1-6, Sep. 2012.