Lição 9/13 · 17 palavras · 0 aprendidas
Databases and data management
Bancos de dados e gestão de dados
restaurar, recuperar
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.
Restauramos os arquivos excluídos a partir do backup da noite passada.
It took four hours to restore the service after the crash.
Sinônimosrecoverrevivereestablishrebuildrepairreinstatereturnbring backAntônimosdamagedestroyimpairworsendegradebanco de dados, base de dados
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.
Todos os pedidos de clientes são armazenados em um banco de dados central.
The database administrator checks the database performance every morning.
Sinônimosrepositorydata storedata bankAntônimosnoneSGBD, sistema gerenciador de banco de dados
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 são dois SGBDs amplamente usados.
The DBMS controls which users can read or change the data.
Sinônimosdatabase systemdatabase management systemdata management systemAntônimosfile systemfazer backup, fazer cópia de segurança
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.
O sistema faz backup do banco de dados automaticamente toda noite.
Remember to back up your files before you reinstall the operating system.
SinônimossupportcopyduplicatesavepreserveAntônimosdeleteremoveerasebanco de dados relacional
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.
Nosso sistema de contabilidade usa um banco de dados relacional com mais de duzentas tabelas.
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.
O campo de e-mail no formulário de cliente não pode ficar vazio.
We added a new field to record each customer's preferred language.
chave estrangeira
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.
A tabela de pedidos usa o ID do cliente como chave estrangeira.
The delete failed because of a foreign key constraint.
consulta, query
a request for specific data from a database, usually written in SQL
This query returns all orders placed in the last thirty days.
Esta consulta retorna todos os pedidos feitos nos últimos trinta dias.
The report is slow because one query takes almost a minute to run.
SQL, linguagem de consulta estruturada
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.
Os analistas de dados usam SQL todos os dias para extrair números para relatórios.
The test checks basic SQL skills such as joining tables.
NoSQL, banco de dados não relacional
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.
Escolhemos um banco de dados NoSQL porque os dados dos produtos não têm uma estrutura fixa.
NoSQL databases are often used for real-time apps with large amounts of data.
esquema, schema
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.
Qualquer alteração no esquema do banco de dados deve ser revisada pelo desenvolvedor líder.
The schema shows how customers, orders and products are related.
migração de dados
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.
A migração de dados para o novo sistema ERP levou três fins de semana.
We tested the data migration carefully to make sure no records were lost.
integridade de dados
the accuracy, completeness and consistency of data over its whole life
Foreign keys help protect data integrity in the database.
As chaves estrangeiras ajudam a proteger a integridade dos dados no banco de dados.
The audit found data integrity problems in the sales records.

