Limitations of the Relational Database Model

Written by rachelle reese
  • Share
  • Tweet
  • Share
  • Pin
  • Email
Limitations of the Relational Database Model
Rows and columns are the building blocks of a relational database. (deep in database image by .shock from Fotolia.com)

The relational database model defines a method of structuring data into related tables. Each entity is represented by a table. Each column represents an attribute of the entity. Each instance of an entity is represented by a row. This structure makes it easy to update and retrieve information. However, relational databases are not appropriate for storing all types of data or for every data retrieval situation. The relational database model has significant limitations for some data storage and retrieval scenarios.

Other People Are Reading

Limited Scalability

As the amount of data processed by an application grows, the increasing volume puts a strain on the relational database infrastructure. Normalisation can help reduce the amount of redundant data stored, but highly normalised data requires many joins during data retrieval, so data is often denormalized to enhance data retrieval performance.

Poor Support for Unstructured Data

The relational database model requires that a structure be imposed on data. Some data is unstructured and does not map well to a set of related tables.

Not Suited to Analytics

The relational model is flat, or two-dimensional. Some analytic scenarios require multidimensional structures, such as online analytical processing (OLAP) cubes.

Difficult Upkeep

Efficient relational database storage requires ongoing maintenance. Indexes must be created and maintained as requirements change. Sometimes data must be restructured to meet changing business requirements.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.