Lección 9/13 · 17 palabras · 0 aprendidas
Databases and data management
Bases de datos y gestión de datos
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 los archivos eliminados a partir de la copia de seguridad de anoche.
It took four hours to restore the service after the crash.
Sinónimosrecoverrevivereestablishrebuildrepairreinstatereturnbring backAntónimosdamagedestroyimpairworsendegradebase de datos
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 los pedidos de los clientes se almacenan en una base de datos central.
The database administrator checks the database performance every morning.
Sinónimosrepositorydata storedata bankAntónimosnoneDBMS, SGBD, sistema de gestión de bases de datos
database management system: software used to create, manage and control access to databases
MySQL and Oracle are two widely used DBMS products.
MySQL y Oracle son dos productos de DBMS ampliamente utilizados.
The DBMS controls which users can read or change the data.
Sinónimosdatabase systemdatabase management systemdata management systemAntónimosfile systemrespaldar, hacer una copia de seguridad
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.
El sistema respalda la base de datos automáticamente todas las noches.
Remember to back up your files before you reinstall the operating system.
SinónimossupportcopyduplicatesavepreserveAntónimosdeleteremoveerasebase de datos 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.
Nuestro sistema de contabilidad usa una base de datos relacional con más de doscientas tablas.
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.
El campo de correo electrónico del formulario de clientes no puede quedar vacío.
We added a new field to record each customer's preferred language.
clave externa, clave foránea
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 tabla de pedidos usa el ID de cliente como clave externa.
The delete failed because of a foreign key constraint.
consulta
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 devuelve todos los pedidos realizados en los últimos treinta días.
The report is slow because one query takes almost a minute to run.
SQL, lenguaje de consulta estructurado
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.
Los analistas de datos usan SQL todos los días para obtener cifras para los informes.
The test checks basic SQL skills such as joining tables.
NoSQL, base de datos no 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.
Elegimos una base de datos NoSQL porque los datos de los productos no tienen una estructura fija.
NoSQL databases are often used for real-time apps with large amounts of data.
esquema, esquema de base de datos
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.
Cualquier cambio en el esquema de la base de datos debe ser revisado por el desarrollador principal.
The schema shows how customers, orders and products are related.
índice
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.
Agregar un índice a la columna de correo electrónico hizo la búsqueda diez veces más rápida.
Too many indexes can slow down inserts and updates.
migración de datos
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 migración de datos al nuevo sistema ERP tomó tres fines de semana.
We tested the data migration carefully to make sure no records were lost.
integridad de los datos
the accuracy, completeness and consistency of data over its whole life
Foreign keys help protect data integrity in the database.
Las claves externas ayudan a proteger la integridad de los datos en la base de datos.
The audit found data integrity problems in the sales records.

