Implementation of Data Mining and Data Warehousing In E-Governance

Agarwal, Sonali; Singh, Neera; Pandey, Gaurav

doi:10.5120/1374-1851

Cited by 4 publications

(3 citation statements)

References 3 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…Various e-government projects worldwide have made usage of data warehousing and business intelligence techniques in diverse fields such as agriculture (Sonali et al , 2010), education (Bhanti et al , 2011; ElFangary, 2009), public heath (Ewen and Smith, 1999), citizen grievance (Sangeetha and Manjunatha, Rao, 2016), finance (Ferreira et al , 2017) and public security (Syvajarvi and Stenvall, 2010). Indeed, there exist various practices depicted in kinds of literature to increase the efficiency of e-government systems, where data warehousing techniques were used, however, to the best of our knowledge the use of DWs for assessing governance locally or nationwide was not covered so far.…”

Section: Data Warehouse and E-governancementioning

confidence: 99%

“…Sonali et al (2010) propose a nationwide DW model for India named “state data warehouse.” According to the authors, the provided model covers all aspects of e-governance including four main parts, namely, administration, technical know-how, service and stakeholders. The purpose of the suggested DW is to integrate all distributed databases in a single repository and offer an easy and quicker view over historical data while providing reports of organizational performance.…”

Section: Data Warehouse and E-governancementioning

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

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: Data Warehouse and E-governancementioning

confidence: 99%

Section: Data Warehouse and E-governancementioning

confidence: 99%

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

Chakiri

Mohajir

Assem

2020

View full text Add to dashboard Cite

show abstract

“…Data warehouse merupakan central point pengingrasian banyak database [8,9]. Implementasi data warehouse sangat luas dan terbuka di lingkungan pemerintahan [4] sebab pemerintah telah memiliki banyak sumber data untuk diolah menjadi informasi lintas departemen yang komprehensif [10]. Beberapa implementasi data warehouse [11,12] dapat meningkatkan kinerja pemerintah, sebagian yang lain [4,10] menjadi perangkat lunak kecerdasan bisnis.…”

unclassified