Data Management Foundations Study Guide C175 GRADED A+ 2024\202
Study online at https://quizlet.com/_h5pucy
·Helps organizations use data / informa-
Why databases?
tion as a resource to make decisions
o Attempt to computerize old manual fil-
ing system
o Was easy to retrieve small amounts of
information from
File based structure (Prior to BDMS) o As data grew, it became difficult to lo-
cate and retrieve information
o Retrieval speed depended on file struc-
ture and how data was organized within
the structure
File types that utilized file based struc- Flat files, heap files, Index files, hashed
ture files
no internal hierarchy and data is unstruc-
Flat files
tured
unsorted set of records uniquely identi-
fied by record ID
Heap files
-allows heap files to be inserted or delet-
ed using ID
· File that stores a list of Look Up Field
values from data file that includes the
location (address) in the data file of the
corresponding record
· Smaller than the entire record, usually
index files fits in main memory for quick look up
· Lists keywords and phrases that are in
a particular file
· Becomes a pointer to the location in the
file where the information can be found
when stored with keywords and phrases
· Uses hash functions to decide where
records should be placed on a disk
hashed files
· Allows for faster data look up without the
use of an index file
data
, Data Management Foundations Study Guide C175 GRADED A+ 2024\202
Study online at https://quizlet.com/_h5pucy
raw facts not processed to reveal mean-
ing. Requires transformation to better un-
derstand.
o Produced by Processing Raw Data to
reveal its meaning
information o Key to good decision making and busi-
ness survival is accurate, relevant, and
timely information
o Information and facts about a specific
subject
o Implies familiarity awareness and un-
knowledge derstanding of Information
o Key Characteristic is that New Knowl-
edge can be derived from Old Knowl-
edge
o A discipline that focuses on the proper
data management
generation, storage, and retrieval of data
o An intermediary between user and
database
role of the DBMS
o Receives all application requests and
translates them into complex operations
-Improves data sharing
-improves data security
-better data integraiton
advantages of DBMS -minimize data inconsistency
improvs Data access
-improves decision making
-increases End-User Productivity
A comprehensive approach to ensuring
Data quality the accuracy, validity, and timeliness of
data.
· exists when different versions of the
data inconsistency
same data appear in different places
o Supports and reflects critical
day-to-day operations that must be
recorded accurately and immediately
Study online at https://quizlet.com/_h5pucy
·Helps organizations use data / informa-
Why databases?
tion as a resource to make decisions
o Attempt to computerize old manual fil-
ing system
o Was easy to retrieve small amounts of
information from
File based structure (Prior to BDMS) o As data grew, it became difficult to lo-
cate and retrieve information
o Retrieval speed depended on file struc-
ture and how data was organized within
the structure
File types that utilized file based struc- Flat files, heap files, Index files, hashed
ture files
no internal hierarchy and data is unstruc-
Flat files
tured
unsorted set of records uniquely identi-
fied by record ID
Heap files
-allows heap files to be inserted or delet-
ed using ID
· File that stores a list of Look Up Field
values from data file that includes the
location (address) in the data file of the
corresponding record
· Smaller than the entire record, usually
index files fits in main memory for quick look up
· Lists keywords and phrases that are in
a particular file
· Becomes a pointer to the location in the
file where the information can be found
when stored with keywords and phrases
· Uses hash functions to decide where
records should be placed on a disk
hashed files
· Allows for faster data look up without the
use of an index file
data
, Data Management Foundations Study Guide C175 GRADED A+ 2024\202
Study online at https://quizlet.com/_h5pucy
raw facts not processed to reveal mean-
ing. Requires transformation to better un-
derstand.
o Produced by Processing Raw Data to
reveal its meaning
information o Key to good decision making and busi-
ness survival is accurate, relevant, and
timely information
o Information and facts about a specific
subject
o Implies familiarity awareness and un-
knowledge derstanding of Information
o Key Characteristic is that New Knowl-
edge can be derived from Old Knowl-
edge
o A discipline that focuses on the proper
data management
generation, storage, and retrieval of data
o An intermediary between user and
database
role of the DBMS
o Receives all application requests and
translates them into complex operations
-Improves data sharing
-improves data security
-better data integraiton
advantages of DBMS -minimize data inconsistency
improvs Data access
-improves decision making
-increases End-User Productivity
A comprehensive approach to ensuring
Data quality the accuracy, validity, and timeliness of
data.
· exists when different versions of the
data inconsistency
same data appear in different places
o Supports and reflects critical
day-to-day operations that must be
recorded accurately and immediately
