News

 

 

29/05/2013
Fernando Proença presented his dissertation defense at 3:00 pm in the Prof. Mauro Biajiz Auditorium.


12/13/2012
Renata Tsuruda presented her dissertation defense at 3:00 pm in the Room 4.


11/19/2012
Francisco Pirolla presented his dissertation defense at 2:30 pm in the Prof. Mauro Biajiz Auditorium.


09/27/2012
Claudia Amadeu presented her qualification exam at 2:30 pm in the Room 4.


08/08/2012
Rodrigo Ayres presented his dissertation defense at 2:00 pm in the Teaching Laboratory VI.


07/30/2012
Arturo Baldárrago presented his dissertation defense at 9:30 am in the Prof. Mauro Biajiz Auditorium.

Main Menu

Logo CCBD

SCC-245: Data Analytical Processing

 

Date

(mm/dd/yyyy)

Lectures (in portuguese)

12/09/2010

- Presentation about Geographical Data Warehouse

- Substitutive Test

12/02/2010

- Presentation of Chapters 14 of Ralph Kimball's book "The Data Warehouse Toolkit"

- 2nd Test

11/30/2010

- Presentation of Chapters 8 and 13 of Ralph Kimball's book "The Data Warehouse Toolkit"

- Oracle Data Integrator (Practical Class)

  • Continuation of the previous class about Oracle Data Integrator: Interfaces for Data Integration (continuation), Packages and Scenarios (Renata Tsuruda)
11/25/2010

- Presentation of Chapters 10, 11 and 12 of Ralph Kimball's book "The Data Warehouse Toolkit"

- Oracle Data Integrator (Practical Class)

  • Continuation of the previous class about Oracle Data Integrator: Data Quality Control and Interfaces for Data Integration (Renata Tsuruda)
11/18/2010

- Presentation of Chapters 6, 7 and 9 of Ralph Kimball's book "The Data Warehouse Toolkit"

- Oracle Data Integrator (Theoretical Class)

  • Introduction (Renata Tsuruda)
11/16/2010

- Bitmap Index

  • FastBit and Bitmap Join Index (Anderson Carniel)
10/21/2010

- Presentation of Chapter 5 of Ralph Kimball's book "The Data Warehouse Toolkit"

- 1st Test

10/14/2010

- Presentation of Chapters 3 and 4 of Ralph Kimball's book "The Data Warehouse Toolkit"

- Comparing the Performance of Queries in Denormalized DWs, Normalized DWs and Materialized Views

  • Materialized Views in Oracle (Renata Tsuruda)
  • Script for Creating Tables
09/30/2010

- Materialized Views (Practical Class)

  • Continuation of the previous class about Materialized Views (Bruno Tomazela)
09/23/2010

- Computer Week, USP - São Carlos, SP, Brazil

09/16/2010

- Materialized Views (Practical Class)

  • Materialized Views in Oracle (Bruno Tomazela)
  • Soccer Championships Project: Entity-Relationship and Relational Model Diagrams
  • Script for Creating Tables
  • Script for Inserting Data
08/26/2010

- Materialized Views (Theoretical Class)

  • Materialized Views (Cristina Ciferri)
  • VisualTPCH: A Tool for Generating Synthetic Data for Data Warehouse
  • Benchmark SSB
08/19/2010

- Star Schema

  • Star Schema Creation Process. Material based in Chapter 2 of the book KIMBALL, R., ROSS, M. The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, 2nd edition. John Wiley and Sons, Inc., 2002. ISBN 0-471-20024-7. (Cristina Ciferri)
08/12/2010

- Introductory Material

  • Multidimensional Modeling (Cristina Ciferri)
08/05/2010

- Introductory Material

  • Introduction (Cristina Ciferri)
  • Data Warehouse Environment Architecture (Cristina Ciferri)