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;
58 Cards in this Set
- Front
- Back
Information Granularity |
extent of detail within the information (fine and detailed or coarse and abstract) |
|
4 Primary traits of the value of information |
Information type Information timeliness Information quality Information governance |
|
Real-Time information |
Immediate, up-to-date information |
|
Real-time systems |
Provide real-time information in response to requests |
|
Information inconsistency |
When the same data element has different values |
|
Information integrity issues |
when a system produces incorrect, inconsistent, or duplicate data |
|
Data governance |
overall management of the availability, usability, integrity, and security of company data |
|
Database |
maintains information about various type of objects, events, people and places |
|
Database management system (DBMS) |
creates, reads, update and deletes data in a database while controlling access and security |
|
Query by example (QBE) tool |
helps users graphically design the answer to a question against a database |
|
Structured query language (SQL)
|
asks users to write lines of code to answer questions against a database
|
|
Data element (data field) |
smallest or basic unit of information |
|
Data models |
logical data structures that detail the relationships among data elements using graphics or pictures |
|
Metadata |
provides details about data |
|
Data dictionary |
compiles all of the metadata about the data elements in the data model |
|
Relational database model |
stores information in the form of logically related two demential tables |
|
Relational database management system |
Allows users to create, read, update and delete data in a relational database |
|
Entity
|
stores information about a person, place, thing, transition or event
|
|
Attributes |
the data elements associated with an entity |
|
Record |
collection of related data elements |
|
Primary keys |
a field that uniquely identifies a given record in a table |
|
Foreign key |
Primary ey of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables |
|
Physical view of information |
physical storage of information on a storage device |
|
Logical view of information |
how individual users logically access information to meet their own particular business needs |
|
Information redundancy |
the duplication of data or storage of the same data in multiple places |
|
Information inegrity |
A measure of the quality of information |
|
Integrity constraints |
Rules that help ensure the quality of information |
|
Relational integrity constraints |
rules that enforce basic and fundamental information-based contraints |
|
Business rule |
defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer |
|
Business-critical integrity constraints |
enforce business rules vital to an organizations success and often require more insight and knowledge than relational integrity constraints |
|
Content creator |
the person responsible for creating the original website content |
|
Content editor |
the person responsible for updating and maintaining website content |
|
Static information |
fixed data incapable of change in the event of user action |
|
Dynamic information |
data that changes based on users actions |
|
Dynamic catalog |
an area of a website that stores information about products in a database |
|
Data-driven website |
An interactive website kept constantly updated and relevant to the needs of its customers using a database |
|
Data warehouse |
Logical collection of information, gathered from many different operational databases, that supports business analysis actives and decision-making tasks |
|
Extraction, transformation, and loading (ETL) |
process that extracts information from internal and external databases, transforms it using a commons et of enterprise definitions, and loads it into a data warehouse |
|
Information cube
|
The common term for the representation of multidimensional information
|
|
Data mart |
subset of data warehouse information |
|
Information cleansing or scrubbing |
processes that weeds out and fixes or discards inconsistent, incorrect or incomplete information |
|
Data quality audits |
determine the accuracy and completeness of its data |
|
Data mining |
The process of analyzing data to extract information not offered by the raw data alone |
|
Data-mining tools |
variety of techniques to find patters & relationships in large volumes of information that predict future behavior and guide decision making |
|
Untructured data |
do not exist in a fixed location and can include text documents, PDFs, voice messages, e-mails |
|
Text mining |
analyzes unstructured data to find trends & patters in words and sentences |
|
Web mining |
analyzes unstructured data associated with websites to identify consumer behavior and website navigation |
|
Cluster analysis |
Technique to divide information sets into mutually exclusive groups such that the members of each group are as close together as possible to one another and different groups are as far apart as possible |
|
Association detection |
reveals the relationship between variables along with the nature and frequency of the relationships |
|
Market basket analysis |
Analyzes such items as website and checkout scanner information to detect customers' buying behavior and predict future behavior by identifying affinities among customers' choices of product and services |
|
Statistical analysis |
preforms such functions as information correlations, distributions, calculations and variance analysis |
|
Time-series information |
Time-stamped information collected at a particular frequency |
|
Forcasts |
Predictions based on time-series information |
|
Informing |
Accessing large amounts of data from different management information systems |
|
Infographics (information graphics) |
displays information graphically so it can be easily understood |
|
data visualization |
describes technologies that allow users to "see" or visualize data to transformation into business perspective |
|
Data visualization tools |
Sophisticated analysis techniques such as pie charts, controls, instruments, maps, time-series graphs, etc |
|
Business intelligence dashboards |
track corporate metics as critical success factors and key performance indicators and include advanced capabilities such as interactive controls allowing users to manipulate data for analysis |