跳至主要內容

第 9/13 課 · 17 個單字 · 已學會 0 個

Databases and data management

資料庫與資料管理

  1. 1

    restore(verb)

    /rɪˈstɔːr/

    還原, 復原

    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.

    我們從昨晚的備份中還原了被刪除的檔案。

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

    同義詞recoverrevivereestablishrebuildrepairreinstatereturnbring back
    反義詞damagedestroyimpairworsendegrade
  2. 2

    database(noun)

    /ˈdeɪtəbeɪs/

    資料庫

    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.

    所有客戶訂單都儲存在一個中央資料庫中。

    The database administrator checks the database performance every morning.

    同義詞repositorydata storedata bank
    反義詞none
  3. 3

    DBMS(abbreviation)

    /ˌdiː biː em ˈes/

    資料庫管理系統, DBMS

    database management system: software used to create, manage and control access to databases

    MySQL and Oracle are two widely used DBMS products.

    MySQL 和 Oracle 是兩種廣泛使用的資料庫管理系統產品。

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

    同義詞database systemdatabase management systemdata management system
    反義詞file system
  4. 4

    back up(phrasal verb)

    /bæk ʌp/

    備份

    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.

    系統每晚都會自動備份資料庫。

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

    同義詞supportcopyduplicatesavepreserve
    反義詞deleteremoveerase
  5. 5

    relational database(noun)

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

    關聯式資料庫

    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.

    我們的會計系統使用的關聯式資料庫有兩百多個資料表。

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

  6. 6

    table(noun)

    /ˈteɪbl/

    資料表

    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.

    客戶資料表包含姓名、電話號碼和地址。

    We added a new table to store product reviews.

  7. 7

    record(noun)

    /ˈrekɔːd/

    記錄, 資料列

    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.

    資料表中的每一筆記錄代表一位員工。

    The import created duplicate records for some customers.

  8. 8

    field(noun)

    /fiːld/

    欄位

    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.

    客戶表單中的電子郵件欄位不能留空。

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

  9. 9

    primary key(noun)

    /ˌpraɪməri ˈkiː/

    主鍵, 主索引鍵

    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.

    客戶編號是客戶資料表的主鍵。

    Two records cannot have the same primary key.

  10. 10

    foreign key(noun)

    /ˌfɒrən ˈkiː/

    外部索引鍵, 外鍵

    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.

    訂單資料表使用客戶編號作為外部索引鍵。

    The delete failed because of a foreign key constraint.

  11. 11

    query(noun)

    /ˈkwɪəri/

    查詢, 查詢語句

    a request for specific data from a database, usually written in SQL

    This query returns all orders placed in the last thirty days.

    這個查詢會傳回過去三十天內下的所有訂單。

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

  12. 12

    SQL(abbreviation)

    /ˌes kjuː ˈel/

    SQL, 結構化查詢語言

    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.

    資料分析師每天都使用 SQL 來提取報表所需的數據。

    The test checks basic SQL skills such as joining tables.

  13. 13

    NoSQL(noun)

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

    NoSQL, 非關聯式資料庫

    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.

    由於產品資料沒有固定結構,我們選擇了 NoSQL 資料庫。

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

  14. 14

    schema(noun)

    /ˈskiːmə/

    綱要, 結構描述

    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.

    對資料庫綱要的任何變更,都必須經過主導開發人員審核。

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

  15. 15

    index(noun)

    /ˈɪndeks/

    索引

    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.

    在電子郵件欄位加上索引後,搜尋速度快了十倍。

    Too many indexes can slow down inserts and updates.

  16. 16

    data migration(noun)

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

    資料遷移, 資料移轉

    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.

    遷移到新 ERP 系統的資料作業花了三個週末。

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

  17. 17

    data integrity(noun)

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

    資料完整性

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

    Foreign keys help protect data integrity in the database.

    外部索引鍵有助於保護資料庫中的資料完整性。

    The audit found data integrity problems in the sales records.