본문으로 건너뛰기

레슨 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은 널리 사용되는 DBMS 제품이다.

    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/

    관계형 데이터베이스, 관계형 DB

    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.

    우리 회계 시스템은 200개가 넘는 테이블로 이루어진 관계형 데이터베이스를 사용합니다.

    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.

    고객 ID는 고객 테이블의 기본 키입니다.

    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.

    주문 테이블은 고객 ID를 외래 키로 사용합니다.

    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.

    이 쿼리는 최근 30일 동안 접수된 모든 주문을 반환합니다.

    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.

    이메일 열에 인덱스를 추가했더니 검색 속도가 10배 빨라졌습니다.

    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.