Fundamentals of database

Heterogeneous Databases

According to Elmasri and Navathe (2015), these are more advanced databases that are set up to create an interrelation between database modules. The purpose of this communication is to ensure that information is swapped while queries are also being answered. It is important to note that it is possible to have objects in one module differing from objects in another module of the same database (Elmasri & Navathe, 2015). This implies that with heterogeneous databases, it is possible to store different types of data in a single module but with a relationship. Further, heterogeneous databases combine a set of other advanced databases.

Figure 3: Illustration of how heterogeneous databases work (Kumar & Dwivedu, 2015).

Pros and Cons of Advanced Databases

There are many benefits that are associated with advanced databases. Similarly, there are many disadvantages that are associated with the same.

Pros of Advanced Databases

The first advantage of advanced databases is that they have improved shareability and local autonomy of the information (Thakur, 2017). Due to the fact that data can be shared across a range of users, it has facilitated collaboration among individuals. Although people can collaborate, it is possible to maintain the local autonomy whereby data is stored close to the person working on it. However, a global database administrator ensures that the system is operational and effective (Thakur, 2017).

Secondly, advanced databases have facilitated availability since they do not depend on a single centralized database (Yan & Ma, 2011). In the case of the latter, the failure of the central repository implies that the database is not available for the rest of the users. With these advanced databases, failure of a single node does not mean an overall failure. Instead, it implies that all the other nodes can continue reinforcing the failed node until the problem is rectified.

Thirdly, with the advanced databases, there is better and improved performance (Yan & Ma, 2011). Advanced databases have better performance owing to the fact that one can perform more than one function in the database. Other than storing, manipulating, and accessing the information, it is possible to mine data and determine indirect patterns that are directly visible from the look of the eye (Yan & Ma, 2011).

Cons of Advanced Databases

First, relative to the simple relational databases, advanced databases are complex on nature (Conway, 2017). This implies that understanding them and their functionality might require an advanced level of expertise. The built-in replication of databases and the algorithms on which database modules are implemented raises the level of complexity. This implies that a single module’s failure would lead to effects on the availability of the database, performance, and even reliability of the same.

Secondly, there are huge costs that are associated with advanced databases. The requirement of their implementation over a cloud environment implies that additional hardware, software, and expertise are required (Conway, 2017). These requirements imply that the entity applying it must incur some additional costs. These costs may result in serious financial challenges in an organization considering that they may not have been foreseen (Conway, 2017).

Thirdly, advanced databases face a severe challenge of databases security (Kumar & Dwivedu, 2015). Database security entails protection of information in the database against unauthorized access. Due to the implementation of different standards across different modules, securing advanced databases becomes a daunting task (Kumar & Dwivedu, 2015). Further, with the rising complexity and differing standards on which the databases are implemented, securing these databases remains a serious challenge. Due to the possibility of feeding information and accessing information from different modules, a breach of one module’s security might result in an entire database’s security breach.

In summation, it is evident from the discussion above that advanced databases have changed the status quo. The manner in which operations in the databases were carried out is different from the manner in which they are being carried out. One functionality that is exceptional with the advanced databases is the data mining functionality which it brings with it many benefits with regards to future predictions. Although the advanced databases have many advantages, there are many challenges that they are facing although if proper mechanisms are put in place, better results can be achieved.

References Conway, M. (2017). Learn filemaker pro 16: The comprehensive guide to building custom databases. Lewisburg: Apress. Elmasri, R., & Navathe, S. (2015). Fundamentals of database systems. Miami: Pearson Education. Kumar, K., & Dwivedu, A. (2015). An analysis of different types of advanced databases based on basic factors. International Journal on Recent and Innovation Trends in Computing, 2-6. Thakur, D. (2017, Jul 04). Advantages and disadvantages of advanced distributed database systems. Retrieved from Yan, L., & Ma, Z. (2011). Advancaed database query systems: Techniques, applications and technologies. New York: IGI global.