Disadvantages of Anomalies in Relational Model
- Redundancy: When the same data is stored in various locations, a relational architecture may cause data redundancy. This can result in inefficiencies and even inconsistent data.
- Complexity: Establishing and keeping up a relational database calls for specific knowledge and abilities and can be difficult and time-consuming.
- Performance: Because more tables must be joined in order to access information, performance may degrade as a database gets larger.
- Incapacity to manage unstructured data: Text documents, videos, and other forms of semi-structured or unstructured data are not well-suited for the relational paradigm.
Anomalies in Relational Model
Anomalies in the relational model refer to inconsistencies or errors that can arise when working with relational databases, specifically in the context of data insertion, deletion, and modification. There are different types of anomalies that can occur in referencing and referenced relations which can be discussed as:
These anomalies can be categorized into three types:
- Insertion Anomalies
- Deletion Anomalies
- Update Anomalies.