Skip to main content
SpringerLink
Log in
Book cover

Technology Systems and Management pp 160–167Cite as

The Study on Data Warehouse Modelling and OLAP for Birth Registration System of the Surat City

  • Conference paper

  • 1577 Accesses

Part of the book series: Communications in Computer and Information Science ((CCIS,volume 145))

Abstract

Data Warehousing has been a buzzword in the IT industry, 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 unorganised data. In this paper we proposed Data Warehouse Modelling 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 Modelling and OLAP for Birth Registration System.

This is a preview of subscription content, log in via an institution.

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Inmon, W.H.: Building the Data Warehouse, 4th edn. John Wiley & Sons, New York (2006)

    Google Scholar 

  2. Fox, A.: Data warehousing: avoiding the pitfalls. Behavioral Health Management 20(3), 18 (2000)

    Google Scholar 

  3. Tong, L., Yan, C., Po, R.S.: Analysis on Data Warehouse Technology and Its Development Situation. In: IEEE International Symposium on Information Science and Engieering, pp. 486–488 (2008)

    Google Scholar 

  4. Fayyad, U., Piatetsky-Shapiro, G., Smyth, P.: The KDD process for extracting useful knowledge from volumes of data. Association for Computing Machinery. Communications of the ACM 39(11), 27–34 (1996)

    Article  Google Scholar 

  5. Brabazon, T.: Data mining: A new source of competitive advantage? Accountancy Ireland, 30–31 (1997)

    Google Scholar 

  6. Tong, L., Yan, C., et al.: Analysis on Data Warehouse Technology and Its Development Situtation. In: IEEE International Symposium on Information Science and Engineering, pp. 486–488 (2008)

    Google Scholar 

  7. Liao, S.h.: Knowledge Management Technologies and applications-Literature review from 1995 to 2002. In: Expert System with Application 25, Pergamon, pp. 155–164 (2003)

    Google Scholar 

  8. Neumuth, T., Mansmann, S., et al.: Data Warehousing Technology for Surgical Workflow Analysis. In: 21st IEEE International Symposium on Computer-Based Medical Systems, pp. 230–235 (2008)

    Google Scholar 

  9. Kuanfu, W., Xuanzi, H.: Application of Data Warehouse Technology in Data Centre Design. In: IEEE International Conference on Computational Intelligence and Security, pp. 484–488 (2008)

    Google Scholar 

  10. Wen, C.P.: Hierarchical Analysis For Discovering Knowledge in Large Databases. In: Information Systems Management, pp. 81–88 (2004)

    Google Scholar 

  11. Zhang, X.: A New Modelling Method for the Data Analysis Solution in Business. In: IEEE International Symposium on Electronics Commerce and Security, pp. 175–178 (2008)

    Google Scholar 

  12. Xuezhong, B., et al.: Building Clinical Data Warehouse for Traditional Chinese Medical Knowladge Discovery. In: IEEE International Conference on Bio-Medical Engineering and Informatics, pp. 615–620 (2008)

    Google Scholar 

  13. Dan-Ping, Z.: A Data Warehouse Based on University Human Resources Management of Performance Evaluation. In: IEEE International Forum on Information Technology and Application, pp. 655–658 (2009)

    Google Scholar 

  14. Qian, Z., Qing, X.: The Study on Data Warehouse Modelling and OLAP for Highway Management. In: IEEE International Conference on Measuring Technology and Mechatronics Automation, pp. 416–419 (2009)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Veer Narmad South Gujarat University, Surat, Gujarat, India

    Desai Pushpal

  2. Department of Computer Science, Veer Narmad South Gujarat University, Surat, Gujarat, India

    Desai Apurva

Authors
  1. Desai Pushpal
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Desai Apurva
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. SVKM’s NMIMS, MPSTME, Mukesh Patel School of Technology Management and Engineering, Bhakti Vedant Swami Marg, JVPD, 400056, Vile- Parle (W) Mumbai, Maharashtra, India

    Ketan Shah

  2. SVKM’s NMIMS, MPSTME Mukesh Patel School of Technology Management and Engineering, Bhakti Vedant Swami Marg, JVPD, 400056, Vile- Parle (W), Mumbai, Maharashtra, India

    V. R. Lakshmi Gorty

  3. SVKM’s NMIMS, MPSTME, Mukesh Patel School of Technology Management and Engineering, Bhakti Vedant Swami Marg, JVPD, 400056, Vile- Parle (W), Mumbai, Maharashtra, India

    Ajay Phirke

Rights and permissions

Reprints and permissions

Copyright information

© 2011 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Pushpal, D., Apurva, D. (2011). The Study on Data Warehouse Modelling and OLAP for Birth Registration System of the Surat City. In: Shah, K., Lakshmi Gorty, V.R., Phirke, A. (eds) Technology Systems and Management. Communications in Computer and Information Science, vol 145. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-20209-4_22

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-20209-4_22

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-20208-7

  • Online ISBN: 978-3-642-20209-4

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation