Database Design: Information Retrieval and Analytics

How does understanding the database design assist with information retrieval and analytics?

Database design is a crucial aspect of working with databases (DBs), which refers to a complex of procedures aimed at creating a structure that will be used to store and manage end-user data. If the end-user realizes the DB structure, it enables him or her to access and process information efficiently. The three central benefits are as follows (Kimelfeld, 2014):

  • Understanding the DB design helps to identify the rules that can be applied to information extraction (IE). Different DB designs call for various means of IE rules, as NoSQL DBs require more complicated manipulations rather than logically designed DBs.
  • Awareness of the DB structure helps to realize the type of stored data, its attributes, and relationships between the entities. It saves time the end-user could waste on searching for the data or attributes that are not kept in the database or trying to perform actions that are not predefined by design.
  • Realization of database characteristics allows choosing the effective means of working with it. For instance, if the end-user realizes that the DB is massive and requires a good PC or a stable internet connection, he or she will not waste time trying to access the database with an old laptop using mobile internet.

Reference

Kimelfeld, B. (2014). Database principles in information extraction. Web.