Lezione 9/13 · 17 parole · 0 imparate
Databases and data management
Database e gestione dei dati
ripristinare, recuperare
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.
Abbiamo ripristinato i file eliminati dal backup di ieri sera.
It took four hours to restore the service after the crash.
Sinonimirecoverrevivereestablishrebuildrepairreinstatereturnbring backContraridamagedestroyimpairworsendegradedatabase, base di dati
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.
Tutti gli ordini dei clienti sono memorizzati in un database centrale.
The database administrator checks the database performance every morning.
Sinonimirepositorydata storedata bankContrarinoneDBMS, sistema di gestione di basi di dati
database management system: software used to create, manage and control access to databases
MySQL and Oracle are two widely used DBMS products.
MySQL e Oracle sono due DBMS molto diffusi.
The DBMS controls which users can read or change the data.
Sinonimidatabase systemdatabase management systemdata management systemContrarifile systemeseguire il backup, fare il backup, salvare una copia
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.
Il sistema esegue automaticamente il backup del database ogni notte.
Remember to back up your files before you reinstall the operating system.
SinonimisupportcopyduplicatesavepreserveContrarideleteremoveerasedatabase relazionale
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.
Il nostro sistema di contabilità usa un database relazionale con oltre duecento tabelle.
In a relational database, customers and orders are stored in separate but linked tables.
campo
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.
Il campo e-mail nel modulo cliente non può essere lasciato vuoto.
We added a new field to record each customer's preferred language.
chiave esterna
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 tabella degli ordini usa l'ID cliente come chiave esterna.
The delete failed because of a foreign key constraint.
query, interrogazione
a request for specific data from a database, usually written in SQL
This query returns all orders placed in the last thirty days.
Questa query restituisce tutti gli ordini effettuati negli ultimi trenta giorni.
The report is slow because one query takes almost a minute to run.
SQL, linguaggio di interrogazione strutturato
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.
Gli analisti di dati usano SQL ogni giorno per estrarre le cifre per i report.
The test checks basic SQL skills such as joining tables.
NoSQL, database non relazionale
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.
Abbiamo scelto un database NoSQL perché i dati dei prodotti non hanno una struttura fissa.
NoSQL databases are often used for real-time apps with large amounts of data.
schema, schema del database
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.
Qualsiasi modifica allo schema del database deve essere rivista dallo sviluppatore responsabile.
The schema shows how customers, orders and products are related.
indice
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.
Aggiungere un indice alla colonna e-mail ha reso la ricerca dieci volte più veloce.
Too many indexes can slow down inserts and updates.
migrazione dei dati
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 migrazione dei dati al nuovo sistema ERP ha richiesto tre fine settimana.
We tested the data migration carefully to make sure no records were lost.
integrità dei dati
the accuracy, completeness and consistency of data over its whole life
Foreign keys help protect data integrity in the database.
Le chiavi esterne contribuiscono a proteggere l'integrità dei dati nel database.
The audit found data integrity problems in the sales records.

