Articles
Fraunhofer Ipsi
- Category: Portfolio
- Hits: 16493
Indexing and Retrieval Digitized Information
Functional Goal:
Collaboratory for Annotation, Indexing and Retrieval of Digitized Historical Archive Material - Development of complex services in support of the cultural heritage sector.
Technological Environment
- DBServer: Linux – DBMS Oracle 9
- Application Server “collaborative”: Linux – Web Logic 6.1 sp4
- Web Server “collaborative”: Linux – Web Logic 6.1 sp4
- Application Server “laboratory”: Linux – TomCat
- Web Server “laboratory”: Linux – TomCat
- Data Dictionary Server: Linux – DBMS Oracle 9
Statistics
- 100 enabled users
- 40 "dimensions" of which 10 with hierarchical domain
- 30 "measures
- one subject area (information - data and images - historical) divided into more than 30 tables
- no historical time limit
Project elapsed:
24 months.
Bancoposta
- Category: Portfolio
- Hits: 12001
Diagnostic Reporting
Functional Goal:
Reporting system and navigation data for users Risk Management. The sources feeding the system, which together constitute the Repository Finance, are:- Data of reporting to Central Bank, Input and Output
- Operational risk data
- Statistical data Bank of Italy (Bastra)
- VaR
- ALM
- RAPM
Technological Environment
- SO: Linux RH5 Enterprise
- DBServer: MySql 5.1
- Application Server J2EE: JBoss 4.x
- Web Server: Apache
Statistics
- about 50 users enabled
- 1500 Dimensions
- 1000 Measures
- about 500 reports
- Database size 4 TB by year
- about 500 Mln of record by month
Project Elapsed:
12 months for the first phase; 4 months for second phase; in progress.
Al Rajhi Bank - Malaysia
- Category: Portfolio
- Hits: 17422
Credit Trade & Finance Reporting System
Functional Goal:
CTF Smart Reporting System, for the analysis, navigation and reporting of bank loan data warehouse.
Technological Environment
- DBServer: DBMS DB2 8.1
- Application Server: IBM AIX – Web Sphere
- Web Server: IBM AIX – Web Sphere
- Data Dictionary Server: IBM AIX – DBMS DB2 8.1
Statistics
- more than 500 users enabled
- 439 "Analysis Dimensions " in 39 Managed Classes
- 168 "Measures" to be processed and analysed in 24 Classe
- 76 Main Entities
- 2 Aggregation Plans
- No historical time limit
Project Elapsed:
6 months.
Gruppo bancario Iccrea
- Category: Portfolio
- Hits: 17130
Regulatory Reporting - Basel - Pillar 2 and 3
Functional Goal:
System for the navigation and the analysis of the Bank of Italy observations and – in the same time - Project for the construction of the Basel Reporting (Basel 1 and Basel 2), Pillar 2 and 3.
Technological Environment
- DBServer: Oracle9i
- Application Server: Web Sphere 6.1
- Web Server: IBM http Server
- Data Dictionary Server: Oracle9i
Statistics
- more than 2 million records managed
- over 250 reports made
- one Data Mart
- No historical time limit
Project elapsed:
One week for the product installation and 3 months for the project to support the Basel Reporting (including data extraction and customization of the ETL system).
Intesa Sanpaolo
- Category: Portfolio
- Hits: 20014
Rating System Analysis
Functional Goal:
System for rating model management designed for 'specific' customer (Data Entry for the dynamic data allocation, calculating the Rating by interfacing to Java Excel, Analysis and Testing Results).
Technological Environment
- DBServer: Oracle 9i
- Application Server: 3 server in cluster HP-UX 11.0 – Web Logic 8.1 sp 4
- Web Server: 3 server in cluster Red Hat Enterprise Linux – Apache 2.0
- Data Dictionary Server: HP-UX 11.1 – DBMS Oracle 9
Statistics
- more than 400 users (around the world) enabled
- 1352 Dimensions
- 548 Measures
- 2 Aggregation Plans
- 15 Computation Models (one or more for each customer segment)
Project elapsed:
6 months for the first one; 1 to 4 months for the others.