MIS Chapter 6 Flashcards
Association Detection
Reveals the relationship between variables along with the nature and frequency of the relationships.
Attribute
The data elements associated with an entity.
Business-Critical Integrity Constraint
Enforces business rules vital to an organization’s success and often requires more insight and knowledge than relational integrity constraints.
Business Rule
Defines how a company performs a certain aspect of its business and typically results in either a yes/no or true/false answer.
Business Intelligence Dashboard
Track corporate metrics such as critical success factors and key performance indicators and include advanced capabilities such as interactive controls, allowing users to manipulate data for analysis.
Cluster Analysis
A technique used 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 the different groups are as far apart as possible.
Content Creator
The person responsible for creating the original website content.
Content Editor
The person responsible for updating and maintaining website content.
Data Dictionary
Compiles all of the metadata about the data elements in the data model.
Data Element (or Data Field)
The smallest or basic unit of information.
Data Governance
Refers to the overall management of the availability, usability, integrity, and security of company data.
Data Mart
Contains a subset of data warehouse information.
Data Mining
The process of analyzing data to extract information not offered by the raw data alone.
Data Model
Logical data structures that detail the relationships among data elements using graphics or pictures.
Data Quality Audit
Determines the accuracy and completeness of its data.
Data Visualization
Describes technologies that allow users to “see” or visualize data to transform information into a business perspective.
Data Visualization Tools
Moves beyond excel graphs and charts into sophisticated analysis techniques such as pie charts, controls, instruments, maps, time-series graphs, ect.
Data Warehouse
A logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks.
Database
Maintains information about various types of objects (inventory), events (transactions, people (employees), and places (warehouses).
Database Management System (DBMS)
Creates, reads, updates, and deletes data, in a database while controlling access and security.
Data-Driven Website
An interactive website kept constantly updated and relevant to the needs of its customers using a database.
Data-Mining Tool
Uses a variety of techniques to find patterns and relationships in large volumes of information that predict future behavior and and guide decision making.
Dynamic Catalog
An area of a website that stores information about products in a database.
Dynamic Information
Includes data that change based on user actions. For example, static websites supply only information that will not change until the content editor changes the information.
Entity
Stores information about a person, place, thing, transaction, or event.
Extraction Transformation, and Loading (ELT)
A process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse.
Forecasts
Predictions based on time-series information.
Foreign Key
A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.
Inforgraphic (or Information Graphic)
Displays information graphically so it can be easily understood.
Information Cleansing or Scrubbing
A process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.
Information Cube
The common term for the representation of multidimensional information.
Information Granularity
The extent of detail within the information (fine and detailed or course and abstract).
Information Inconsistency
Occurs when the same data element has different values.
Information Integrity
A measure of the quality of information.
Information Integrity Issues
Occurs when a system produces incorrect, inconsistent, or duplicate data.
Information Redundancy
The duplication of data, or the storage of the same data in multiple places.
Informing
Accessing large amounts of data from different management information systems.
Integrity Constraint
Rules that help ensure the quality of information.
Logical View of Information
Shows how individual users logically access information to meet their own particular business needs.
Market Basket Analysis
Analyzes such inters as websites and checkout scanner information to detect customers’ buying behavior and predict future behavior by identifying affinities among customers’ choices of products and services.
Metadata
Details about data.
Physical View of Information
The physical storage of information on a storage device.
Primary Key
A field (or group of fields) that uniquely identifies a given record in a table.
Query-By-Example (QBE) Tool
Helps users graphically design the answer to a question against a database.
Real-Time Information
Immediate, up-to-date information.
Real-Time System
Provides real-time information in response to requests.
Record
A collection of related data elements.
Relational Database Management
Allows users to create, read, update, and delete data in a relational database.
Relational Database Model
Stores information in the form of logically related two-dimensional tables.
Relational Integrity Constraint
Rules that enforce basic and fundamental information-based constraints.
Static Information
Includes fixed data that are not capable of change in the event of a user action.
Statistical Analysis
Performs such functions as information correlations, distributions, calculations, and variance analysis.
Structured Data
Data already in a database or a spreadsheet.
Structured Query Language (SQL)
Users write lines of code to answer questions against a database.
Text Mining
Analyzes unstructured data to find trends and patterns in words and sentences.
Time-Series Information
Time-stamped information collected at a particular frequency.
Unstructured Data
Data that do not exist in a fixed location and can include text documents, PDFs, voice messages, emails, ect.
Web Mining
Analyzes unstructured data associated with websites to identify consumer behavior and website navigation.
