CH 6 MIS Test 1

transactional information
all the information contained within a single business process or unit of work, purpose is to support daily operational tasks
analytical information
contains all organizational information, purpose is to support managerial tasks
characteristics of high-quality information
1. accurate 2. complete 3. consistent 4. unique 5. timely
Database management systems (DBMS)
Allows users to create, read, update, and delete data in a relational database
data element
smallest or basic unit of information
data model
data structure that details relationships among data elements using graphs or pictures
metadata
provides details about data
data dictionary
compiles all of the metadata about the data elements in the data model
entity
place were information is stored (the entire table)
Attribute (column)
data elements associated with an entity (values of a sing field)
record
single line of data
primary key
a key locator and a unique identifier
foreign key
a primary key of one table that appears in another table (relates one table to another)
scalability
refers to how well a system can adapt to increased demands
information integrity
measure the quality of information
integrity constraint
rules that help ensure the quality of information
1. relational
2. business critical
data driven wedsite
An interactive website kept constantly updated and relevant to the needs of its customers using a database
data warehouse
collection of information that supports business decision making tasks
Extraction, transformation, and loading (ETL)
extracts information from internal and external databases transforms info and loads it into a data warehouse
data mart
contains a subset of data warehouse information
Information cleansing or scrubbing
process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information
data mining
The process of analyzing data to extract information not offered by the raw data alone
structured/unstructured data
data already in a database or spreadsheet/data that does not exist in a fixed location
text mining
analyzes unstructured data to find trends and patterns
web mining
analyzed unstructed data associated with websites to identify consumer behavior and website navigation
Cluster analysis
technique used to divide an information set into mutually exclusive groups such that the 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 such functions as information correlations, distributions, calculations, and variance analysis
informing
Accessing large amounts of data from different management information systems
Data visualization
Allows users to “see” or visualize data to transform information into a business perspective