BGD Software Incorporated

Web OLAP Data Warehouse
	Web based On-Line Analytical Processing Envrionment Client: ASP serving financial sector. Number of customers: 4 large mutual fund institutions. Data Warehouse size: ranging from 100MB - 3GB per client. Data refresh schedule: nightly incremental or per request. Special requirements: internal security between client data warehouses is extremely important due to competitivenes between the financial institutions. Technology (front end): - Client: any browser (v3.+) or Cognos Impropmptu/PowerPlay client - Administrator: IE 5.+ Technology (back end): - Web Application Server: COGNOS PowerPlay - Web Server: Microsoft IIS 4.0 - Database Server: IBM DB2 UDB 6.1 - Microsoft Active Server Pages (ASP) using Visual Basic (VB) Time to deliver: - 6 weeks (Release 1 - Data Warehouse) - 6 months (Release 2 - Back-end integration) - 12 Months (Release 3 - Final)
Scalable Architecture
	view...

Virtual Private Network Environment
	Clients use Virtual Private Network (VPN) to access the Data Warehouse. Traffic is limited to TCP over IP. HTTP ports 80 and 443 (SSL) are only allowed for browser based access.
	view...
Reverse proxy security hardening
	Principle of reverse proxy was used to ensure that only dedicated customers proxy web server has access internal web server. In this scenario, no end user can hit the internal web server directly.
	view...
Automated Data ETL
	Automated Data ETL (Extract, Transform and Load) controlling both back-end database and middle tier data warehouse and coordinating scheduled synchronisation. Extensive administrator interface with built in error notification/escalation rules.
	view...