Powered by OpenAIRE graph
Found an issue? Give us feedback
image/svg+xml art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos Open Access logo, converted into svg, designed by PLoS. This version with transparent background. http://commons.wikimedia.org/wiki/File:Open_Access_logo_PLoS_white.svg art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos http://www.plos.org/ Engineer Journal of ...arrow_drop_down
image/svg+xml art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos Open Access logo, converted into svg, designed by PLoS. This version with transparent background. http://commons.wikimedia.org/wiki/File:Open_Access_logo_PLoS_white.svg art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos http://www.plos.org/
image/svg+xml art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos Open Access logo, converted into svg, designed by PLoS. This version with transparent background. http://commons.wikimedia.org/wiki/File:Open_Access_logo_PLoS_white.svg art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos http://www.plos.org/
versions View all 1 versions
addClaim

Evaluation and Selection of Tools for Data Migration from Non-Spatial to Spatially Referenced Software – A Case Study Migration from MySQL to PostgreSQL

Authors: E. A. G. Chandramali; N. T. S. Wijesekera;

Evaluation and Selection of Tools for Data Migration from Non-Spatial to Spatially Referenced Software – A Case Study Migration from MySQL to PostgreSQL

Abstract

Geographic Information Systems and open source software are becoming more and more popular resulting in an increased requirement for data migration from common non spatial software to spatially referenced software. MySQL is a very popular open source Database Management System used by most web developers but without support for spatial referencing. PostgreSQL is an open source software that supports Geographic Information Systems. It is often necessary to migrate data from MySQL to PostgreSQL and it is possible to identify many tools that are capable of executing the desired task. Therefore best available tool should be selected to ensure that the selected tool satisfies the main functionalities expected of the software and capabilities of performing the tasks with user friendly features. This paper describes a systematic methodology adopted to select the best free tool for data migration from MySQL to PostgreSQL using literature and rational judgement incorporating a qualitative ranking system to Migrate the base data. For easy comparison, an Evaluation Score of Tool was defined by calculating the percentage of available functionality when compared with the user desires for satisfaction. After comparing three available tools, Postgres Plus 8.3 free software was identified as the best with a Evaluation Score of Tool value of 76%. The present work identified 3 main and 11 sub database functions together with 4 main and 13 sub components of Graphical User Interface functionality as important parameters for data migration.

Related Organizations
  • BIP!
    Impact byBIP!
    selected citations
    These citations are derived from selected sources.
    This is an alternative to the "Influence" indicator, which also reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
    0
    popularity
    This indicator reflects the "current" impact/attention (the "hype") of an article in the research community at large, based on the underlying citation network.
    Average
    influence
    This indicator reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
    Average
    impulse
    This indicator reflects the initial momentum of an article directly after its publication, based on the underlying citation network.
    Average
Powered by OpenAIRE graph
Found an issue? Give us feedback
selected citations
These citations are derived from selected sources.
This is an alternative to the "Influence" indicator, which also reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
BIP!Citations provided by BIP!
popularity
This indicator reflects the "current" impact/attention (the "hype") of an article in the research community at large, based on the underlying citation network.
BIP!Popularity provided by BIP!
influence
This indicator reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
BIP!Influence provided by BIP!
impulse
This indicator reflects the initial momentum of an article directly after its publication, based on the underlying citation network.
BIP!Impulse provided by BIP!
0
Average
Average
Average
gold