Application of Data Architecture Model

Running head: DATABASE SYSTEMS
Database systems
Name of the Student
Name of the University
Author Note

DATABASE SYSTEMS
1
Introduction
Enterprise Database Management Systems (EDMS) is defined as the type of system
which is very much useful to manage huge datasets of commercial establishments (Liu, Zhou
& Chen, 2018). The queries coming from the multiple users can be addressed with the help of
this system as well. There are diverse categories of EDMS which are deployed in our society
such as MS SQL, Post Grey SQL, and Oracle Database, apart from these three major EDMSs
there are other EDMSs as well which play a huge role in the growth and development of
commercial organization by protecting the integrity of the larger datasets such as Mongo DB,
IBM Simple DB. The annual rental of these EDMS is very much affordable for most of the
users of this system as data is being considered as an asset in most of the major commercial
establishments these days. The role of the Database Administrator (DBA) is very much
crucial to work with any type of EDMS as there are numerous challenges associated with
EDMS as well such as the faster retrieving of the data in adverse business situations.
Mobile databases are defined as the type of database which are very much flexible as
compared to the functionalities of EDMS (Foss, 2018). This database can be easily
transported to other locations apart from its host location. Sharing and exchanging of data is
much easier due to the help coming from EDMS. One of the prime specifications of the
mobile database is that it allows the users to store and manage data while the users of the data
are on the move, as there is a communication link between the mobile database and the main
database.
The notable determination of this individual essay is to evaluate the effectiveness of
major EDMSs, which helps in managing huge data sets. Critical evaluation of mobile
databases based on data management and security shall also be conducted in this essay.

DATABASE SYSTEMS
2
Categories of functions in EDMS
There are diverse categories of functions which are related to the EDMS such as data
dictionary, database communication interfaces, data storage management, data
transformation, security management, multi-user access control, data integrity management,
and database access languages (Macyna & Kukowski, 2019). Each of these functions is very
much useful for the effective function of EDMS.
Data Dictionary
Data elements and their relationships ate stored in the data dictionary, as a result, it is
one of the most significant functions of EDMS (Nuessle & Kennedy, 2019). The data
components and the structure of the data can be analysed from the data dictionary, at the
same time this function is also very much useful to manage ay type of changes in the
structure of the database.
Data storage management
Reporting of the data is conducted from this function of EDMS, this function is also
very much responsible for validating the data which are stored in EDMS (Bittner, 2017). The
procedural code of EDMS can be verified in the first place with the help of this function as
well. The orientation of the different type of data which are stored in the EDMS can be
identified by the DBA from this function as well.
Data transformation
The raw data which are provided to the EDMS is converted to data structures using
this function (Lu & Holubová, 2017). The function is also very much useful to distinguish the
physical data and the logical data, as the categorization of the data is one of the prime