Body of Report
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.
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 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.
Conclusion
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 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 manage
ment, 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 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.
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.
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.
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
