Review & Opinion Search Engine (Rose)

• Main Author: Teo, Yong Sieng.
• Other Authors: Chang Kuiyu
• Format: Final Year Project
• Language: English
• Published: 2011
• Subjects: DRNTU::Engineering::Computer science and engineering
• Online Access: http://hdl.handle.net/10356/45153
• Institution: Nanyang Technological University

The purpose of this report is to allow me to share my experience on designing, developing and implementing the migration process for partial data migration of ROSE application from a relational database management system, PostgreSQL to a schema-less NoSQL class of DBMS, Cassandra. This report discussed the problem encountered in the application prompting the need to explore other solutions, and explore the different method to efficiently perform the migration and ensure data synchronization during and after the data migration.The main focus will be on understanding the data model of Cassandra or NoSQL class of databases, the different methods in exporting and importing data from one database to another, in a time and cost efficient method. Various problems encountered will also be discussed with recommendation or alternative approaches to avoid these issues.