WGU D426 - Data Management Foundations
Study online at https://quizlet.com/_evoyts
1. Data numeric, textual, visual, or audio information
that de- scribes real-world systems.
2. analog Historically, data was mostly , encod-
ed as continuous variations on various physical media.
3. digital Today, data is mostly , encoded as
zeros and ones on electronic and magnetic
media.
4. database a collection of data in a structured format. In
principle,
can be stored on paper or even clay tablets. In
practice, however, modern ones are invariably
stored on com- puters.
5. database system software that reads and writes data in a
/ database man- database. en- sure data is secure, internally
agement system / consistent, and available at all times. These
DBMS functions are challenging for large databases
with many users, so data base systems are
complex.
6. database applica-
tion software that helps business users interact
with data- base systems.
7. database
adminis- trator - responsible for securing the database system
against unauthorized users.
- enforces procedures for user access and
database system availability.
8. database designer determines the format of each data element and
the
overall database structure. Must balance
several prior- ities, including storage, response
time, and support for rules that govern the
data. Since these priorities often conflict,
database design is technically challenging.
9. database program- mer
1/
84
, WGU D426 - Data Management Foundations
Study online at https://quizlet.com/_evoyts
develops computer programs that utilize a database.
10. database user - a consumer of data in a database.
request, update, or use stored data to
generate reports or information.
2/
84
, WGU D426 - Data Management Foundations
Study online at https://quizlet.com/_evoyts
- usually access the database via applications
but can also submit queries directly to the
database system.
11. transaction a group of queries that must be either completed
or
rejected as a whole. Execution of some, but not
all, queries results in inconsistent or incorrect
data.
12. query processor - interprets queries, creates a plan to modify the
data-
base or retrieve data, and returns query
results to the application.
- manages connections from multiple users
and com- piles queries into low-level
instructions for the storage engine.
13. query optimization The query processor performs to en-
sure the most efficient instructions are
executed on the data.
14. indexes used by the storage manager to quickly locate
data.
15. transaction manag- ensures transactions are properly executed.
er
16. log a file containing a complete record of all
inserts, up- dates, and deletes processed by
the database.
17. relational database stores data in tables, columns, and rows, similar
to a
spreadsheet.
18. SQL includes statements that read and write data,
create and delete tables, and administer the
database system.
19. big data The growth of the internet in the 1990s
3/
84
, WGU D426 - Data Management Foundations
Study online at https://quizlet.com/_evoyts
generated mas-
sive volumes of online data, often with poorly
structured or missing information.
20. NoSQL The newer non-relational systems, for 'not only
SQL',
and are optimized for big data.
21. Open source
4/
84
Study online at https://quizlet.com/_evoyts
1. Data numeric, textual, visual, or audio information
that de- scribes real-world systems.
2. analog Historically, data was mostly , encod-
ed as continuous variations on various physical media.
3. digital Today, data is mostly , encoded as
zeros and ones on electronic and magnetic
media.
4. database a collection of data in a structured format. In
principle,
can be stored on paper or even clay tablets. In
practice, however, modern ones are invariably
stored on com- puters.
5. database system software that reads and writes data in a
/ database man- database. en- sure data is secure, internally
agement system / consistent, and available at all times. These
DBMS functions are challenging for large databases
with many users, so data base systems are
complex.
6. database applica-
tion software that helps business users interact
with data- base systems.
7. database
adminis- trator - responsible for securing the database system
against unauthorized users.
- enforces procedures for user access and
database system availability.
8. database designer determines the format of each data element and
the
overall database structure. Must balance
several prior- ities, including storage, response
time, and support for rules that govern the
data. Since these priorities often conflict,
database design is technically challenging.
9. database program- mer
1/
84
, WGU D426 - Data Management Foundations
Study online at https://quizlet.com/_evoyts
develops computer programs that utilize a database.
10. database user - a consumer of data in a database.
request, update, or use stored data to
generate reports or information.
2/
84
, WGU D426 - Data Management Foundations
Study online at https://quizlet.com/_evoyts
- usually access the database via applications
but can also submit queries directly to the
database system.
11. transaction a group of queries that must be either completed
or
rejected as a whole. Execution of some, but not
all, queries results in inconsistent or incorrect
data.
12. query processor - interprets queries, creates a plan to modify the
data-
base or retrieve data, and returns query
results to the application.
- manages connections from multiple users
and com- piles queries into low-level
instructions for the storage engine.
13. query optimization The query processor performs to en-
sure the most efficient instructions are
executed on the data.
14. indexes used by the storage manager to quickly locate
data.
15. transaction manag- ensures transactions are properly executed.
er
16. log a file containing a complete record of all
inserts, up- dates, and deletes processed by
the database.
17. relational database stores data in tables, columns, and rows, similar
to a
spreadsheet.
18. SQL includes statements that read and write data,
create and delete tables, and administer the
database system.
19. big data The growth of the internet in the 1990s
3/
84
, WGU D426 - Data Management Foundations
Study online at https://quizlet.com/_evoyts
generated mas-
sive volumes of online data, often with poorly
structured or missing information.
20. NoSQL The newer non-relational systems, for 'not only
SQL',
and are optimized for big data.
21. Open source
4/
84
