WGU D426 - Data Management Foundations
b b b b b
Studybonlinebatbhttps://quizlet.com/_evoyts
1. Data numeric, textual, visual, or audio information that de- b b b b b b b
scribes real-world systems.
b b b
2. analog Historically, data was mostly , encod- b b b b b
ed as continuous variations on various physical media.
b b b b b b b
3. digital Today, data is mostly , encoded as
b b b b b b
zeros and ones on electronic and magnetic media.
b b b b b b b
4. database a collection of data in a structured format. In principle,
b b b b b b b b b
can be stored on paper or even clay tablets. In practice, h
b b b b b b b b b b b
owever, modern ones are invariably stored on com-
b b b b b b b
puters.
b
5. database system b software that reads and writes data in a database. en-
b b b b b b b b b
/ database man-
b b bsure data is secure, internally consistent, and available
b b b b b b b b
bagement system / b b at all times. These functions are challenging for large da
b b b b b b b b b
bDBMS tabases with many users, so data base systems are com
b b b b b b b b b
plex.
6. database applica- b software that helps business users interact with data-
b b b b b b b
tion
b base systems.
b b
7. database adminis- - responsible for securing the database system against u
b b b b b b b b
trator
b nauthorized users. b
- enforces procedures for user access and database s b b b b b b b
ystem availability. b
8. database designer determines the format of each data element and the
b b b b b b b b b b
overall database structure. Must balance several prior- b b b b b b
ities, including storage, response time, and support for r
b b b b b b b b b
ules that govern the data. Since these priorities often co
b b b b b b b b b
nflict, database design is technically challenging. b b b b b
9. database program- develops computer programs that utilize a database.
b b b b b b b
mer
b
10. database user b - a consumer of data in a database.
b b b b b b b
request, update, or use stored data to generate reports o
b b b b b b b b b
r information.
b
1b/b51
, WGU D426 - Data Management Foundations
b b b b b
Studybonlinebatbhttps://quizlet.com/_evoyts
- usually access the database via applications but can a
b b b b b b b b
lso submit queries directly to the database system.
b b b b b b b
11. transaction a group of queries that must be either completed or
b b b b b b b b b
rejected as a whole. Execution of some, but not all, queries
b b b b b b b b b b
bresults in inconsistent or incorrect data.
b b b b b
12. query processor
b bbb - interprets queries, creates a plan to modify the data-
b b b b b b b b b
base or retrieve data, and returns query results to the a
b b b b b b b b b b
pplication.
- manages connections from multiple users and com- b b b b b b
piles queries into low-
b b b b
level instructions for the storage engine.
b b b b b
13. query optimization The query processor performs
b b b to en- b b b b
sure the most efficient instructions are executed on the d
b b b b b b b b b
ata.
14. indexes used by the storage manager to quickly locate data.
b b b b b b b b
15. transaction manag- ensures transactions are properly executed.
b b b b b
ber
16. log a file containing a complete record of all inserts, up-
b b b b b b b b b
dates, and deletes processed by the database.
b b b b b b b
17. relational database stores data in tables, columns, and rows, similar to a
b b b b b b b b b b b
spreadsheet.
18. SQL
includes statements that read and write data, create b b b b b b b b
and delete tables, and administer the database system.
b b b b b b b
19. big data
b The growth of the internet in the 1990s generated mas-
b b b b b b b b b
sive volumes of online data, often with poorly structured o
b b b b b b b b b
r missing information.
b b
20. NoSQL The newer non-relational systems, for 'not only SQL',
b b b b b b b
and are optimized for big data.
b b b b b
21. Open source
b
2b/b51
, WGU D426 - Data Management Foundations
b b b b b
Studybonlinebatbhttps://quizlet.com/_evoyts
software that anyone can inspect, copy, and modify with n
b b b b b b b b b
o licensing fee.
b b
22. query a command for a database that typically inserts new
b b b b b b b b
data, retrieves data, updates data, or deletes data from a
b b b b b b b b b b
database.
23. query language b a computer programming language for writing data-
b b b b b b
base queries.b
24. CRUD The four common queries are an acronym for Create,
b b b b b b b b
Read, Update, and Delete data.
b b b b
25. SELECT retrieves data from a table. b b b b
26. UPDATE modifies data in a table. b b b b
27. CREATE TABLE b creates a new table by specifying the table and column
b b b b b b b b b
names.
28. data type
b Each column is assigned a
b that indi- b b b b b
cates the format of column values and can be numeric, text
b b b b b b b b b b
ual, or complex.
b b
29. database design b a specification of database objects such as tables,
b b b b b b b
columns, data types, and indexes. Also refers to the proce
b b b b b b b b b
ss used to develop the specification.
b b b b b
30. analysis
specifies database requirements without regard to b b b b b b
a specific database system.
b b b
31. ER diagrams
b depicts entities, relationships, and attributes.
b b b b
32. logical design b implements database requirements in a specific data- b b b b b b
base system. specifies tables, columns, and keys.
b b b b b b
33. key a column used to identify individual rows of a table.
b b b b b b b b b
34. table diagram
b depicts the logical design.
b b b
3b/b51
, WGU D426 - Data Management Foundations
b b b b b
Studybonlinebatbhttps://quizlet.com/_evoyts
35. schema The logical design, as specified in SQL and depicted in
b b b b b b b b b
a table diagram.
b b
36. data independence The principle that physical design never affects query
b b b b b b b b b
results.
37. application pro- b a library of procedures or classes that links a host progra
b b b b b b b b b b
bgramming inter b mming language to a database. b b b b
- face / API
b b b
38. MySQL a leading relational database system sponsored by
b b b b b b
Oracle.
39. MySQL Community a free edition.
b b b
/MySQL Server b
40. MySQL Enterprise a paid edition for managing commercial databases,
b b b b b b b
includes MySQL Server and additional administrative app b b b b b b
ications.
41. root account
b the administrative account that has full control of
b b b b b b b
MySQL.
42. MySQL Com- b a text interface included in the MySQL Server down-
b b b b b b b b
mand-Line Client b load. allows developers to connect to the database serv
b b b b b b b b b
er, perform administrative functions, and execute SQL st
b b b b b b b
atements.
43. error code b returned by MySQL Server with a description when an
b b b b b b b b
SQL statement is syntactically incorrect or the data-
b b b b b b b
bbase cannot execute the statement.
b b b b
44. MySQL Workbench is installed with MySQL Server and allows developers
b b b b b b b b b
to execute SQL commands using an editor. b b b b b b
45. database model b a conceptual framework for database systems, with
b b b b b b
three parts: b
- Data structures: that prescribe how data is organized.
b b b b b b b
- Operations: that manipulate data structures. b b b b
- Rules: that govern valid data. b b b b
4b/b51
b b b b b
Studybonlinebatbhttps://quizlet.com/_evoyts
1. Data numeric, textual, visual, or audio information that de- b b b b b b b
scribes real-world systems.
b b b
2. analog Historically, data was mostly , encod- b b b b b
ed as continuous variations on various physical media.
b b b b b b b
3. digital Today, data is mostly , encoded as
b b b b b b
zeros and ones on electronic and magnetic media.
b b b b b b b
4. database a collection of data in a structured format. In principle,
b b b b b b b b b
can be stored on paper or even clay tablets. In practice, h
b b b b b b b b b b b
owever, modern ones are invariably stored on com-
b b b b b b b
puters.
b
5. database system b software that reads and writes data in a database. en-
b b b b b b b b b
/ database man-
b b bsure data is secure, internally consistent, and available
b b b b b b b b
bagement system / b b at all times. These functions are challenging for large da
b b b b b b b b b
bDBMS tabases with many users, so data base systems are com
b b b b b b b b b
plex.
6. database applica- b software that helps business users interact with data-
b b b b b b b
tion
b base systems.
b b
7. database adminis- - responsible for securing the database system against u
b b b b b b b b
trator
b nauthorized users. b
- enforces procedures for user access and database s b b b b b b b
ystem availability. b
8. database designer determines the format of each data element and the
b b b b b b b b b b
overall database structure. Must balance several prior- b b b b b b
ities, including storage, response time, and support for r
b b b b b b b b b
ules that govern the data. Since these priorities often co
b b b b b b b b b
nflict, database design is technically challenging. b b b b b
9. database program- develops computer programs that utilize a database.
b b b b b b b
mer
b
10. database user b - a consumer of data in a database.
b b b b b b b
request, update, or use stored data to generate reports o
b b b b b b b b b
r information.
b
1b/b51
, WGU D426 - Data Management Foundations
b b b b b
Studybonlinebatbhttps://quizlet.com/_evoyts
- usually access the database via applications but can a
b b b b b b b b
lso submit queries directly to the database system.
b b b b b b b
11. transaction a group of queries that must be either completed or
b b b b b b b b b
rejected as a whole. Execution of some, but not all, queries
b b b b b b b b b b
bresults in inconsistent or incorrect data.
b b b b b
12. query processor
b bbb - interprets queries, creates a plan to modify the data-
b b b b b b b b b
base or retrieve data, and returns query results to the a
b b b b b b b b b b
pplication.
- manages connections from multiple users and com- b b b b b b
piles queries into low-
b b b b
level instructions for the storage engine.
b b b b b
13. query optimization The query processor performs
b b b to en- b b b b
sure the most efficient instructions are executed on the d
b b b b b b b b b
ata.
14. indexes used by the storage manager to quickly locate data.
b b b b b b b b
15. transaction manag- ensures transactions are properly executed.
b b b b b
ber
16. log a file containing a complete record of all inserts, up-
b b b b b b b b b
dates, and deletes processed by the database.
b b b b b b b
17. relational database stores data in tables, columns, and rows, similar to a
b b b b b b b b b b b
spreadsheet.
18. SQL
includes statements that read and write data, create b b b b b b b b
and delete tables, and administer the database system.
b b b b b b b
19. big data
b The growth of the internet in the 1990s generated mas-
b b b b b b b b b
sive volumes of online data, often with poorly structured o
b b b b b b b b b
r missing information.
b b
20. NoSQL The newer non-relational systems, for 'not only SQL',
b b b b b b b
and are optimized for big data.
b b b b b
21. Open source
b
2b/b51
, WGU D426 - Data Management Foundations
b b b b b
Studybonlinebatbhttps://quizlet.com/_evoyts
software that anyone can inspect, copy, and modify with n
b b b b b b b b b
o licensing fee.
b b
22. query a command for a database that typically inserts new
b b b b b b b b
data, retrieves data, updates data, or deletes data from a
b b b b b b b b b b
database.
23. query language b a computer programming language for writing data-
b b b b b b
base queries.b
24. CRUD The four common queries are an acronym for Create,
b b b b b b b b
Read, Update, and Delete data.
b b b b
25. SELECT retrieves data from a table. b b b b
26. UPDATE modifies data in a table. b b b b
27. CREATE TABLE b creates a new table by specifying the table and column
b b b b b b b b b
names.
28. data type
b Each column is assigned a
b that indi- b b b b b
cates the format of column values and can be numeric, text
b b b b b b b b b b
ual, or complex.
b b
29. database design b a specification of database objects such as tables,
b b b b b b b
columns, data types, and indexes. Also refers to the proce
b b b b b b b b b
ss used to develop the specification.
b b b b b
30. analysis
specifies database requirements without regard to b b b b b b
a specific database system.
b b b
31. ER diagrams
b depicts entities, relationships, and attributes.
b b b b
32. logical design b implements database requirements in a specific data- b b b b b b
base system. specifies tables, columns, and keys.
b b b b b b
33. key a column used to identify individual rows of a table.
b b b b b b b b b
34. table diagram
b depicts the logical design.
b b b
3b/b51
, WGU D426 - Data Management Foundations
b b b b b
Studybonlinebatbhttps://quizlet.com/_evoyts
35. schema The logical design, as specified in SQL and depicted in
b b b b b b b b b
a table diagram.
b b
36. data independence The principle that physical design never affects query
b b b b b b b b b
results.
37. application pro- b a library of procedures or classes that links a host progra
b b b b b b b b b b
bgramming inter b mming language to a database. b b b b
- face / API
b b b
38. MySQL a leading relational database system sponsored by
b b b b b b
Oracle.
39. MySQL Community a free edition.
b b b
/MySQL Server b
40. MySQL Enterprise a paid edition for managing commercial databases,
b b b b b b b
includes MySQL Server and additional administrative app b b b b b b
ications.
41. root account
b the administrative account that has full control of
b b b b b b b
MySQL.
42. MySQL Com- b a text interface included in the MySQL Server down-
b b b b b b b b
mand-Line Client b load. allows developers to connect to the database serv
b b b b b b b b b
er, perform administrative functions, and execute SQL st
b b b b b b b
atements.
43. error code b returned by MySQL Server with a description when an
b b b b b b b b
SQL statement is syntactically incorrect or the data-
b b b b b b b
bbase cannot execute the statement.
b b b b
44. MySQL Workbench is installed with MySQL Server and allows developers
b b b b b b b b b
to execute SQL commands using an editor. b b b b b b
45. database model b a conceptual framework for database systems, with
b b b b b b
three parts: b
- Data structures: that prescribe how data is organized.
b b b b b b b
- Operations: that manipulate data structures. b b b b
- Rules: that govern valid data. b b b b
4b/b51
