History of the Data Warehouse

1
History of the Data Warehouse

• John Rome
• Director, Data Administration and Data Warehouse

2
1992
Roseanne Batman Returns Washington
Redskins Chicago Bulls Andre Agassi/Steffi
Graf Barney the Dinosaur 0.29

• Top TV Show
• Top Grossing Movie
• Super Bowl Champs
• NBA Championship
• Wimbledon
• Kids Pick
• Postage

3
1992

• Open House in Moeur Building September 1992
• Data AccessA Piece of Cake
• 11 PC products/6 Macintosh query tools on display
• 250 Faculty/Staff Attended
• Could access student data through demonstration
  tools

4
1992

• Project started to demonstrate the ability to
  make data accessible through a relational
  database (SQL)
• Spent 6 months on prototype
• Server Sun Sparc 630 - 512 MB (RAM) 2
  CPUs (40 Mhz?)
• Storage 4 GB?
• 30 Concurrent Users Threshhold
• 30 Pilot Users

5
30 Original Users of Warehouse
Sheila Ainley David Bear Kent Blaylock Lowell
Crary Nancy Dickson Jim Eberle Cathie
Fox Marilyn Hart Nancy Higgins Darrel
Huish Kurt Johnson Stephanie Jacobson Judy
Kyrala Steve Latino Lois Lehman Pao-Seh
Lin Sarah Lindquist Roger Lurie (2) Marsha
Martin Cyndee Miller (2) Jeani Mitchell Cecile
Morrow John Rome Ernie Santiago Janet
Snell Linda Reed Verne Talavera Tammy Vavra
6
1992 - Original Warehouse Gang
7
1992 - Original Warehouse Gang
8
1992 - Brio

• After an extensive query tool evaluation (thanks
  to Roger Lurie), Data Prism was selected
• Data Prism will eventually became Brio Query and
  is now Brio Enterprise
• Data Pivot was originally a separate product
• ASU was one of Brio Technologies 1st ten
  customers

9
1992 - Sybase

• Original relational database of Data Warehouse
• Started with version 4.9
• Have used version 10.x, 11.x and will migrate to
  12.x.
• Supported tools that talked SQL
• In 1992, Sybase cost more than Brio

10
19931997 (Major Milestones/Events)

• Data Access Policy Approved (1993)
• Famous Aqua Brochure (1993)
• Data Warehouse Training Offered (1994)
• FINANCIAL database developed (1995)
• WUG meetings started (1995)
• Class Roster via the Web (1996)
• Smithsonian Award for Innovation (1997)
• HUMAN_RESOURCE database developed (1997)

11
1997 (5 Years Later)
ER Men in Black Green Bay Packers Chicago
Bulls Pete Sampras/M.Hingis Beanie Babies 0.34

• Top TV Show
• Top Grossing Movie
• Super Bowl Champs
• NBA Championship
• Wimbledon
• Kids Pick
• Postage

12
1997 (5 Years Later)

• Data Warehouse was being used for more reporting
  at University
• More Warehouse/Web development
• Server HP 9000/T500 - 2 GB (RAM)
  4 CPUs (90 Mhz)
• Storage 20 GB?
• 100 Concurrent Users Threshhold
• 350 Users

13
19982001 (Major Milestones/Events)

• Property Control/ Web Site (1998)
• Sponsored Data/Web reports (1999)
• FA database development (1999)
• Comptrollers Web Reports available (2000)
• Governors Award of Excellence (2000)
• Successful ABOR Audit (2001)

14
2002 (10 Years Later)

• Data Warehouse has become Mission-Critical to
  University
• Contract signed with Brio Technology
• Still running on Sybase database
• Server Sun - 3 GB (RAM)
  6 CPUs (450 Mhz?)
• Storage 80 GB
• 250 Concurrent Users Threshhold
• 1781 users (logins to E1)

15
Cost of BRIO( per user)
3.5
5.0.4
6.6
16
Brio Intelligence 6.6 Arrives
Doug Vinzant Leaves
17
Warehouse Users (logins)
18
Distribution of Warehouse Users
19
2002 - Current Gang
20
Ware-q and Friends of Warehouse
Clara Adams Elaine Moore Sue Bishop Hema
Indap Jack Davis Bridgot Allcott Jere
Coon Kathy Hermanson Kato Haws Kevin
Miller Melinda Jobe Sheldon Zola Sherry
Eshkibok Bill Hetke Terry Deasey Kimberly
Sturdy Walter Ellis Cheryl Conover Millie
Torre Joseph Matt Melinda Gebel Keith Elgin IT
Operations Computer Accounts Val Patten Rosa
Corrales Gordon Smith
21
ASU Data Warehouse
OTHERSOURCES
MAINFRAME
LEGACY SYSTEM (DB2/IDMS)
JAVA
UNIX WEB SERVER
OS/390
SQL/JDBC
UNIX
ASP COLD FUSION
SQL/ODBC
SQL/Native
NT WEB SERVER
SQL/ODBC
22
Warehouse Databases Today
PRIMARY
SUPPORT
SPECIAL
DICTIONARY
USER_TABLE
FINANCIAL
HUMAN_ RESOURCE
STUDENT
LOOKUP
SRC
WAREHOUSE (CENSUS)
COURSE
STUDENT_FEE
PERSON
DIRECTORY_ SERVICES
STUDENT_AID SIGMA
SPONSORED
STUDENT_AID
TRAINING()
STUDENT_ RETENTION
WAREHOUSE_ ADMIN
HOPE_TAX_ PROJECT
REPORTING
DARS_ REPORTING
FACILITY_ REPORTING
PROPERTY_CONTROL_ REPORTING
PROXY DBs
March 1, 2002
23
ASUs Data Warehouse 10 Years Old
24
2002 (10 Years Later)
Osbournes? Spiderman? New England Patriots LA
Lakers Pete Sampras/Serena ? 0.37

• Top TV Show
• Top Grossing Movie
• Super Bowl Champs
• NBA Championship
• Wimbledon
• Kids Pick
• Postage