Paper Title
Converting And Configuration Of A Calibrating Software From Ms-Access To Oracle

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. General Terms— Query languages, Heterogeneous database, data warehousing client/server, spatial databases. Keywords— Database conversion, migration, RDBMS, cross-platform environment, database.

Author - Vanessa Jose, Sneha Sunil Sharma, K. P. Moholkar

Published : Volume-3,Issue-6  ( Jun, 2016 )

	|		PDF	|	Viewed - 51	|	Published on 2016-07-12