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.
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.