Oracle Grupa Korisnika Srbije 21.05.09.
Oracle Tehnološka Rešenja u Srbiji
Saša Djordjević
Principal Sales Consultant
1
Continuous Innovation Oracle 11g
Active DataGurad
Database Vault
Grid Computing
Oracle 8i In-Memory Database Cache
Automatic Storage Mgmt
Oracle 8 Self Managing Database
XML Database
Oracle Data Guard
Oracle 7 Real Application Clusters
Flashback Query
Oracle 6 Virtual Private Database
Built in Java VM
Partitioning Support
Partitioning
Oracle 10g
in
Built in Messaging
Oracle 5 Object Relational Support
Multimedia Support Oracle 9i
Oracle 2 Data Warehousing Optimizations
Parallel Operations
Distributed SQL & Transaction Support
Cluster and MPP Support
Multi-
Multi-version Read Consistency
Client/Server Support
Platform Portability
Commercial SQL Implementation
2
Acquisition Best-In-Class
Oracle Oracle Oracle Oracle
Fiscal Year Fiscal Year Fiscal Year Fiscal Year
2005 2006 2007 2008
3
Communities (Partners)
• Grid and database options
• Identity Management
• Business Intelligence
• Content Management
• SOA
• Information, news, trainings, workshops, demos etc
• Product overview, VMware or TDS workshop
• RFP, Tender, demo
4
Oracle 11g Database Options
5
Grid Computing
In-Memory
Database
Cache
Real
Application
Clusters
Grid Control
Automatic
Storage
Management
Highly secured DB environment
(Network encryption / ASO) Protected by
Database Vault
Protected by
Secure Backup
Virtual Private Database
Oracle Label Security
Encryption (TDE)
Strong authentication
Monitored by Enterprise
Manager Protected by Audit Vault
7
Elpiko doo
• Core technologies
- Oracle Real Application Clusters
- Oracle Active Data Guard
- Oracle Security
- Oracle Data Vault
- Oracle Audit Vault
- Oracle Identity Management PoC
- Oracle DataWarehouse
- Performance tuning and troubleshooting
8
Oracle RAC and ADG
Regular Reporting
users users
TEST CMS DGTEST
Log shipping
Primary RAC Site Standby Single Instance
9
DW project - Telenor
Switch 1
OK CDR
By Customers
Rating Billing
Mediation
Device Rejected CDR
After stage I
Rejected CDR
Switch Z after rating
Rejected CDR Customer
After stage II
OK CDR Invoice
1 B
By TRUNK group 2
1’
3
Pairing
Invoiced CDR
with mediated CDR
Data
Interconnect
Warehouse
A
Interconnect Analysis
Invoice
10
Oracle Fusion Middleware
11
11
Java/FORMS Environment
Oracle Portal
Portleti
Single Sign On (SSO)
Oracle Forms / Reports Oracle Oracle WebLogic
Identity &
server Access
J2EE server
Manager
Oracle RAC database
12
Oracle BI Suite Enterprise Edition Plus
Interactive Ad hoc Proactive Microsoft Reporting & Publishing
Dashboards Analysis Detection Office
and Alerts BI Publisher Web Analysis
Financial Reporting
Interactive Reporting
SQR Production Reporting
Common Enterprise Information Model
Oracle BI Server
Set
Goals
Align Plan
Insight
Performance
Action
Report Monitor
Analyze
Data SAP, Oracle Files Financial
OLTP & ODS Warehouse PeopleSoft, Siebel, Excel Business Performance Hyperion
Systems Data Mart Custom Apps XML Process Management Essbase
Applications
13
Integrated Platform For Document Management
Scanning
Oracle ECM Business Process Modeling
Universal Content Management
Universal Records Management
Universal Online Archive
Imaging & Process Management
Information Rights Management
Document Capture
Portals
Records & Archiving
Users & Security
Retention Management
Document Access &
Management
14
Omni logika d.o.o.
• Specijalizovani tehnološki partner za
nove Fusion / Java tehnologije:
• Fusion 11g aplikativni razvoj (J2EE 5 / ADF 11g)
• Enterprise Content Management (ECM)
• Service Oriented Architecture (SOA)
– Business Process Execution Language (BPEL)
– Enterprise Service Bus (ESB)
• WebCenter 11g (Portal, Web 2.0 kolaboracija)
• Business Intelligence (BI)
• Agilna metodologija razvoja:
• Oracle Unified Method (OUM)
15
Omni logika d.o.o.
Razvoj i implementacija Web / SOA rešenja
prema Oracle Fusion 11g arhitekturalnim standardima
Oracle WebCenter 11g Portal
WSRP 2
portleti
portleti Oracle
Single Sign On Identity
(SSO) &
Access
Oracle Beehive / OCS
Manager
.NET, Axis Web Services
Oracle WebLogic Oracle BPM Oracle ECM Oracle BI Java, JCA Components
Non-Oracle Database
ADF 11g
aplikacije Oracle ESB ERPs
JAX web servisi BPEL Integracioni
Integracioni
adepteri Files
JMS Queue or Topic
200+ iWay Adapters
Oracle
Oracle 10g
11g
16
Osnovne karakteristike IS LPA :
• Rešenje obuhvata sve oblasti delovanja i rada lokalne poreske administracije
• Rešenje je prilagođeno načinu praćenja obveznika Poreska uprava - Lokalna
samouprava
• Povezanost sa sistemima iz okruženja
• Potpuna i jedinstvena baza podataka na nivou integralnog sistema
• Deo e - Governmenta:
• Podnošenje prijava preko Interneta
• Praćenje stanja poreskih računa
17
Arhitektura sistema
18
Realizovan i uveden u rad IS LPA
19
Izgradja gasovodne mreže
Ugovaranje
Distribucija i obračun potrošnje gasa
Održavanje gasovodne mreže
20
Arhitektura BrezaERP sistema
21
Tehnološka platforma
EDIS V.3
Java/XML tehnologija
Oracle 11g baza podataka
Java serverska aplikacija
Oracle aplikativni server 10.1.3.4
JDeveloper 10g
Oracle ADF
Jasper reports
22
EDIS V.3 Produkciona platforma
Aplikativni i web serveri
Poslovna logika
Interne Logika pristupa podacima
Interne Prezentaciona logika
tt
Klijent
Firewall
LAN
Klijent
Serveri podataka
23
Parallel d.o.o.
Aktivnosti Parallel-a u domenu Business Intelligence:
• Instalacija BI platforme,
• Implementacija BI rešenja,
• Razvoj BI aplikacija,
• Edukativne Workshop sesije,
• Održavanje BI platforme,
Parallel BI tim u ovom trenutku broji četiri sertifikovana BI stručnjaka sa brojnim
referencama u ovoj i srodnim oblastima.
24
Projekti Parallel-a u domenu Business Intelligence:
Ministarstvo finansija – Uprava za sprečavanje pranja novca
(Oracle BI Standard Edition - Discoverer)
DDOR Novi Sad (Oracle BI Enterprise Edition)
• Proof Of Concept,
• Interaktivne Workshop sesije,
Nakon uspešnih POC-a sprovodjene su Interaktivne Workshop sesije sa ciljem
kreiranja modela podataka i seta izveštaja nad podacima korisnika.
25
Platforma ELES SOA
• Platforma ELES SOA: omogućava jednostavan razvoj korisničkih
interfejsa, usluga i poslovnih procesa.
• ELES-SOA se sastoji od:
• Pretraživača ETE (Jedinstvena tehnička evidencija):
prepoznavanje osnovnih sredstava, komponenti i naprava potrebnih za
izvodjenje poslovnih procesa
• Zaštita: implementira poslovni proces Ispitivanje Zaštite
• Meritve: implementira poslovne procese Funkcionalni test, Kontrola brojila
i Intervencije na brojilu
• Elektronska depešna knjiga (e-Depeše) – implementira poslovni proces
slanja i primanja depeša.
26
Platforma ELES SOA
Admin
ELES-SOA
platforma
ELES partneri
(B2B)
Portal Oracle BPEL
Vanjski korisnici
Web servisi
Mobilni korisnici
GDA
(CIM) ELES
ELES
Oracle
Active ELES
DB
Directory eArhiv
Back-end sistemi 27
Energy Trading solution (ETA)
• Web Based/ Feature Reach, Ergonomic, Thin Client Application
By using JavaADF components - Jdeveloper 11g /Weblogic 10g/Oracle 11g
DB
• Mission Critical By using Oracle 11g RAC and WebLogic
10g LoadBallancing/Failover option
• Dynamic Reporting, Automatic exchange of relevant information with
TradePartners and European Energy Exchange
Each screen/grid is customizable and available to export to PDF/.XLS/XML
• Minimal staff training cost familiar with Forms/Reports/Oracle Pl/SQL
15 of our staff has undergone Oracle Jdeveloper 10g/11g training for two
weeks
Also we have attended additional Free Oracle Workshops
28
Energy Trading solution (ETA)
29
30
31