UB MGS 351 - MGS Exam #2 Comprehensive Study Guide (17 pages)

Previewing pages 1, 2, 3, 4, 5, 6 of 17 page document View the full content.
View Full Document

MGS Exam #2 Comprehensive Study Guide



Previewing pages 1, 2, 3, 4, 5, 6 of actual document.

View the full content.
View Full Document
View Full Document

MGS Exam #2 Comprehensive Study Guide

61 views


Pages:
17
School:
University at Buffalo, The State University of New York
Course:
Mgs 351 - Intro to Mgmt Info Systms
Intro to Mgmt Info Systms Documents

Unformatted text preview:

Chapter 3 Databases and Data Warehouses Supporting the Analytics Driven Organization Business intelligence BI collective information that gives you the ability to make effective important and strategic business decisions Analytics the science of fact based decision making OLTP Online Transaction Processing OLAP Online Analytical Processing Database collection of information that you organize and access according to the logical structure of the information Relational database series of logically related two dimensional tables or files for storing information Relation table file Primary key field or group of fields that uniquely describes each record Foreign key primary key of one file that appears in another file Database management system DBMS helps you specify the logical requirements for a database and access and use the information in a database 5 Components of a DBMS 1 DBMS engine 2 Data definition subsystem 3 Data manipulation subsystem 4 Application generation subsystem 5 Data administration subsystem Data warehouse collection of information from many places that supports business analysis activities and decision making The Tool Set of the Analytics Professional The Analytics Life Cycle Data Marts subset of a data warehouse in which only a focused portion of the data warehouse information is kept Information is a resource you must manage and organize to help the organization meet its goals and objectives You need to consider Strategic management support Sharing information with responsibility Information cleanliness Chapter 4 Analytics Decision Support and Artificial Intelligence Brainpower for Your Business DECISIONS AND DECISION SUPPORT Find or recognize the problem need or opportunity Consider ways of solving the problem Examine the merits of each solution and choose the best one Carry out the chosen solution and monitor the results Decision support system DSS a highly flexible and interactive system that is designed to support decision making when the



View Full Document

Access the best Study Guides, Lecture Notes and Practice Exams

Loading Unlocking...
Login

Join to view MGS Exam #2 Comprehensive Study Guide and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view MGS Exam #2 Comprehensive Study Guide and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?