Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
33 Cards in this Set
- Front
- Back
Information Granularity |
refers to the extent of detail within the information (fine and detailed, or coarse and abstract) |
|
Transactional information |
includes all of the information contained within a single business process of unity of work; its primary purpose is to support daily operational tasks. |
|
analytical information |
includes all organizational information; its primary purpose is to support the performing of managerial analysis tasks. |
|
Real-time information |
immediate, up-to-date information. |
|
Real-time systems |
provide rel-time information in response to requests. |
|
Data inconsistency |
when the same data element has different values. |
|
Data integrity issues |
when a system produces incorrect, inconsistent, or duplicate data. |
|
5 characteristics of high quality info. |
accurate, complete, consistent, timely, unique |
|
Data governance |
the overall management of the availability, usability, integrity, and security of company data. |
|
2 tools for retrieving info in a DBMS |
query by example tool & structured query language |
|
query-by-example tool |
helps users graphically design the answer to a question |
|
structured query language |
asks users to write lines of code to answer questions in a database. |
|
data element (field) |
smallest of basic unit of info. |
|
Metadata |
provides details about data in a database |
|
data dictionary |
complies all of the metadata about data elements |
|
3 types of data models |
hierarchical, network, & relational |
|
relational DBMS |
allows users to create, read, update, and dele data in a relational database |
|
physical view |
deals with the physical storage of info on a storage device |
|
logical view |
focuses on how individual users logically access info to meet their own particular business needs. |
|
data redundancey |
the duplication of data, or the storage of data in multiple places |
|
Informational integrity |
measures quality of information |
|
integrity constraints |
rules that help ensure the quality of info. |
|
relational integrity contraints |
rules that enforce basic and fundamental info-based constraints |
|
business-critical integrity constraints |
enforces business rules vital to an organization's success. |
|
data-driven website |
interactive website kept constantly updated and relevant to the needs of its customers and using a database |
|
data warehouse |
logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks. |
|
data mart |
contains a subset of data warehouse information; have functional focus |
|
data mining |
process of analyzing data to extract info not offered by raw data alone. |
|
data mining tools |
use a variety of techniques to find patterns and relationships in large volumes of information that predict future behavior and guide decision-making |
|
cluster analysis |
technique used to divide info sets into mutually exclusive groups so that members of each group are as close together as possible to one another and the different groups are as far apart as possible. |
|
association detection |
reveals the relationship between variables along with the nature and frequency of the relationships |
|
statistical analysis |
performs functions such as: info correlations, distributions, calculations, and variance analysis. |
|
Business Intelligence |
provides managers with the ability to make better decisions |