MIS 313 (Test2)

What is a tool that asks users to write lines of code to answer questions against a database? A) Structured query language B) Query-by-example tool C) Data mining tools

A) structured query language

_____ ______ (AI) simulates human thinking and behavior, such as the ability to reason and learn

Artificial intelligence

What are the "data elements" associated with an "entity"? A) Metadata B) Attributes C) Keys

B) Attributes

Which tool helps users graphically design the answer to a question against a database? A) Structured query language B) Query-by-example C) Database management system D) Data warehouse

B) Query-by-example

_______ critical integrity constraints enforce business rules vital to an organizations success and often require more insight and knowledge than relational integrity constraints.

Business

Who is the person responsible for updating and maintaining website content? A) content administrator B) content creator C) content editor

C) content editor

_______ is the aggregation of data from simple roll-ups to complex groupings of interrelated information

Consolidation

Compiles all the "metadata" about the "data elements" in the "data model".

Data Dictionary

The two terms representing the smallest or basic unit of information.

Data element Data field

____ ______ is the process of analyzing data to extract information not offered by the raw data alone.

Data mining

_____ ______ describes technologies that allow users to "see" or visualize data to transform information into a business perspective.

Data visualization

____ ________ ____ move beyond Excel graphs and charts into sophisticated analysis techniques such as pie charts, controls, instruments, maps, time-series graphs, and more

Data visualization tools

______-______ ______ use a variety of techniques to find patterns and relationships in large volumes of information and infer rules from them that predict future behavior and guide decision making.

Data-mining tools

_____ _____ ______ (DSSs) model information using OLAP, which provides assistance in evaluating and choosing among different courses of action. DSSs enable high-level managers to examine and manipulate large amounts of detailed data from different internal and external sources.

Decision support systems

_____-_____ enables users to view details, and details of details, of information.

Drill-down

3 advantages of a data-driven website are

Easy to eliminate human errors Easy to store large amounts of data Easy to manage content

What stores information about a person, place, thing, transaction, or event?

Entity

_______ systems are computerized advisory programs that imitate the reasoning processes of experts in solving difficult problems.

Expert

_____ ______ is a mathematical method of handling imprecise or subjective information.

Fuzzy logic

____-____ analysis finds the inputs necessary to achieve a goal such as a desired level of output.

Goal-seeking

_______ refers to the level of detail in the model or the decision-making process.

Granularity

________ displays information graphically so it can be easily understood.

Infographics (information graphics)

_______ ______ or scrubbing is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.

Information cleansing

________ is accessing large amounts of data from different management information systems

Informing

_________ allow separate systems to communicate directly with each other, eliminating the need for manual entry into multiple systems.

Integrations

_______ _______ are various commercial applications of artificial intelligence.

Intelligent systems

_______ is the process within a genetic algorithm of randomly trying combinations and evaluating the success (or failure) of the outcome.

Mutation

________ ______ _______ (OLAP) is the manipulation of information to create business intelligence in support of strategic decision making

Online analytical processing

______ ________ ______ (OLTP) is the capture of transaction and event information using technology to (1) process the information according to defined business rules, (2) store the information, and (3) update existing information to reflect the new information.

Online transaction processing

______ ______, an extension of goal-seeking analysis, finds the optimum value for a target variable by repeatedly changing other variables, subject to specified constraints.

Optimization analysis

________ analysis, a special case of what-if analysis, is the study of the impact on other variables when one variable is changed repeatedly.

Sensitivity

_____-____-_____ is the ability to look at information from different perspectives

Slice-and-dice

4 functions a database management system can perform on data in a database

Update Data Create Data Delete Data Read Data

___-__ analysis checks the impact of a change in a variable or assumption on the model

What-if

A ______ is a 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

A ______ _______ contains a subset of data warehouse information.

data mart

A _______ ________ is a logical collection of information—gathered from many different operational databases—that supports business analysis activities and decision-making tasks.

data warehouse

A common tool that supports visualization is a ____ _______, which tracks key performance indicators (KPIs) and critical success factors (CSFs) by compiling information from multiple sources and tailoring it to meet user needs.

digital dashboard

An _____ _______ _______ (EIS) is a specialized DSS that supports senior-level executives and unstructured, long-term, nonroutine decisions requiring judgment, evaluation, and insight.

executive information system

A _____ _______ is an artificial intelligence system that mimics the evolutionary, survival-of-the-fittest process to generate increasingly better solutions to a problem.

genetic algorithm

An ______ _______ is a special-purpose knowledge-based information system that accomplishes specific tasks on behalf of its users.

intelligent agent

At the ________ level, employees are continuously evaluating company operations to hone the firm's abilities to identify, adapt to, and leverage change.

managerial

A _____ is a simplified representation or abstraction of reality. Models help managers calculate risks, understand uncertainty, change variables, and manipulate time to make decisions.

model

A ______ ______, also called an artificial neural network, is a category of AI that attempts to emulate the way the human brain works.

neural network

The _______ view of information deals with the physical storage of information on a storage device.

physical

Metadata

provides details about data

Information ___________ is the duplication of data, or the storage of the same data in multiple places.

redundancy

These types of decisions are considered ______ decisions; they occur in situations in which a few established processes help to evaluate potential solutions, but not enough to lead to a definite recommended decision.

semistructured

A ______ ____ is software that will search several retailer websites and provide a comparison of each retailer's offerings including price and availability.

shopping bot

At the ______ level, managers develop overall business strategies, goals, and objectives as part of the company's strategic plan

strategic

A _____ _______ ________ (TPS) is the basic business system that serves the operational level (analysts) and assists in making structured decisions.

transaction processing system

Strategic decisions are highly ________ decisions, occurring in situations in which no procedures or rules exist to guide decision makers toward the correct choice.

unstructured

extraction, transformation, and loading (ETL)

which is a process that extracts information from internal and external databases, transforms the information using a common set of enterprise definitions, and loads the information into a data warehouse