WGU d426
Study online at https://quizlet.com/_f0406u
1. Data Data is numeric, textual, visual or audio information that describes real-world
systems.
2. Analog Historically, data was mostly analog, encoded as continuous variations on various
physical media
3. digital today, data is mostly digital, encoded as zeros and ones on electronic and mag-
netic 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 specifically for database systems.
7. database appli- software that helps business users interact with database systems.
cation
8. database admin- responsible for securing the database system against unauthorized users
istrator
9. database design- determines the format of each data element and the overall database structure.
er
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
, WGU d426
Study online at https://quizlet.com/_f0406u
interprets queries, creates a plan to modify the databse or retrieve data, and
returns query results to the application.
15. query optimiza- performed by the query processor to ensure the most efficient instructions are
tion 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 dic- a directory of tables, columns, indexes and other database objects
tionary
21. relational data- stores data in tables, columns, and rows, similar to a spreadsheet
base
22. SQL Stands for structured query language. Includes statements 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
, WGU d426
Study online at https://quizlet.com/_f0406u
27. CRUD The four common queries: Create, Read, Update and Delete
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 specific 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 database 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 this phase adds indexes and specifies how tables are organized on storage media.
Study online at https://quizlet.com/_f0406u
1. Data Data is numeric, textual, visual or audio information that describes real-world
systems.
2. Analog Historically, data was mostly analog, encoded as continuous variations on various
physical media
3. digital today, data is mostly digital, encoded as zeros and ones on electronic and mag-
netic 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 specifically for database systems.
7. database appli- software that helps business users interact with database systems.
cation
8. database admin- responsible for securing the database system against unauthorized users
istrator
9. database design- determines the format of each data element and the overall database structure.
er
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
, WGU d426
Study online at https://quizlet.com/_f0406u
interprets queries, creates a plan to modify the databse or retrieve data, and
returns query results to the application.
15. query optimiza- performed by the query processor to ensure the most efficient instructions are
tion 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 dic- a directory of tables, columns, indexes and other database objects
tionary
21. relational data- stores data in tables, columns, and rows, similar to a spreadsheet
base
22. SQL Stands for structured query language. Includes statements 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
, WGU d426
Study online at https://quizlet.com/_f0406u
27. CRUD The four common queries: Create, Read, Update and Delete
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 specific 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 database 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 this phase adds indexes and specifies how tables are organized on storage media.
