Pelajaran 9/13 · 17 perkataan · 0 sudah dipelajari
Databases and data management
Pangkalan data dan pengurusan data
memulihkan, memulihkan semula
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.
Kami memulihkan fail yang dipadam daripada sandaran malam tadi.
It took four hours to restore the service after the crash.
Sinonimrecoverrevivereestablishrebuildrepairreinstatereturnbring backAntonimdamagedestroyimpairworsendegradepangkalan data
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.
Semua pesanan pelanggan disimpan dalam pangkalan data pusat.
The database administrator checks the database performance every morning.
Sinonimrepositorydata storedata bankAntonimnoneDBMS, sistem pengurusan pangkalan data
database management system: software used to create, manage and control access to databases
MySQL and Oracle are two widely used DBMS products.
MySQL dan Oracle ialah dua produk DBMS yang digunakan secara meluas.
The DBMS controls which users can read or change the data.
Sinonimdatabase systemdatabase management systemdata management systemAntonimfile systemmembuat sandaran, menyandarkan
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.
Sistem itu membuat sandaran pangkalan data secara automatik setiap malam.
Remember to back up your files before you reinstall the operating system.
SinonimsupportcopyduplicatesavepreserveAntonimdeleteremoveerasepangkalan data hubungan, pangkalan data relasi
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.
Sistem perakaunan kami menggunakan pangkalan data hubungan dengan lebih dua ratus jadual.
In a relational database, customers and orders are stored in separate but linked tables.
medan
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.
Medan e-mel dalam borang pelanggan tidak boleh dibiarkan kosong.
We added a new field to record each customer's preferred language.
kunci asing
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.
Jadual pesanan menggunakan ID pelanggan sebagai kunci asing.
The delete failed because of a foreign key constraint.
kueri, pertanyaan
a request for specific data from a database, usually written in SQL
This query returns all orders placed in the last thirty days.
Kueri ini memaparkan semua pesanan yang dibuat dalam tempoh tiga puluh hari lepas.
The report is slow because one query takes almost a minute to run.
SQL, Bahasa Pertanyaan Berstruktur
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.
Penganalisis data menggunakan SQL setiap hari untuk mengambil angka bagi laporan.
The test checks basic SQL skills such as joining tables.
NoSQL, pangkalan data bukan hubungan
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.
Kami memilih pangkalan data NoSQL kerana data produk tidak mempunyai struktur tetap.
NoSQL databases are often used for real-time apps with large amounts of data.
skema
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.
Sebarang perubahan pada skema pangkalan data mesti disemak oleh pembangun utama.
The schema shows how customers, orders and products are related.
migrasi data, pemindahan data
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.
Migrasi data ke sistem ERP baharu mengambil masa tiga hujung minggu.
We tested the data migration carefully to make sure no records were lost.
integriti data
the accuracy, completeness and consistency of data over its whole life
Foreign keys help protect data integrity in the database.
Kunci asing membantu melindungi integriti data dalam pangkalan data.
The audit found data integrity problems in the sales records.

