You are required to conduct research on how you will implement the web database

Question

You are required to conduct research on how you will implement the web database in a cloud instance (for business case below). Your research should be based on recent developments in the field of database technology. Your response should address not only the implementation considerations but also the security issues. Length: 700 words

_____________________________________________________________________________________________________________________________________________________

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.

Explanation / Answer

Analysis:

After analysing the Business Case, We can assume a strategy to implement the web database in a cloud.
For Example:
Bruce is a volunteer football (soccer) coach at XYZ United. 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.

5 steps to implement the web database in a cloud:

Design the application as a collection of services:
Cloud applications are best deployed as a collection of cloud services, or APIs. You build up from the data to the services and then combine those services into composite services or complete composite applications.Additional benefits may include service reuse from other applications or more coarse-grained services. You can separate the application services physically, executing on the proper machine instances, and service/API managers and governance technology that provide services directories can help track the many services that make up your application.
Example:
Creating and Launching a MySQL DB Instance

Decouple the data:

Example:
Independence of each request is the basis for unlimited scalability.

Consider communications between application components:
Focus on designing applications that optimize communications between application components. For example, combine communications into a single stream of data or a group of messages, rather than constantly communicating as if the application components reside on a single platform.
Example:
Application->DB->cloud

Model and design for performance and scaling:

Example:

Amazon Aurora is a MySQL and PostgreSQL-compatible relational database engine that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases.

Make security systemic within the application:

Example:
Enable Enhanced Monitoring,Backup,etc..

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.