{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

module.2.session.3 - Module2:DataManagement...

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

View Full Document Right Arrow Icon
Module 2: Data Management Session 3: Data Warehousing Dr. Russ Robbins
Background image of page 1

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

View Full Document Right Arrow Icon
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
Background image of page 2
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
Background image of page 3

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

View Full Document Right Arrow Icon
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)
Background image of page 4
OLTP  – gathering and processing transaction  information and updating existing information to  reflect transactions Databases support OLTP Operational database  – database that supports OLTP 
Background image of page 5

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

View Full Document Right Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}