Why study the design of an RDBMS?

This is an article that I will call a “bridge” between the introduction of the series about the operation of a Relational Database Management System (RDBMS) based on PostgreSQL. After reading the book “Physical Database Design: the database professiona…

This is an article that I will call a “bridge” between the introduction of the series about the operation of a Relational Database Management System (RDBMS) based on PostgreSQL. After reading the book “Physical Database Design: the database professional’s guide to exploiting indexes, views, storage, and more” by Lightstone, Teorey, and Nadeau (2010), I found it relevant to write about why understanding database design is very important.

In a brief summary of what the authors bring as motivation, the volume of data in the world tends to grow exponentially. As the volume of data increases, so does the demand for more robust data structures to securely store data and return queries faster and faster.

According to Andre (2023), the amount of data created daily on the internet is 1.134 trillion MB. Lately, this increase has been mainly due to the popularization of social media and streaming services. If in 2010 we were talking about petabytes, Figure 1 presents the estimate of data consumption in zettabytes since 2021, which is expected to double by 2024.

Estimated data consumption from 2021 to 2024.
Figure 1 – Estimated data consumption from 2021 to 2024. Adapted from Andre (2023).

In addition, new technologies are continuously emerging to help make sense of this data. For example, Bitnine Global Inc. has Apache AGE to provide graph data analysis for relational databases. G-FDS is a graph-based solution for fraud detection, and G-PAS focuses on predictive analysis for Big Data. There are other products and more new developments on the horizon! Therefore, understanding the foundation and needs of database structures is essential to deliver quality solutions. In the next post, I will discuss the life cycle of an RDBMS and explain the architecture of PostgreSQL in practice.

Errata

My intention is to provide access to technology information through reliable sources. If you have found any incorrect information, please contact me at carlasanches@live.com.

Related Articles

References

Lightstone, Sam S., Toby J. Teorey, and Tom Nadeau. Physical Database Design: the database professional’s guide to exploiting indexes, views, storage, and more. Morgan Kaufmann, 2010.

Andre, Louie. 53 Important Statistics About How Much Data Is Created Every Day. Finances Online. 2023. Available at https://financesonline.com/how-much-data-is-created-every-day/. Acessed on 03/15/2023.

Contribute to Apache AGE

Apache AGE website: https://age.apache.org/

Apache AGE Github: https://github.com/apache/age


Print Share Comment Cite Upload Translate
APA
Carla Sanches | Sciencx (2024-03-28T21:02:31+00:00) » Why study the design of an RDBMS?. Retrieved from https://www.scien.cx/2023/03/18/why-study-the-design-of-an-rdbms/.
MLA
" » Why study the design of an RDBMS?." Carla Sanches | Sciencx - Saturday March 18, 2023, https://www.scien.cx/2023/03/18/why-study-the-design-of-an-rdbms/
HARVARD
Carla Sanches | Sciencx Saturday March 18, 2023 » Why study the design of an RDBMS?., viewed 2024-03-28T21:02:31+00:00,<https://www.scien.cx/2023/03/18/why-study-the-design-of-an-rdbms/>
VANCOUVER
Carla Sanches | Sciencx - » Why study the design of an RDBMS?. [Internet]. [Accessed 2024-03-28T21:02:31+00:00]. Available from: https://www.scien.cx/2023/03/18/why-study-the-design-of-an-rdbms/
CHICAGO
" » Why study the design of an RDBMS?." Carla Sanches | Sciencx - Accessed 2024-03-28T21:02:31+00:00. https://www.scien.cx/2023/03/18/why-study-the-design-of-an-rdbms/
IEEE
" » Why study the design of an RDBMS?." Carla Sanches | Sciencx [Online]. Available: https://www.scien.cx/2023/03/18/why-study-the-design-of-an-rdbms/. [Accessed: 2024-03-28T21:02:31+00:00]
rf:citation
» Why study the design of an RDBMS? | Carla Sanches | Sciencx | https://www.scien.cx/2023/03/18/why-study-the-design-of-an-rdbms/ | 2024-03-28T21:02:31+00:00
https://github.com/addpipe/simple-recorderjs-demo