CFP last date
22 April 2024
Reseach Article

Converting and Configuration a Calibrating Software from Ms-Access to Oracle

Published on May 2016 by Vanessa Jose, Sneha Sunil Sharma
National Conference on Advancements in Computer & Information Technology
Foundation of Computer Science USA
NCACIT2016 - Number 2
May 2016
Authors: Vanessa Jose, Sneha Sunil Sharma
3269ba31-0932-4912-88d2-3a9931184cbd

Vanessa Jose, Sneha Sunil Sharma . Converting and Configuration a Calibrating Software from Ms-Access to Oracle. National Conference on Advancements in Computer & Information Technology. NCACIT2016, 2 (May 2016), 20-21.

@article{
author = { Vanessa Jose, Sneha Sunil Sharma },
title = { Converting and Configuration a Calibrating Software from Ms-Access to Oracle },
journal = { National Conference on Advancements in Computer & Information Technology },
issue_date = { May 2016 },
volume = { NCACIT2016 },
number = { 2 },
month = { May },
year = { 2016 },
issn = 0975-8887,
pages = { 20-21 },
numpages = 2,
url = { /proceedings/ncacit2016/number2/24707-3043/ },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Proceeding Article
%1 National Conference on Advancements in Computer & Information Technology
%A Vanessa Jose
%A Sneha Sunil Sharma
%T Converting and Configuration a Calibrating Software from Ms-Access to Oracle
%J National Conference on Advancements in Computer & Information Technology
%@ 0975-8887
%V NCACIT2016
%N 2
%P 20-21
%D 2016
%I International Journal of Computer Applications
Abstract

Nowadays information is becoming an increasingly valuable corporate asset, the demand for a right tool which can store, manage, and move this information is in high demand. A cross-platform environment has the concept of a heterogeneous database system where different sites may use different ways of storing and representing the data, file formats, query language, access protocols etc. Conversion of database and migration refers to the process of moving data from one database to another without having to manually rewriting all existing applications. Database transformation is rather straight forward, assuming the database is used just as storage. It "only" requires moving the data from one database to another. However, even this may be a difficult task. The main issues one may encounter include: Unmatched data types (number, date, sub-records) and different character sets (encoding). The most challenging aspect for organizations occurs during conversion of large databases, which easily consumes more terabytes of data. This paper provides a solution in which the relational database is converted and configured from one database to another without any loss of information and development of application in a three tier architecture to convert and configure a calibrating software. Here, every site can have different Relational Database Management Systems (RDBMSs) like Oracle, MySQL, DB2, MS Access etc.

References
  1. Lixian Xing, Yanhong Li, "Design and application of Data Migration system in heterogeneous database" in 2010 International Forum on Information Technology and applications.
  2. Shinde Anita Vitthal, Thite Vaishali Baban, Roshni Warade, Krupali Chaudhari, "Data Migration System in Heterogeneous Database" in 2013 International Engineering and Science and innovative technology
  3. Chang-Yang Lin Eastern Kentucky University, "Migrating to Relational Systems: Problems, Methods, and Strategies" in Contemporary Management Research Pages 369-380, Vol. 4, No. 4, December 2008
  4. Pvnss Krishna Murthy, Surabhi Agarwal, Tulsi Garbyal, and Pavan Chakrobarty, "Secure Migration of Tables across Different Database Management Systems over a Cross-Platform Environment" in International Journal of information and Electronics Engineering, Vol 2, No. , May 2012
  5. Shashikant Patel, Sagar Wakchaure, Mahendra Pingale, Saba Siraj, "Data Migration System in Heterogeneous Database" in Internation Journal of Research in Engineering and Technology.
  6. Jiahong Wang, Segawa, N. Miyazaki, M, "On-line data migration approaches and their performance comparison" in IEEE Software and Information Science, 0-7803-7080-5/01, 2001.
  7. Chadi Kari, Yoo-Ah Kim, Alexander Russell, "Data Migration In Heterogeneous Storage System", IEEE International conference on Distributed Computing Systems, DOI 10. 1109/ICDCS, 2011.
Index Terms

Computer Science
Information Sciences

Keywords

Database Conversion Migration Rdbms Cross-platform Environment Database.