Skip to main content
SpringerLink
Log in

Development of a Business Intelligence Environment for e-Gov Using Open Source Technologies

  • Conference paper
Data Warehousing and Knowledge Discovery (DaWaK 2010)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 6263))

Included in the following conference series:

Abstract

It has become common for modern organizations to use advanced information systems for helping their daily operational task. However, there is still a large demand for software solutions that enable straightforward data analysis from these systems. Aiming to solve this problem, Business Intelligence (BI) environments were created. Electronic Government (e-Gov) systems, which typically work with governmental operational data, can take great benefits from a BI environment. Therefore, in e-Gov systems BI tools can be used, among others, to pursue the following goals: enhance the relationship between city and state government and the citizen; help administrating public resources; monitor the impacts of public policies upon the society. This paper presents a proposal for creating a BI environment for Electronic Government systems, using open source technologies with a special application to Social Welfare, developed for the city of Campinas, SP, Brazil.

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

Access this chapter

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

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Xu, L., Zeng, L., Shi, Z., He, Q., Wang, M.: Research on Business Intelligence in enterprise computing environment. In: ISIC. IEEE International Conference on Systems, Man and Cybernetics, pp. 3270–3275 (2007)

    Google Scholar 

  2. Moss, L.T., Atre, S.: Business Intelligence Roadmap: The Complete Project Lifecycle for Decision-Support Applications. Addison-Wesley Longman Publishing Co., Inc., Amsterdam (2003)

    Google Scholar 

  3. Hong, X., Zai-wen, L., Hai-yang, M.: Study and Realization of Supermarket BI System Based on Data Warehouse and Web Technique. In: CSSE 2008: Proceedings of the 2008 International Conference on Computer Science and Software Engineering, pp. 482–485. IEEE Computer Society, Washington (2008)

    Chapter  Google Scholar 

  4. Xu, Z., Zhang, M., Jiang, X.: Business Intelligence - A Case Study in Life Insurance Industry. In: ICEBE 2005: Proceedings of the IEEE International Conference on e-Business Engineering (2005)

    Google Scholar 

  5. Li, S., Shue, L., Lee, S.: Business intelligence approach to supporting strategy-making of ISP service management. J. Expert Syst. Appl. 35, 739–754 (2008)

    Article  Google Scholar 

  6. Ruschel, A.J.: Governo eletrônico: Business Intelligence para a modernização do Judiciário (2008)

    Google Scholar 

  7. Kimball, R.: The data warehouse toolkit: practical techniques for building dimensional data warehouses. John Wiley & Sons, Inc., Chichester (1996)

    Google Scholar 

  8. Sahama, T.R., Croll, P.R.: A data warehouse architecture for clinical data warehousing. In: ACSW 2007: Proceedings of the Fifth Australasian Symposium on ACSW Frontiers, pp. 227–232. Australian Computer Society, Inc., Australia (2007)

    Google Scholar 

  9. Wah, T.Y., Sim, O.S.: Development of a data warehouse for Lymphoma cancer diagnosis and treatment decision support. J. WSEAS Trans. Info. Sci. and App. 6, 530–543 (2009)

    Google Scholar 

  10. Rifaie, M., Blas, E.J., Muhsen, A.R.M., Mok, T., Kianmehr, K., Alhajj, R., Ridley, M.J.: Data warehouse architecture for GIS applications. In: iiWAS 2008: Proceedings of the 10th International Conference on Information Integration and Web-based Applications & Services, pp. 178–185. ACM, New York (2008)

    Google Scholar 

  11. Mussi, C., Murahovschi, D., Bettni, G., Kratz, L.G.: Data Warehouse - A Experiência da ANVISA. In: IX CBIS - Congresso Brasileiro de Informática em Saúde (2004)

    Google Scholar 

  12. Business intelligence at age 17, http://www.computerworld.com/s/article/266298/BI_at_age_17

  13. Kimball, R., Reeves, L., Ross, M., Thornwaite, W.: The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses. John Wiley & Sons, Inc., Chichester (1998)

    Google Scholar 

  14. Inmon, W.H.: Building the Data Warehouse. John Wiley & Sons, Inc., Chichester (1992)

    Google Scholar 

  15. Almeida, M.S., Ishikawa, M., Reinschmidt, J., Roeber, T.: Getting Started with Data Warehouse and Business Intelligence. IBM Redbooks (1999)

    Google Scholar 

  16. Biere, M.: Business intelligence for the enterprise. IBM Press (2003)

    Google Scholar 

  17. Codd, E.F., Codd, S.B., Salley, C.T.: Providing OLAP to User-Analysts: An IT Mandate (1993)

    Google Scholar 

  18. Chaudhuri, S., Dayal, U.: An overview of data warehousing and OLAP technology. J. SIGMOD Rec. 26, 65–74 (1997)

    Article  Google Scholar 

  19. Dunham, M.H.: Data Mining: Introductory and Advanced Topics. Prentice Hall PTR, Englewood Cliffs (2002)

    Google Scholar 

  20. Yu, C.: Role-Based and Service-Oriented Security Management in the E-Government Environment. In: EGOV 2009: Proceedings of the 8th International Conference on Electronic Government, pp. 364–375. Springer, Berlin (2009)

    Google Scholar 

  21. Lee, S.M., Tan, X., Trimi, S.: Current practices of leading e-government countries. J. Commun. ACM 48, 99–104 (2005)

    Article  Google Scholar 

  22. Velsen, L., Geest, T., Hedde, M., Derks, W.: Engineering User Requirements for e-Government Services: A Dutch Case Study. In: Wimmer, M.A., Scholl, H.J., Ferro, E. (eds.) EGOV 2008. LNCS, vol. 5184, pp. 243–254. Springer, Heidelberg (2008)

    Chapter  Google Scholar 

  23. Al-Omari, H.: E-Government Architecture in Jordan: A Comparative Analysis. J. of Computer Science 2(11), 846–852 (2006)

    Article  MathSciNet  Google Scholar 

  24. Tilli, M., Panhan, A.M., Lima, O., Mendes, L.S.: A Web-based Architecture for e-Gov. Application Development. In: ICE-B: Proceedings of the International Conference on e-Business (2008)

    Google Scholar 

  25. Talend: Open Source ETL and Data Integration Software, http://www.talend.com

  26. MySQL, http://www.mysql.com

  27. Mondrian, http://mondrian.pentaho.org

  28. XML for Analysis, http://www.xmla.org

  29. OpenI: Open Source Business Intelligence for On-Demand Deployments, http://openi.org

  30. Snell, J., Tidwell, D., Kulchenko, P.: Programming Web services with SOAP. O’Reilly & Associates, Inc., Sebastopol (2002)

    Google Scholar 

  31. Prefeitura Municipal de Campinas, http://2009.campinas.sp.gov.br/trabalho/

  32. Inmon, W.H.: Building the Data Warehouse, 4th edn. John Wiley & Sons, Inc., Chichester (2005)

    Google Scholar 

  33. Luján-Mora, S., Trujillo, J., Song, I.: A UML profile for multidimensional modeling in data warehouses. J. Data Knowl. Eng. 59, 725–769 (2006)

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Communication, School of Electrical and Computer Engineering, University of Campinas, Campinas, SP, Brazil

    Eduardo Zanoni Marques, Rodrigo Sanches Miani, Everton Luiz de Almeida Gago Júnior & Leonardo de Souza Mendes

Authors
  1. Eduardo Zanoni Marques
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Rodrigo Sanches Miani
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Everton Luiz de Almeida Gago Júnior
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Leonardo de Souza Mendes
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Department of Computer Science, Aalborg University, Selma Lagerløfs Vej 300, 9220, Aalborg, Denmark

    Torben Bach Pedersen

  2. IBM India Research Lab, 4, Block C, Institutional Area, Vasant Kunj, 110 070, New Delhi, India

    Mukesh K. Mohania

  3. Institute of Software Technology, Vienna University of Technology, Favoritenstr. 9-11/188, 1040, Vienna, Austria

    A Min Tjoa

Rights and permissions

Reprints and permissions

Copyright information

© 2010 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Marques, E.Z., Miani, R.S., de Almeida Gago Júnior, E.L., de Souza Mendes, L. (2010). Development of a Business Intelligence Environment for e-Gov Using Open Source Technologies. In: Bach Pedersen, T., Mohania, M.K., Tjoa, A.M. (eds) Data Warehousing and Knowledge Discovery. DaWaK 2010. Lecture Notes in Computer Science, vol 6263. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-15105-7_16

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-15105-7_16

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-15104-0

  • Online ISBN: 978-3-642-15105-7

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation