Database and Web Server Solution for AdventureWorks with Accompanying Deployment Documentation
SHANNON WETNIGHT
SVAD 111
OCTOBER 3, 2024

Executive Summary

#

The AdventureWorks project focuses on designing and deploying a cloud-based data management solution, including a web application, using Amazon Web Services (AWS) to drive the company’s operational efficiency and scalability. Amazon Web Services is a comprehensive cloud computing platform that offers a wide range of services, including computing power, storage, and databases, to help businesses and developers build and scale applications on-demand. The core objective is to migrate the AdventureWorks database to the cloud, utilizing AWS’s infrastructure to improve data accessibility, streamline reporting, and significantly enhance overall system performance. By moving to the cloud, the company can reduce dependence on the currently in-use legacy systems and adapt more easily to growing data demands, as well as improve the customer experience for finding products.

From a business perspective, the transition to AWS offers numerous advantages. One key benefit is the reduction in on-premises IT costs, eliminating the need for maintaining expensive hardware and physical infrastructure. Moreover, cloud services offer a pay-as-you-go model, allowing for better cost management and financial flexibility. The project aims to improve system reliability by leveraging AWS’s high availability zones and disaster recovery solutions, which will ensure continuous service uptime and minimal disruptions. These services are built-in to the proposed solution and will not require any additional context or hands-on to be provided during the utilization of the AWS service.

In addition to operational improvements, the project also seeks to enhance customer experience by providing a detailed, searchable database of AdventureWorks’ current products. This feature will allow customers and AdventureWorks employees to easily search for product information, resulting in more efficient sales and support processes. The modernization of AdventureWorks’ infrastructure through AWS services with Amazon’s EC2 will not only reduce upfront capital investments but also open opportunities for future scalability as the company grows. The project will import the current database already in-use and convert it through a series of implantation steps to provide an online platform for managing the system moving forward.

Upon successful implementation, this cloud-hosted solution will support both business intelligence and day-to-day operational needs. Improved security protocols, built-in data backup, and high levels of encryption will ensure that sensitive customer and business data remain secure. This will further reduce operational risks while providing AdventureWorks with a more agile, responsive infrastructure.

While the project offers significant benefits, there are potential associated risks that should be responsibly mentioned. These include potential budget overruns due to variable AWS costs, as well as technical challenges encountered during data migration. To mitigate these risks, the implementation will be conducted in phases, with each phase undergoing thorough testing before moving to the next stage. Regular communication with stakeholders and contingency planning will also help address any unforeseen issues that arise during the project lifecycle.

The overall timeline for the project is estimated to be no more than (1) month. Throughout this period, the project team will maintain open communication with management to ensure alignment with business goals. The long-term return on investment is anticipated to be substantial, with savings in IT resource costs, improved processing speeds, and enhanced reporting capabilities driving value well into the future. This project seeks to see completion in (2) phases, with a long-term support contract and IT hand-off at the end of the project.