SLIDE 1
PostgreSQL
A Platform for Multiple Sources Data Retrieval
3rd ICTVET UNP Bukittingi, 16-17 Oct 2015
Abdul Yadi
abdulyadi.wordpress.com
Software Developer, Datatrans Informatika Front End: GWT, Sencha GXT Database: PostgreSQL
PostgreSQL A Platform for Multiple Sources Data Retrieval 3 rd - - PowerPoint PPT Presentation
PostgreSQL A Platform for Multiple Sources Data Retrieval 3 rd - - PowerPoint PPT Presentation
PostgreSQL A Platform for Multiple Sources Data Retrieval 3 rd ICTVET UNP Bukittingi, 16-17 Oct 2015 Abdul Yadi abdulyadi.wordpress.com Software Developer, Datatrans Informatika Front End: GWT, Sencha GXT Database: PostgreSQL data data
SLIDE 2
SLIDE 3
nformation
data
data
data
data
data
data
data
data
data
data
data
Integrated Processed Meaningful
SLIDE 4
Presentation Tier Logic Tier Data Tier
SLIDE 5
Logic Tier
Multiple Data Sources
PostgreSQL MSSQL 2D Barcode Generator SOAP/XML Web Service
<?xml>
OpenLDAP Server
Client Library Network Address
SLIDE 6
Web Logic Tier
Multiple Data Sources
PostgreSQL MSSQL 2D Barcode Generator SOAP/XML Web Service
<?xml>
OpenLDAP Server
Desktop Logic Tier
Client Library Platform Dependency Different Network Segments
SLIDE 7
PostgreSQL MSSQL 2D Barcode Generator SOAP/XML Web Service
<?xml>
OpenLDAP Server
Abstraction Layer
Web Logic Tier Desktop Logic Tier
SLIDE 8
Standardized Data Fetch Language Client Libraries Integration
<?xml>
Abstraction Layer
Desktop Logic Tier Web Logic Tier
SLIDE 9
Structured Query Language Extensible Server Side Function
(c, tcl, perl, python, plsql)
<?xml>
PostgreSQL as Abstraction Layer
Desktop Logic Tier Web Logic Tier
SLIDE 10
SQL: Structured Query Language
SELECT ... FROM… WHERE … ORDER BY ...
PostgreSQL as Abstraction Layer
<?xml>
Function shared
- bject
client library Function shared
- bject
client library Function shared
- bject
client library Function shared
- bject
client library Function shared
- bject
client library
SLIDE 11
Case Study 1:
Smartcard for Traveler
(SOAP/XML Web Service)
SLIDE 12
subscription
- verdue
travel ban verification travel recording local travel recording
Logic Tier #2 Logic Tier #1
subscription
- verdue
travel ban verification travel recording local travel recording
Local Database Server SOAP/XML Web Service
<?xml>
SLIDE 13
PostgreSQL Abstraction Layer
Logic Tier #1 Logic Tier #2
SOAP/XML Web Service
<?xml>
travel ban verification shared
- bject
gSOAP SOAP/XML Web Service
<?xml>
travel recording shared
- bject
gSOAP subscription
- verdue
Local Table local travel recording Local Table
SQL: SELECT ...
SLIDE 14
Case Study 2:
MSSQL, 2D Barcode
SLIDE 15
product part number bar code generation
Logic Tier #2 Logic Tier #1
measurement data
MSSQL PostgreSQL 2D Barcode Generator Measurement Device
product part number bar code generation measurement data
SLIDE 16
PostgreSQL Abstraction Layer
Logic Tier #1 Logic Tier #2
measurement data dbi-link bar code generation shared
- bject
product part number Local Table
SQL: SELECT ...
MSSQL Measurement Device 2D Barcode Generator
iec16022 ImageMagick unixODBC
SLIDE 17
Mail Server Manufacturing Control Accounting Online Purchasing HRMS
Case Study 3:
OpenLDAP User Authentication
OpenLDAP
User Authentication
SLIDE 18
data transaction
Logic Tier #2 Logic Tier #1
user authentication
PostgreSQL
data transaction user authentication
OpenLDAP Server mail server
SLIDE 19
PostgreSQL Abstraction Layer
Logic Tier #1 Logic Tier #2
user authentication shared
- bject
data transaction Local Table
SQL: SELECT ...
OpenLDAP client
OpenLDAP Server mail server
SLIDE 20
Summary
Simpler Network Configuration Simpler Client Library Integration
SLIDE 21
Summary
Simpler Heterogenous Data Source Integration
SLIDE 22