Review & Opinion Search Engine (Rose)
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 discus...
Saved in:
| Main Author: | |
|---|---|
| Other Authors: | |
| Format: | Final Year Project |
| Language: | English |
| Published: |
2011
|
| Subjects: | |
| Online Access: | http://hdl.handle.net/10356/45153 |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| Institution: | Nanyang Technological University |
| Language: | English |
| Summary: | 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. |
|---|