More Web Proxy on the site http://driver.im/

research-article

Queries-based requirements imprecision study for data warehouse update structural approach

Authors:

Larbi Abdelmadjid,

Malki MimounAuthors Info & Claims

ICIST '18: Proceedings of the 8th International Conference on Information Systems and Technologies

Article No.: 5, Pages 1 - 10

https://doi.org/10.1145/3200842.3200851

Published: 16 March 2018 Publication History

Abstract

Due to the increasing complexity of Data Warehouse (DW), continuous attention must be paid for evaluation of their quality throughout their design and development [1]. A good requirements model quality may lead to a good DW quality [2]. Various authors have proposed metrics to assure the quality of conceptual, logical and physical models for DW. However, there is no significant work in the DW literature to assure the requirements model quality. Starting from a misinterpretation of fuzzy requirements, all data warehouse conceptions and OLAP analysis ensuing will be wrong. To design a DW model, it is necessary to take into account not only data sources, but also the analysis requirements. Therefore, in the literature they have focused studies on the data inaccuracy but not in queries-based requirements imprecision. In order to evaluate the queries-based requirements imprecision and in order to improve the data warehouse design quality and inspiring Fasel model, this paper presents a naive solution which represent a structural proposition for the update data warehouse case. We're going to apply this proposal in the road accidents risk casee.

References

[1]

Gam I., Camille Salinesi, (2006), Analyse des Exigences pour la Conception d'Entrepots de Données, Université de Paris 1, Panthéon Sorbonne

[2]

Manoj Kumar, (2011), Quality-Oriented Requirements Engineering for a Data Warehouse, ACM SIGSOFT Software Engineering

Digital Library

[3]

Siqueira &al, (2014), Modeling vague spatial data warehouses using the VSCube conceptual model TLL Geo Informatica - Springer

Digital Library

[4]

Mustafa Musa J., (2015), Flexible Data Warehouse Parameters: Toward Building an Integrated Architecture, Intern. Journal of Computer Theory and Eng.

[5]

Pivert O.& al., (2012), Fuzzy preference queries to relational databases, Book, World Scientific

[6]

Fasel D. (2014), Fuzzy Data Warehouse, - Fuzzy Data Warehousing for Performance, Springer

Digital Library

[7]

Chiu CY. &al, (2014), Customer information system using fuzzy query and cluster analysis. - Journal of Industrial and ..., - Taylor & Francis

[8]

Chen CT. &al, (2009), A comprehensive model for selecting information system project under fuzzy environment Intern. Journal P.M., - Elsevier.

[9]

Sabri Aziza, Kjiri Laila; (2012), Patterns to analyze requirements of a Decisional Information System, Journal of Computer Application (IJCA), Special Issue On Software Engineering Databases and EXpert Systems (SEDEXS), Number 2, ISBN: 973-93-80870-26-8, 17

[10]

Tamani N., (2013), A Fuzzy Ontology for Database Querying with Bipolar Preferences, International Journal of Intelligent Systems

Digital Library

[11]

Rodríguez ND. & al., (2014), A fuzzy ontology for semantic modelling and recognition of human behavior - Knowledge-Based ..., Elsevier

Digital Library

[12]

Bellahsene Z., (2002), Schema Evolution in Data Warehouses, Knowledge and Information Systems, - Springer

Digital Library

[13]

Larbi A., MALKI M., Boukhalfa K., Merzoug A., (Avril 2017), A Survey of Decisional Requirements: Imprecision study; JFSE 2017; Proceeding, ISSN 1613-0073, pp 21--26

[14]

Abran A, J.W. Moore, P. Bourque and R.E. Dupuis. (2004), Guide to the Software Engineering Body of Knowledge. http://www.swebok.org/.IEEE Computer Society.

Digital Library

[15]

Garima Thakur & al., (2011), DWEVOLVE: A Requirement Based Framework for Data Warehouse Evolution, ACM SIGSOFT Software Engineering Notes, Volume 36 Number 6

Digital Library

[16]

Keele Legros D., (2009), Maîtrise des risques dans les systèmes de transport, Thèse.

[17]

Jean S., OntoQL, (2007), langage d'exploitation des bases de données à base ontologique, Thèse, France.

[18]

Miloud D. & al., (2013), A fuzzy logic model for identifying spatial degrees of exposure to the risk of road accidents, 978-14799-0313-9/13 IEEE

[19]

Larbi A., Malki M., Boukhalfa K., (2018), Fuzzy Ontology-based Approach for the Requirements Query Imprecision Assessment in Data Warehouse Design Process Near Negative Fuzzy Operator, International Journal of Information Technology and Computer Science(IJITCS), Vol.10, No.2, pp.18--32, 2018.

[20]

Mayer N., Humbert P., (Avril-Mai 2006), la gestion des risques pour les systèmes d'information, Revue MISC, Luxembourg.

[21]

Seo, K. & al. (2009), Ontology-based fuzzy support agent for ship steering control. Expert Systems with Applications 36 (1), 755--765.

Digital Library

[22]

Nebot V.& al., (2009), Multidimensional integrated ontologies: a framework for designing semantic data warehouses.

[23]

Golfarelli M. & al., (2011), Modern Software Engineering Methodologies Meet Data Warehouse Design: 4WD; DaWaK, LNCS 6862, Springer

Digital Library

[24]

Pardillo J.& al., (2011), Using ontologies for the Design of DWs, IJDMS

[25]

Ghozzi F., (2005), Méthode de conception d'une base multidimensionnelle contrainte. In Revue des Nouvelles Technologies de l'Information - Entrepôts de Données et l'Analyse en ligne (EDA'05), volume RNTI B-1, pages 51--70. Cépadues éditions,

[26]

Prakash N., Gosain A., (2005), Requirements Driven Data Warehouse Development, CAiSE Short Paper Proceedings, India.

[27]

Romero O. Abelló; (2009), A Survey of Multidimensional Modeling Methodologies, International Journal of Data Warehousing & Mining.

[28]

Sapir L. & al., (2008), A methodology for the design of FDW 4th Intern. IEEE Conference "Intelligent Systems"

[29]

Boyadzhieva D., & al., (2014), Intuitionistic Fuzzy Data Warehouse and Some Analytical operations, IEEE Transactions on Fuzzy Systems, Vol.22, No. 4, AUGUST

[30]

Delgado A. & al., (2015), Automating the process of building flexible Web Warehouses with BPM Systems, Latin American Computing Conference

[31]

Daniel Fasel, (2014), Fuzzy Data Warehousing for Performance Measurement Part of the series Fuzzy Management Methods pp 43--114

Digital Library

[32]

Fasel D.; (2012), Concept and Implementation of a Fuzzy Data Warehouse; University of Fribourg; thesis

[33]

Khouri, S.;Boukhari I.;Bellatreche L.;Sardet E.; Jean S.; Baron M.; (2012), Ontology-based structured web data warehouses for sustainable interoperability :requirement modeling, design methodology and tool, Computers in industry; Elsevier

Digital Library

[34]

Ghorbel,H.,Bahri,A., Bouaziz,R., (2009), Fuzzy Protégé for fuzzy ontology models. In: Proc. Of 11th International Conference IPC'2009. Academic Medical Center, University of Amsterdam, Amsterdam, Netherlands.

[35]

Jiang, Y.& al., (2011), Reasoning and change management in modular fuzzy ontologies. Expert Systems with Applications 38 (11), 13975--13986.

[36]

Martinez-Cruz, C.; (2014), An Ontology to represent Queries in Fuzzy Relational Databases, ISDA, Page(s): 1317--1322 ISSN: 2164--7143

[37]

Bobillo F., Straccia, U. (2011), Fuzzy ontology representation using OWL 2. International Journal of Approximate Reasoning 52(7), 1073--1094

Digital Library

[38]

Larbi A.; Malki M.; Boukhalfa K.; Layachi h.; (2013), Modeling the Imprecision of Flexible Queries Using a Fuzzy SQL Language; 2nd International Conference on Software Engineering and New Technologies; ICSENT'13. Tunis.

Cited By

Larbi AMalki M(2019)Requirements Imprecision of Data Warehouse Design Fuzzy Ontology-Based Approach - Fuzzy Connector CaseProceedings of the 8th International Conference on Sciences of Electronics, Technologies of Information and Telecommunications (SETIT’18), Vol.110.1007/978-3-030-21005-2_11(115-122)Online publication date: 11-Jul-2019
https://doi.org/10.1007/978-3-030-21005-2_11

Index Terms

Queries-based requirements imprecision study for data warehouse update structural approach
1. Computing methodologies
  1. Artificial intelligence
    1. Knowledge representation and reasoning
2. Information systems
  1. Information systems applications
    1. Decision support systems
      1. Data warehouses

Recommendations

Alliance Rules for Data Warehouse Cleansing
ICSPS '09: Proceedings of the 2009 International Conference on Signal Processing Systems

Data Cleansing is an activity performed on the data sets of data warehouse to enhance and maintain the quality and consistency of the data. This paper addresses the problems related with dirty data, entrance of dirty data and detection of dirty data in ...
Towards Data Quality into the Data Warehouse Development
DASC '11: Proceedings of the 2011 IEEE Ninth International Conference on Dependable, Autonomic and Secure Computing

Commonly, DW development methodologies, paying little attention to the problem of data quality and completeness. One of the common mistakes made during the planning of a data warehousing project is to assume that data quality will be addressed during ...
Managing Data Quality of the Data Warehouse: A Chance-Constrained Programming Approach
Abstract
To make informed decisions, managers establish data warehouses that integrate multiple data sources. However, the outcomes of the data warehouse-based decisions are not always satisfactory due to low data quality. Although many studies focused on ...

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

cover image ACM Other conferences

ICIST '18: Proceedings of the 8th International Conference on Information Systems and Technologies

March 2018

84 pages

ISBN:9781450364041

DOI:10.1145/3200842

Conference Chair:
Mohamed Ridda Laouar,
Program Chair:
Ejub Kajan

Copyright © 2018 ACM.

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than the author(s) must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected].

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 16 March 2018

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Research-article

Conference

ICIST '18

ICIST '18: 8th International Conference on Information Systems and Technologies

March 16 - 18, 2018

Istanbul, Turkey

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

1
Total Citations
View Citations
62
Total Downloads

Downloads (Last 12 months)3
Downloads (Last 6 weeks)0

Reflects downloads up to 02 Mar 2025

Other Metrics

View Author Metrics

Citations

Cited By

Larbi AMalki M(2019)Requirements Imprecision of Data Warehouse Design Fuzzy Ontology-Based Approach - Fuzzy Connector CaseProceedings of the 8th International Conference on Sciences of Electronics, Technologies of Information and Telecommunications (SETIT’18), Vol.110.1007/978-3-030-21005-2_11(115-122)Online publication date: 11-Jul-2019
https://doi.org/10.1007/978-3-030-21005-2_11

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Figures

Tables

Media

View Table of Conten