module.2.session.3

module.2.session.3 - Module 2: Data Management Session 3:...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Module 2: Data Management Session 3: Data Warehousing Dr. Russ Robbins Database / Relational Database DBMS / DBMS Components Tables / Queries / Forms / Reports Columns / Fields / Rows / Records Primary Keys / Foreign Keys / Relationships SQL / Select / From / Inner Join / Where / QBE Integrity Constraints / Data Types Data Dictionary, Schema Design and Relationship Views Logical vs. Physical View Views / Report Generators CRUD / Create (or Insert) / Read (or Select) / Update / Delete OLTP / OLAP Operational Database / Analytical Database Accounting-oriented / Forecasting-oriented Business Intelligence Data Warehouse / Data Mart / Multidimensional Analysis Tools / Query/Reporting Tools Data Mining / Intelligent Agents / Statistical Tools Data Mining Business intelligence – knowledge about your customers, competitors, business partners, environment, and internal operations which enables effective decision making IT tools help process information to create business intelligence according to… ◦ OLTP (online transaction processing) ◦ OLAP (online analytical processing) OLTP – gathering and processing transaction information and updating existing information to...
View Full Document

This note was uploaded on 08/11/2011 for the course BUSMIS 1060 taught by Professor Robbins during the Spring '09 term at Pittsburgh.

Page1 / 27

module.2.session.3 - Module 2: Data Management Session 3:...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online