Call for Paper - April 2023 Edition
IJCA solicits original research papers for the April 2023 Edition. Last date of manuscript submission is March 20, 2023. Read More

Migration from Proprietary to Open Source Database for eHealth Domain

International Journal of Computer Applications
© 2014 by IJCA Journal
Volume 87 - Number 16
Year of Publication: 2014
Shail Dubey
Kumari Nita
Sujeet Kumar

Shail Dubey, Kumari Nita and Sujeet Kumar. Article: Migration from Proprietary to Open Source Database for eHealth Domain. International Journal of Computer Applications 87(16):36-40, February 2014. Full text available. BibTeX

	author = {Shail Dubey and Kumari Nita and Sujeet Kumar},
	title = {Article: Migration from Proprietary to Open Source Database for eHealth Domain},
	journal = {International Journal of Computer Applications},
	year = {2014},
	volume = {87},
	number = {16},
	pages = {36-40},
	month = {February},
	note = {Full text available}


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.


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