Archives de
Catégorie : Base de données

SQL Index and co.

SQL Index and co.

In research progress in development, we need to have a good structure of our DataBase. Today I will show you the importance of a great organisation in your Data! His name is “index”. First of all, what are the basics of this idea? Based on: … What that: Structured Query Language (SQL). What for? Permit a communication with the database. How? Allow to write scripts. Ok, now we can begin : First of all: How to use index? To fully understand…

Lire la suite Lire la suite

Data Protections.

Data Protections.

In research progress in development, you must keep in mind the protection for your data. Today i will show you dependency of protetcions. It has a lot of name, because it has a lot of breaches. First of all, what are the basics of this idea ? Based on : Here I use SQL langage What that : It’s a langage uses to manipulate database. What for ? It’s to create and manipulate information. How ? With scripts and that’s why it’s dangerous. Ok, now…

Lire la suite Lire la suite

What is the GDPR (RGPD)

What is the GDPR (RGPD)

The acronym GDPR stands for « General Data Protection Regulation« . It provides a framework for the processing and circulation of personal data within the territory of the European Union. This European regulation, which actually dates from April 27, 2016, entered into force in all Member States on May 25, 2018. It is directly applicable and binding since that date. The GDPR was born out of the European desire to create a unified legal framework, in order to face the major challenges…

Lire la suite Lire la suite

SQL vs NoSQL

SQL vs NoSQL

When it comes to database and DBMS (Data Base Management System), one question should come to mind : Should I use SQL (Structured Query Language) or NoSQL (Not Only SQL or No SQL) databases.Well, it depends on every projects. Both systems will store your datas but each of them has its way. The primary difference is that SQL databases are relational while NoSQL databases are non-relational. Then, NoSQL databases have dynamic schema for unstructured data while SQL databases use structured…

Lire la suite Lire la suite

Embedded Databases

Embedded Databases

An embedded database doesn’t need a server: data is stored on the same machine as the application that uses it (typically in a sub-folder of the application). Advantages Extremely fast read/write operations. Not dependent on a database hosting service, avoiding all associated costs. No need for a network connection because queries are executed locally. Drawbacks The database is not shared between different machines, and is therefore limited to storing local data. Execution speed of queries is harder to predict because…

Lire la suite Lire la suite

PROTECTION DES DONNEES

PROTECTION DES DONNEES

Cybersécurité : nouvelles technologies, dangers inchangés Introduction Le tout numérique entraîne inévitablement l’augmentation des cyberattaques. Particuliers, entreprises, ou encore gouvernements, personne ne semble épargné. 5G : « Il n’y a pas de raison pour que ce soit plus dangereux, mais cela nécessite des efforts » Une récente étude du cabinet de conseil Deloitte met en avant que nombre de leurs clients s’inquiètent des risques de cyberattaques liés au deploiement des réseaux 5G. Afin d’éclaircir ce sujet, Siècle Digital a rencontré…

Lire la suite Lire la suite