CFP last date
20 January 2025
Call for Paper
February Edition
IJCA solicits high quality original research papers for the upcoming February edition of the journal. The last date of research paper submission is 20 January 2025

Submit your paper
Know more
The week's pick
Responsive image
SFLA-Based Line Balancing and Task Optimization in Master-Slave Controlled Hanger Transportation Systems for Garment Production

Duc Hoang Nguyen
Random Articles
Reseach Article

Modeling Extraction Transformation Load Embedding Privacy Preservation using UML

by Kiran P, S Sathish Kumar, Kavya N P
journal cover thumbnail

International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 50 - Number 6
Year of Publication: 2012
Authors: Kiran P, S Sathish Kumar, Kavya N P
10.5120/7772-0854

Kiran P, S Sathish Kumar, Kavya N P . Modeling Extraction Transformation Load Embedding Privacy Preservation using UML. International Journal of Computer Applications. 50, 6 ( July 2012), 1-5. DOI=10.5120/7772-0854

@article{ 10.5120/7772-0854,
author = { Kiran P, S Sathish Kumar, Kavya N P },
title = { Modeling Extraction Transformation Load Embedding Privacy Preservation using UML },
journal = { International Journal of Computer Applications },
issue_date = { July 2012 },
volume = { 50 },
number = { 6 },
month = { July },
year = { 2012 },
issn = { 0975-8887 },
pages = { 1-5 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume50/number6/7772-0854/ },
doi = { 10.5120/7772-0854 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T20:47:34.870762+05:30
%A Kiran P
%A S Sathish Kumar
%A Kavya N P
%T Modeling Extraction Transformation Load Embedding Privacy Preservation using UML
%J International Journal of Computer Applications
%@ 0975-8887
%V 50
%N 6
%P 1-5
%D 2012
%I Foundation of Computer Science (FCS), NY, USA
Abstract

Extraction Transformation Load plays an important phase in development of data warehouse due its complexity of selecting data from different location and having different structures. The recent industry of data warehouse is driven by Privacy Preserving Data Mining which ensures privacy of sensitive information during Mining and is a requirement of most Data Bases. Current approaches to modelling extraction transformation load do not include privacy representation in Conceptual Modelling. This paper proposes object-oriented approach to model Extraction Transformation Load embedding privacy preservation. The major components of extraction include Data Source, Source Identifier, Retrieval, Join, Privacy Preserving Area and Data Staging Area. All the above mentioned components have been modelled using Unified Modelling Language.

References
  1. Fang Ying-lan and Han Bing, Design and Implementation of ETL Management Tool, In proc. of International Symposium on Knowledge Acquisition and Modeling, pp 446-449, 2009.
  2. Xudong Song, Xiaolan Yan and Liguo Yang,Design ETL Metamodel based on UML Profile, In proc. of Second International Symposium on Knowledge Acquisition and Modeling, pp 69-72,2009.
  3. Lunan Li, A Framework Study of ETL Processes Optimization Based on Metadata Repository, In proc of Computer Engineering and Technology (ICCET), pp 125-129, 2010.
  4. Darshan M. Tank, Amit Ganatra and Y P Kosta, Speeding ETL Processing in Data Warehouses Using High-Performance Joins For Changed Data Capture (CDC), In proc. of International Conference on Advances in Recent Technologies in Communication and Computing, 2010
  5. L. Muñoz, J. N. Mazón and J. Trujillo, ETL Process Modeling Conceptual for Data Warehouses: A Systematic Mapping Study, IEEE Latin America Transactions, vol. 9, no. 3, june 2011.
  6. Alkis Simitsis, Panos Vassiliadis, and Timos Sellis, State-Space Optimization of ETL Workflows, IEEE Transactions On Knowledge and Data Engineering, vol. 17, no. 10, october 2005.
  7. Alkis Simitsis, Chetan Gupta, Song Wang and Umeshwar Daya, Partitioning Real-Time ETL Workflows, In Proceedings of ICDE Workshops, pp 159-162, 2010.
  8. M. Mrunalini, T. V. Suresh Kumar, D. Evangelin Geetha and K. Rajanikanth, Modelling of Data Extraction in ETL Processes Using UML 2. 0, DESIDOC Bulletin of Information Technology, Vol. 2, pp. 3-9, 2006.
  9. M Mrunalini, T V Suresh Kumar and K Rajani Kanth, Simulating Secure Data Extraction in Extraction Transformation Loading (ETL) Processes, In proc. Of Third UKSim European Symposium on Computer Modeling and Simulation,2009.
  10. G. Aggarwal, T. Feder, K. Kenthapadi, R. Motwani, R. Panigrahy, D. Thomas, and A. Zhu. Anonymizing tables. In Proc. of the 10th Int'l Conference on Database Theory, January 2005.
  11. R. Bayardo and R. Agrawal. Data privacy through optimal k-anonymity. In Proc. of the 21st Int'l Conference on Data Engineering, April 2005.
  12. K. Lefevre, D. J. Dewitt, R. Ramakrishna, Incognito: Efficient fulldomain k-anonymity, In Proc. of the 24th ACM SIGMOD International Conference on Managemant of Data, pp. 4960, Baltimore, Maryland, USA, 2005
  13. P. Samarati and L. Sweeney. Generalizing data to pro¬vide anonymity when disclosing information. In Proc. of the 17th ACM SIGMOD-SIGACT-SIGART Sympo¬sium on the Principles of Database Systems, 188, 1998.
Index Terms

Computer Science
Information Sciences

Keywords

Privacy Preserving Data Mining ETL Data Stage Area Privacy Preserving Area Data Warehouse

Powered by PhDFocusTM