GOLDEN GATE UNIVERSITY
School
of Technology and Industry

 

ITM 319: Data Warehousing/Marts Design and Development - Fall 2004

Instructor: Bob Timlin
Email:      bob@timlin
Web Site:   www.timlin.net
Office:     None Ė Off Site

Bio:
Iíve been in the Information Technology field for over 15 years and have been teaching in this field for over five, mostly at GGU.I obtained my MS in Software Engineering from GGU in 2002 and undergraduate degree in Management Information Technology from Pace University, New York, in 1991.My experience includes over 15 years with Oracle, SQL, C and Unix. I also have five to ten years experience with Java, Visual Basic, PL/SQL, Perl, C++ and many more.

I currently work during the day at California Pacific Medical Center where I work on their Oracle data-warehouse and do web development using Java, JSP, Servlets, etc.Prior to CPMCI worked at Apple Computer on their Oracle data-warehouse.Between the two I have a total of ten years experience with data warehouses.

I am originally from New York and moved out to California in 1992 after a one year stint in Australia. My Californization was completed in 1995 when I gave up red meat and started to eat and like tofu .

Please feel free to consult with me during the semester for assistance. This can be done personally, by phone, or by email. If you call or email, please leave me contact information and the best time to contact you.

 

Donít wait until late in the semester.

Required Text:
Essential Oracle8i Data Warehousing by Wiley Computer Publishing
    Authors: Gary Dodge and Tim Gorman    
    ISBN: 0-471-37678-7

The Data Warehouse Lifecycle Toolkit by Wiley Computer Publishing
    Authors: Ralph Kimball, Laura Reeves, Margy Ross, and Warren Thornthwaite
    ISBN: 0-471-25547-5

Book Store

To purchase course books and materials from eFollett, GGU's official online bookstore, follow this link:

http://shop.efollett.com/htmlroot/storehome/goldengateuniversity690.html

 

University Library

San Francisco students can visit the University General Library. The library's site

(http://internet.ggu.edu/university_library) provides wonderful resources.

 

One of GGUs richest resources is the library and its staff. There are connections to a lot of good, highly

useful information at the library link above. Itís a wonderful resource, and itís value added for you!

 

Students also need to become familiar with library resources in the IS/Management areas; this applies to all

students.

 

Prerequisite: ITM 310 Ė Distributed Systems.

Class Hours: Tuesdays's: 6:50PM Ė 8:50PM Please be on time.

Method of Instruction: Lecture/Lab/Cyber.Instructional material can be found at www.timlin.net

Course Description:
(formerly CIS 328) Provides advanced coverage of data warehousing and data marts. You will be exposed to the components of data warehousing and data marts and will learn how to identify their requirements. Focuses on design and implementation. There will be extensive use of Oracle in our computer labs..

TOPICS (All links can be found at: http://www.timlin.net/ggu/itm319.html):

  1. Introduction to Data Warehouses (Dodge: 1).
  2. Hardware Architectures for Oracle Data Warehousing(Dodge: 2).
  3. Oracle Server Software Architecture and Features(Dodge: 3).
  4. Dimensional Modeling(Kimball: 5, 6, 7).
  5. Designing the Oracle Data Warehouse(Kimball: 4, Dodge: 4).
  6. Building the Oracle Data Warehouse(5).
  7. Populating the Oracle Data Warehouse(6).
  8. Oracle PL/SQL Stored Procedures, Functions, and Triggers(8).
  9. Post-Load Processing in the Data Warehouse(7). 
  10. Administering and Monitoring the Oracle Data Warehouse(8).
  11. Data Warehouse Performance Tuning(9). 
  12. Analytical Processing in the Oracle Data Warehouse(13).
  13. Excel 2000 Pivot Tables and Excel 2000 VBA.
  14. Java and XML ETLEngine

 

SCHEDULED ASSIGNMENTS:

Assigned Date

Description

Due Date

Pre-week 1

Read Chapters 1 in BOTH Books.
Click on the link above for Topic 1 Intro to Data Warehouses (http://www.timlin.net/ggu/dwIntro.html)

12-Oct-04

12-Oct-04

Read Chapters 2 and 3 in the Dodge book
Click on the links above for Topics
2(http://www.timlin.net/ggu/HWArch.html)
and 3 (http://www.timlin.net/ggu/ora_arch.html)

19-Oct-04

19-Oct-04

Read Chapters 5,6, and 7 in the Kimball book
Click on the link above for Topic 4 Dimensional Modeling

26-Oct-04

26-Oct-04

Read Chapter 4 in BOTH Books
Homework #1, Star Schema & Materialized Views

02-Nov-04

02-Nov-04

Read Chapter 5,6, & 8 in the Dodge Book, Expect a Quiz

09-Nov-04

09-Nov-04

Homework #2, SQL Loader

16-Nov-04

16-Nov-04

Homework #3, PL/SQL ETL Trigger 
Read Chapters 8, 9, and 10. in the Kimball book

23-Nov-04

23-Nov-04

Homework #4, ETL Report Parser.

30-Nov-04

30-Nov-04

Homework #5 Oracle OLAP 
Read Chapters 14, 18, and 19 in the Kimball book 

07-Dec-04

07-Dec-04

TBD

14-Dec-04

14-Dec-04

Final Exam, All Assignments Due!

 

Class Assignments:Weekly reading assignments and regular class exercises.All assignments and lecture notes will be available several days prior to class at www.timlin.net.You may be able to purchase a personal version of Oracle9i from Oracleís web-site (www.oracle.com).You must turn in all assignments on time, one AND ONLY ONE late assignment will be forgiven.If you miss a class, it is your responsibility to contact the instructor or another student by email to obtain the current assignment, or any changes to the current assignment.NOTE: While this will usually be available at my web-site, you should still confirm by email in the event of last minute changes.

 

Course Requirements:
1.††††††††††† Class Attendance
2.††††††††††† Assignments
3.††††††††††† Tests
4.††††††††††† Quizzes
5.††††††††††† Projects

Grading Policy:
Quizzes:††††††††††††††††††††††††††††† 10%- Almost weekly quizes based on the prior weeks reading assignment.
Assignments:††††††††††††††††††† 20%
Research Project:            †††††††††††††† 30%
Weekly Questions:††††††††† 10%         
Final Exam:†††††† †††††††††††††† 30%

Average        Grade:
98+††††††† †††††††† A+
94 - 97            A
90 - 93            A-
87 - 89            B+
83 - 86            B
80 - 82            B-
77 - 79            C+
73 - 76            C
70 - 72            C-
67 - 69            D+
63 - 66            D
60 - 62            D-
< 60                F

TurnItIn.com

We will be using the TurnItIn.com resource during the semester. TurnItIn identifies plagiarized papers

quite well. It also provides resources helpful to the student on formatting research papers and using

citations and reference material properly.

 

Your research paper will be submitted to TurnItIn as a resource TO YOU AND TO ME. You should also

submit a final copy of your paper to me as an .rtf file. You MAY submit it as a formatted paper copy if you

want to, but a digital copy must be submitted regardless.

 

* Unless you make arrangements in advance with both instructors, and make those arrangements known, a

paper can be submitted for only one class.

 

 

* Academic Integrity: for your benefit, your GGU courses and programs must have the respect of the

business and academic communities. The world of work expects original thought and ethical behavior from

working professionals.

 

One thing that increasingly compromises the value of your degree is plagiarism. Plagiarism occurs when

work, usually research papers, are incorrectly taken from outside sources and not cited properly, or not

cited at all. Another instance is when student papers have been purchased, or come prepackaged from

another source.

 

University and Instructor Policy on Cheating and Academic Integrity

From the student handbook: "Golden Gate University requires that students be honest in their academic

work. Academic dishonesty is viewed as an ethical issue and the violation of the principles expressed in the

University's Statement of Educational Mission.

 

Academic dishonesty defrauds all those who depend upon the integrity of the University, its course, and its

degrees. Definitions of academic dishonesty, identification and reporting procedures, academic and

administrative sanctions and appeal procedures are outlined in detail in the Griffin (student handbook), and

are available from the Division of Student Affairs."

 

What this means for this class is that all work submitted must either be the original work product of the

student or students (team members), or must be specifically identified as coming from another source. It is

not permissible to copy from other sources without disclosing the source with usual in-text parenthetical

citation and reference page entry.

 

Your papers canít be submitted to more than one GGU course without consent of the instructors involved.

Plagiarism is completely unacceptable and will result in academic review with appropriate consequences as

outlined in the Griffin handbook. If your paper or other work proves to be plagiarized, it can result in your

failing the course. Here are three examples: a paraphrase, a short quote, and a long quote. These are the

most common uses of source material that require citation formatting.

 

For more information on listing sources on a reference page, visit

http://internet.ggu.edu/university_library/cite.html

See also http://www.turnitin.com/research_site/e_citation.html

 

NEW TOPIC: Turnitin.com

The University subscribes to a highly effective plagiarism service that identifies quoted passages in

submitted papers from a huge body of Internet/Web/Research Paper Mill sources. This topic is discussed at more length in the syllabus section on the Research Paper.

 

* More on Academic Integrity: for your benefit, your GGU courses and programs must have the respect

of the business and academic communities. The world of work expects original thought and professional

behavior from working professionals.

 

One thing that increasingly compromises student work these days is plagiarism. Plagiarism occurs when

work, usually research papers, are incorrectly taken from outside sources and not cited. Another instance is

when student papers have been purchased, or come prepackaged from another source.

 

Itís important to me, but more important to you, that your research work is original and that it adheres to

presentation standards common in academia and business.

 

We will be using the Turn tin resource during the semester. Turn tin identifies plagiarized papers quite

well. It also provides resources helpful to the student on formatting research papers and using citations and

reference material properly.

 

 

Research Project Assignment: Your writing project for this course will ask that you develop a business

needs analysis paper of a data-warehouse produce such as an ETL tool or OLAP tool. It will be developed according to criteria presented in class, and will utilize a case.You may pick any data-warehouse tool you like, however you must clear it with me first.

 

If you are a working student with significant experience, you may develop a paper based on a real work

situation, as long as you are able to significantly articulate that work situation prior to start.

 

Research Project

*See the section above on the Writing Center

 

Itís important to me, but more important to you, that your research work is original and that it adheres to

presentation standards common in academia and business.

 

Point value of the research project: up to 30

 

If you use sources, these sources are to be noted on a page named References. The paper should be

formatted in an acceptable style, such as MLA or (preferably) APA.

 

Due Date: 10th week of class.

 

There will be checkpoints during the trimester with your instructor to check progress. These checkpoints

may have points attached.

 

See the University Library and TurnItIn sites for information on formatting, and citing/using sources.

Line spacing should be 1.5 (between single and double spacing).

 

Submit the paper to Turnitin.com as per the syllabus and submit a formatted copy (.rtf if email, or

formatted paper) to me.

 

If you want your paper project back with comments, include a STAMPED self-addressed envelope with the

paper. Donít be stingy with postage.