module.2.session.4.slides.a

module.2.session.4.slides.a - BUSMIS1060...

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

View Full Document Right Arrow Icon
Click to edit Master subtitle style  8/11/11 BUSMIS 1060 Module 2: Data Management Session 4: Quality, Privacy, & Security Dr. Russ Robbins
Background image of page 1

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

View Full DocumentRight Arrow Icon
 8/11/11 Quiz 2 due now. Web Presence due, M, 2/14 Midterm Review, F, 2/11, at 4pm, Mervis 115 Midterm Review, F, 2/18, at 4pm, Mervis 115 Midterm on M, 2/21 Quiz 3 due W, 2/23 Final Exam, 4/29, 8am – 9:50am, Room TBD Announcements
Background image of page 2
 8/11/11 CBA Business Review Presentation  Discuss Midterm & Midterm Review Process Midterm Midterm Review Sheets Midterm Reviews Five minutes for Registration Exercise Very, Very Quick RDBMS Concepts Review Very Quick Data Warehouse Concepts Review Cognos BI Demo Data Quality, Security, & Privacy Lecture Agenda
Background image of page 3

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

View Full DocumentRight Arrow Icon
 8/11/11 40 questions, M/C, Problem-Solving Oriented Show students where Midterm Review Materials  Are Start with Midterm Review Sheet Then Go to Midterm Review Slides Midterm
Background image of page 4
 8/11/11 Work through XLM A, B, E, J, K, and be sure to  understand terms. Work through Chapters 1, 2, 3, and 5 Don’t read more into the question than what is  there. For example, if an example is given, use the example. Almost always, more than one answer may seem  correct. Don’t just go with your Initial guess. General Test-taking Guidelines
Background image of page 5

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

View Full DocumentRight Arrow Icon
Click to edit Master subtitle style  8/11/11 Relational Database Review
Background image of page 6
 8/11/11 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 Data Concepts and Skills you should understand  and be able to apply very soon
Background image of page 7

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

View Full DocumentRight Arrow Icon
Click to edit Master subtitle style  8/11/11 Data Warehousing Recap
Background image of page 8
 8/11/11 OLTP vs. OLAP
Background image of page 9

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

View Full DocumentRight Arrow Icon
 8/11/11 OLTP OLA P
Background image of page 10
 8/11/11 Subject-oriented  – the data are organized around  major subjects of the organization, such as  customers, sales, or items produced Integrated  – All the data about the subject are  combined and can be analyzed together Nonvolatile  – The data are typically read-only.  That is, they are not updated or changed by users Features of a Data Warehouse
Background image of page 11

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

View Full DocumentRight Arrow Icon
 8/11/11 Typical Analytical Structure 
Background image of page 12
 8/11/11 Subject-oriented  – the data are organized around  major subjects of the organization, such as  customers, sales, or items produced Integrated  – All the data about the subject are  combined and can be analyzed together Nonvolatile  – The data are typically read-only.  That is, they are not updated or changed by users Features of a Data Warehouse
Background image of page 13

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

View Full DocumentRight Arrow Icon
 8/11/11 Data Marts
Background image of page 14
 8/11/11 http://download.boulder.ibm.com/ibmdl/pub/softwar IBM Cognos BI Tool
Background image of page 15

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

View Full DocumentRight Arrow Icon
Image of page 16
This is the end of the preview. Sign up to access the rest of the 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 / 53

module.2.session.4.slides.a - BUSMIS1060...

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

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