Plan du site  
pixel
pixel

Articles - Étudiants SUPINFO

Choose the right Stack: The database

Par Anis BENZIANE Publié le 03/08/2019 à 22:44:27 Noter cet article:
(0 votes)
Avis favorable du comité de lecture

Summary

This series of articles demystifies marketing myths and jargon for software product design and MVPs.

Here is the summary:

Introduction

The database is a data-centric layer of software.

It allows us to:

  • Store the data representing in a way, how this data will be used in our product → How the data will look like at any stage of the product.

  • Modify and query data efficiently without errors or inconsistencies.

  • Potentially store large amounts of data that could be explored to obtain market knowledge and strategic visions of the product. The marketing word for that is Big Data

The importance of the database

The first step in building a technology stack is to design how our data will look like. We do this by establishing an “Entity-relationship diagram” (ERD).

We take the ERD and examine in detail all connections and relationships between the data. This is an iterative process that occurs in brainstorming sessions between the CTO, the product owner and the developers.

This step is essential for the stability and security of the entire Stack. You will often hear that "Early optimization is evil". This rule does not apply here.

The software architecture is not an early optimization

...

Once the Entity-Association Diagram is fully specified and we have ensured that no significant connections between the data entities have been missed; it is time to choose the technology that will be responsible for our database.

Today, in most software projects, there are two main types of databases, called Sql and NoSql

Sql versus NoSql

I think we should build a Sql database / - Whoa! // Does he understand what he said or is it something he saw in a marketing magazine ad? // What color do you want for your database? - I think the mauve has more ram.

These two types of databases are different in the way they manage the relationships between the data and in the way they allow us to access and modify them.

There is an endless debate on the positive and negative aspects of each approach. As you make many choices in software, there is no single solution for any system. Since we are building an MVP, we want the fastest solution first.

Conclusion

There is no single solution for any system

In the majority of cases, an SQL database will meet all needs at the MVP stage. They have been around for a long time and are still used by the world's largest software companies. So, unless you have specific reasons, an SQL database will meet the needs very well.

A propos de SUPINFO | Contacts & adresses | Enseigner à SUPINFO | Presse | Conditions d'utilisation & Copyright | Respect de la vie privée | Investir
Logo de la société Cisco, partenaire pédagogique de SUPINFO, la Grande École de l'informatique, du numérique et du management Logo de la société IBM, partenaire pédagogique de SUPINFO, la Grande École de l'informatique, du numérique et du management Logo de la société Sun-Oracle, partenaire pédagogique de SUPINFO, la Grande École de l'informatique, du numérique et du management Logo de la société Apple, partenaire pédagogique de SUPINFO, la Grande École de l'informatique, du numérique et du management Logo de la société Sybase, partenaire pédagogique de SUPINFO, la Grande École de l'informatique, du numérique et du management Logo de la société Novell, partenaire pédagogique de SUPINFO, la Grande École de l'informatique, du numérique et du management Logo de la société Intel, partenaire pédagogique de SUPINFO, la Grande École de l'informatique, du numérique et du management Logo de la société Accenture, partenaire pédagogique de SUPINFO, la Grande École de l'informatique, du numérique et du management Logo de la société SAP, partenaire pédagogique de SUPINFO, la Grande École de l'informatique, du numérique et du management Logo de la société Prometric, partenaire pédagogique de SUPINFO, la Grande École de l'informatique, du numérique et du management Logo de la société Toeic, partenaire pédagogique de SUPINFO, la Grande École de l'informatique, du numérique et du management Logo du IT Academy Program par Microsoft, partenaire pédagogique de SUPINFO, la Grande École de l'informatique, du numérique et du management

SUPINFO International University
Ecole d'Informatique - IT School
École Supérieure d'Informatique de Paris, leader en France
La Grande Ecole de l'informatique, du numérique et du management
Fondée en 1965, reconnue par l'État. Titre Bac+5 certifié au niveau I.
SUPINFO International University is globally operated by EDUCINVEST Belgium - Avenue Louise, 534 - 1050 Brussels