7/2/25, 12:21 AM D426 Data Management Foundations Flashcards | Quizlet
Science Computer Science Save
D426 Data Management Foundations
More
Leave the first rating
Students also studied
Flashcard sets Study guides Practice tests
WGU D426 V2 Data Management Foundations 2.3 - Data Encapsulation ITI 112 L
160 terms 222 terms 10 terms 70 terms
MoDhoches Preview Cameron_Snowden44 Preview jonleefamily Preview Kap
Terms in this set (957)
data Numeric, textual, visual, or audio information that describes real-world systems
scope, format, and access 3 ways data can vary
scope the amount of data produced and collected
format describes that data may be produced as numbers, text, image, audio, or video
describes that some data sets may be private while others are made publicly
access
available
historically, most data was ____, encoded as continuous variations on various physical
analog
media
Today, data is mostly ____, encoded as zeros and ones on electronic and magnetic
digital
media
the shift from analog to digital What facilitated the rise of large computer databases?
database a collection of data in a structured format
database system, also known as database software that reads and writes data in a database.
management system, or DBMS
Data is secure, internally consistent, and DBMS ensures these three things
available at all times
True T/F: Database systems are complex
query a request to retrieve or change data in a database I Accept
We Care About Your Privacy
query language
We and our 909 partners store and/or access information ona aspecialized programming
device, such as language,
unique IDs in cookies designed
to process specifically
personal for
data. You may database
accept or systems
Show Purposes
manage your choices by clicking below, including your right to object where legitimate interest is used, or at any time in the privacy policy page. These
False, query languages differ significantly T/F: query languages are very similar to general purpose languages
choices will be signaled to our partners and will not affect browsing data.
from
We general-purpose languages
and our partners process such
data to as
provide:
Python, Java,geolocation
Use precise and C++ data. Actively scan device characteristics for identification. Store and/or access information on a device. Personalised
advertising and content, advertising and content measurement, audience research and services development.
database application software that helps business users interact with database systems
List of Partners (vendors)
https://quizlet.com/849689765/d426-data-management-foundations-flash-cards/ 1/5
, 7/2/25, 12:21 AM D426 Data Management Foundations Flashcards | Quizlet
Information Management System a software application that manages corporate data for a specific business function
user interface, business logic, and an information management system usually includes a database system as well as
interfaces to other systems other components, such as these three items
sometimes refers to a database system rather than the data managed by the system.
database
Meaning is usually clear from contest.
database adminstrator role responsible for securing the database system against unauthorized users.
database administrator role that enforces procedures for user access and database system availability
role that determines the format of each data element and the overall database
database designer
structure.
this role must balance several priorities, including storage, response time, and
database designer
support for rules that govern the data.
database programmer role that develops the computer programs that utilize a database.
role that writes applications that combine database query languages and general-
database programmer
purpose programming languages.
database user this role is a consumer of data in a database
database user this role requests, updates, or uses stored data to generate reports or information
this role usually accesses the database via applications, but can also submit queries
database user
directly to the database system
transaction a group of queries that must be either completed or rejected as a whole
1. Ensure transactions are processed When processing transactions, a database system must do these three things
completely or not at all
2. Prevent conflicts between concurrent
transactions
3. Ensure transaction results are never lost
The database system must reverse partial What must a database system do if it fails to process a transaction?
results and restore the database to the
values prior to the transaction.
sophisticated transaction management what handles the transaction requirements of database systems?
subsystems of most database systems
describes the internal components and the relationships between components of a
architecture of a database system
database system.
True T/F: At a high level, the components of most database systems are similar.
interprets queries, creates a plan to modify the database or retrieve data, and returns
query processor
query results to the application
query optimization ensures the most efficient instructions are executed on data
translates the query processor instructions into low-level file-system commands that
storage manager
modify or retrieve data.
indexes storage managers use these to quickly locate data
We Caremanager
transaction About Your Privacy ensures transactions are properly executed
We and our manager
transaction 909 partners store and/or access information onprevents
a device, such as unique
conflicts IDs in cookies
between to process
concurrent personal data. You may accept or
transactions
manage your choices by clicking below, including your right to object where legitimate interest is used, or at any time in the privacy policy page. These
choices will be signaled to our partners and will not affect browsing
restoresdata.
the database to a consistent state in the event of a transaction or system
transaction
We and ourmanager
partners process data to provide:
failure
Use precise geolocation data. Actively scan device characteristics for identification. Store and/or access information on a device. Personalised
a file
advertising and content, advertising and content measurement, containing
audience a complete
research and servicesrecord of all inserts,
development. updates, and deletes processed by
log
the database
https://quizlet.com/849689765/d426-data-management-foundations-flash-cards/ 2/5
Science Computer Science Save
D426 Data Management Foundations
More
Leave the first rating
Students also studied
Flashcard sets Study guides Practice tests
WGU D426 V2 Data Management Foundations 2.3 - Data Encapsulation ITI 112 L
160 terms 222 terms 10 terms 70 terms
MoDhoches Preview Cameron_Snowden44 Preview jonleefamily Preview Kap
Terms in this set (957)
data Numeric, textual, visual, or audio information that describes real-world systems
scope, format, and access 3 ways data can vary
scope the amount of data produced and collected
format describes that data may be produced as numbers, text, image, audio, or video
describes that some data sets may be private while others are made publicly
access
available
historically, most data was ____, encoded as continuous variations on various physical
analog
media
Today, data is mostly ____, encoded as zeros and ones on electronic and magnetic
digital
media
the shift from analog to digital What facilitated the rise of large computer databases?
database a collection of data in a structured format
database system, also known as database software that reads and writes data in a database.
management system, or DBMS
Data is secure, internally consistent, and DBMS ensures these three things
available at all times
True T/F: Database systems are complex
query a request to retrieve or change data in a database I Accept
We Care About Your Privacy
query language
We and our 909 partners store and/or access information ona aspecialized programming
device, such as language,
unique IDs in cookies designed
to process specifically
personal for
data. You may database
accept or systems
Show Purposes
manage your choices by clicking below, including your right to object where legitimate interest is used, or at any time in the privacy policy page. These
False, query languages differ significantly T/F: query languages are very similar to general purpose languages
choices will be signaled to our partners and will not affect browsing data.
from
We general-purpose languages
and our partners process such
data to as
provide:
Python, Java,geolocation
Use precise and C++ data. Actively scan device characteristics for identification. Store and/or access information on a device. Personalised
advertising and content, advertising and content measurement, audience research and services development.
database application software that helps business users interact with database systems
List of Partners (vendors)
https://quizlet.com/849689765/d426-data-management-foundations-flash-cards/ 1/5
, 7/2/25, 12:21 AM D426 Data Management Foundations Flashcards | Quizlet
Information Management System a software application that manages corporate data for a specific business function
user interface, business logic, and an information management system usually includes a database system as well as
interfaces to other systems other components, such as these three items
sometimes refers to a database system rather than the data managed by the system.
database
Meaning is usually clear from contest.
database adminstrator role responsible for securing the database system against unauthorized users.
database administrator role that enforces procedures for user access and database system availability
role that determines the format of each data element and the overall database
database designer
structure.
this role must balance several priorities, including storage, response time, and
database designer
support for rules that govern the data.
database programmer role that develops the computer programs that utilize a database.
role that writes applications that combine database query languages and general-
database programmer
purpose programming languages.
database user this role is a consumer of data in a database
database user this role requests, updates, or uses stored data to generate reports or information
this role usually accesses the database via applications, but can also submit queries
database user
directly to the database system
transaction a group of queries that must be either completed or rejected as a whole
1. Ensure transactions are processed When processing transactions, a database system must do these three things
completely or not at all
2. Prevent conflicts between concurrent
transactions
3. Ensure transaction results are never lost
The database system must reverse partial What must a database system do if it fails to process a transaction?
results and restore the database to the
values prior to the transaction.
sophisticated transaction management what handles the transaction requirements of database systems?
subsystems of most database systems
describes the internal components and the relationships between components of a
architecture of a database system
database system.
True T/F: At a high level, the components of most database systems are similar.
interprets queries, creates a plan to modify the database or retrieve data, and returns
query processor
query results to the application
query optimization ensures the most efficient instructions are executed on data
translates the query processor instructions into low-level file-system commands that
storage manager
modify or retrieve data.
indexes storage managers use these to quickly locate data
We Caremanager
transaction About Your Privacy ensures transactions are properly executed
We and our manager
transaction 909 partners store and/or access information onprevents
a device, such as unique
conflicts IDs in cookies
between to process
concurrent personal data. You may accept or
transactions
manage your choices by clicking below, including your right to object where legitimate interest is used, or at any time in the privacy policy page. These
choices will be signaled to our partners and will not affect browsing
restoresdata.
the database to a consistent state in the event of a transaction or system
transaction
We and ourmanager
partners process data to provide:
failure
Use precise geolocation data. Actively scan device characteristics for identification. Store and/or access information on a device. Personalised
a file
advertising and content, advertising and content measurement, containing
audience a complete
research and servicesrecord of all inserts,
development. updates, and deletes processed by
log
the database
https://quizlet.com/849689765/d426-data-management-foundations-flash-cards/ 2/5
