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

Submit your paper
Know more
The week's pick
Responsive image
Enhancing Privacy Preservation: Multi-Attribute Protection with P-Sensitive K-Anonymity

Twinkle Patel Kiran Amin
Random Articles
Reseach Article

Migration from Proprietary to Open Source Database for eHealth Domain

by Shail Dubey, Kumari Nita, Sujeet Kumar
journal cover thumbnail

International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 87 - Number 16
Year of Publication: 2014
Authors: Shail Dubey, Kumari Nita, Sujeet Kumar
10.5120/15295-3990

Shail Dubey, Kumari Nita, Sujeet Kumar . Migration from Proprietary to Open Source Database for eHealth Domain. International Journal of Computer Applications. 87, 16 ( February 2014), 36-40. DOI=10.5120/15295-3990

@article{ 10.5120/15295-3990,
author = { Shail Dubey, Kumari Nita, Sujeet Kumar },
title = { Migration from Proprietary to Open Source Database for eHealth Domain },
journal = { International Journal of Computer Applications },
issue_date = { February 2014 },
volume = { 87 },
number = { 16 },
month = { February },
year = { 2014 },
issn = { 0975-8887 },
pages = { 36-40 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume87/number16/15295-3990/ },
doi = { 10.5120/15295-3990 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T22:06:07.141515+05:30
%A Shail Dubey
%A Kumari Nita
%A Sujeet Kumar
%T Migration from Proprietary to Open Source Database for eHealth Domain
%J International Journal of Computer Applications
%@ 0975-8887
%V 87
%N 16
%P 36-40
%D 2014
%I Foundation of Computer Science (FCS), NY, USA
Abstract

Due to the varying economic climate, organizations running Oracle are struggling to meet rising information demands with constricted budgets. Postgres significantly reduces total cost of database ownership, without sacrificing performance and scalability by eliminating up-front perpetual license fees. Why migrate at all? Either the current system has some functional flaws or its cost/benefit ratio does not appeal anymore to its owner. Three arguments are put forward in support of migrating to Open Source database management systems: Lowering Total Cost of Ownership (TCO), special features, and Open Source code. C-DAC's Hospital Management Information System "e-Sushrut" is a complete ERP solution for Hospitals or a chain of Hospitals. Commonly used technology in e-Sushrut is J2EE and proprietary database Oracle as backend. Organization has to pay certain amount to get license of oracle. Day by Day demand of health care services increase and it is not possible for all client to afford the cost of oracle's license. So by migration of database from Oracle to Postgres an effort is made to reduce database license cost as Postgres Community Edition is available free of cost.

References
  1. Drawater 2006, PostgreSQL 8. 1 for J2EE/JDBC applications v1. 0-http://www. holindis. co. uk/
  2. Oracle 9i documentation- http://download-east. oracle. com/otndoc/oracle9i/901_doc/nav/docindex. htm
  3. Gurjeet Singh 2011, Oracle to Postgres Migration- http://www. pgcon. org/2011/schedule/attachments/205_Oracle_to_Postgres_Migration. pdf
  4. PostgreSQL documentation- http://www. postgresql. org/idocs/
  5. Oracle to Postgre Conversion- http://openacs. org/doc/openacs/html/oracle-to-pg-porting. html
  6. PostgreSQL JDBC 2. 0 compliance- http://lab. applinet. nl/postgresql-jdbc/
  7. An important source of information is the PostgreSQL mailing lists-http://archives. postgresql. org/
  8. Web Commerce Group 2002. A Web Commerce Group Case Study on PostgreSQL. -http://www. postgresql. org/files/about/casestudies/wcgcasestudyonpostgresqlv1. 2. pdf
  9. Understanding open source CRM-http://www. allindoc. com/story. php?title=crm-open-source-ID949
Index Terms

Computer Science
Information Sciences

Keywords

Migration HIMS (Hospital Management Information System) e-Sushrut Postgres (open source community edition) Electronic Medical Record

Powered by PhDFocusTM