WGU C175: data management foundations
data - ANS-numeric, textual, visual or audio information that describes real-world
systems
scope of data - ANS-the amount of data produced and collected
format of data - ANS-data may be produced as numbers, text, image, audio, or video
access of data - ANS-some data sources are private while others are made publicly
available
database - ANS-a collection of data in a structured format
database system aka DBMS - ANS-is software that reads and writes data in a
database. ensures data is secure, internally consistent, and available at all times
query language - ANS-a specialized programming language designed specifically for
database systems. reads and writes data efficiently, and differs significantly from
general purpose languages such as python or java
database application - ANS-software that helps business users interact with database
systems
database administrator - ANS-the person responsible for securing the database system
against unauthorized users. enforces procedures for user and database system
availability
database designer - ANS-the person that determines the format of each data element
and the overall database structure. must balance several priorities including storage,
response time, and support for rules that govern the data.
database programmer - ANS-the person that develops computer programs that utilize a
database. they write applications that combine database query languages and general
purpose programming languages.
database user - ANS-a consumer of data in a database. request, update, or use stored
data to generate reports or information.
, transaction - ANS-a group of queries that must be either completed or rejected as a
whole.
ensure transactions are processed completely or not at all
prevent conflicts between concurrent transactions
ensure transaction results are never lost - ANS-when processing transactions, database
systems must:
architecture of a database system (5) - ANS-describes the internal components and the
relationships between components:
query processor
storage manager
transaction manager
log
catalog
query processor - ANS-interprets queries, creates a plan to modify the database or
retrieve data, and returns query results to the application.
storage manager - ANS-translates the query processor instructions into low-level
file-system commands that modify or retrieve data.
query optimization - ANS-query processor performs ___________ to ensure that most
efficient instructions are executed on the data
indexes - ANS-storage manager uses ______ to quickly locate data
transaction manager - ANS-Ensures transactions are properly executed. Prevents
conflicts between concurrent transactions. Restores the database to a consistent state
in the event of a transaction or system failure.
log - ANS-a file containing a complete record of all inserts, updates, and deletes
processed by the database. the transaction manager writes these before applying
changes to the database.
catalog/data dictionary - ANS-A directory of tables, columns, indexes, and other
database objects.
data - ANS-numeric, textual, visual or audio information that describes real-world
systems
scope of data - ANS-the amount of data produced and collected
format of data - ANS-data may be produced as numbers, text, image, audio, or video
access of data - ANS-some data sources are private while others are made publicly
available
database - ANS-a collection of data in a structured format
database system aka DBMS - ANS-is software that reads and writes data in a
database. ensures data is secure, internally consistent, and available at all times
query language - ANS-a specialized programming language designed specifically for
database systems. reads and writes data efficiently, and differs significantly from
general purpose languages such as python or java
database application - ANS-software that helps business users interact with database
systems
database administrator - ANS-the person responsible for securing the database system
against unauthorized users. enforces procedures for user and database system
availability
database designer - ANS-the person that determines the format of each data element
and the overall database structure. must balance several priorities including storage,
response time, and support for rules that govern the data.
database programmer - ANS-the person that develops computer programs that utilize a
database. they write applications that combine database query languages and general
purpose programming languages.
database user - ANS-a consumer of data in a database. request, update, or use stored
data to generate reports or information.
, transaction - ANS-a group of queries that must be either completed or rejected as a
whole.
ensure transactions are processed completely or not at all
prevent conflicts between concurrent transactions
ensure transaction results are never lost - ANS-when processing transactions, database
systems must:
architecture of a database system (5) - ANS-describes the internal components and the
relationships between components:
query processor
storage manager
transaction manager
log
catalog
query processor - ANS-interprets queries, creates a plan to modify the database or
retrieve data, and returns query results to the application.
storage manager - ANS-translates the query processor instructions into low-level
file-system commands that modify or retrieve data.
query optimization - ANS-query processor performs ___________ to ensure that most
efficient instructions are executed on the data
indexes - ANS-storage manager uses ______ to quickly locate data
transaction manager - ANS-Ensures transactions are properly executed. Prevents
conflicts between concurrent transactions. Restores the database to a consistent state
in the event of a transaction or system failure.
log - ANS-a file containing a complete record of all inserts, updates, and deletes
processed by the database. the transaction manager writes these before applying
changes to the database.
catalog/data dictionary - ANS-A directory of tables, columns, indexes, and other
database objects.
