Database Management Report: Web Database System for Football Coaching

This report addresses the need for a web database system to improve the management of training sessions for a football club, XYZ United. The current system of sending SMS messages is inefficient for tracking attendance and managing last-minute changes. The report explores the application of modern database technologies, including in-memory databases and automated servers, to enhance data storage and retrieval. The use of cloud servers, platform-as-a-service (PaaS), and their advantages, such as reduced costs and improved data security, are discussed. The report also highlights the security features of modern databases, such as data backup and protection against hacking. The aim is to design a relational database that records operational data, including player details, training session information (ID, date, time, and venue), and player attendance with performance ratings, to effectively manage the training sessions and player data. The report concludes by emphasizing how modern database systems can streamline data management for the coach, enabling efficient tracking of player information and communication.

Running head: DATABASE MANAGEMENT
Database Management
Name of the student
Name of the University
Author Note

1DATABASE MANAGEMENT
Modern Database Systems
The database technology is one of the most important technologies that has been
developed and is used in almost every purpose of data storage. In the recent times there have
been a number of changes and updates that is made in the database technology (Pappas et al.,
2014). These new technologies help in the process of easy management of the databases over
the cloud or in local systems. One of the major progresses that can help the process of the
database management is the In-memory Database Systems.
The In-memory Databases have reduced the financial inputs of analysing huge
amount of the data in an accelerated rate. In this case the need of the In-memory database can
help a coach in accessing the number of players attending training (Fisch et al., 2015). This
process automatically collects the data form the present players and stores the record of the
players’ attendance. Hence, this can help Bruce in identifying the data about players present
in a specific data set without any chances of errors.
Also these are cloud enabled systems that can store the information in real time.
Hence, there is a reduced need of any manual adjustments, thus ensuring data security. One
of the other major technologies that could help Bruce with the process of web-based database
management is the automated use of servers. This process can help Bruce in controlling data
of the athletes in a better way by using the both the databases in a manual way as well as in
an autonomous way (Mariotti et al., 2017). With the help of this technology, an automated
text is sent to the athlete and the athlete is asked for immediate responses in either YES or
NO. Depending on the response of the player, the information of his or her availability is
stored in the servers. This can help Bruce to know whether the player will be available or not
and make plans accordingly.

2DATABASE MANAGEMENT
Thus these new techniques can provide help for the process for better management of
database servers. Further, one of other major things that can be used is the databases, the
cloud servers, or the using the Platform-as-a-Service or PaaS. Implementing this process is
very much simple, only the thing that is needed to be done is buying of the cloud as servers.
The first step is to property define the project, that is to ensure what are the needs of the
project. The second and the most important step is to ensure that platform is to be used. The
third step is to migrate the databases to the cloud server. There are many advantages of using
these servers like, the non-requirement of high-end computer systems, eventually reducing
the prices for the same (Zaman et al., 2017). The needs of storage systems are very much less
as all the data are stored in cloud. This also reduces the cost of buying the servers. Apart from
the advantages, there are also some of the major disadvantages in using the cloud servers.
One of the major disadvantages for this system can be that the main computer is always in
need to be put online to automatically update the data.
Security Features
The modern databases are very much secured; the data protection level has increased
in a signigficat amount in the last few years. The cloud servers can provide some of the best
and most advanced security options to Bruce. One of the major security features include the
data being always backed up hence preventing any data loss (Haynes et al., 2018). Once the
data is updated, it can simultaneously be backed up. Another major feature includes the
servers not being easily susceptible to hacking and hence, there is no any need to back the
data up manually. Other than this all the data is the responsibility of the server providers and
thus, there is no process of the data management (Zhang et al., 2017). It can be said that the
use of the modern databases can help Bruce in a very clear manner. Utilizing this system,
Bruce can easily store the information about the athletes that are present in the training. The

3DATABASE MANAGEMENT
search for the players by their numbers or their date of births is made easy. Bruce can also
send SMS to the players in an urgent basis using the web servers.

4DATABASE MANAGEMENT
References
Pappas, V., Krell, F., Vo, B., Kolesnikov, V., Malkin, T., Choi, S. G., ...&Bellovin, S. (2014,
May). Blind seer: A scalable private dbms. In Security and Privacy (SP), 2014 IEEE
Symposium on (pp. 359-374). IEEE.
Fisch, B. A., Vo, B., Krell, F., Kumarasubramanian, A., Kolesnikov, V., Malkin, T.,
&Bellovin, S. M. (2015, May). Malicious-client security in blind seer: a scalable
private DBMS. In Security and Privacy (SP), 2015 IEEE Symposium on (pp. 395-
410). IEEE.
Mariotti, M., Gervasi, O., Vella, F., Cuzzocrea, A., &Costantini, A. (2017). Strategies and
systems towards grids and clouds integration: a DBMS-based solution. Future
Generation ComputerSystems.
Zaman, F., Raza, B., Malik, A. K., &Anjum, A. (2017). Self-Protection against Insider
Threats in DBMS through Policies Implementation. Self, 8(3).
Haynes, B., Mazumdar, A., Alaghi, A., Balazinska, M., Ceze, L., & Cheung, A. (2018).
LightDB: a DBMS for virtual reality video. Proceedings of the VLDB Endowment,
11(10), 1192-1205.
Zhang, Y., Ordonez, C., &Johnsson, L. (2017, August). A cloud system for machine learning
exploiting a parallel array DBMS. In Database and Expert Systems Applications
(DEXA), 2017 28th International Workshop on (pp. 22-26). IEEE.