Advanced

Databasmigration från SQL Server till Amazon Redshift

Lindgren, Viktor (2017)
Computer Science and Engineering (BSc)
Abstract
Growing databases create a need for improved storage and analysis solutions. One company with that need is Bring SCM, who have been looking for a solution to better analyze their business data, which is currently hosted on a SQL Server-database by Elastic Mobile. To improve this solution, this paper will examine a data warehouse solution to the problem, specifically using the cloud-based Amazon Redshift data warehouse. Additionally, Amazon’s Database Migration Service will be examined as an alternative to the current migration solution. For Database Migration Service, both the migration of the full database as well as the continuous data replication are tested. Redshift is tested based on performance for eight SQL statements that Bring SCM... (More)
Growing databases create a need for improved storage and analysis solutions. One company with that need is Bring SCM, who have been looking for a solution to better analyze their business data, which is currently hosted on a SQL Server-database by Elastic Mobile. To improve this solution, this paper will examine a data warehouse solution to the problem, specifically using the cloud-based Amazon Redshift data warehouse. Additionally, Amazon’s Database Migration Service will be examined as an alternative to the current migration solution. For Database Migration Service, both the migration of the full database as well as the continuous data replication are tested. Redshift is tested based on performance for eight SQL statements that Bring SCM currently use in their work. This is performed both on a storage-optimized cluster and a computation-optimized one. Finally, the costs of running the different clusters are used to evaluate the cost-effectiveness of the solutions. Database Migration Service showed great potential compared to the current migration solution, and the storage-optimized Redshift-cluster gave both good performance and cost-efficiency. The computation-optimized cluster performed worse than expected, especially in relation to the cost. Redshift and Database Migration Service are very promising alternatives to the current SQL Server-solution for analysis purposes, but when implementing such a system, consideration should be taken regarding optimizing the data structure for data warehouse use. (Less)
Please use this url to cite or link to this publication:
author
Lindgren, Viktor
organization
year
type
M2 - Bachelor Degree
subject
keywords
redshift, databas, databasmigration, datalager, it-moln, big data, data warehouse
language
Swedish
id
8917780
date added to LUP
2017-06-21 04:09:48
date last changed
2018-10-18 10:36:08
@misc{8917780,
  abstract     = {Growing databases create a need for improved storage and analysis solutions. One company with that need is Bring SCM, who have been looking for a solution to better analyze their business data, which is currently hosted on a SQL Server-database by Elastic Mobile. To improve this solution, this paper will examine a data warehouse solution to the problem, specifically using the cloud-based Amazon Redshift data warehouse. Additionally, Amazon’s Database Migration Service will be examined as an alternative to the current migration solution. For Database Migration Service, both the migration of the full database as well as the continuous data replication are tested. Redshift is tested based on performance for eight SQL statements that Bring SCM currently use in their work. This is performed both on a storage-optimized cluster and a computation-optimized one. Finally, the costs of running the different clusters are used to evaluate the cost-effectiveness of the solutions. Database Migration Service showed great potential compared to the current migration solution, and the storage-optimized Redshift-cluster gave both good performance and cost-efficiency. The computation-optimized cluster performed worse than expected, especially in relation to the cost. Redshift and Database Migration Service are very promising alternatives to the current SQL Server-solution for analysis purposes, but when implementing such a system, consideration should be taken regarding optimizing the data structure for data warehouse use.},
  author       = {Lindgren, Viktor},
  keyword      = {redshift,databas,databasmigration,datalager,it-moln,big data,data warehouse},
  language     = {swe},
  note         = {Student Paper},
  title        = {Databasmigration från SQL Server till Amazon Redshift},
  year         = {2017},
}