to ensure the requirements of the warehouse area and what the purpose of this data warehouse will be. Afterward, the physical storage configuration will come. It involves all setting up servers and systems. Then choose the data warehouse model through which the data will be stored. It helps to decide the schema of the data collection. Next comes the transfer process from the previous storage method to the data warehouse. Then the front end is designed to interact with the system [ CITATION Mar195 \l 1033 ].
DATABASE 16 References Beaulieu, A. (2005). Learning SQL. Concord: O'Reilly. Boyer, J. (2018, September 12). THE AWS SHARED RESPONSIBILITY MODEL: 3 AREAS OF IMPROVEMENT TO MAKE TODAY, PART 1 . Retrieved from Hackerone: - Shared-Responsibility-Model-3-Areas-Improvement-Make-Today-Part-1-Keep-Your-Private-Keys Brewer, W. (2017, June 20). Database Code Analysis . Retrieved from Redgate Hub: - gate.com/simple-talk/sql/database-devops-sql/database-code-analysis/ Bulacan State University. (2019). Uses, Advantages & Disadvantages of Database, Guides, Projects, Research for Database Management Systems (DBMS). docsity. Greengard, S. (2019, June 20). 10 Top Data Quality Tools . Retrieved from Datamation: Keary, T. (2020, May 5). 14 Best Database Monitoring Tools . Retrieved from Comparitech: Kriegel, A., Taylor, A., Trukhnov, B., Gillenson, M., & Ponniah, P. (August 2008). Introduction to database management. India: Wiley. Microsoft Docs. (2019, September 12). Create a Full Database Backup . Retrieved from Microsoft. docs: - database-backup-sql-server?view=sql-server-ver15 Ott, M. (2015, December 1). A Ten-Step Plan for an Effective Data Governance Structure . Retrieved from The Data Administration Newsletter: - governance-structure/19183 Smallcombe, M. (2019, August 2). The Ultimate Guide to Data Warehouse Design . Retrieved from xplenty: Software Testing Help. (2020, April 16). Database Testing Complete Guide (Why, What, And How To Test Data) . Retrieved from Software Testing Help: - testing-process/ Swersky, D. (2018, May 31). The SDLC: 7 phases, popular models, benefits & more . Retrieved from Raygun:
- Fall '19
- administrator, Relational database management system