Data Warehousing and Data Mining are widely used by many industries like banking, insurance, healthcare, security and many others, however very little work has been done for e-governance systems in India. The e-governance systems developed by the Surat Municipal Corporation has achieved great success in several years, to service citizens in a more timely, effective, and cost-efficient method. This initiative has resulted in collection of large amount of unexplored and unorganized data. In this paper we proposed Data Warehouse Modeling and Online Analytical Procession (OLAP) for Birth Registration System using Microsoft SQL Server 2008. Our study utilizes data of the Surat city from the year of 2000 to 2009. To query and analyze the data in the data warehouse conveniently and effectively, we designed Data Warehouse using star schema. Our work will help administrators of The Surat Municipal Corporation analyze Birth Registration System data and provide decision-making support for future planning and better service to citizens of the Surat city. Since the research is still in its early stage, the paper mainly focuses on design and implementation of Data Warehouse Modeling, OLAP and Microsoft Data Mining Clustering algorithm for Birth Registration System. The Microsoft Clustering algorithm is used to identify important clusters from the Birth Registration Warehouse.

1. William H.Inmon, Building the Data Warehouse. 2006. Fourth Edition,New York:John Wiley & Sons.
2. Fox. 2000. A.: Data warehousing: avoiding the pitfalls, Behavioral Health Management, Vol. 20, No. 3, p. 18.
3. Li Tong Cui Yan Ren Shu Po. 2008. Analysis on Data Warehouse Technology and Its Development Situation, IEEE International Symposium on Information Science and Engieering, pp. 486--488.
4. Fayyad, U., Piatetsky-Shapiro, G., & Smyth, P. 1996 The KDD process for extracting useful knowledge from volumes of data, Association for Computing Machinery. Communications of the ACM, 39(11), 27--34.
5. Brabazon, T. 1997. Data mining: A new source of competitive advantage? Accountancy Ireland, pp 30--31.
6. Li Tong, Cui Yan et al. 2008. Analysis on Data Warehouse Technology and Its Development Situtation, IEEE International Symposium on Information Science and Engineering, pp. 486-488.
7. Liao, S. h. 2003. Knowledge Management Technologies and applications-Literature review from 1995 to 2002. Expert System with Application 25, Pergamon, pp. 155--164.
8. Thomas Neumuth, Svetlana Mansmann et al. 2008. Data Warehousing Technology for Surgical Workflow Analysis, 21st IEEE International Symposium on Computer-Based Medical Systems, pp. 230--235.
9. Wang Kuanfu, Hu Xuanzi. 2008. Application of Data Warehouse Technology in Data Center Design, IEEE International Conference on Computational Intelligence and Security, pp. 484-488.
10. Wen, C. P. 2004. Hierarchical Analysis For Discovering Knowledge in Large Databases, Information Systems management, pp. 81—88.
11. Xiaofeng Zhang. 2008. A New Modelling Method for the Data Analysis Solution in Business. IEEE International Symposium on Electronics Commerce and Security, pp. 175—178.
12. Xuezhong, Baoyan et al. 2008. Building Clinical Data Warehouse for Traditional Chinese Medical Knowladge Discovery, IEEE International Conference on Bio-Medical Engineering and Informatics, pp. 615--620.
13. ZHANG Dan-Ping. 2009. A Data Warehouse Based on University Human Resources Management of Performance Evaluation, IEEE International Forum on Information Technology and Application, pp. 655—658.
14. ZHOU Qian, XIAO Qing. 2009. The Study on Data Warehouse Modelling and OLAP for Highway Management, IEEE International Conference on Measuring Technology and Mechatronics Automation, pp. 416--419.
15. Desai Pushpal, Desai Appurva, 2011. The Study on Data Warehouse Modelling and OLAP for Birth Registration System of the Surat City. TECHNOLOGY SYSTEMS AND MANAGEMENT, Communications in Computer and Information Science, 2011, Volume 145, Part 1, 160-167.

OLAP Clustering Birth Registration System