PA and OA set Flashcards
Organization of data for the purpose of producing desired information involves:
recording, classifying, sorting, summarizing, calculating, disseminating and storing data.
Data Processing
____ is the the result of processing raw facts to reveal its meaning.
Data
______ is the result of revealing the meaning of raw facts.
information
_____ is the body of information and facts about a specific subject.
knowledge
Accurate, relevant, and timely information is the key to _____.
good decision making
_____ serve as the intermediary between the user and the database.
Database Management System
The database structure in a DBMS is stored as a _____.
collection of files
A desktop database is a _____ database.
single-user
To reveal meaning, information requires _____.
context
Raw data must be properly _____ for storage, processing and presentation.
formatted
_____ describe the data characteristics and the set of relationships that links the data found within the database.
Metadata
Where end-user data are integrated and managed.
- The _____ itself is stored as a collection of files
- The only way to access the data in those files is through the DBMS.
database structure
_____ receive all application requests and translate them into the complex operations required to fulfill those requests.
database programming languages
One disadvantage of the DBMS is that it increases the risk of data _____.
security breaches
A _____ can store data derived from many sources.
data warehouse
- database is designed for transactional processing, while
- A data warehouse is optimized for analytical processing of data from multiple sources.
_____ is raw facts of interest to the end user.
end-user data
______ provide a description of the data characteristics and the set of relationships that link the data found within the database.
Metadata
Where end-user data are integrated and managed.
- _____ exists when different versions of the same data appear in different places
- In essence, ________ is a consequence of poorly managed data redundancy.
data inconsistency
Say a customer’s address is stored in both:
- the customer relationship management (CRM) system
- marketing database
inconsistencies can arise if the address is updated in one system but not the other
The response of the DBMS to a query is the _____.
query result set
A(n) ______ database is used by an organization and supports many users across many departments.
enterprise
Workgroup databases are designed for smaller teams or departments, while enterprise databases support larger organizations with many users and departments.
A(n) _____ database supports a relatively small number of users (usually fewer than 50) or a specific department within an organization.
workgroup
- Workgroup databases are designed for smaller teams or departments, while
- Enterprise databases support larger organizations with many users and departments.
A workgroup database is a(n) _____ database.
multi-user
Data warehouse contains historical data obtained from the_____.
operational databases
_____ data exist in the format in which they were collected.
unstructured
as is