Lektion 9/13 · 17 Wörter · 0 gelernt
Databases and data management
Datenbanken und Datenmanagement
wiederherstellen, zurückspielen
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.
Wir haben die gelöschten Dateien aus dem Backup von gestern Nacht wiederhergestellt.
It took four hours to restore the service after the crash.
Synonymerecoverrevivereestablishrebuildrepairreinstatereturnbring backAntonymedamagedestroyimpairworsendegradedie Datenbank
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.
Alle Kundenaufträge werden in einer zentralen Datenbank gespeichert.
The database administrator checks the database performance every morning.
Synonymerepositorydata storedata bankAntonymenonedas DBMS, das Datenbankmanagementsystem, das Datenbankverwaltungssystem
database management system: software used to create, manage and control access to databases
MySQL and Oracle are two widely used DBMS products.
MySQL und Oracle sind zwei weit verbreitete DBMS-Produkte.
The DBMS controls which users can read or change the data.
Synonymedatabase systemdatabase management systemdata management systemAntonymefile systemsichern, ein Backup erstellen
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.
Das System sichert die Datenbank jede Nacht automatisch.
Remember to back up your files before you reinstall the operating system.
SynonymesupportcopyduplicatesavepreserveAntonymedeleteremoveerasedie relationale Datenbank
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.
Unser Buchhaltungssystem nutzt eine relationale Datenbank mit über zweihundert Tabellen.
In a relational database, customers and orders are stored in separate but linked tables.
das Feld, das Datenfeld
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.
Das E-Mail-Feld im Kundenformular darf nicht leer bleiben.
We added a new field to record each customer's preferred language.
der Primärschlüssel
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.
Die Kundennummer ist der Primärschlüssel der Kundentabelle.
Two records cannot have the same primary key.
der Fremdschlüssel
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.
Die Bestelltabelle verwendet die Kundennummer als Fremdschlüssel.
The delete failed because of a foreign key constraint.
die Abfrage, die Query
a request for specific data from a database, usually written in SQL
This query returns all orders placed in the last thirty days.
Diese Abfrage liefert alle Bestellungen der letzten dreißig Tage.
The report is slow because one query takes almost a minute to run.
SQL, die Datenbankabfragesprache
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.
Datenanalysten verwenden täglich SQL, um Zahlen für Berichte abzurufen.
The test checks basic SQL skills such as joining tables.
NoSQL, die nicht-relationale Datenbank
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.
Wir haben uns für eine NoSQL-Datenbank entschieden, weil die Produktdaten keine feste Struktur haben.
NoSQL databases are often used for real-time apps with large amounts of data.
das Datenbankschema, das 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.
Jede Änderung am Datenbankschema muss vom Lead Developer geprüft werden.
The schema shows how customers, orders and products are related.
der Index, der Datenbankindex
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.
Ein Index auf der E-Mail-Spalte hat die Suche zehnmal schneller gemacht.
Too many indexes can slow down inserts and updates.
die Datenmigration
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.
Die Datenmigration in das neue ERP-System dauerte drei Wochenenden.
We tested the data migration carefully to make sure no records were lost.
die Datenintegrität
the accuracy, completeness and consistency of data over its whole life
Foreign keys help protect data integrity in the database.
Fremdschlüssel tragen dazu bei, die Datenintegrität in der Datenbank zu schützen.
The audit found data integrity problems in the sales records.

