Data Management - Foundations - D426 WGU
Study online at https://quizlet.com/_cyv993
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, encoded as continu-
ous 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 database. they use, request and update data. to
generate reports
6. transaction: a group of queries that must be completed or rejected 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 efficient instructions are executed on the
data from the processor.
9. Storage Manager: translates the query processor instructions into low-level
file-system commands that modify or retrieve data.
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 objects.
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 systems that is not based
on the traditional relational database model.
15. query: command for a database that typically inserts, retrieves, updates and
deletes data from the database.
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 unaffected by changes
in the physical data storage characteristics.
1/8
, Data Management - Foundations - D426 WGU
Study online at https://quizlet.com/_cyv993
22. database model: Describes the relationship between the data elements 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 tables, called relations, which are the logical
equivalent of files.
24. row: an unnamed tuple of values , each value corresponds 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 entire
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 oper-
ations
30. analytic data: Historical data used to make decisions in the present
31. operational data: data used for managing business processes, such as for
processing transactions or for data analysis
32. distributed transaction: A database transaction that accesses data in several
remote data processors in a distributed database.
33. Local Transactions: updates data on a single node of a distributed database
34. CREATE TABLE: A SQL command that creates a table's structures using the
characteristics and attributes given.
CREATE TABLE Persons (
PersonID int,
LastName varchar(255),
FirstName varchar(255),
Address varchar(255),
City varchar(255)
);
35. Data Transaction Language (DTL): manages database transactions
36. Data Control Language (DCL): Commands that control a database, including
administering privileges and committing data
2/8
Study online at https://quizlet.com/_cyv993
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, encoded as continu-
ous 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 database. they use, request and update data. to
generate reports
6. transaction: a group of queries that must be completed or rejected 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 efficient instructions are executed on the
data from the processor.
9. Storage Manager: translates the query processor instructions into low-level
file-system commands that modify or retrieve data.
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 objects.
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 systems that is not based
on the traditional relational database model.
15. query: command for a database that typically inserts, retrieves, updates and
deletes data from the database.
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 unaffected by changes
in the physical data storage characteristics.
1/8
, Data Management - Foundations - D426 WGU
Study online at https://quizlet.com/_cyv993
22. database model: Describes the relationship between the data elements 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 tables, called relations, which are the logical
equivalent of files.
24. row: an unnamed tuple of values , each value corresponds 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 entire
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 oper-
ations
30. analytic data: Historical data used to make decisions in the present
31. operational data: data used for managing business processes, such as for
processing transactions or for data analysis
32. distributed transaction: A database transaction that accesses data in several
remote data processors in a distributed database.
33. Local Transactions: updates data on a single node of a distributed database
34. CREATE TABLE: A SQL command that creates a table's structures using the
characteristics and attributes given.
CREATE TABLE Persons (
PersonID int,
LastName varchar(255),
FirstName varchar(255),
Address varchar(255),
City varchar(255)
);
35. Data Transaction Language (DTL): manages database transactions
36. Data Control Language (DCL): Commands that control a database, including
administering privileges and committing data
2/8
