Leçon 9/13 · 17 mots · 0 appris
Databases and data management
Bases de données et gestion des données
restaurer, rétablir
to bring something, such as data or a system, back to its earlier condition, for example from a backup
We restored the deleted files from last night's backup.
Nous avons restauré les fichiers supprimés à partir de la sauvegarde de la nuit dernière.
It took four hours to restore the service after the crash.
Synonymesrecoverrevivereestablishrebuildrepairreinstatereturnbring backAntonymesdamagedestroyimpairworsendegradebase de données, BD
an organized collection of data stored on a computer so that it can be searched, updated and managed easily
All customer orders are stored in a central database.
Toutes les commandes des clients sont stockées dans une base de données centrale.
The database administrator checks the database performance every morning.
Synonymesrepositorydata storedata bankAntonymesnonesystème de gestion de bases de données, SGBD
database management system: software used to create, manage and control access to databases
MySQL and Oracle are two widely used DBMS products.
MySQL et Oracle sont deux SGBD très répandus.
The DBMS controls which users can read or change the data.
Synonymesdatabase systemdatabase management systemdata management systemAntonymesfile systemsauvegarder
to make an extra copy of data or files so they can be recovered if the original is lost or damaged
The system backs up the database automatically every night.
Le système sauvegarde automatiquement la base de données chaque nuit.
Remember to back up your files before you reinstall the operating system.
SynonymessupportcopyduplicatesavepreserveAntonymesdeleteremoveerasebase de données relationnelle
a database that stores data in tables which are linked to each other by shared values
Our accounting system uses a relational database with over two hundred tables.
Notre système comptable utilise une base de données relationnelle de plus de deux cents tables.
In a relational database, customers and orders are stored in separate but linked tables.
table
a set of data in a database arranged in rows and columns, usually about one type of thing
The customer table contains names, phone numbers and addresses.
La table des clients contient les noms, les numéros de téléphone et les adresses.
We added a new table to store product reviews.
champ
one piece of information in a record, such as a name or date, usually one column in a table
The email field in the customer form cannot be left empty.
Le champ e-mail du formulaire client ne peut pas être laissé vide.
We added a new field to record each customer's preferred language.
clé primaire
a field whose value is different for every record, used to identify each row in a table
The customer ID is the primary key of the customer table.
L'identifiant client est la clé primaire de la table des clients.
Two records cannot have the same primary key.
clé étrangère
a field in one table that refers to the primary key of another table, linking the two tables
The orders table uses customer ID as a foreign key.
La table des commandes utilise l'identifiant client comme clé étrangère.
The delete failed because of a foreign key constraint.
requête
a request for specific data from a database, usually written in SQL
This query returns all orders placed in the last thirty days.
Cette requête renvoie toutes les commandes passées au cours des trente derniers jours.
The report is slow because one query takes almost a minute to run.
SQL, langage de requêtes structuré
Structured Query Language: the standard language used to create, read and change data in relational databases
Data analysts use SQL every day to pull figures for reports.
Les analystes de données utilisent SQL tous les jours pour extraire des chiffres pour les rapports.
The test checks basic SQL skills such as joining tables.
NoSQL, base de données non relationnelle
a type of database that stores data in flexible formats such as documents, rather than in fixed tables
We chose a NoSQL database because the product data has no fixed structure.
Nous avons choisi une base de données NoSQL parce que les données produit n'ont pas de structure fixe.
NoSQL databases are often used for real-time apps with large amounts of data.
schéma, schéma de base de données
the structure of a database, describing its tables, fields and the links between them
Any change to the database schema must be reviewed by the lead developer.
Toute modification du schéma de la base de données doit être validée par le développeur principal.
The schema shows how customers, orders and products are related.
index
a structure in a database that helps find data in a table much faster
Adding an index to the email column made the search ten times faster.
L'ajout d'un index sur la colonne des e-mails a rendu la recherche dix fois plus rapide.
Too many indexes can slow down inserts and updates.
migration de données
the process of moving data from one system, format or storage location to another
The data migration to the new ERP system took three weekends.
La migration des données vers le nouveau système ERP a pris trois week-ends.
We tested the data migration carefully to make sure no records were lost.
intégrité des données
the accuracy, completeness and consistency of data over its whole life
Foreign keys help protect data integrity in the database.
Les clés étrangères contribuent à protéger l'intégrité des données de la base.
The audit found data integrity problems in the sales records.

