C1 · 50 words
Databases in Spanish
Table, key, query, transaction — and why a field may be empty.
La vista here is the stored query a reader looks at a table through, and English calls that a « view » as well. The Spanish word then goes on to do jobs English hands to other words. La vista is eyesight — tiene buena vista has nothing to do with scenery — and it is the view out of a window, and in a courtroom la vista oral is the hearing, the day the case is actually spoken aloud. English needs « sight », « view » and « hearing » for those, one of them borrowed from a different sense altogether. What holds the Spanish together is simply the act of looking.
The words
View
Phrase (32)
la base de datos relacionalthe relational databasePhraseC1
La base de datos relacional tiene cuarenta tablas.The relational database has forty tables.
la fila de datosthe record, one row of dataPhraseC1
La fila de datos se borró por error.The record was deleted by mistake.
el campo de la tablathe field in the tablePhraseC1
El campo de la tabla admite treinta caracteres.The field in the table takes thirty characters.
el tipo de datothe type of the dataPhraseC1
El tipo de dato es entero.The type of the data is whole number.
la clave primariathe key that identifies the rowPhraseC1
La clave primaria no puede repetirse.The key that identifies the row cannot repeat.
la clave ajenathe key that points at another tablePhraseC1
La clave ajena apunta a otra tabla.That key points at a row in another table.
la integridad referencialthe rule that a reference must point at somethingPhraseC1
La integridad referencial impide el borrado.The rule that a reference must point at something blocks the deletion.
el valor nulothe null value meaning nothing is knownPhraseC1
El valor nulo no es cero.The null value meaning nothing is known is not a zero.
el índice de la tablathe index on the tablePhraseC1
El índice de la tabla acelera la búsqueda.The index on the table speeds the search up.
la consulta a la basethe query put to the databasePhraseC1
La consulta a la base tarda dos segundos.The query put to the database takes two seconds.
la unión de tablasthe joining of two tablesPhraseC1
La unión de tablas duplica las filas.The joining of two tables doubles the rows.
el filtro de la consultathe condition that narrows the queryPhraseC1
El filtro de la consulta reduce a diez filas.The condition that narrows the query cuts it to ten rows.
la función de agregaciónthe function that sums a groupPhraseC1
La función de agregación suma el importe.The function that sums a group adds the amounts up.
el procedimiento almacenadothe stored procedurePhraseC1
El procedimiento almacenado corre cada noche.The stored procedure runs every night.
la confirmación de la transacciónthe committing of the transactionPhraseC1
La confirmación de la transacción llegó tarde.The committing of the transaction came late.
la reversión de cambiosthe rolling back of a transactionPhraseC1
La reversión de cambios salvó los datos.The rolling back of a transaction saved the data.
el bloqueo de filathe lock held on one rowPhraseC1
El bloqueo de fila duró demasiado.The lock held on one row lasted too long.
el nivel de aislamientothe isolation levelPhraseC1
El nivel de aislamiento es el más estricto.The isolation level is the strictest one.
la redundancia de datosthe same data held in two placesPhraseC1
La redundancia de datos causó el fallo.The same data held in two places caused the failure.
la migración de datosthe moving of data to a new homePhraseC1
La migración de datos duró una noche.The moving of data to a new home took a night.
el modelo entidad-relaciónthe entity-relationship modelPhraseC1
El modelo entidad-relación cabe en una hoja.The entity-relationship model fits on one sheet.
la copia de seguridad incrementalthe backup of what changed since the last onePhraseC1
La copia de seguridad incremental corre cada hora.The backup of what changed since the last one runs every hour.
la recuperación ante desastrethe recovery after a disasterPhraseC1
La recuperación ante desastre se probó en un servidor aparte.The recovery after a disaster was tried on a separate server.
el registro de transaccionesthe log of every transactionPhraseC1
El registro de transacciones creció sin control.The log of every transaction grew out of control.
el plan de ejecuciónthe plan the engine will followPhraseC1
El plan de ejecución revela el problema.The plan the engine will follow shows the problem.
el barrido completo de tablathe reading of the whole table end to endPhraseC1
El barrido completo de tabla tarda un minuto.The reading of the whole table end to end takes a minute.
la optimización de consultasthe tuning of the queriesPhraseC1
La optimización de consultas ahorró la mitad.The tuning of the queries saved half of it.
la caché de resultadosthe store of results already computedPhraseC1
La caché de resultados dura cinco minutos.The store of results already computed lasts five minutes.
la base de datos documentalthe document databasePhraseC1
La base de datos documental no exige esquema fijo.The document database asks for no fixed schema.
el almacén de datosthe warehouse of data kept for yearsPhraseC1
El almacén de datos guarda diez años.The warehouse of data kept for years holds ten of them.
la carga de datosthe loading of data inPhraseC1
La carga de datos falla si el archivo cambia.The loading of data in fails if the file changes.
la retención de datoshow long data is keptPhraseC1
La retención de datos es de seis años.How long data is kept is six years.
Noun (f) (15)
la tablathe tableNoun (f)C1
La tabla guarda un registro por pedido.The table keeps one record per order.
la restricciónthe constraint a value has to satisfyNoun (f)C1
La restricción exige un valor positivo.The constraint a value has to satisfy demands a positive number.
la subconsultathe query inside another queryNoun (f)C1
La subconsulta se ejecuta primero.The query inside another query runs first.
la filathe rowNoun (f)C1
La fila número mil dio el error.Row number one thousand threw the error.
la columnathe columnNoun (f)C1
La columna admite valores nulos.The column allows null values.
la agrupaciónthe grouping of rows togetherNoun (f)C1
La agrupación es por mes.The grouping of rows together is by month.
la ordenaciónthe sorting of the resultNoun (f)C1
La ordenación es descendente.The sorting of the result is downwards.
la vistathe stored view of a queryNoun (f)C1
La vista esconde tres columnas.The stored view of a query hides three columns.
la transacciónthe transactionNoun (f)C1
La transacción se deshizo entera.The transaction was undone in full.
la concurrenciahow much runs at the same timeNoun (f)C1
La concurrencia sube por la mañana.How much runs at the same time rises in the morning.
la normalizaciónthe splitting out of repeated dataNoun (f)C1
La normalización elimina la repetición.The splitting out of repeated data removes the repetition.
la desnormalizaciónthe folding of data back together for speedNoun (f)C1
La desnormalización acelera la lectura.The folding of data back together for speed makes reading faster.
la cardinalidadhow many on each side of a relationNoun (f)C1
La cardinalidad es de uno a muchos.How many on each side of a relation is one to many.
la anonimizaciónthe stripping of identity for goodNoun (f)C1
La anonimización se hace antes de la copia.The stripping of identity for good is done before the copy.
la seudonimizaciónthe replacing of identity by a tokenNoun (f)C1
La seudonimización permite volver atrás.The replacing of identity by a token can be undone.
Noun (m) (3)
el disparadorthe trigger that fires on a changeNoun (m)C1
El disparador escribe en la tabla de auditoría.The trigger that fires on a change writes to the audit table.
el interbloqueothe deadlock where each lock waitsNoun (m)C1
El interbloqueo se resolvió solo.The deadlock where each lock waits cleared itself.
el esquemathe schemaNoun (m)C1
El esquema cambió en la versión nueva.The schema changed in the new version.
This list belongs to Technology and industry — 26 lists and 1296 words that can also be practised as a whole.
Practise this list
From these 50 words, as many per round as you like — up to all of them: first what is due today, then new ones. First you choose, then you fill the gap, then you write it yourself. Mistakes come back again shortly.