COMP5349 | Cloud Computing | Implementation of the Web Database
Task
Overview of the business case:
Bruce is a volunteer football (soccer) coach at XYZ United. At this stage, to announce training sessions, Bruce sends an SMS to his players. While this system works for him, it does not help him with getting accurate numbers of those who are coming to training sessions, especially when there are last minute changes. To address this problem he decided to implement a web database system. Accordingly, he hired you to design a relational database to better track and record the operational data.
NOTE: The overview of the business case is included here to provide context only. For the purpose of identifying entities, attributes and relationships between entities please read the business rules and instructions for creating your ERD below.
NOTE: For guidance on how to draw an ERD based on business rules,
watch this YouTube video:
https://www.youtube.com/watch?v=YvJ4t9_2SWk
The business rules and instructions for creating your ERD:
Each player is expected to attend all 20 training sessions. For each training session to go ahead,
six or more players must register to attend it. Every training session is identified by a training session ID. The date, time and venue are also kept in the system for each training session. Each player is identified by a player ID. For each player, the player’s name, DOB and playing position are recorded in the system. An important training session’s detail is that the system also takes note of the players who attended each training session and the rating of the performance that each player gives at the end of each training session.
Create an ERD that represents the entities, attributes, the relationships between entities, and the cardinality and optionality of each relationship that are described by this business rule.
Answer:
Introduction:
The increase in the usage of cloud computing in recent years has made the cloud database a common phenomenon in new and innovative technology implementation (Costa et al., 2015). It has become so popular that people without having proper knowledge about the benefits it can deliver to their organization, select cloud environment for their database deployment.
After researching about cloud database implementation it has been identified that database as a service, scope breakdown of database implementation in cloud and process of implementation is crucial to describe. No specific cloud database management system has been focused on this research article.
Database as a Service:
The database management system or DBMS considered as an integral aspect of various programs. In organizations particular relational database management system deployed in cloud environment is hugely used.
- The cloud databases are comparatively simple and in-built models makes it possible to model various types of programs freely (Balalaie, Heydarnoori & Jamshidi, 2016)
- The database as a service is consistent in performance and it can deal with simultaneous workloads. The database as a service is very effective in data syncing
- Better performance, high throughput and low latency has been achieved in cloud database after continuous research and development in database as a service domain (Barker et al., 2014)
- The cloud database are highly reliable because of persistence of data through maintaining data safety at occurrence of various failures
The manual method for administration of database is not feasible for database cloud-computing as it is consisted of thousands of servers that have data centres incorporated within those. The database as a service of Google, Microsoft and Amazon compute hundred and thousands of nodes. These nodes can be used by numerous applications for achieving unparalleled economics-of-sales (Rai, Mehfuz & Sahoo, 2018). These three organizations are constantly improving their Database as a Service so that scalability, load distribution and elasticity can be achieved in terms of self-management or layer autonomic.
Scope Breakdown Structure:
The breakdown structure, a project management tool, is utilized by all the organizations for organizing the deliverables of the project (Balalaie, Heydarnoori & Jamshidi, 2016). These deliverable are managed in hierarchical way through breakdown structure. The scope of Migrating Database to cloud are as following.
- Leveraging and testing cloud database
- Generating the concept proof
- Providing support to the organization and managing cloud
- Executing technical plans
- Data migration process execution
- Generating documents
- Providing training to users and administrators
- Optimizing and monitoring the database
- Switch over operation to the cloud
Process of Migration:
The selection of homo or heterogeneous migration is the first task for database migration to cloud. The feasibility analysis and benefits of both the migration must be done. A list will be created based on the finding. The organization will evaluate the size of the database to determine hardware support required. The application will then tested before the migration process starts. The organization will decide which databases are mission critical and select only those data for migration to cloud (Zhao & Zhou, 2014). The Service Level Agreement will be developed after that. The service level agreement will be created by making sure that down times are not interfering with the business requirements. Then organization will communicate with the service provider to make the database scalable as per business need. For this part proper business analysis is to be done to identify the areas where scalability is mostly required. It has to be remembered that scalability is related to hardware support.
The database migration is not a simple and easy task. There will be various challenges that organization and service provider have to face. The first challenge is security. The organization must not consider public cloud as an option as these domains are highly vulnerable (Vodomin & Androcec, 2015). Another challenge is the performance of the application that will be dependent on the database. Not all the application parts are compatible to cloud as data in cloud will be transmitted to not only LAN or remote networks after the database is migrated.
Conclusion:
The research article concludes that database in cloud must be secured properly. A security check should be created based on organization need, cloud domain and best practices. The database migration is based on the database size and complexity. The applications that will use the database also determines the cloud database architecture and scalability.
References:
Balalaie, A., Heydarnoori, A., & Jamshidi, P. (2016). Microservices architecture enables devops: Migration to a cloud-native architecture. IEEE Software, 33(3), 42-52.
Barker, S. K., Chi, Y., Hacigümüs, H., Shenoy, P. J., & Cecchet, E. (2014, June). ShuttleDB: Database-Aware Elasticity in the Cloud. In ICAC (pp. 33-43).
Costa, C. H., Maia, P. H., Mendonça, N. C., & Rocha, L. S. (2015, September). Supporting partial database migration to the cloud using non-intrusive software adaptations: an experience report. In European Conference on Service-Oriented and Cloud Computing (pp. 238-248). Springer, Cham.
Rai, R., Mehfuz, S., & Sahoo, G. (2018). Efficient migration of application to clouds: analysis and comparison. GSTF Journal on Computing (JoC), 3(3).
Vodomin, G., & Androcec, D. (2015). Problems during Database Migration to the Cloud. In Central European Conference on Information and Intelligent Systems (p. 11). Faculty of Organization and Informatics Varazdin.
Zhao, J. F., & Zhou, J. T. (2014). Strategies and methods for cloud migration. International Journal of Automation and Computing, 11(2), 143-152.
Buy COMP5349 | Cloud Computing | Implementation of the Web Database Answers Online
Talk to our expert to get the help with COMP5349 | Cloud Computing | Implementation of the Web Database Answers to complete your assessment on time and boost your grades now
The main aim/motive of the management assignment help services is to get connect with a greater number of students, and effectively help, and support them in getting completing their assignments the students also get find this a wonderful opportunity where they could effectively learn more about their topics, as the experts also have the best team members with them in which all the members effectively support each other to get complete their diploma assignments. They complete the assessments of the students in an appropriate manner and deliver them back to the students before the due date of the assignment so that the students could timely submit this, and can score higher marks. The experts of the assignment help services at urgenthomework.com are so much skilled, capable, talented, and experienced in their field of programming homework help writing assignments, so, for this, they can effectively write the best economics assignment help services.