Platform as a Service - Amazon Redshift

Platform as a Service (PaaS) - Amazon Redshift
Student’s name
Institution Affiliation(s)

Platform as a Service - Amazon Redshift
PaaS is a cloud computing models in which cloud computing providers (third party)
provides both software and hardware application services tools needed for application
development to individual users and organizations over the internet. PaaS cloud providers host
the both software and hardware on their own infrastructure. As a result, PaaS users do not have
to install their own software and hardware components for them to run any new applications.
Amazon Redshift, RDS and DynamoDB are AWS PaaS products that have been
developed to make it less onerous for clients to manage both commercial SQL and NoSQL
database types. Clients are able to offload routing database maintenance to the PaaS subsystems
layer.
Business/Commercial applications suited for Amazon Redshift.
Amazon Redshift can help an individual or an organization migrate their data from most
of the commonly used open source and commercial databases. Amazon Redshift supports both
homogeneous data migration for instance from Amazon Redshift to Amazon Redshift or from
Oracle to Oracle and heterogeneous data migrations such as from Amazon Redshift to Oracle or
moves data between one relational database and another (Narasimhan, 2018). Amazon Redshift
can also move data between NoSQL, text-based targets and SQL.
Considerations when migrating your database from legacy to the Redshift scheme.
When carrying out heterogeneous database migration, the source database and the target
database are different, for instance from Oracle to Amazon Redshift. In these case,
considerations of the structure of the schema, data types, and database code have to be put in
place because they are different for the two databases (Ellison, Calinescu, & Paige, 2018). Thus,
when doing heterogeneous database migration, you will need the AWS Schema Conversion Tool