Types of structure in the Design of Data Storage

Hello, i want to share with you one way to choose the right storage for the data. For the purpose of choosing a storage technology, it is help to consider how data is structured. There are three widely recognized categories:

1. Structured Data

It has a fixed set of attributes that can be modeled in a Table of rows and columns.

Structured Data may be oriented to transactional processes or analytical processes. Transactional processes is often operated on one row at a time. Instead, in the Analytical processes the analyst would query many rows and only columns, not all. This is a common pattern in analytical applications.

2. Semi- Structured Data

It has a attributes like structured data, but the set of this attributes can vary from one instnce to another. Semi Structure Data may be organized using arrays or sets of key-value pairs.

For Semi Structured Data, there are two possible ways to store the data either in document base or wide columns forms. An important distinction between the two is how data is retrieved from them. In the first case, document base, you can retrieve the data using indexex. In the other case, wide columns, you can retrieve the data by organizing it into different tables based on a key column. In the last one, wide columns, the data is repeated.

3. Unstructured Data

It does not fit into a tabular structure. I mean, hte unstructured data does not have a defined schema ir data model. Unstructure data may have a internal structure that is not relevant to the way it is stored.

Finally I want with you a Google's Storage Decision Tree

I invite you to know our service in CONAUTI

or Contact me by Whatsapp

Enrique Suárez

AI & Data Product Development Leader.

Source: Professional Data Engineer, Dan Sullivan, Google.

I see you in the next article.