Skip to main content
SpringerLink
Log in

A Data Warehouse Schema to Support Financial Process in Local eGov

  • Conference paper
  • First Online:
Book cover Recent Advances in Information Systems and Technologies (WorldCIST 2017)

Part of the book series: Advances in Intelligent Systems and Computing ((AISC,volume 569))

Included in the following conference series:

  • 2545 Accesses

Abstract

Organizations are constantly changing due to the evolution of technologies, requiring them to restructure their strategies. On this case, local autarchies are not an exception. Due to the big data volume involved within the government ecosystem, Business Intelligence (BI) systems were implemented to deal with several processes where effective and efficient decisions are crucial. These systems have proved to be worth on the global government and this article will show how those systems can also be applied to local autarchies, where Business Intelligence can make a positive difference. The multidimensional model created for the local autarchy will be presented, consisting on one fact table and eleven dimensions. This model was created aiming to optimize the autarchy’s decision-making processes, related with the financial department.

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 169.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 219.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

References

  1. Lenin: Business Intelligence and E-governance. Department of information Technology Ministry of Communication & IT (2006)

    Google Scholar 

  2. Negash, S.: Business Intelligence. The Communications of the Association for Information (2004)

    Google Scholar 

  3. Santos, M.Y., Ramos, I.: Business Intelligence: Tecnologias da informação na gestão de conhecimento. FCA-Editora de Informática (2006)

    Google Scholar 

  4. Thompson, O.: Business Intelligence Success (2009). Retrieved from Technology evaluation: technologyevalution.com

  5. Turban, E., Sharda, R.: eBook - Turban 2010 - Decision Support and Business Intelligence (2010)

    Google Scholar 

  6. Van der Lans, R.: Data Virtualization for Business Intelligence Systems (2012)

    Google Scholar 

  7. Vercellis, C.: Business Intelligence: Data Mining and Optimization for Decision Making (2009)

    Google Scholar 

  8. PGDL. Regime Financeiro das Autarquias Locais e Entidades Intermunicipais (2009). http://www.pgdlisboa.pt/leis/lei_mostra_articulado.php?nid=545&tabela=leis. Accessed

  9. CMG, Guimarães, C.M., Relatório de Contas 2014. (2014)

    Google Scholar 

  10. Hai, J.: Fundamental of Development Administration. Scholar Press, Selangor (2007)

    Google Scholar 

  11. GESMA. Simplex Autárquico - Quanto Mais Perto Melhor (2008). http://www.gsema.gov.pt/index2.php?option=com_docman&task=doc_view&gid=34&Itemid=32. Accessed

  12. Kimball, R.: The data warehouse toolkit: the complete guide to dimensional modeling (2002)

    Google Scholar 

  13. Brandão, A., Pereira, E., Esteves, M., Portela, F., Santos, M.F., Abelha, A., Machado, J.: A benchmarking analysis of open-source business intelligence tools in healthcare environments. Information 7(4) (2016). ISSN: 2078-2489. MDPI

    Google Scholar 

  14. Pereira, A., Portela, F., Santos, M.F., Abelha, A., Machado, J.: Pervasive business intelligence: a new trend in critical healthcare. In: Procedia Computer Science - ICTH 2016 - International Conference on Current and Future Trends of Information and Communication Technologies in Healthcare, vol. 98, pp. 362–367. Elsevier (2016). ISSN: 1877-0509

    Google Scholar 

  15. Carvalhosa, P., Portela, F., Santos, M.F., Abelha, A., Machado, J.: Pervasiveness in digital marketing – a global overview. In: Rocha, Á., Correia, A.M., Adeli, H., Reis, L.P., Costanzo, S. (eds.) Recent Advances in Information Systems and Technologies, Part 3. Advances in Intelligent Systems and Computing, vol. 517, pp. 391–398. Springer, Cham (2017)

    Google Scholar 

  16. Carvalhosa, P., Portela, F., Machado, J., Santos, M.F., Abelha, A.: Good practices in local government - a first overview of Portuguese reality. In: The International Conference on Information Technology and Digital Applications (ICITDA 2016). IOP (2016). Accepted for publication

    Google Scholar 

  17. Teixeira, R., Afonso, F., Oliveira, B., Machado, J., Abelha, A., Santos, M.F., Portela, F.: Decision support in E-government – A pervasive business intelligence approach. In: Rocha, A., Correia, A.M., Costanzo, S., Reis, L.P. (eds.) New Contributions in Information Systems and Technologies. AISC, vol. 354, pp. 155–166. Springer, Cham (2015). doi:10.1007/978-3-319-16528-8_15

    Google Scholar 

  18. Teixeira, R., Afonso, F., Oliveira, B., Portela, F., Santos, M.F.: Business intelligence to improve the quality of local government services - case-study in a local government town hall. In: KMIS 2014 - International Conference on Knowledge Management and Information Sharing, pp. 153–160. SciTePress, Rome (2014). ISBN: 978-989-758-050-5

    Google Scholar 

  19. Teixeira, R.: Apoio à decisão na melhoria dos processos de qualidade, através da utilização de técnicas de Business Intelligence (2014)

    Google Scholar 

Download references

Acknowledgments

This work has been supported by Compete: POCI-01-0145-FEDER-007043 and FCT within the Project Scope UID/CEC/00319/2013.

Author information

Authors and Affiliations

  1. Algoritmi Research Centre, University of Minho, Braga, Portugal

    Andreia Costa, Manuel Filipe Santos & António Abelha

Authors
  1. Andreia Costa
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Manuel Filipe Santos
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. António Abelha
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Manuel Filipe Santos .

Editor information

Editors and Affiliations

  1. DEI/FCT, Universidade de Coimbra, Coimbra, Baixo Mondego, Portugal

    Álvaro Rocha

  2. Nova IMS, Universidade Nova de Lisboa, Lisboa, Portugal

    Ana Maria Correia

  3. College of Engineering, The Ohio State University, Columbus, Ohio, USA

    Hojjat Adeli

  4. DSI/EEUM, Universidade do Minho, Guimarães, Portugal

    Luís Paulo Reis

  5. DIMES, Università della Calabria, Arcavacata di Rende, Italy

    Sandra Costanzo

Rights and permissions

Reprints and permissions

Copyright information

© 2017 Springer International Publishing AG

About this paper

Cite this paper

Costa, A., Santos, M.F., Abelha, A. (2017). A Data Warehouse Schema to Support Financial Process in Local eGov. In: Rocha, Á., Correia, A., Adeli, H., Reis, L., Costanzo, S. (eds) Recent Advances in Information Systems and Technologies. WorldCIST 2017. Advances in Intelligent Systems and Computing, vol 569. Springer, Cham. https://doi.org/10.1007/978-3-319-56535-4_36

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-56535-4_36

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-56534-7

  • Online ISBN: 978-3-319-56535-4

  • eBook Packages: EngineeringEngineering (R0)

Publish with us

Policies and ethics

Search

Navigation