DEV Community: Flavio Francisco

The AI Iceberg

Flavio Francisco — Sat, 24 Oct 2026 12:01:39 +0000

We see a lot of news about AI everywhere, and much of it can bring anxiety and uncertainty about the future. While nobody can predict exactly how far AI will go, think back to when the internet was first created—who could have imagined it would one day replace our home phones and completely change how we watch TV?

But what is just hype, and what should we actually take seriously? That is exactly what I will explore in this article.

First, let's look at the "AI iceberg" represented in the picture below, where I will try to break down each layer in a friendly, easy-to-understand way.

On the surface, it represents all the most well-known, user-friendly tools available on the market to use the power of LLMs (Large Language Models), Agents, and image generation through prompts— but wait: What are prompts?

Prompts are instructions that you can give to the AI to do a task, create an Agent (I will explain later what it is), create a skill, generate an image, summarize a text, or just correct spelling and grammar errors.

For example, this is the prompt that I often use when I am writing emails or other texts, like this article:

From now on, for any text I paste here in English, French, Dutch, or Brazilian Portuguese (just for this session), please fix any grammar and spelling mistakes. Keep in mind that my native language is Brazilian Portuguese. With as few changes as possible, adapt the text so it sounds natural in those specific cultures: US/Canadian for English, Metropolitan French for French, and Netherlandic Dutch for Dutch. Keep the original meaning and wording as close to mine as possible.

To keep this text from getting too long, I'll stop diving into this ocean of an iceberg at the Agent level.

AI Agents

Let's now dive a little bit below the surface, where some of those popular Generative AI tools use AI agents to perform more complex tasks. With the following image, I will explain in a nutshell what is what, without too much technical jargon or detail.

LLM

Why are they called Large Language Models? The word "large" refers specifically to the sheer number of parameters inside the AI's network—typically ranging from billions to trillions—which makes them massive compared to older language models.

When we talk about "parameters," think of them like the billions of connections in a human brain. They allow the AI to learn how language works, using statistics to predict the next most likely word.

MCP (Tools)

Model Context Protocol (MCP) is a little technical, but to keep things simple and understandable to everyone, it provides a standardized way for AI applications to discover and interact with predefined functions (from services on the internet or locally), external tools, and data sources, making them accessible to LLMs.

Memory

Memory can be classified as short-term or long-term and can use databases, files, or other storage mechanisms. Memory helps retain information that can be retrieved later by the runtime orchestration system.

Run Time Orchestration System

Software that manages the execution loop, state management, tool execution, routing and handoffs, error handling, and safety limits. It could execute the following process, for example, as shown in the image below:

What are the impacts of AI now?

This is a very good question. We see a lot of hype and news aimed at driving engagement, which can cause anxiety for many of us, especially if we don't understand what AI is and what it's capable of.

Think of AI as an iceberg. Deep at the bottom, its foundation is mathematics and statistics. Then, as we move up a level, we have machine learning, followed by deep learning, until we reach the surface with generative AI (ChatGPT, Copilot, Claude, Gemini).

AI can perform tasks based on what it has learned during training. Depending on the AI system, it can do things like generate text and images, drive a car, pilot a drone, or describe images and videos.

A good metaphor I heard from a colleague is: "Using AI is like giving your brain a car."

However, there's an interesting nuance. A car doesn't automatically make someone a better driver, and AI doesn't automatically make someone a better thinker.

AI can improve your productivity if you use it as a tool for many tasks. For example, as a software developer, today I can create new features for an application in minutes or hours, whereas before, it could take days, weeks, or even a month. But AI doesn't replace me. Quite the opposite: it takes my knowledge and expertise to determine whether the generated results are safe, maintainable, and correct before they can be used.

But what could happen as AI evolves?

I believe many jobs will be transformed rather than completely replaced, although the impact will vary significantly across professions.

A team could become more productive with the same number of people.

Some fields are already feeling the effects of AI, such as translators, voice actors, and visual artists, including illustrators. Other fields are also being affected by the use of AI-powered robots in automation processes.

I cannot say what the future impact of AI will be as it continues to develop, but we can already see changes in our work environments. For some professions, the way we work today is not the same as it was three years ago.

Some companies are also reducing the number of junior professionals they hire in AI-exposed occupations as AI advances.

The only recommendation I can give you is to learn how to use and get the most out of AI tools like ChatGPT, Claude, Copilot, Gemini... you name it. These tools could become as essential to our work as Excel, Word, and PowerPoint became 10 or 20 years ago.

Another thing to consider is how we should use AI without harming our careers and reputations. For example, some people use AI to read documents, generate summaries, and respond to colleagues. I don't think this is always a good idea. If your colleague is asking for your opinion, are you using Copilot to help you understand the document, or are you letting Copilot form your opinion for you?

AI should help us think, not do all our thinking for us.

I'll leave this question open for you to think about: How are you using AI today?

Database normalization.

Flavio Francisco — Mon, 20 Mar 2023 12:07:35 +0000

Some facts

The words normalization and normal from refer to the structure of a database.
Normalization was developed by IBM researcher E.F. Codd in the 1970s.
Normalization increases clarity in organizing data in databases.

Scenario

Let's say that you are hired to develop a new eCommerce website for some company, than your client shows you the following table:

As you can see the table above has duplicated data and to better organize and optmize our data to be consumed by our new application we do the data modelling called: database normalization.

The 3 most used database normalization are:

First Normal Form (1NF);
Second Normal Form (2NF) and
Third Normal Form (3NF).

Also we have:

Boyce-Codd Normal Form (BCNF);
Fourth Normal Form (4NF) and
Fifth Normal Form (5NF).

I will explain only the 1NF, 2NF and the 3NF because they are the most common used.
The other forms will be explained in different articles.

First Normal Form (1NF)

To be considered a 1NF table:

Each table must have unique columns;
Using row order to convey information is not permitted;
Mixing data types within a primary key is not permitted;
Having a table without a primary key is not permitted and
Repeating groups are not permitted.

As you can see the 'Product Types' columns now is one column, but we can improve our data using the 2NF and that I will explain below.

Second Normal Form (2NF)

To be considered normalized in the 2NF our table must be already normalized as 1NF and each field of a table that is not the primary key is determined by that primary key.
But what is a primary key (PK)? Basically is a code the identifies a unique row in a table.

Take a look at the table above now. We have: Id, Client Name, Phone Number, Product Name, Quantity, Value and Product Type. Since the Id is the PK of the client we can apply the 2NF in the following way:

Does the phone number can be unique for a client? (for simplicity let's say: yes)
Does a product can be unique for a client? (no)
Does the quantity of an ordered product can be unique by a client? (no)
Does the value belongs to the client? (no)
Does the product type belongs to the client? (no).

Based on the answers above we can group the information in a such way that each data will be represented by an unique primary key.

NOTE: a primary key (PK) is a unique value for each row in a table. The PK is used to identify a unique record (row) in a database.
This value cannot be null and can be either a unique column or a set of column that represents an unique combination in a table.
We may have also the foreign Key (FK) is a column or group of columns in a relational database that represents the data in a linked table. A foreign key is just the reference from an table in another table.

Client

Product

But what does happened with the information of the orders? Now we will apply the third normal form (3NF).

Third Normal Form (3NF)

Every non-key attribute in a table should depend on the key, the whole key, and nothing but the key.

An entity is said to be in the third normal form when, it satisfies the criteria to be in the second normal form (2NF) and there is no transitive functional dependency. What this mean? If the table A dependent on table B and the table B is dependent in on the table C then C is transitively dependent on A and B.

So we need to identify the tables were the non-primary-keys field depend on something other than the primary key.

Our candidate for that is the Product table and the field: Product Type. Why? Because a product can only belong to a specific product type and product type can belong to multiple products and also the relations between clients and orders.
We will than have the following entities to have our database in a 3NF.

Client

Product

Product Type

Order

NOTE: I just decided to keep this database model simple. Of course we can include more columns as: creation time; total value; price before taxes and etc, but for explanation I would like to keep it simple.

To conclude our database model will look like the picture below:

Translating our data model we can say that:

1 client can have either 0 or many orders (0 to N);
1 product can be either in 0 or many orders (0 to N);
1 product can have 1 product type (1 to 1) and
1 product type can be assigned to many products (1 to N).

Normalization of a database offers several advantages, including the elimination of redundant information and the maintenance of data consistency. By avoiding the repetition of data, you can optimize storage space and reduce the likelihood of errors. Additionally, by using a unique identifier like the product's ID (primary key) to refer to data, changes to one piece of information, such as a product name, will not affect other related data. This can help ensure the accuracy and reliability of your database over time.

Well this is my first article on the internet and I hope that you enjoyed it.