Out of the Box Solutions Frankfurt/MainPresentation by

Dipl.-Ing. Ralf StefflerNetcool Certified Consultant

01.09.2006

http://www.obs-itconsulting.com

OBS Solutions

Umbrella Management Center

Picture Database

3 Out of the Box Solutions

Enterprise Information Server

OBS-Architecture

Apache WebserverMySQL DB ServerUMC-Application

SuSE

programmable UMC-Application

Central Alarm Collector

PHP

Probes

Secure ShellSecure Copy

VNC

Virtual Network Computing

DB

MySQL database

SSH

OBS-Components

MySQL

Novell

Apache

PHP

LAMP Platform

PHP

Linux

MySQL

Apache

All for free !SugarCRM

Mambo

Joomla

Espresso instead of Java

Rapid PrototypingOpen Source Software

PHP-Scripting

PHP-Middleware

Secure Integration of a SQL Database

Apache

Middleware

SQL DB

PHP

SQL

httphttps

FirefoxInternet Explorer

Mozilla

OBS-Login

Transaction Collision Detection

Multiple Language Support

Virtual Notepad

OBS-Forms

Customers

TroubleTicketsDevices

AlarmsOrders

Service Providers

ServicesUsers

OBS Form Generator

Automatic integration in OBS Application

#genform formname password

>create tables

>create indexes

>create HTML-forms

OBS-Security

Highly protected SQL-Database

Integrated Firewall

Each Form Password protected

Bastíon Host Concept

All Queries encrypted through https

Encrypted Login

Bad Logins & IP-Address check

OBS-Notepad

With Automatic Timestamping

For each Form

OBS-Notepad

OBS Cold Standby

99,99%AT = 2 S1 - S22

EIS

Switch

99%

99%

EIS

S2

S1

Availability:

OBS Scalability

SPEED

Linux

CPU

RAM

SMPH

3G

z

C4

PU

G4

B

Super-Computer

Raid

at best possible Price

OBS Virtual Database

~1 Billion Records

Response Time < 3 seconds

Documents & Pictures reside outside of DB ( ~ 1 TByte)Database

OBS Database Model

Customers

Contacts

Cars

Notes

3 level tree structure

Easy

to

extend

customer-oriented

1:n1:n

customer

Row_idcustomer...

Row_idcustomer...

Details

Notes

OBS Search Options

1. Simple search on rowid

2. Automatic wildcard search

3. Phonetic search on names

Select * from table where column like ´?%´

order by column desc ;

Result:

EIS Cool Colours

EIS Cool Colours are based on:

1. SLA

2. Priority

3. Status

Web Ticket System

WTS

CustomerViews

UMC

InternalViews

PHP

Secure Customer Access to the UMC

https

Spanish Web Tickets

Spanish

OBS-Summary

3 Level Access Control

Intrusion Detection

Very Little Bandwidth Demands

Multiple Desktops (Browser & DB Clients)

Extremly Fast SQL-Database

Central System AdministrationOnline Application Changes

OBS Conclusion

Multiple Language Support

Transaction Collision Detection

3 Out of the Box Solutions

Open Source Software

LAMP Platform

OBS Customers

Companies, that want to improve their information management.

Companies, that want to monitor and analyse protocol und alert files

Companies, that want to store any kind of digital data, documents and pictures in a central database.

OBS Virtual Machines

Windows XP

Mobile

BrowserComputing

https

VMware

EIS PDBUMC

Consulting

http://www.obs-itconsulting.com

Out of the Box Solutions