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

Submit your paper
Know more
Reseach Article

Automated Data Validation for Data Migration Security

by Manjunath T. N, Ravindra S. Hegadi, Mohan H S
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 30 - Number 6
Year of Publication: 2011
Authors: Manjunath T. N, Ravindra S. Hegadi, Mohan H S
10.5120/3642-5088

Manjunath T. N, Ravindra S. Hegadi, Mohan H S . Automated Data Validation for Data Migration Security. International Journal of Computer Applications. 30, 6 ( September 2011), 41-46. DOI=10.5120/3642-5088

@article{ 10.5120/3642-5088,
author = { Manjunath T. N, Ravindra S. Hegadi, Mohan H S },
title = { Automated Data Validation for Data Migration Security },
journal = { International Journal of Computer Applications },
issue_date = { September 2011 },
volume = { 30 },
number = { 6 },
month = { September },
year = { 2011 },
issn = { 0975-8887 },
pages = { 41-46 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume30/number6/3642-5088/ },
doi = { 10.5120/3642-5088 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T20:16:20.486048+05:30
%A Manjunath T. N
%A Ravindra S. Hegadi
%A Mohan H S
%T Automated Data Validation for Data Migration Security
%J International Journal of Computer Applications
%@ 0975-8887
%V 30
%N 6
%P 41-46
%D 2011
%I Foundation of Computer Science (FCS), NY, USA
Abstract

In the present information age, with the invent of new packages and programming languages, there is need of migrating the data from one platform to another as versions are changing, to perform quality assurance of any migrated data is tedious task which require more work force, time and quality checks. To perform efficient data migration process, legacy data should be mapped to new system by considering extraction and loading entities. The new system should handle all the data formats, the good design of data migration process should take minimal time for extraction and more time for loading. Post loading into new system results in verification and validation of data accurately, by comparing with the benchmark values and derive accuracy of data migration process. The manual data validation and verification process is time consuming and not accurate so automated data validation improve data quality in less time, cost and attaining good data quality, Author’s emphasis on Automation of Data migration process for quality and security across industries.

References
  1. English, L. P. (1999). Improving Data Warehouse and Business Information Quality: Methods for Reducing Costs and Increasing Profits, John Wiley and Sons, Inc.Data Quality Issues, Page 10.
  2. Fields, K. T., Sami, H. and Sumners, G. E. (1986). Quantification of the auditor’s evaluation of internal control in data base systems. The Journal of Information Systems, 1(1), pp. 24-77.
  3. Firth, C. (1996). Data quality in practice: experience from the frontline, Paper presented to the Conference of Information Quality, 25-26 Oct.
  4. White paper by Vivek R Gupta, Senior consultant, System Services Corporation, “An Introduction to Data Warehousing”.
  5. Potts, William J. E., (1997), Data Mining Using SAS Enterprise Miner Software. Cary, North Carolina: SAS Institute Inc.
  6. SAS Institute Inc., (1998), SAS Institute White Paper, From Data to Business Advantage: Data Mining, the SEMMA Methodology and the SAS® System, Cary, NC: SAS Institute Inc.
  7. Microsoft® CRM Data Migration Framework White Paper by Parul Manek, Program Manager Published: April 2003.
  8. Jaiwei Han, Michelinne Kamber, "Data Mining: Concepts and Techniques."
  9. DATA MIGRATION BEST PRACTICES NetApp Global Services January 2006.
  10. DATA Quality in health Care Data warehouse Environments Robert L.Leitheiser, University of Wisconsin –Whitepaper
  11. Badri, M. A., Davis, Donald and Davis, Donna (1995). A study of measuring the critical factors of quality management. International Journal of Quality and Reliability Management, 12(2), pp. 36-53.
  12. Larry P. English. Improving Data Warehouse and business Information Quality. Wiley & Sons, New York, 1999.
  13. Miles, M. B. & Huberman, A. M. (1994). Qualitative Data Analysis - A Source Book of New Methods, Sage Publications, Thousand Oaks.
  14. Ravikumar G K,Dr.Justus rabi, Manjunath T.N, Ravindra S Hegadi,”Design of Data Masking Architecture and Analysis of Data Masking Techniques for Testing -IJEST11-03-06-217- Vol. 3 No. 6 June 2011 p.5150-5159
  15. Ravikumar G K, Manjunath T N, Ravindra S Hegadi, Umesh I M “A Survey on Recent Trends, Process and Development in Data Masking for Testing"-IJCSI- Vol. 8, Issue 2, March 2011-p-535-544.
  16. Manjunath T.N, Ravindra S Hegadi, Ravikumar G K."A Survey on Multimedia Data Mining and Its Relevance Today" IJCSNS. Vol. 10 No. 11-Nov 2010, pp. 165-170.
  17. Manjunath T.N, Ravindra S Hegadi, Ravikumar G K."Analysis of Data Quality Aspects in Datawarehouse Systems", (IJCSIT)-Jan-2011.
Index Terms

Computer Science
Information Sciences

Keywords

Data migration Verification ETL Mapping Parsing DV (data Validation)