Tracing data warehouse design lifecycle semantically

Khouri, Selma; Berkani, Nabila; Bellatreche, Ladjel

doi:10.1016/j.csi.2016.12.002

Cited by 5 publications

(3 citation statements)

References 61 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…However, they can complement the formalization of different stakeholders’ needs. Many researchers have used ontologies to help automate the extraction of the MD schema elements of DWs (Khouri et al , 2017; Thenmozhi and Vivekanandan, 2012; Thenmozhi and Vivekanandan, 2013; Vranesiu and Rovan, 2009; Romero and Abelló, 2007; Pardillo and Mazon, 2011). Furthermore, the use of ontologies for the design of DWs has been applied and tested in many domains such as grain trade domain (Itmi and Ouchenne, 2018), earthquake prediction analysis (Nimmagadda and Dreher, 2007), petroleum industry (Nimmagadda and Dreher, 2011) and health care strategic management (Nimmagadda et al , 2008).…”

Section: Ontology-based Data Warehouse Designmentioning

confidence: 99%

“…Accordingly, the design task becomes very tedious and complex, forcing designers to acquire a wide knowledge of the domain on hand. To overcome this, ontologies seem to be an appropriate solution (Khouri et al , 2017; Thenmozhi and Vivekanandan, 2012; Nebot et al , 2009; Liu and Iftikhar, 2013; Gulić, 2013; Pardillo and Mazon, 2011; Romero and Abelló, 2010).…”

Section: Introductionmentioning

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: Ontology-based Data Warehouse Designmentioning

confidence: 99%

Section: Introductionmentioning

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

“…In our work, we use the traceability model that we proposed in [48], the goal of which is to keep traces of the DW during its design cycle. The model is illustrated in Figure 2 as a UML class diagram.…”

Section: Dw Traceability Model For Managing Co-evolutionmentioning

confidence: 99%

LOD for Data Warehouses: Managing the Ecosystem Co-Evolution

Khouri

Bellatreche

2018

Information

Self Cite

View full text Add to dashboard Cite

For more than 30 years, data warehouses (DWs) have attracted particular interest both in practice and in research. This success is explained by their ability to adapt to their evolving environment. One of the last challenges for DWs is their ability to open their frontiers to external data sources in addition to internal sources. The development of linked open data (LOD) as external sources is an excellent opportunity to create added value and enrich the analytical capabilities of DWs. However, the incorporation of LOD in the DW must be accompanied by careful management. In this paper, we are interested in managing the evolution of DW systems integrating internal and external LOD datasets. The particularity of LOD is that they contribute to evolving the DW at several levels: (i) source level, (ii) DW schema level, and (iii) DW design-cycle constructs. In this context, we have to ensure this co-evolution, as conventional evolution approaches are adapted neither to this new kind of source nor to semantic constructs underlying LOD sources. One way of tackling this co-evolution issue is to ensure the traceability of DW constructs for the whole design cycle. Our approach is tested using: the LUBM (Lehigh University BenchMark), different LOD datasets (DBepedia, YAGO, etc.), and Oracle 12c database management system (DBMS) used for the DW deployment.

show abstract