ISOM Chapter 6
determines which things go together
affinity grouping
encompasses all organizational information, and its primary purpose is to support the performing of managerial analysis tasks
analytical information
Market ____ analysis analyzes such items 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.
basket
What is a collection of large, complex data sets, including structured and instructed data, which cannot be analyzed using traditional database methods and tools?
big data
What enforces business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints?
business-critical integrity constraints
assings records to one of a predefined set of classes
classification
What is 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?
cluster analysis
segments a heterogenous population of records into a number of more homogenous subgroups
clustering
integrity ___ are rules that help ensure the quality of information
constraints
Who is responsible for creating the original website content?
content creator
An information ____ is the common term for the representation of multidimensional information.
cube
Business intelligence ____ 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.
dashboards
what compiles all of the metadata about the data elements in the data model?
data dictionary
What moves beyond excel graphs and charts into sophisticated analysis techniques such as pie charts, controls, instruments, maps, time-series graphs and more?
data visualization tools
what maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses)?
database
___ computing processes and manages algorithms across many machines in a computing environment
distributed
What is an area of a website that stores information about products in a database?
dynamic catalog
What stores information about a person, place, thing, transaction, or event?
entity
determines values for an unknown continuous variable behavior or estimated future value
estimation
___, transformation, and loading is 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.
extraction
____ are predictions based on time-series information.
forecasts
What is 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?
foreign key
information ____ refers to the extent of detail within the information (fine and detailed or coarse and abstract).
granularity
Which of the following are problems associated with dirty data?
incorrect data, duplicate data, non-formatted data
Three accurate statements reflecting the business advantages of a relational database
increased information security, increased information integrity, reduced information redundancy
four primary traits of the value of information
information timeliness, information quality, information type, information governance
The ____ view of information focuses on how individual users logically access information to meet their own particular business needs
logical
____- generated data is created by a machine without human intervention
machine
What is the practice of gathering data and ensuring that it is uniform, accurate, constant, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems?
master data management
What provides details about data?
metadata
a ____- by-example tool helps users graphically design the answer to a question against a database
query
___ - time information means immediate, up-to-date information
real
What is a collection of related data elements?
records
____ integrity constraints are rules that enforce basic and fundamental information-based constraints.
relational
What stores information in the form of logically related two-dimensional tables?
relational database model
___ information includes fixed data incapable of change in the event of a user action
static
____ data has a defined length, type and format and includes numbers, dates, or strings such as customer address.
structured
Real- time ___ provide real time information in response to requests
systems
Encompasses all of the information contained within a single business process or unit of work, and its primary purpose is to support daily operational tasks
transactional information
Four functions that a database management system can perform on data in a database
update data, read data, delete data, create data
What analyzes unstructured data associated with websites to identify consumer behavior and website navigation
web analytics