MITS4003: Database Systems, Data Mining, and Data Analysis Report

This report provides an overview of database systems, data mining, and data analysis. It begins by defining a database as an interconnected collection of data managed in a centralized location for easy retrieval, and a database management system (DBMS) as the software used to manage this data. The report emphasizes the DBMS's role in resolving data redundancy and inconsistency. Data mining is described as the process of extracting useful data from existing data sets, enabling informed decision-making, while data analysis involves inspecting, cleaning, transforming, and modeling data to uncover valuable insights. Key points highlighted include the DBMS's resolution of data access issues and the need for security and proper backup and recovery. The conclusion reinforces the importance of DBMS for gathering, storing, and providing easy access to information, as well as facilitating data analysis to enhance business trend understanding. The report references several academic papers supporting the concepts discussed.

Database, data
mining and
data analysis

Database Systems
 Database is a collection of inter related
data that is managed at a single location
so that it can easily be retrieved.
 Database management system is a
software that is used o manage the data
(Van Aken, Pavlo, Gordon and Zhang,
2017) .
 It resolves the issue of data redundancy
and data inconsistency.

Data Mining
It is a practise of extracting the
useful data from already existing
threat. It is process of capturing
knowledge from large data set that
can be future used for making
decisions (chen, han and yu, 2019)
.

Data Analysis
It is a process of inspecting,
cleaning, transforming and
modelling the adapt so that useful
information could be discovered for
making supporting decisions
(Arulraj and Pavlo, 2017)
.

Key Points
 Database management system resolved
the issue of data access.
 It increases the chances of unauthorised
access if security parameters are not
taken accordingly.
 Proper backup and recovery is
maintained so that information is not
lost at time of failure.

Conclusion
It can be concluded that database
management system is used for gathering
information and soring the data at a
single place. It offers easy access of
information and also offer ways through
which information could be analysed and
understanding about the business trends
could be enhanced.

References
 Arulraj, J. and Pavlo, A., 2017, May. How to build a non-
volatile memory database management system.
In Proceedings of the 2017 ACM International Conference
on Management of Data (pp. 1753-1758). ACM
 chen, M., han, j. and yu, p. (2019). [online] Nyu.edu.
Available at:
http://www.nyu.edu/classes/jcf/g22.3033-002/handouts/che
n96data.pdf [Accessed 22 Jan. 2019].
 Van Aken, D., Pavlo, A., Gordon, G.J. and Zhang, B., 2017,
May. Automatic database management system tuning
through large-scale machine learning. In Proceedings of the
2017 ACM International Conference on Management of
Data (pp. 1009-1024). ACM.