A data warehouse for local good governance monitoring and assessement — Case study of local registry office in Morocco

Chakiri, Houda; Mohajir, Mohammed El

doi:10.1109/cist.2016.7804850

Cited by 4 publications

(8 citation statements)

References 5 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…For an unbiased local good-governance assessment, we have worked on the design and implementation of a national DW (Chakiri and El Mohajir, 2017) to provide central and local decision-makers with means to access accurate local government data, to evaluate service delivery at municipalities. In this work, we propose a framework to assess the attributes of good-governance used by the previously described tools and defined by the UNDP (1997) as described in Table II.…”

Section: Local Governance Assessment Toolsmentioning

confidence: 99%

“…In Chakiri and El Mohajir (2017), we proposed to extract the DW MD schema automatically from the contextual modeling of the user requirements (goal, rational and business process diagrams). However, a manual refinement of the extracted MD schema was necessary to adapt the obtained MD schema to the existing relational database sources.…”

Section: Data Warehouse Design Frameworkmentioning

confidence: 99%

See 1 more Smart Citation

A data warehouse hybrid design framework using domain ontologies for local good-governance assessment

Chakiri

Mohajir

Assem

2020

Self Cite

View full text Add to dashboard Cite

Purpose Most local governance assessment tools are entirely or partially based on stakeholders’ surveys, focus groups and benchmarks of different local governments in the world. These tools remain a subjective way of local governance evaluation. To measure the performance of local good-governance using an unbiased assessment technique, the authors have developed a framework to help automate the design process of a data warehouse (DW), which provides local and central decision-makers with factual, measurable and accurate local government data to help assess the performance of local government. The purpose of this paper is to propose the extraction of the DW schema based on a mixed approach that adopts both i* framework for requirements-based representation and domain ontologies for data source representation, to extract the multi-dimensional (MD) elements. The data was collected from various sources and information systems (ISs) deployed in different municipalities. Design/methodology/approach The authors present a framework for the design and implementation of a DW for local good-governance assessment. The extraction of facts and dimensions of the DW’s MD schema is done using a hybrid approach, where the extraction of requirement-based DW schema and source-based DW schema are done in parallel followed by the reconciliation of the obtained schemas to obtain the good-governance assessment DW final design. Findings The authors developed a novel framework to design and implement a DW for local good-governance assessment. The framework enables the extraction of the DW MD schema by using domain ontologies to help capture semantic artifacts and minimize misconceptions and misunderstandings between different stakeholders. The introduction and use of domain ontologies during the design process serves the generalization and automation purpose of the framework. Research limitations/implications The presently conducted research faced two main limitations as follows: the first is the full automation of the design process of the DW and the second, and most important, is access to local government data as it remains limited because of the lack of digitally stored data in municipalities, especially in developing countries in addition to the difficulty of accessing the data because of regulatory aspects and bureaucracy. Practical implications The local government environment is among the public administrations most subject to change-adverse cultures and where the authors can face high levels of resistance and significant difficulties during the implementation of decision support systems, despite the commitment/engagement of decision-makers. Access to data sources stored by different ISs might be challenging. While approaching the municipalities for data access, it was done in the framework of a research project within one of the most notorious universities in the country, which gave more credibility and trust to the research team. There is also a need for further testing of the framework to reveal its scalability and performance characteristics. Originality/value Compared to other local government assessment ad hoc tools that are partially or entirely based on subjectively collected data, the framework provides a basis for automated design of a comprehensive local government DW using e-government domain ontologies for data source representation coupled with the goal, rationale and business process diagrams for user requirements representations, thus enabling the extraction of the final DW MD schema.

show abstract

Section: Local Governance Assessment Toolsmentioning

confidence: 99%

Section: Data Warehouse Design Frameworkmentioning

confidence: 99%

A data warehouse hybrid design framework using domain ontologies for local good-governance assessment

Chakiri

Mohajir

Assem

2020

Self Cite

View full text Add to dashboard Cite

show abstract

“…In addition, the data warehouse with 4 step Kimball method been implemented to build a data warehouse to support the evaluation of the performance of the lecturers at a university [10]. Lecturer evaluated its performance by looking at the ability to work and liveliness not only the faculty evaluation that uses data warehouse, government evaluation is also done by building a data warehouse [2]. In addition to the school and the government, the data warehouse is also Design of E-Grant Application Data Warehouse A.A Ngurah Narendra [1] , Santi Ika Murpratiwi [2] , and Made Sudarma [3] [11].…”

Section: Studi Literature a Literature Reviewmentioning

confidence: 99%

“…Lecturer evaluated its performance by looking at the ability to work and liveliness not only the faculty evaluation that uses data warehouse, government evaluation is also done by building a data warehouse [2]. In addition to the school and the government, the data warehouse is also Design of E-Grant Application Data Warehouse A.A Ngurah Narendra [1] , Santi Ika Murpratiwi [2] , and Made Sudarma [3] [11]. Based on research support and the existing problems in the e-Grant system, it will be the design of the data warehouse to support the operational of the e-Grant system.…”

Section: Studi Literature a Literature Reviewmentioning

confidence: 99%

“…With more advanced age and the era of modernization, the more advanced technology and information systems also for processing large amounts of data ,According to the International Business Machines Corporation (IBM) on the site, large amounts of data generated by everything around us at all times and large data sets can be implemented in a Database Management System (DBMS) which will be processed to obtain necessary information quickly, accurately, and precious [1] Likewise with a government agency in which requires a fast data processing in determining decision and monitoring the government's performance [2].…”

Section: Introductionmentioning

confidence: 99%

See 1 more Smart Citation

Design of E-Grant Application Data Warehouse

Narendra

Murpratiwi

Sudarma

2017

IJEET

View full text Add to dashboard Cite

Grants is a program launched by the government as a means to develop the potential of the region or contribute to society in the form of money or objects In submitting as Grant there are many sources of data stored in the system e -Grant, The amount of the proposal Grant is very much in each period so as to be reorganized, One solution for the storage of e-submission of the Grant is to build a data warehouse, Due to the technological development of data warehouse will be able to support the creation of a single access door managerial parties in obtaining information in the data warehouse, The design of the data warehouse were calculated using a four step Kimball, Methods Kimball 4 step has the advantages of a more compact, dynamic, and supports the creation of a data warehouse that is structured output of the data warehouse to the e-Grant in the form of Reports Grant and a recapitulation of Grant where reports Grant is being used as an attachment to a defense in response to the report Expenditure Provincial Bali whereas Summary of Grants used for List SKPD to evaluate the Grant recipient.

show abstract

CMCD: A data warehouse modeling framework based on goals and business process models

2017

View full text Add to dashboard Cite

A data warehouse for local good governance monitoring and assessement — Case study of local registry office in Morocco

Cited by 4 publications

References 5 publications

A data warehouse hybrid design framework using domain ontologies for local good-governance assessment

A data warehouse hybrid design framework using domain ontologies for local good-governance assessment

Design of E-Grant Application Data Warehouse

CMCD: A data warehouse modeling framework based on goals and business process models

Contact Info

Product

Resources

About