{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,6,10]],"date-time":"2026-06-10T14:55:09Z","timestamp":1781103309302,"version":"3.54.1"},"reference-count":43,"publisher":"IGI Global Scientific Publishing","issue":"1","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2019,1]]},"abstract":"<jats:p>The development of information systems (IS) in a secure environment or condition is a complex task that involves many additional basic security protocols, policies as well as industry standards on passwords, anti-virus programs, firewalls and data encryption. However, in traditional IS development lifecycles, security is either ignored or added as an afterthought, which does not assure the system complete security. So, it is necessary to give more importance to this issue and consider it as part of IS development process. In this context, the authors should guarantee the security of ETL (Extract, Transform, Load) processes, which are among the most critical and complex tasks during DW development project. In this study, security management is carried out for ETL processes by proposing a meta-model integrating the security concepts from the security requirements to the necessary preventive and \/ or corrective treatments. The proposed meta-model is validated with instantiation.<\/jats:p>","DOI":"10.4018\/ijismd.2019010104","type":"journal-article","created":{"date-parts":[[2019,3,27]],"date-time":"2019-03-27T14:25:36Z","timestamp":1553696736000},"page":"60-84","source":"Crossref","is-referenced-by-count":2,"title":["ETL Processes Security Modeling"],"prefix":"10.4018","volume":"10","author":[{"given":"Salma","family":"Dammak","sequence":"first","affiliation":[{"name":"University of Sfax, MIRACL-ISIMS, Sfax, Tunisia"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-6970-0297","authenticated-orcid":true,"given":"Faiza","family":"Ghozzi","sequence":"additional","affiliation":[{"name":"Sfax University, MIRACL-ISIMS, Sfax, Tunisia"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Faiez","family":"Gargouri","sequence":"additional","affiliation":[{"name":"University of Sfax, MIRACL-ISIMS, Sfax, Tunisia"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"2432","reference":[{"key":"IJISMD.2019010104-0","doi-asserted-by":"publisher","DOI":"10.1007\/s41019-016-0016-y"},{"key":"IJISMD.2019010104-1","doi-asserted-by":"crossref","unstructured":"Akeel, F. Y., Wills, G. B., & Gravell, A. M. (2013, December). SecureDIS: a framework for secure data integration systems. In 2013 8th International Conference for Internet Technology and Secured Transactions (ICITST) (pp. 588-593). IEEE.","DOI":"10.1109\/ICITST.2013.6750270"},{"key":"IJISMD.2019010104-2","doi-asserted-by":"publisher","DOI":"10.1109\/ICITST.2014.7038849"},{"key":"IJISMD.2019010104-3","author":"S.Andre","year":"2004","journal-title":"MDA (model driven architecture) principes et \u00e9tats de l\u2019art"},{"key":"IJISMD.2019010104-4","unstructured":"Basili, V. R. (1992). Software modeling and measurement: the Goal\/Question\/Metric paradigm."},{"key":"IJISMD.2019010104-5","doi-asserted-by":"crossref","unstructured":"Bhargava, B. (2000). Security in datawarehousing. In DataWarehousing and Knowledge Discovery (pp. 287\u2013289).","DOI":"10.1007\/3-540-44466-1_28"},{"key":"IJISMD.2019010104-6","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-642-15546-8_8"},{"key":"IJISMD.2019010104-7","author":"J.Bowen","year":"2012","journal-title":"Getting Started with Talend Open Studio for Data Integration"},{"key":"IJISMD.2019010104-8","unstructured":"Brauer, K. (2011). Authentication and security aspects in an international multi-user network."},{"key":"IJISMD.2019010104-9","doi-asserted-by":"crossref","unstructured":"Chew, E., Swanson, M., Stine, K. M., Bartol, N., Brown, A., & Robinson, W. (2008). Sp 800-55 rev. 1. performance measurement guide for information security.","DOI":"10.6028\/NIST.SP.800-55r1"},{"key":"IJISMD.2019010104-10","doi-asserted-by":"publisher","DOI":"10.1109\/AICCSA.2017.65"},{"key":"IJISMD.2019010104-11","unstructured":"Dammak, S., & Jedidi, Ghozzi F.(2011). D\u00e9veloppement d\u2019une d\u00e9marche de conception d\u2019un Webhouse s\u00e9curis\u00e9 bas\u00e9 sur l\u2019architecture MDA [Master thesis]. Higher Institute of Computer Science and Multimedia."},{"key":"IJISMD.2019010104-12","first-page":"160","article-title":"Quantifying Security in Web ETL Processes.","author":"S.Dammak","year":"2015","journal-title":"International Conference on Risks and Security of Internet and Systems"},{"key":"IJISMD.2019010104-13","doi-asserted-by":"publisher","DOI":"10.1109\/AICCSA.2016.7945689"},{"key":"IJISMD.2019010104-14","unstructured":"T.P.S. Documentation. (2005). Information technology\u2013Security techniques\u2013Information security management systems\u2013Requirements."},{"key":"IJISMD.2019010104-15","doi-asserted-by":"publisher","DOI":"10.1109\/CIST.2016.7804961"},{"key":"IJISMD.2019010104-16","doi-asserted-by":"publisher","DOI":"10.1016\/j.jksuci.2011.05.005"},{"key":"IJISMD.2019010104-17","doi-asserted-by":"publisher","DOI":"10.1016\/j.procs.2015.04.164"},{"key":"IJISMD.2019010104-18","unstructured":"ISO. (2003). IEC 19761 software engineering-cosmic-ffp-a functional size measurement method. International Organization for Standardization_ISO."},{"key":"IJISMD.2019010104-19","unstructured":"ITSEC. (1991). Crit\u00e8res d'\u00e9valuation de la s\u00e9curit\u00e9 des syst\u00e8mes informatiques, v1.2. Office des publications officielles des Communaut\u00e9s Europ\u00e9ennes, Luxembourg."},{"key":"IJISMD.2019010104-20","doi-asserted-by":"crossref","unstructured":"Kassab, M., Daneva, M., & Ormandjieva, O. (2007). Early quantitative assessment of non-functional requirements.","DOI":"10.1109\/EUROMICRO.2007.53"},{"key":"IJISMD.2019010104-21","doi-asserted-by":"publisher","DOI":"10.4018\/978-1-5225-5634-3.ch001"},{"key":"IJISMD.2019010104-22","author":"R.Kimball","year":"2000","journal-title":"Le DATA WEBHOUSE: Analyser les comportements client sur leWeb"},{"issue":"6","key":"IJISMD.2019010104-23","article-title":"Modeling Extraction Transformation Load Embedding Privacy Preservation using UML.","volume":"50","author":"P.Kiran","year":"2012","journal-title":"International Journal of Computers and Applications"},{"issue":"6","key":"IJISMD.2019010104-24","article-title":"Data warehouse security issue.","volume":"7","author":"S.Kumar","year":"2016","journal-title":"International Journal of Advanced Research in Computer Science"},{"issue":"45","key":"IJISMD.2019010104-25","first-page":"96","article-title":"Web-enabled data warehouse and data webhouse.","volume":"1","author":"A.Mehedintu","year":"2008","journal-title":"Revista Informatica Economica"},{"key":"IJISMD.2019010104-26","unstructured":"Mell, P., Scarfone, K., & Romanosky, S. (2007, June). A complete guide to the common vulnerability scoring system version 2.0. FIRST-Forum of Incident Response and Security Teams (Vol. 1, p. 23)."},{"key":"IJISMD.2019010104-27","unstructured":"Mrunalini, M., Geetha, D. E., Kumar, T. S., & Kanth, K. R. (2008). Modeling of Secure Transformation, Cleaning and Loading in ETL Processes using UML 2.0. Advances in Computer Vision and Information Technology, 79."},{"key":"IJISMD.2019010104-28","doi-asserted-by":"crossref","unstructured":"Mrunalini, M., Geetha, D. E., Suresh Kumar, T. V., & Kanth, K. R. (2007, October). Modeling of secure data extraction in ETL processes using UML 2.0. In Proceedings of the IASTED Asian Conference on National Vulnerability Database (NVD). Retrieved from https:\/\/www.nist.gov\/programs-projects\/national-vulnerability-database-nvd","DOI":"10.14429\/dbit.26.3.3690"},{"key":"IJISMD.2019010104-29","doi-asserted-by":"publisher","DOI":"10.1016\/j.dss.2011.01.018"},{"key":"IJISMD.2019010104-30","article-title":"View security as the basis for data warehouse security.","author":"A.Rosenthal","year":"2000"},{"issue":"6","key":"IJISMD.2019010104-31","first-page":"2245","article-title":"Private and Secure Hyperlink Navigability Assessment in Web Mining Information System.","volume":"3","author":"K.Sharma","year":"2011","journal-title":"International Journal on Computer Science and Engineering"},{"issue":"4","key":"IJISMD.2019010104-32","article-title":"Analyses of Algorithms and Complexity for Secure Association Rule Mining of Distributed Level Hierarchy in Web.","volume":"2","author":"G.Shrivastava","year":"2011","journal-title":"International Journal of Advanced Research in Computer Science"},{"issue":"6","key":"IJISMD.2019010104-33","first-page":"2240","article-title":"Secure Association Rule Mining for Distributed Level Hierarchy in Web.","volume":"3","author":"G.Shrivastava","year":"2011","journal-title":"International Journal on Computer Science and Engineering"},{"key":"IJISMD.2019010104-34","doi-asserted-by":"crossref","unstructured":"Soler, E., Stefanov, V., Mazon, J. N., Trujillo, J., Fernandez-Madina, E., & Piattini, M. (2008, March). Towards comprehensive requirement analysis for data warehouses: Considering security requirements. In Third International Conference on Availability, Reliability and Security ARES 08. (pp. 104-111). IEEE.","DOI":"10.1109\/ARES.2008.86"},{"key":"IJISMD.2019010104-35","doi-asserted-by":"publisher","DOI":"10.1016\/j.csi.2008.03.002"},{"issue":"3","key":"IJISMD.2019010104-36","first-page":"22","article-title":"Scenario-based black box testing in COSMIC-FFP: A case study.","volume":"8","author":"M. A.Talib","year":"2006","journal-title":"Software Quality Professional"},{"key":"IJISMD.2019010104-37","unstructured":"Tarnes, M. (2012). Information Security Metrics: An Empirical Study of Current Practice. In Specialization Project, Trondheim."},{"key":"IJISMD.2019010104-38","doi-asserted-by":"crossref","first-page":"9","DOI":"10.1007\/978-3-319-10160-6_2","article-title":"Quality measures for ETL processes.","author":"V.Theodorou","year":"2014","journal-title":"International Conference on Data Warehousing and Knowledge Discovery"},{"key":"IJISMD.2019010104-39","unstructured":"Triki, S. (2013). S\u00e9curisation des entrep\u00f4ts de donn\u00e9es: de la conception \u00e0 l\u2019exploitation [Doctoral dissertation]. Lyon 2."},{"key":"IJISMD.2019010104-40","doi-asserted-by":"publisher","DOI":"10.1145\/1754239.1754251"},{"issue":"1","key":"IJISMD.2019010104-41","first-page":"31","article-title":"A UML 2.0\/OCL extension for designing secure data warehouses.","volume":"38","author":"R.Villarroel","year":"2006","journal-title":"Journal of Research and Practice in Information Technology"},{"key":"IJISMD.2019010104-42","doi-asserted-by":"publisher","DOI":"10.1109\/ISRE.1997.566873"}],"container-title":["International Journal of Information System Modeling and Design"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.igi-global.com\/viewtitle.aspx?TitleId=226236","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,5,5]],"date-time":"2022-05-05T16:20:24Z","timestamp":1651767624000},"score":1,"resource":{"primary":{"URL":"http:\/\/services.igi-global.com\/resolvedoi\/resolve.aspx?doi=10.4018\/IJISMD.2019010104"}},"subtitle":[""],"short-title":[],"issued":{"date-parts":[[2019,1]]},"references-count":43,"journal-issue":{"issue":"1"},"URL":"https:\/\/doi.org\/10.4018\/ijismd.2019010104","relation":{},"ISSN":["1947-8186","1947-8194"],"issn-type":[{"value":"1947-8186","type":"print"},{"value":"1947-8194","type":"electronic"}],"subject":[],"published":{"date-parts":[[2019,1]]}}}