MITS4003 - Database Systems: Fundamentals, Design & Embedded Impact

This report provides an introduction to the fundamentals of database systems and their impact on embedded systems, focusing on database models, middleware, and the design of file systems. It discusses the importance of database management systems (DBMS) in managing data efficiently, reducing redundancy, and ensuring data security. The report explores various database models, including the Perst database system and the use of Structured Query Language (SQL), highlighting the differences between procedural and non-procedural query languages. It also examines the integration of database systems with embedded languages like C and C++, the role of database design in organizing data, and the importance of selecting the right embedded database to support system requirements. The conclusion emphasizes the applicability of database models within embedded systems and the ability to design basic database systems using the discussed principles.

Running head: AN INTRODUCTION TO THE FUNDAMENTALS OF DATABASE
SYSTEMS
An Introduction to the Fundamentals of Database Systems
Demystifying Embedded Systems Middleware
Author Name: Tammy Noergaard
Name of the Student
Student ID

1AN INTRODUCTION TO THE FUNDAMENTALS OF DATABASE SYSTEMS
1. Introduction
The primary purpose of the report is based on the discussion of the topic based on the
fundamentals of database systems and also discusses about the impacts made by a database
system within any embedded system. The selected article have been chosen based on discussing
about the introduction of the fundamental concepts of database within any computerized system
(Elmasri and Navathe 2016). The article focuses on the various kinds of database models that
would be in relation with the database middleware. The discussion based on the selected article
is based on conducting a study and research on the database systems that help in the underlying
of file systems. The chosen article is based on researching on the various fundamental
applications of database systems in the modern world. The review on this article would also help
in understanding of fundamental concepts that would be helpful in the design of a database
system.
2. Discussion
A database system, which is also known as a Database Management System (DBMS) is
generally referred as a database system that would be used for managing of data within any kind
of embedded computerized system. A centralized database system forms an integral part in the
management of data within an organisation (Coronel and Morris 2016). They are also used
reliably for efficiently managing the data. A database system could be easily accessible by the
user of the embedded system based on the help of other form of middleware software. The
different kind of application used within the system help in the designing of the structure of the
file storage of the organisation. A database is also used for the management of access to the
similar data that would be used within the file system. There is a particular form of design of
database that would not be able to eliminate the redundancy of data (Hababeh, Khalil and
Khreishah 2015). Based on the research on the article under review, it has been seen that the
designs of the DBMS would be mostly implemented within the file system.
Further review on the article helps in understanding that the database system comprises
of two form of major components. These include the overlying middleware or application
software and database. These would be used for the management of access to the centralized
Name of the Student student
id 1

2AN INTRODUCTION TO THE FUNDAMENTALS OF DATABASE SYSTEMS
database. The bases help in managing of data based on allowing of the organisation, storing and
managing of interrelated data. They also help in querying of data with the help of a query based
language (Diallo et al. 2015). They also provide the generating of vast amount of reports that
would be based on the analysis of data. Thus, the use of database systems would also underlie
the integrity of data, reduce data redundancy and ensure the security of data. This article has
further put contrast over a variety of data that would be typically be stored within the file system.
This would also simply put the data that would be interrelated (Telnarova and Rombová 2015).
The article discusses that a database system should comprise of an efficient mode of ‘data
modelling’ scheme that would be able to create different components based on storing of data,
processing of data and location of data.
In this article, the research has also been focused on providing examples about the
common form of real-world language that is mainly used within the database systems. The
language used for performing of queries within the database tables is Structured Query Language
(SQL). The SQL is defined as the computer database language, which is mainly used for the
creation, maintaining and co trolling the internal structures of the database (Ong,
Papakonstantinou and Vernoux 2014). The SQL also comprises of DDL, DCL and DML
elements. The article also focuses on a particular form of database system that is known as the
Perst database system, which primarily makes use of procedural query language. This would be
based on deriving the SQL standard that is known as JSQL (Kolonko 2018). The discussion
about the impact of database systems also provide information on the database query languages
that would be either considered as procedural or non-procedural. This article also provides a
detailed analysis of each of the supported languages within the SQL systems.
A thorough observation over the article helps in forming a certain view about the
different kind of operations that are performed within the procedural query language. The
supported examples would help in forming a view about the different situations in which these
queries would be supported (Dalton, Dietz and Allan 2014). These different operations are
mostly used for performing different queries within the database systems. The method of
observation of the functioning of different queries is mainly supported by providing examples of
real-life situation analysis. Based on the performance analysis of the queries, some information is
Name of the Student student
id 2

3AN INTRODUCTION TO THE FUNDAMENTALS OF DATABASE SYSTEMS
also been provided that supports the view. From the analysis gathered with the use of SQL
queries in real-world situation, it has been discussed that SQL is primarily interpreted during
run-time. The primary plan of execution is determined with the help of SQL optimizer of the
database system. Thus, it results in increasing of difficulty level for embedded programmers
based on the understanding of the working of a database system (Wang, Cheung and Bodik
2017). These queries are mostly been run during the processing of SQL statements with the
embedded languages supported by C or C++.
The article also provides a real-life example of SQL query based on the data provided
within a table. The article puts focus on the fact about how the SQL queries would be linked with
programmable interface. This would thus result in enabling of faster storage of data within the
embedded systems of various kind of functionalities (Chan et al. 2014). It has also been
discussed in the article that in some of the database systems, the queries would mainly be
implemented within an existing DML, which could be further expanded for providing an object-
oriented support. On the other hand, the database solutions would put an impact on the queries
with the help of an application programming interface (API) that could be further used within an
OOP language such as C# or Java.
Another topic of major discussion that has been put under major focus is the fact about
the importance of different database models for a middleware developer. It also focuses on the
importance of a particular database design that would be able to determine about the ways in
which the database would logically organize data, define different constraints over the data and
support the different inter-relationships (Zhao et al. 2014). The different database models that
follow the object-oriented approach would be able to support the needs of complex object graphs
that would be found within social networking and different engineering functions. The
discussion on this article supports the fact that with an embedded solution of database based on
integration of overlying applications and code of data management, it would be possible for
better performance of systems. It would also include the decreasing amount of memory required
and the reduced CPU cycles based on processing and management of huge volumes of data.
The article also puts light on the fundamental practices of database design by discussing
about the steps that would be needed for the design of a particular form of database. Based on
Name of the Student student
id 3

4AN INTRODUCTION TO THE FUNDAMENTALS OF DATABASE SYSTEMS
building of such kind of database system, a real-world database model is also discussed. The
authors have also put major focus on the ways of utilizing different embedded databases in
designing real-world databases and the application layer (Medeiros et al. 2017). With the effect
from different forms of middleware, the selection of proper form of embedded database that
would be able to support the system requirements would be defined. This would further ensure
the successful implementation of the database that would support the underlying platform.
3. Conclusion
Based on the discussion on the selected article, it could be concluded that the different
database design schemas could be implemented within the database system. The article discusses
about the impact of database systems within the design of a file system. The choice of the proper
database design should be appropriate for the proper designing of an embedded device. This
would also be required for understanding the impact of such a database on the particular device.
The article further explains the fundamental components that would help in the design of a
database system. The article helps in the introduction of the basic concepts in relation to the
design of database systems. Based on the discussion provided in the article, an individual would
be able to apply the fundamental principles for the purpose of analysing different designs within
the database. Some of the discussed features offered by the database design are also discussed
within the article, which would further enhance the knowledge of applicability of database
models within any embedded system. Thus, with the gained knowledge from this article, the
developer of any system would be able to design a basic idea of embedding the database systems
for their use in various systems. They would also be able to list the different hardware and
software requirements with the aid of middleware components based on the implementation of a
database system.
Name of the Student student
id 4

5AN INTRODUCTION TO THE FUNDAMENTALS OF DATABASE SYSTEMS
References
Chan, E.S., Gawlick, D., Ghoneimy, A. and Liu, Z.H., 2014, October. Situation aware computing
for big data. In Big Data (Big Data), 2014 IEEE International Conference on (pp. 1-6). IEEE.
Coronel, C. and Morris, S., 2016. Database systems: design, implementation, & management.
Cengage Learning.
Dalton, J., Dietz, L. and Allan, J., 2014, July. Entity query feature expansion using knowledge
base links. In Proceedings of the 37th international ACM SIGIR conference on Research &
development in information retrieval (pp. 365-374). ACM.
Diallo, O., Rodrigues, J.J., Sene, M. and Lloret, J., 2015. Distributed database management
techniques for wireless sensor networks. IEEE Transactions on Parallel and Distributed
Systems, 26(2), pp.604-620.
Elmasri, R. and Navathe, S., 2016. Fundamentals of database systems. London: Pearson.
Hababeh, I., Khalil, I. and Khreishah, A., 2015. Designing high performance web-based
computing services to promote telemedicine database management system. IEEE transactions on
services computing, 8(1), pp.47-64.
Kolonko, K., 2018. Performance comparison of the most popular relational and non-relational
database management systems.
Medeiros, J., Vasconcelos, A., Goulão, M., Silva, C. and Araújo, J., 2017, April. An approach
based on design practices to specify requirements in agile projects. In Proceedings of the
Symposium on Applied Computing (pp. 1114-1121). ACM.
Ong, K.W., Papakonstantinou, Y. and Vernoux, R., 2014. The SQL++ query language:
Configurable, unifying and semi-structured. arXiv preprint arXiv:1405.3631.
Telnarova, Z. and Rombová, Z., 2015, March. Data modelling and ontological semantics. In AIP
Conference Proceedings(Vol. 1648, No. 1, p. 550008). AIP Publishing.
Name of the Student student
id 5

6AN INTRODUCTION TO THE FUNDAMENTALS OF DATABASE SYSTEMS
Wang, C., Cheung, A. and Bodik, R., 2017, June. Synthesizing highly expressive sql queries
from input-output examples. In ACM SIGPLAN Notices (Vol. 52, No. 6, pp. 452-466). ACM.
Zhao, G., Lin, Q., Li, L. and Li, Z., 2014, November. Schema conversion model of SQL
database to NoSQL. In P2P, Parallel, Grid, Cloud and Internet Computing (3PGCIC), 2014
Ninth International Conference on (pp. 355-362). IEEE.
Name of the Student student
id 6