Langsung ke konten

Pelajaran 9/13 · 17 kata · 0 sudah hafal

Databases and data management

Basis data dan manajemen data

  1. 1

    restore(verb)

    /rɪˈstɔːr/

    memulihkan, me-restore

    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 berkas yang terhapus dari cadangan semalam.

    It took four hours to restore the service after the crash.

    Sinonimrecoverrevivereestablishrebuildrepairreinstatereturnbring back
    Antonimdamagedestroyimpairworsendegrade
  2. 2

    database(noun)

    /ˈdeɪtəbeɪs/

    basis data, pangkalan 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 basis data pusat.

    The database administrator checks the database performance every morning.

    Sinonimrepositorydata storedata bank
    Antonimnone
  3. 3

    DBMS(abbreviation)

    /ˌdiː biː em ˈes/

    DBMS, sistem manajemen basis 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 adalah dua produk DBMS yang banyak digunakan.

    The DBMS controls which users can read or change the data.

    Sinonimdatabase systemdatabase management systemdata management system
    Antonimfile system
  4. 4

    back up(phrasal verb)

    /bæk ʌp/

    mencadangkan, membuat cadangan

    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 ini mencadangkan basis data secara otomatis setiap malam.

    Remember to back up your files before you reinstall the operating system.

    Sinonimsupportcopyduplicatesavepreserve
    Antonimdeleteremoveerase
  5. 5

    relational database(noun)

    /rɪˌleɪʃənl ˈdeɪtəbeɪs/

    basis data relasional

    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 akuntansi kami menggunakan basis data relasional dengan lebih dari dua ratus tabel.

    In a relational database, customers and orders are stored in separate but linked tables.

  6. 6

    table(noun)

    /ˈteɪbl/

    tabel

    a set of data in a database arranged in rows and columns, usually about one type of thing

    The customer table contains names, phone numbers and addresses.

    Tabel pelanggan berisi nama, nomor telepon, dan alamat.

    We added a new table to store product reviews.

  7. 7

    record(noun)

    /ˈrekɔːd/

    rekaman, rekaman data, record

    one complete set of information about a single item in a database, usually one row in a table

    Each record in the table represents one employee.

    Setiap rekaman dalam tabel mewakili satu karyawan.

    The import created duplicate records for some customers.

  8. 8

    field(noun)

    /fiːld/

    kolom, bidang, field

    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.

    Kolom email pada formulir pelanggan tidak boleh dikosongkan.

    We added a new field to record each customer's preferred language.

  9. 9

    primary key(noun)

    /ˌpraɪməri ˈkiː/

    kunci primer

    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.

    ID pelanggan adalah kunci primer dari tabel pelanggan.

    Two records cannot have the same primary key.

  10. 10

    foreign key(noun)

    /ˌfɒrən ˈkiː/

    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.

    Tabel pesanan menggunakan ID pelanggan sebagai kunci asing.

    The delete failed because of a foreign key constraint.

  11. 11

    query(noun)

    /ˈkwɪəri/

    kueri, query

    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 menampilkan semua pesanan yang dibuat dalam tiga puluh hari terakhir.

    The report is slow because one query takes almost a minute to run.

  12. 12

    SQL(abbreviation)

    /ˌes kjuː ˈel/

    SQL, bahasa kueri terstruktur

    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.

    Analis data menggunakan SQL setiap hari untuk mengambil angka-angka bagi laporan.

    The test checks basic SQL skills such as joining tables.

  13. 13

    NoSQL(noun)

    /ˌnəʊ ˌes kjuː ˈel/

    NoSQL, basis data non-relasional

    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 basis data NoSQL karena data produk tidak memiliki struktur yang tetap.

    NoSQL databases are often used for real-time apps with large amounts of data.

  14. 14

    schema(noun)

    /ˈskiːmə/

    skema basis 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.

    Setiap perubahan pada skema basis data harus ditinjau oleh pengembang utama.

    The schema shows how customers, orders and products are related.

  15. 15

    index(noun)

    /ˈɪndeks/

    indeks

    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.

    Menambahkan indeks pada kolom email membuat pencarian sepuluh kali lebih cepat.

    Too many indexes can slow down inserts and updates.

  16. 16

    data migration(noun)

    /ˈdeɪtə maɪˌɡreɪʃn/

    migrasi 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 yang baru memakan waktu tiga akhir pekan.

    We tested the data migration carefully to make sure no records were lost.

  17. 17

    data integrity(noun)

    /ˈdeɪtə ɪnˌteɡrəti/

    integritas data

    the accuracy, completeness and consistency of data over its whole life

    Foreign keys help protect data integrity in the database.

    Kunci asing membantu menjaga integritas data dalam basis data.

    The audit found data integrity problems in the sales records.