Chapter 3 Notes

3 Pages
47 Views
Unlock Document

Department
Financial Accounting
Course
MGAC70H3
Professor
Tim Richardson
Semester
Winter

Description
Chapter 3 NotesIntroductionneed business intelligence BIcollective info about customers competitors business partners competitive environment and own internal operationsthat gives the ability to make effective important and often strategic business decisionsbusiness intelligence enables an organization to extract the true meaning of information so that employees can take creative and powerful steps to ensure a competitive advantage such as customer relationship managementonline transaction processing OLTP is the gathering of input information processing of that information and updating of existing information to reflect the gathered and processed informationdatabases that support OLTP are most often referred to as operational databasesinside these operational databases is valuable information that forms the basis for business intelligenceonline analytical processing OLAP is the manipulation of information to support decision makinga data warehouse is a special form of a database that contains information gathered from operational databases for the purpose of supporting decisionmaking tasks data warehouses only support OLAPThe Relational Database Modelany database is a collection of information that is organized and accessed according to the logical structure of that informationa relational database uses a series of logically related twodimensional tables or files to store info in the form of a databasea relational database is actually composed of two distinct parts 1 the information itself stored in a series of twodimensional tables files or relations and 2 the logical structure of that informationDatabase Management System Toolsa database management system DBMS helps to specify the logical organization for a database and use info within a databasea DBMS contains 5 important software components1 DBMS engine 2 data definition subsystem 3 data manipulation subsystem 4 application generation subsystem and 5 data administration subsystemDBMS engine accepts logical requests from the various other DBMS subsystems converts them into their physical equivalent and actually accesses the database and data dictionary as they exist on a storage devicethe physical view of info deals with how info is physically arranged stored and accessed on some type of storage devicethe logical view of info focuses on how a knowledge worker need to arrange and access info to meet particular business needsdatabases and DBMSs provide 2 great advantages in separating the logical from the physical view of info1 DBMS engine handles the physical tasks so a database user can concentrate solely on logical info needs and 2 although there is only one physical view of info there may be numerous knowledge workers w
More Less

Related notes for MGAC70H3

Log In


OR

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


OR

By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.


Submit