Data Management - Foundations - D426 WGU Exam Answered Correctly!
1. Data numeric , textual , visual or audio information that
describes real-world systems.
varies in ways such as scope, format, access.
2. analog data Historically most common before computers, en-
coded as continuous variations on various physical
media.
3. digital data most common today, recorded as 0's and 1's on
electronic and magnetic media.
4. database designer determines the format of each data element and the
overall database structure
5. database user a consumer of data in a database. can either use an
application or submit queries directly to the data-
base. they use, request and update data. to gener-
ate reports
6. transaction a group of queries that must be completed or re-
jected as whole. will result in incomplete or incorrect
data if not terminated as a whole.
7. Query processor interprets queries, creates a plan to modify the
database or retrieve data, and returns query results
to the application.
8. Query optimization to ensure the most eflcient instructions are execut-
ed on the data from the processor.
9. Storage Manager translates the query processor instructions into
low-level file-system commands that modify or re-
trieve data.
, Data Management - Foundations - D426 WGU Exam Answered Correctly!
10. indexes used by the storage manager to quickly locate data
11. catalog also called a data dictionary , a directory of tables,
columns and indexes as well as other database ob-
jects.
12. relational database a database that stores data in tables that consist of
rows and columns, similar to a spreadsheet
13. SQL Structured Query Language
14. NoSQL A new generation of database management sys-
tems that is not based on the traditional relational
database model.
15. query command for a database that typically inserts, re-
trieves, updates and deletes data from the data-
base.
16. crud Create, Read, Update, Delete
17. statement a database command such as a query that inserts ,
selects updates and deletes data
18. SELECT Retrieves data from a table
19. UPDATE modifies data in a table
20. data type indicates the type of data that can be stored in a field
of a column
21. data independence A condition in which data access is unattected by
changes in the physical data storage characteristics.
22. database model
, Data Management - Foundations - D426 WGU Exam Answered Correctly!
Describes the relationship between the data ele-
ments and provides a framework for organizing the
data. contains 3 parts
data structures
operations
rules
23. relational model A database model that describes data in which all
data elements are placed in two-dimensional ta-
bles, called relations, which are the logical equiva-
lent of files.
24. row an unnamed tuple of values , each value corre-
sponds to a column and belongs to the columns
data type.
25. relational rules part of the relational model and govern data in every
relational database
26. data lake An analytic database of raw, unprocessed data
copied from multiple data sources.
27. in-memory database A database management system that stores the en-
tire database in random access memory (RAM).
28. replica a cop of an entire database
29. data warehouse a separate database optimized for analytics instead
of operations
30. analytic data Historical data used to make decisions in the pre-
sent
1. Data numeric , textual , visual or audio information that
describes real-world systems.
varies in ways such as scope, format, access.
2. analog data Historically most common before computers, en-
coded as continuous variations on various physical
media.
3. digital data most common today, recorded as 0's and 1's on
electronic and magnetic media.
4. database designer determines the format of each data element and the
overall database structure
5. database user a consumer of data in a database. can either use an
application or submit queries directly to the data-
base. they use, request and update data. to gener-
ate reports
6. transaction a group of queries that must be completed or re-
jected as whole. will result in incomplete or incorrect
data if not terminated as a whole.
7. Query processor interprets queries, creates a plan to modify the
database or retrieve data, and returns query results
to the application.
8. Query optimization to ensure the most eflcient instructions are execut-
ed on the data from the processor.
9. Storage Manager translates the query processor instructions into
low-level file-system commands that modify or re-
trieve data.
, Data Management - Foundations - D426 WGU Exam Answered Correctly!
10. indexes used by the storage manager to quickly locate data
11. catalog also called a data dictionary , a directory of tables,
columns and indexes as well as other database ob-
jects.
12. relational database a database that stores data in tables that consist of
rows and columns, similar to a spreadsheet
13. SQL Structured Query Language
14. NoSQL A new generation of database management sys-
tems that is not based on the traditional relational
database model.
15. query command for a database that typically inserts, re-
trieves, updates and deletes data from the data-
base.
16. crud Create, Read, Update, Delete
17. statement a database command such as a query that inserts ,
selects updates and deletes data
18. SELECT Retrieves data from a table
19. UPDATE modifies data in a table
20. data type indicates the type of data that can be stored in a field
of a column
21. data independence A condition in which data access is unattected by
changes in the physical data storage characteristics.
22. database model
, Data Management - Foundations - D426 WGU Exam Answered Correctly!
Describes the relationship between the data ele-
ments and provides a framework for organizing the
data. contains 3 parts
data structures
operations
rules
23. relational model A database model that describes data in which all
data elements are placed in two-dimensional ta-
bles, called relations, which are the logical equiva-
lent of files.
24. row an unnamed tuple of values , each value corre-
sponds to a column and belongs to the columns
data type.
25. relational rules part of the relational model and govern data in every
relational database
26. data lake An analytic database of raw, unprocessed data
copied from multiple data sources.
27. in-memory database A database management system that stores the en-
tire database in random access memory (RAM).
28. replica a cop of an entire database
29. data warehouse a separate database optimized for analytics instead
of operations
30. analytic data Historical data used to make decisions in the pre-
sent
