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 data nformation data data data data data data data Integrated data Processed Meaningful

Data Tier Logic Tier Presentation Tier

Client Library Network Address PostgreSQL <?xml> SOAP/XML MSSQL Web Service Logic Tier Multiple Data Sources OpenLDAP 2D Barcode Server Generator

PostgreSQL <?xml> Client Library SOAP/XML MSSQL Platform Web Service Web Desktop Dependency Logic Tier Logic Tier Different Network Segments Multiple Data Sources OpenLDAP 2D Barcode Server Generator

Desktop Web Logic Logic Tier Tier Abstraction Layer MSSQL 2D Barcode <?xml> Generator OpenLDAP PostgreSQL Server SOAP/XML Web Service

Desktop Logic Tier Web Logic Tier <?xml> Standardized Client Data Fetch Libraries Language Integration Abstraction Layer

Desktop Logic Tier Web Logic Tier <?xml> Structured Extensible Query Server Side Language Function (c, tcl, perl, python, plsql) PostgreSQL as Abstraction Layer

PostgreSQL as Abstraction Layer SQL: Structured Query Language SELECT ... FROM… WHERE … ORDER BY ... Function Function Function Function Function shared shared shared shared shared object object object object object client client client client client library library library library library <?xml>

Case Study 1: Smartcard for Traveler (SOAP/XML Web Service)

Logic Logic Tier #1 Tier #2 subscription subscription overdue overdue Local Database travel ban travel ban Server verification verification <?xml> travel travel recording recording SOAP/XML Web Service local travel local travel recording recording

Logic Logic Tier #2 Tier #1 PostgreSQL Abstraction Layer SQL: SELECT ... subscription travel ban travel local travel overdue verification recording recording shared shared object object Local Table Local Table gSOAP gSOAP <?xml> <?xml> SOAP/XML SOAP/XML Web Service Web Service

Case Study 2: MSSQL, 2D Barcode

Logic Logic Tier #1 Measurement Tier #2 Device measurement measurement data data MSSQL product product part number part number PostgreSQL bar code bar code generation generation 2D Barcode Generator

Logic Logic Tier #2 Tier #1 PostgreSQL Abstraction Layer SQL: SELECT ... measurement product bar code data part number generation dbi-link shared object iec16022 Local Table unixODBC ImageMagick Measurement MSSQL 2D Barcode Device Generator

Case Study 3: OpenLDAP User Authentication Mail Server Online HRMS Purchasing OpenLDAP User Authentication Manufacturing Accounting Control

Logic Logic Tier #1 Tier #2 mail server user user authentication authentication OpenLDAP Server data data transaction transaction PostgreSQL

Logic Logic Tier #2 Tier #1 PostgreSQL Abstraction Layer SQL: SELECT ... user data authentication transaction shared object OpenLDAP Local Table client mail server OpenLDAP Server

Summary Simpler Client Library Integration Simpler Network Configuration

Summary Simpler Heterogenous Data Source Integration

Future Work Standardized SQL/MED (Management of External Data)