[PPT] - ICE A Web-Based Information System to Support Higher Education PowerPoint Presentation

SLIDE 1

A Web-Based Information System to Support Higher Education Policy Decisions

ICE

20/21 June 2007

Peter Müßig-Trapp (muessig@his.de) HIS - Higher Education Information System, Hannover, Germany

Presentation in Zagreb

Title

SLIDE 2

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 2

Structure

1. ICE Overview and Main System Features
2. Using the System (Demonstration)
3. Outlook

Structure

SLIDE 3

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 3

Organisation

History

– Founded in 1969 – 1975: Taken over by

the federal government

Funding

– A Non-profit Organisation – Services free of charge – Results of studies and

analyses are published

1. About HIS

HIS Organisation

SLIDE 4

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 4

Mission and Services

Software Developement

Administrative computing applications for higher education

Planning and

Management Assistance

Pool of Information

– Empirical Studies – Higher Education Funding – Support of Desision Making

1. About HIS

HIS Mission

SLIDE 5

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 5

ICE History

~ 1990: Proprietary Hypercard based system for

MacIntosh

~ 1995: Completely reengineering towards a

platform independent architecture

– intranet system, Multi-tier-architecture, RDBMS at the

backend, Java as middleware

~ 2000: Extending the System

– Presentation- and exportmoduls – User authentication

~ 2005: Refactoring/Rewriting

– object oriented architecture

2. ICE History

History Overview

SLIDE 6

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 6

5 Central Goals

1.Make the best out of standard agregated data records 2.Data Warehouse: integrated and flexible analysing of different data stocks 3.Platform independent system 4.Easy in use (no computing skills or detailed data knowledge needed) 5.Combinated analyses of individual case data and aggregated data records

2. Central Goals

Central Goals

SLIDE 7

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 7

ICE installations

ICEbmbf: German Ministry of Education and Research

(BMBF)

ICEland: Central System for Science and Research

Ministries in all German Federal States and the German Science Council (Wissenschaftsrat)

ICEnds: regional system for the State Ministry of Lower

Saxony (other states will follow)

ICEwwo: German Academic Exchange Service (DAAD) HIS

Entscheidung Decision Information, Controlling,

2. ICE Overview

ICE Overview

SLIDE 8

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 8

Protection of personal Data

1980s: Political and

legeslative debate

n the protection of

personal data in Germany

Restricted access to

individual case data

Use of

standard aggregated datasets

2. ICE Overview

Data Protection

SLIDE 9

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 9

Standard Aggregated Datasets vs. Individual Case Data

Standard Aggregated Datasets allows only

previously-defined analyses

Individual case data records are much more

flexible

Individual case data: Less work to import ICE can process both:

standard aggregated data and individual case data

2. ICE Overview

Datasets

SLIDE 10

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 10

Individual Case Data

00 00 0 0 2024098 00 00 0 1 1011047 00 00 0 2 1013062 00 00 1 0 1767594 00 00 1 1 934127 00 00 1 2 833467 ... ... ... ... ... 16 11 2 2 104321 000 00 0 0 2024098 000 00 0 1 1011047 ... ... ... ... ... 124 00 0 0 127831 124 00 1 1 76432 124 00 1 2 51399 ... ... ... ... ... 577 11 2 2 72112

... ... ... ... ... ... ... ... 0001459 09 124 05 2 1 ... ... 0001460 03 237 07 1 1 ... ... ... ... ... ... ... ... ... ... number number S t a t e I n s t i t u t i

n

G e n d e r N a t i

n

a l i t y S u b j e c t I n s t i t u t . . . G e n d e r N a t i

n

. . .

Aggregated data

Ident Nr. State Subject Institution Gender Nationality

Datasets 2

SLIDE 11

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 11

Main System Features

Web application: Access via Java capable

Webbrowser

Platform independence!

– Operation System:

Server-side: Linux, Sun OS, MS Windows Client-side: All comonly-used platforms

– Database:

Commercial Databases: Oracle, Informix Open Source Databases: MySQL, PostgreSQL

2. System Features

Features Platform

SLIDE 12

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 12

Feature: Flexibility

Flexible data import

– Data with any structure and depth of structure

can be imported

– New topics can be included

Flexible data analysis

– Flexible table generator – Combining informations from several data stocks

Flexible data export

– HTML, MS Excel, PDF

2. System Features

Features Flexi

SLIDE 13

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 13

Feature: Data Integration

Data harmonisation with an integrated key Centraly maintained uniform ICE key Equivalency rules System known key internal hierarchies

2. System Features

Feature Integration

SLIDE 14

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 14

Feature: ICE standard tables

Analyses can be stored as ICE standard

tables in standard table collections on the server

Integrated automatic updating of ICE

standard tables (or whole standard table collections)

ICE standard table export formats:

HTML, XML, MS-Excel, Gnumeric, PDF, ...

2. System Features

Feature Standard Tables

SLIDE 15

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 15

Feature: ICE Publishing Framework

w e b s e r v e r A p a c h e X S P : k e y w o r d s e a r c h X S P p a g e : t a b l e l i s t ( e X t e n s i b l e S e r v e r P a g e s ) I C E - T a b L i s t . x s p e . g . : c o l l e c t i o n " I t n e r " : T a b 0 1 : [ X M L ] [ H T M L ] [ G N U ] [ E X C E L ] [ P D F ] T a b 0 2 : [ X M L ] [ H T M L ] [ G N U ] [ E X C E L ] [ P D F ] . . . T a b 4 3 : [ X M L ] [ H T M L ] [ G N U ] [ E X C E L ] [ P D F ] X S P p a g e I C E - T a b e l l e n . x s p T a b I D = x z . B . : x = " S . I t n e r . T 0 1 4 " T a b F o r m a t = y z . B . : y = " P D F " e . g . : I C E - T a b e l l e n . x s p ? T a b I D = S . I t n e r . T 0 1 4 & T a b F o r m a t = P D F R e q u e s t ( u s e r r e q u e s t w it h w e b b r o w s e r ) H T M L E X C E L P D F J a v a s e r v le t a n d J S P s e r v e r T o m c a t X M L - P u b lis h in g - E n g in e X S P - P r o z e s s o r J a v a S e r v le t C o c o o n X S P I C E - T a b e l l e n . x s p E S Q L - T a g L ib x m ln s : e s q l= " h t t p : / / a p a c h e . o r g / c o c o o n / S Q L / v 2 " < e s q l: e x e c u t e : q u e r y > . . . < e s q l: q u e r y > s e le c t * f r o m S t a n d T a b w h e r e id = 'S . I t n e r . T 0 1 4 ' . . . < / e s q l: q u e r y > < e s q l: r e s u lt s > < T a b T it e l> < e s q l: g e t - s t r in g c o lu m n = " T a b T it e l" / > < / T a b T it e l> . . . < / e s q l: r e s u lt s > < / e s q l: e x e c u t e : q u e r y > I C E s t a n d a r d t a b le - d a t a b a s e ( M y S Q L )

2. System Features

Feature Publ Framework

SLIDE 16

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 16

Publishing Framework:

Generating Excel and PDF

I C E s t a n d a r d t a b le - d a t a b a s e ( M y S Q L ) W e b - S e r v e r A p a c h e X S P I C E - T a b e l l e n . x s p t a b l e c o n t e n t s X A L A N X S L T - P a r s e r ( u n d e r c o n t r o l o f C o c o o n ) X S L - S k r i p t I C E - T a b L a T e X . x s l F O f o r m a t a t io n P D F d o c u m e n t I C E - T a b e l l e n . p d f F O d o c u m e n t I C E - T a b e l l e n . f o F O P - S e r i a l i z e r P D F - G e n e r a t o r v is u a liz a t io n in P D F v ie w e r ( e . g . A c r o b a t ) v is u a liz a t io n in t a b le c a lc u la t io n ( e . g . E x c e l) I C E s t a n d a r d t a b le - a d m in is t r a t io n a p p le t ( c h a n g e s F O f o r m a t , d e p o s e s in D B )

P D F

X S P I C E - T a b e l l e n . x s p t a b l e c o n t e n t s X A L A N X S L T - P a r s e r ( u n d e r c o n t r o l o f C o c o o n ) X S L s c r i p t I C E - T a b L a T e X . x s l G n u m e r ic f o r m a t it io n E X C E L d o c u m e n t I C E - T a b e l l e n . x l s G n u m e r ic - d o c u m e n t I C E - T a b e l l e n . g n u H S S F - S e r i a l i z e r E x c e l- G e n e r a t o r

E X C E L

X M L X M L R e q u e s t ( u s e r r e q u e s t w it h w e b b r o w s e r )

2. System Features

Publ Framework 2

SLIDE 17

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 17

ICE

2 access pathes

Standard tables

individuell • collections data-recall facility • authentification • integrated automatic • updating collection organization •

Table Generation

Table generation
Calculation:

percents differences

multi stock tables
Format conversion

XML HTML

Excel
PDF
u. a.
ICE

access path

SLIDE 18

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 18

Feature: ICE Cluster

W e b s e r v e r

A p a c h e R e q u e s t

( v ia W e b b r o w s e r ) J a v a s e r v le t - e n g iin e

T o m c a t

C o m m u n ic a t io n - s e r v le t I C E la n d - S e r v e r I C E -

a p p lic a t io n s e r v e r

I C E - N o d e 2

D B

I C E -

a p p l ic a t i o n s e r v e r

I C E - N o d e 1

D B

I C E -

a p p l ic a t i o n s e r v e r

I C E - N o d e n

D B

...

2. System Features

Feature Cluster

SLIDE 19

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 19

ICE Cluster II

Feature Cluster II

SLIDE 20

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 20

Demonstration of

ICE

Live Demonstration

SLIDE 21

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 21

Outlook

Data

– Increase the data stocks – Increase use of individual case data records

ICE in the Open Source (GPL)

– make it available as free software – establish coopertative development

Internationalization

– Multilingual output – European comparison

4. Outlook

Outlook

SLIDE 22

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 22

ICEmobil

ICE mobil

SLIDE 23

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 23 AnzHH 6

SLIDE 24

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 24

Contact / Information

Peter Müßig-Trapp Helena Kopp muessig@his.de kopp@his.de +49 511 1220 193 +49 511 1220 291 HIS ICE Group ice@his.de Demo and Information about ICE: http://ice.his.de HIS Higher Education Information System http://www.his.de Goseriede 9 30159 Hannover Germany

Folie 24

SLIDE 25

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 25

ICE in practical use

Demo Url

SLIDE 26

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 26

Main menu and authentication

Demo Main menu

SLIDE 27

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 27

Keywords Data stock

verview

Demo keywords

SLIDE 28

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 28

Data stock details Table generation

Demo Tablegen

SLIDE 29

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 29

Defining the structure

f tables

Demo Tablegen 2

SLIDE 30

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 30

Result table

Demo Result table

SLIDE 31

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 31

Result table HTML-Version Result table MS Excel

Version

Demo Result table 2

SLIDE 32

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 32

Storing as ICE standard table

Demo standtable

SLIDE 33

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 33

Actualisation typ Access rights

Demo standtable 2

SLIDE 34

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 34

Save ICE standard table

Demo standtable 3

SLIDE 35

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 35

ICE standard table collection

Demo standtable 4

SLIDE 36

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 36

Standard table actualization

Demo standtable 5

SLIDE 37

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 37

before ... ... after!

Self-updating standard tables

Demo standtable 6

SLIDE 38

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 38

1. About HIS

You are wondering what

this

is?

AnzHH 1

SLIDE 39

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 39

1. About HIS

AnzHH 2

SLIDE 40

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 40

1. About HIS

AnzHH 4

SLIDE 41

ICE

Peter Müßig-Trapp Zagreb 20/21 June 2007 41

Built: 1927 / 1928 Architect: Fritz Höger Roof: 50m / 164ft Floors: 12 Headquater of HIS Oldest skyscraper in Hannover The building is rated as a historic monument by the city of Hannover

1. About HIS

AnzHH 5