Forem

Carla Sanches
Carla Sanches

Posted on • Edited on

6

How an RDBMS works #2: Reasons to study its design

This is the second article 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 let your contribution in the comments below 😊.

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

Image of Timescale

🚀 pgai Vectorizer: SQLAlchemy and LiteLLM Make Vector Search Simple

We built pgai Vectorizer to simplify embedding management for AI applications—without needing a separate database or complex infrastructure. Since launch, developers have created over 3,000 vectorizers on Timescale Cloud, with many more self-hosted.

Read full post →

Top comments (0)

Some comments may only be visible to logged-in visitors. Sign in to view all comments.

👋 Kindness is contagious

Explore a sea of insights with this enlightening post, highly esteemed within the nurturing DEV Community. Coders of all stripes are invited to participate and contribute to our shared knowledge.

Expressing gratitude with a simple "thank you" can make a big impact. Leave your thanks in the comments!

On DEV, exchanging ideas smooths our way and strengthens our community bonds. Found this useful? A quick note of thanks to the author can mean a lot.

Okay