Transcript Presentation - OBS IT

01.09.2006
http://www.obs-itconsulting.com
Out of the Box Solutions
Frankfurt/Main
Presentation by
Dipl.-Ing. Ralf Steffler
Netcool Certified Consultant
OBS Solutions
3 Out of the Box
Solutions
Picture Database
Enterprise Information Server
Umbrella Management Center
OBS-Architecture
SuSE
DB
Apache Webserver
MySQL DB Server
UMC-Application
MySQL
database
PHP
VNC
Virtual
Network
Computing
SSH
Probes
Secure Shell
Secure Copy
Central Alarm
Collector
programmable
UMC-Application
OBS-Components
Novell
MySQL
PHP
Apache
LAMP Platform
All for free !
SugarCRM
Mambo
Joomla
PHP
MySQL
Apache
Linux
Espresso instead of Java
PHP-Scripting
Rapid Prototyping
Open Source Software
PHP-Middleware
Secure Integration of a SQL Database
https
http
Apache
PHP
Middleware
Internet Explorer
Firefox
Mozilla
SQL
SQL DB
OBS-Login
Virtual Notepad
Multiple Language
Support
Transaction Collision
Detection
OBS-Forms
Customers
Service Providers
TroubleTickets
Devices
Orders
Alarms
Services
Users
OBS Form Generator
#genform formname password
>create tables
>create indexes
>create HTML-forms
Automatic integration in OBS Application
OBS-Security
Bastíon Host Concept
Highly protected SQL-Database
Integrated Firewall
Encrypted Login
Bad Logins & IP-Address check
Each Form Password protected
All Queries encrypted through https
OBS-Notepad
OBS-Notepad
For each Form
With Automatic
Timestamping
OBS Cold Standby
EIS
99%
S1
Switch
EIS
Availability:
AT = 2 S1 - S22
99%
99,99%
S2
OBS Scalability
Super-Computer
Linux
4
at best
possible Price
G
RAM
SMP
CPU
4
C
3
B
U
P
G
Hz
S
P
E
E
D
Raid
OBS Virtual Database
Database
Documents & Pictures
reside outside of DB
( ~ 1 TByte)
~1 Billion
Records
Response Time < 3 seconds
OBS Database Model
Customers
customer-oriented
customer
3 level tree structure
Notes
Contacts
Row_id
customer
...
1:n
Cars
Row_id
customer
...
1:n
Details
Notes
E
a
s
y
t
o
e
x
t
e
n
d
OBS Search Options
1. Simple search on rowid
2. Automatic wildcard search
3. Phonetic search on names
Result: Select * from table
where column like ´?%´
order by column desc ;
EIS Cool Colours
EIS Cool Colours are based on:
1. SLA
2. Priority
3. Status
Web Ticket System
WTS
https
Customer
Views
UMC
PHP
Internal
Views
Secure Customer Access to the UMC
Spanish Web Tickets
S
p
a
n
i
s
h
OBS-Summary
3 Level Access Control
Intrusion Detection
Extremly Fast SQL-Database
Very Little Bandwidth Demands
Central System Administration
Online Application Changes
Multiple Desktops (Browser & DB Clients)
OBS Conclusion
3 Out of the Box Solutions
Multiple Language Support
Transaction Collision Detection
Open Source Software
LAMP Platform
OBS Customers
Companies, that want to store any kind of digital
data, documents and pictures in a central
database.
Companies, that want to improve their
information management.
Companies, that want to monitor and analyse
protocol und alert files
OBS Virtual Machines
M
o
b
i
l
e
C
o
m
p
u
t
i
n
g
Browser
EIS
PDB
UMC
VMware
Windows XP
https
Consulting
Out of the Box
Solutions
http://www.obs-itconsulting.com