SIS Hardware Update: The Back End

1
SIS Hardware Update The Back End the Front End

• UTFAB Presentation
• October 31, 2007
• Rusty Scott

2
SIS Back-End Hardware Upgrade Before
After
Back-end - All Oracle Applications
Oracle DB 1 - SIS
Oracle DB 2 Other
Banner Application
Portal/ RAMweb
2
3
SIS Hardware Costs

• UTFAB - 173,000
• Exactly as approved by the UTFAB last year
• Central Administration - 173,000
• Information Systems 5,000
• The balance needed for the entire project

3
4
Results of Back-End Hardware Upgrade

• Every request for registration this fall was met
  during add/drop
• Original prime objective of the UTF!!!
• Also allowed a full SIS database refresh in lt 24
  hours
• Prior projection was 60 hours
• Database server has headroom for future
• A great success!

4
5
Pause for Discussion and Questions
5
6
Front End Infrastructure

• The RamPoint Portal
• The Message Broker (a nerve center)
• Traffic cop that feeds all critical systems
  with student and course data
• RamPoint Identities, roles
• RamCT Persons, courses, instructors,
  enrollments

6
7
RamPoint The Nerve Center
RamWEB
RamCT
Libraries, Research Services, Group Course Tools
RamPoint Portal
ARIES-SIS
Kuali
FAMIS
Email/Collaboration
7
8
Rampoint Usage Logins/Month
8
9
RamPoint Usage Tab Stats
9
10
Front End Upgrade Proposal

• Now 4 years old
• 25k/yr maintenance cost (very expensive)
• Maintenance included in SIS annual costs (50)
• Older software platform
• Concurrent user-limited
• Options
• Maintain continue with existing systems until
  they melt
• Build deconstruct and replicate all front-end
  services
• Integration all of those plus new services
  infeasible!
• Buy upgrade to new, scalable architecture

10
11
Front-end Proposed Upgrade Before
After
Multiple, Redundant Boxes
11
12
Cost Analysis

• Upgrade front-end hardware
• Net cost 125K
• Consulting (40K estimate) is already paid for!
• Normalized costs
• Annual front-end cost 125K/4 yrs 31,250/yr
• Student portion 15,625/yr
• Given 25,000 students, 2 semesters
• Normalized cost 15,625/2 semesters/25K
  students
• 31/semester/student
• 2.1 of 15/semester UTF
• 25k savings/yr in maintenance costs
• Initial cost of hardware will include 3 years
  maintenance

12
13
Why Does CSU Not Fund This?

• ALL available resources this year devoted to
  RamCT
• Upgrade to new system 330k
• Add disk 30k
• Add back-up capability 60k
• Add spare DB server - 30k
• Need to double back-end server to 4 procs,
• Currently, do not have the for even that
• Use it or lose it consulting services this
  fiscal year

13
14
Other

• Time to reinvigorate front end services
• Support new (Google/MS) communication services
  for students
• Create student group to help define new services
• ACNS Targeted hire
• 3-year time frame
• Year 1
• Upgrade hardware, portal software
• Assess tab content (remove noise)
• Integrate new communication tools
• Begin 3rd party integrations
• Years 2 3
• Assess usage
• Refine define new services

15
Hardware Upgrade, the Checklist
15
16
Discussion and Questions

• Are most welcome.

16