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