logo image

MIS 4330- Chapter 13

Algorithm
A process or set of operations in a calculation. Most commonly used in data mining is neural networks, decision trees, rules induction, genetic algorithm, classification, regression trees, memory- based reasoning, nearest neighbor, clustering, and etc.
Attribute Hierarchy
A top-down data organization that is used for two main purposes: aggregation and drill-down/ roll up aggression
Business intelligence
A comprehensive, cohesive, and integrated set of tools and processes used to capture, collect, integrate, store, and and analyze data with the purpose of generating and presenting information to support business decision making (business need).
Cube Cache
In multidimensional OLAP, the shared, reserved memory area where data cubes are held. This is also used to speed up data access.
Dashboard
A web-based system that presents key business performance indicators (KPIs) in a single, integrated view with clear and concise graphs.
Data Analytics
A subset of BI functions that encompasses a wide range of mathematical, statistical, and modeling techniques with the purpose of extracting knowledge from data.
Data Cube
The multidimensional data structure used to store and manipulate data in a multidimensional DBMS. These are static , meaning they must be created before they are used, so they cannot be created by an ad hoc query.
Data Extraction
A process used to extract and validate data from an operational database and external data sources prior to their placement in a data warehouse.
Data Filtering
A process used to extract and validate data from an operational database and external data sources prior to their placement in a data warehouse.
Data Mart
A small, single-subject data warehouse subset that provides decision support to small group of people.
Data mining
A process that employs automated tools to analyze data in a data warehouse and other sources and to proactively identify possible relationships and anomalies.
Data Store
The component of the decision support system that acts as a database for storage of business data and business model data.
Data Warehouse
A integrated, subject-oriented, time- variant, nonvolatile, collection of data that provides support for decision making, according to Bill Inmon, the acknowledged father of the data warehouse.
Decision Support System (DSS)
An arrangement of computerized tools used to assist managerial decision making within a business
Dimension tables
In a data warehouse, tables used to search, filter, or classify facts within a star schema. The fact table is in a one-to-many relationship with dimension tables.
Dimensions
In a star schema design, qualifying characteristics that provide additional perspectives to a give fact.
Drill down
Lower levels of aggregation. Primarily used in a decision support to focus on specific geographic areas, business types, needs, and etc…
End-user presentation tool
A data analysis tool that organizes and presents selected data complied by the end-user query tool.
End-user query tool
A data analysis tool that organizes and presents selected data complied by the end-user query tool
Exploratory Analytics
Data analysis that provides ways to discover relationships, trends and patterns among data.
Extraction, transformation, and Loading (ETL)
In data warehouse environment, the integrated processes of getting data from original sources into the data warehouse. This includes retrieving data from original data sources, manipulation the data into a appropriate form, and storing the data in the data warehouse.
Fact Table
The star schema that contains facts linked an classified through their common dimensions. A fact table is in a one-to-many relationship with each associated dimension table.
Facts
The measurements that represent a specific business aspect or activity. For example, sale figures are numeric measurements. facts are usually units, cost, prices, and revenues.
KPIs (Key Performance Indicators)
Quantifiable numeric or scale-based measurements that assess a company’s effectiveness or success in reaching strategic and operational goals. Example: turnover rates, sales by promotions, earning per share, and etc.
Master Data Management (MDM)
A collection of concepts, techniques, and processes for the proper identification, definition, and management of data elements within an organization.
Materialized View
A dynamic table that not only contain the SQL query command to generate rows but stores the actual rows. If this is created for the first time, they query is run and the summary rows are stored in the table. Rows are automatically updated when the base tables are updated.
Metrics
Numeric facts that measure a business characteristic of interest to the end user.
Multidimensional Database Management System
A system that uses proprietary techniques to store data in a matrix like arrays of n dimensions known to cubes.
Multidimensional online analytical processing
An extension of online analytical processing to multidimensional database management systems
Online Analytical Processing (OLAP)
Decision support system tools that use multidimensional data analysis techniques. This creates an advanced data analysis environment that support decision making, business modeling, and operations research.
Partitioning
The process of splitting a table into subsets of rows or columns
Periodicity
Information about the time span of data stored in a table, usually expressed as current year only, previous years, or all years.
Portal
A unified, single point of entry for information distribution
Predictive analytics
Advance statistical and modeling techniques to predict future business outcomes with great accuracy.
Relational online analytical processing (ROLAP)
Analytical processing functions that use relational database and familiar relational query tools to store and analyze multidimensional data.
Replication
The process of creating and imagine duplicate versions of a database. This is used to place copies in different locations and to improve accesss time and fault tolerance
Roll Up
An OLAP extension used with the GROUP BY clause to aggregate data by different dimensions. This is the exact opposite of drilling down the data.
Slice and Dice
The ability to cut slices off a data cube to perform a more detailed analysis
Snowflake Schema
A data modeling technique used to map multidimensional decision support data into a relational database. This is known to have a one-to-many relationship with one or more dimension tables.
Very Large Databases (VLDBs)
Databases that contain huge amount of gigabyte, terabyte, and petabyte ranges are not unusual.
In business intelligence framework, data are captured from a production system and placed in ___?
A) Decision support system
B) Portal
C) Data warehouse
D) Dashboard
C) Data Warehouse
__ tools focus on the strategic and tactical use of information.
A) Business
B) Relational database management
C) Business Intelligence
D) Networking
C) Business Intelligence
From a data analyst’s point of view, decision support data differ from operational data in three main areas: time span, granularity, and etc…
A) Usability
B) Dimensionality
C) Transaction Processing
D) Sparsity
B) Dimensionality
Operational data are commonly stored in many tables, and stored data represent information about give __ only.
A) Transaction
B) Database
C) Table
D) Concept
A) Transaction
___ can server as a test vehicle for companies exploring the potential benefits of a data warehouse
A) Data networks
B) Data mart
C) Data cubes
D) OLAPs
B) Data mart
The basic star schema has four components: facts, ___, attributes, and attribute hierarchies.
A) Keys
B) Relationships
C) Cube
D) Dimensions
D) Dimensions
In a start schema representation, a fact table is related to each dimension in a ____ relationship
A) many-to-one
B) many-to-many
C) one-to-many
D) one-to-one
A) or C)
Facts and dimension tables are related by ___ keys.
A) Shared
B) Primary
C) Foreign
D) linked
C) foreign keys
A ___ schema is a type of star schema in which dimension tables can have their own dimension tables.
A) snowflake
B) star flake
C) dimension
D) Matrix
A) Snowflake
Decision support data tend to be non-normalized, ___, pre-aggrated
A) Unique
B) Duplicated
C) Optimized
D) Sorted
B) Duplicated

Need essay sample on "MIS 4330- Chapter 13"? We will write a custom essay sample specifically for you for only .90/page

Can’t wait to take that assignment burden offyour shoulders?

Let us know what it is and we will show you how it can be done!
×
Sorry, but copying text is forbidden on this website. If you need this or any other sample, please register
Signup & Access Essays

Already on Businessays? Login here

No, thanks. I prefer suffering on my own
Sorry, but copying text is forbidden on this website. If you need this or any other sample register now and get a free access to all papers, carefully proofread and edited by our experts.
Sign in / Sign up
No, thanks. I prefer suffering on my own
Not quite the topic you need?
We would be happy to write it
Join and witness the magic
Service Open At All Times
|
Complete Buyer Protection
|
Plagiarism-Free Writing

Emily from Businessays

Hi there, would you like to get such a paper? How about receiving a customized one? Check it out https://goo.gl/chNgQy