WGU d426
1. Data Data is numeric, textual, visual or audio information that
describes real-world systems.
2. Analog Historically, data was mostly analog, encoded as contin-
uous variations on various physical media
3. digital today, data is mostly digital, encoded as zeros and ones
on electronic and magnetic medai
4. Database a collection of data in a structured format
5. database system also known as DBMS, is software that reads and writes
data in a database. ensures data is secure, consistent and
available at all times
6. query language a specialized programming language, designed specifi-
cally for database systems.
7. database appli- software that helps business users interact with database
cation systems.
8. database admin- responsible for securing the database system against
istrator unauthorized users
9. database design- determines the format of each data element and the
er overall database structure.
10. database pro- develops computer programs that utilize a database
grammer
11. database user a consumer of data in a database.
12. transaction A group of queries that must be either completed or
rejected as a whole
13. architecture describes the internal components and the relationship
between components.
14. query processor interprets queries, creates a plan to modify the databse or
retrieve data, and returns query results to the application.
, WGU d426
15. query optimiza- performed by the query processor to ensure the most
tion efficient instructions are executed on the data.
16. storage manager translates the query processor instructions into low-level
file-system commands that modify or retrieve data.
17. indexes used by storage manager to quickly locate data
18. transaction man- ensures transactions are properly executed
ager
19. log a file containing a complete record of all inserts, updates
and deletes processed by the database.
20. catalog / data a directory of tables, columns, indexes and other data-
dictionary base objects
21. relational data- stores data in tables, columns, and rows, similar to a
base spreadsheet
22. SQL Stands for structured query language. Includes state-
ments that read and write data, create and delete tables,
and administer the database system.
23. big data massive volumes of online data. often poorly structured
or missing information.
24. NoSQL Newer non-relational systems (Not Only SQL). Optimized
for big data.
25. Open source Software that anyone can inspect, copy and modify with
no licensing fee
26. query a command for a database that typically inserts new
data, retrieves data, updates data, or deletes data from
a database
27. CRUD The four common queries: Create, Read, Update and
Delete
, WGU d426
28. statement A SQL statement is a database command, such as
a query that inserts, that inserts, selects, updates, or
deletes data
29. INSERT command that inserts rows into a table
30. SELECT command that retrieves data from a table
31. UPDATE command that modifies data in a table
32. DELETE command that deletes data in a table
33. CREATE TABLE command that creates a new table by specifying the table
and column names
34. data type indicates the format of column values. can b e numeric,
textual or complex
35. database design specification of database objects such as tables,
columns, data types and indexes. also refers to the
process used to develop the specification
36. analysis specifies database requirements without regard to a spe-
cific database system. develops ERD.
37. ER diagrams entities, relationships and attributes are depicted in these
diagrams
38. logical design implements database requirements in a specific data-
base system. converts the ERD into tables, columns and
keys
39. key a column used to identify individual rows of a table.
40. table diagram the logical design is is depicted in a ____.
41. schema the logical design, as specified in SQL and depicted in a
table diagram, is called a database ______.
42. physical design
1. Data Data is numeric, textual, visual or audio information that
describes real-world systems.
2. Analog Historically, data was mostly analog, encoded as contin-
uous variations on various physical media
3. digital today, data is mostly digital, encoded as zeros and ones
on electronic and magnetic medai
4. Database a collection of data in a structured format
5. database system also known as DBMS, is software that reads and writes
data in a database. ensures data is secure, consistent and
available at all times
6. query language a specialized programming language, designed specifi-
cally for database systems.
7. database appli- software that helps business users interact with database
cation systems.
8. database admin- responsible for securing the database system against
istrator unauthorized users
9. database design- determines the format of each data element and the
er overall database structure.
10. database pro- develops computer programs that utilize a database
grammer
11. database user a consumer of data in a database.
12. transaction A group of queries that must be either completed or
rejected as a whole
13. architecture describes the internal components and the relationship
between components.
14. query processor interprets queries, creates a plan to modify the databse or
retrieve data, and returns query results to the application.
, WGU d426
15. query optimiza- performed by the query processor to ensure the most
tion efficient instructions are executed on the data.
16. storage manager translates the query processor instructions into low-level
file-system commands that modify or retrieve data.
17. indexes used by storage manager to quickly locate data
18. transaction man- ensures transactions are properly executed
ager
19. log a file containing a complete record of all inserts, updates
and deletes processed by the database.
20. catalog / data a directory of tables, columns, indexes and other data-
dictionary base objects
21. relational data- stores data in tables, columns, and rows, similar to a
base spreadsheet
22. SQL Stands for structured query language. Includes state-
ments that read and write data, create and delete tables,
and administer the database system.
23. big data massive volumes of online data. often poorly structured
or missing information.
24. NoSQL Newer non-relational systems (Not Only SQL). Optimized
for big data.
25. Open source Software that anyone can inspect, copy and modify with
no licensing fee
26. query a command for a database that typically inserts new
data, retrieves data, updates data, or deletes data from
a database
27. CRUD The four common queries: Create, Read, Update and
Delete
, WGU d426
28. statement A SQL statement is a database command, such as
a query that inserts, that inserts, selects, updates, or
deletes data
29. INSERT command that inserts rows into a table
30. SELECT command that retrieves data from a table
31. UPDATE command that modifies data in a table
32. DELETE command that deletes data in a table
33. CREATE TABLE command that creates a new table by specifying the table
and column names
34. data type indicates the format of column values. can b e numeric,
textual or complex
35. database design specification of database objects such as tables,
columns, data types and indexes. also refers to the
process used to develop the specification
36. analysis specifies database requirements without regard to a spe-
cific database system. develops ERD.
37. ER diagrams entities, relationships and attributes are depicted in these
diagrams
38. logical design implements database requirements in a specific data-
base system. converts the ERD into tables, columns and
keys
39. key a column used to identify individual rows of a table.
40. table diagram the logical design is is depicted in a ____.
41. schema the logical design, as specified in SQL and depicted in a
table diagram, is called a database ______.
42. physical design
