Use of multidimensional data models to increase active public transparency
DOI:
https://doi.org/10.18617/liinc.v9i2.599Keywords:
Transparência Pública, Tecnologias de Informação e Comunicação, Coleta de Dados, Citizen Intelligence, Data WarehouseAbstract
Abstract Environments for access to government data, via
Information and Communications Technologies, may expand possibilities for citizen monitoring, providing feedback for future demands. The aim of this study is to identify, in the available data via active transparency, the existence of elements that allow the construction of new proposals of dimensional models, enabling an anticipation of demands on data access. The theoretical-methodological framework, the text uses the concepts Citizen Intelligence and Business Intelligence. As a result, a dimensional model was proposed, building on a dimensional model from a daily expenses query, available in the Transparency home-page of the Brazillian Federal Government.
Keywords Public Transparency, Information and Communication Technologies, Collecting Data, Citizen Intelligence, Data Warehouse.
Downloads
Additional Files
- Figura 1 - Exemplo de tabela venda em uma base de dados transacional (Portuguese)
- Figura 2 - Exemplo de tabela de fato Venda em um modelo dimensional (Portuguese)
- Figura 3 - Exemplo de tabela de dimensão Funcionário em um modelo dimensional (Portuguese)
- Figura 4 - Exemplo de um modelo dimensional em esquema estrela (Portuguese)
- Figura 5 - Formas de refinamento na consulta Detalhamento Diário das Despesas (Portuguese)
- Figura 6 - Resultados da consulta Detalhamento Diário das Despesas em forma de lista (Portuguese)
- Figura 7 - Detalhamento de documentos vinculados em cada despesa (Portuguese)
- Figura 8 - Proposta de modelo dimensional no esquema estrela (star schema) (Portuguese)
- USO DE MODELOS DE DADOS MULTIDIMENSIONAIS PARA AMPLIAÇÃO DA TRANSPARÊNCIA ATIVA (Portuguese)
Published
Issue
Section
License
Authors who publish with this journal agree to the following terms:
Authors retain copyright and grant Liinc em Revista the right of first publication with the work simultaneously licensed under a Creative Commons Attribution 4.0 International License.
The authors have permission and are encouraged to deposit their manuscripts and versios of record (VoR) in their personal web pages or institutional repositories, generic repositories etc., before (pre-print) or after (post-print) the publication in Liinc em Revista, according to its open access depositing policy registered in the Directory of Editorial Policies of Brazilian Journals (DIADORIM), kindly providing a link to the article published on Liinc's website.
Liinc em Revista, published by Instituto Brasileiro de Informação em Ciência e Tecnologia, is licensed under a Creative Commons Attribution 4.0 International License – CC BY 4.0