Upload File

postgresql...mssql postgresql 2d barcode generator measurement device product part number bar code...

  • Home
  • Documents
  • PostgreSQL...MSSQL PostgreSQL 2D Barcode Generator Measurement Device product part number bar code generation measurement data PostgreSQL Abstraction Layer Logic Tier #1 Logic Tier
22
PostgreSQL A Platform for Multiple Sources Data Retrieval 3 rd  ICTVET UNP Bukittingi, 16-17 Oct 2015

Upload: others

Post on 06-Jun-2020

12 views

Category:

Documents


1 download

Report

TRANSCRIPT

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

PostgreSQLA Platform for Multiple Sources Data Retrieval3rd ICTVET UNPBukittingi, 16­17 Oct 2015

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

Abdul Yadiabdulyadi.wordpress.com

Software Developer, Datatrans InformatikaFront End: GWT, Sencha GXT

Database: PostgreSQL

Page 3: PostgreSQL...MSSQL PostgreSQL 2D Barcode Generator Measurement Device product part number bar code generation measurement data PostgreSQL Abstraction Layer Logic Tier #1 Logic Tier

nformationdatadatadata

data

data

data

data

data

datadata data IntegratedProcessedMeaningful

Page 4: PostgreSQL...MSSQL PostgreSQL 2D Barcode Generator Measurement Device product part number bar code generation measurement data PostgreSQL Abstraction Layer Logic Tier #1 Logic Tier

Presentation Tier

Logic Tier

Data Tier

Page 5: PostgreSQL...MSSQL PostgreSQL 2D Barcode Generator Measurement Device product part number bar code generation measurement data PostgreSQL Abstraction Layer Logic Tier #1 Logic Tier

Logic Tier

Multiple DataSources

PostgreSQL

MSSQL

2D BarcodeGenerator

SOAP/XMLWeb Service

<?xml>

OpenLDAPServer

Client Library Network Address

Page 6: PostgreSQL...MSSQL PostgreSQL 2D Barcode Generator Measurement Device product part number bar code generation measurement data PostgreSQL Abstraction Layer Logic Tier #1 Logic Tier

WebLogic Tier

Multiple DataSources

PostgreSQL

MSSQL

2D BarcodeGenerator

SOAP/XMLWeb Service

<?xml>

OpenLDAPServer

DesktopLogic Tier

Client Library Platform 

Dependency

Different Network Segments

Page 7: PostgreSQL...MSSQL PostgreSQL 2D Barcode Generator Measurement Device product part number bar code generation measurement data PostgreSQL Abstraction Layer Logic Tier #1 Logic Tier

PostgreSQL

MSSQL 2D BarcodeGenerator

SOAP/XMLWeb Service

<?xml>

OpenLDAPServer

Abstraction Layer

WebLogicTier

DesktopLogic

Tier

Page 8: PostgreSQL...MSSQL PostgreSQL 2D Barcode Generator Measurement Device product part number bar code generation measurement data PostgreSQL Abstraction Layer Logic Tier #1 Logic Tier

StandardizedData FetchLanguage

Client LibrariesIntegration

<?xml>

Abstraction Layer

DesktopLogicTier

WebLogicTier

Page 9: PostgreSQL...MSSQL PostgreSQL 2D Barcode Generator Measurement Device product part number bar code generation measurement data PostgreSQL Abstraction Layer Logic Tier #1 Logic Tier

StructuredQuery

Language

ExtensibleServer Side Function(c, tcl, perl, python, plsql)

<?xml>

PostgreSQL asAbstraction Layer

DesktopLogicTier

WebLogicTier

Page 10: PostgreSQL...MSSQL PostgreSQL 2D Barcode Generator Measurement Device product part number bar code generation measurement data PostgreSQL Abstraction Layer Logic Tier #1 Logic Tier

SQL: Structured Query LanguageSELECT ... FROM… WHERE … ORDER BY ...

PostgreSQL asAbstraction Layer

<?xml>

Functionsharedobject

clientlibrary

Functionsharedobject

clientlibrary

Functionsharedobject

clientlibrary

Functionsharedobject

clientlibrary

Functionsharedobject

clientlibrary

Page 11: PostgreSQL...MSSQL PostgreSQL 2D Barcode Generator Measurement Device product part number bar code generation measurement data PostgreSQL Abstraction Layer Logic Tier #1 Logic Tier

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

Page 12: PostgreSQL...MSSQL PostgreSQL 2D Barcode Generator Measurement Device product part number bar code generation measurement data PostgreSQL Abstraction Layer Logic Tier #1 Logic Tier

subscriptionoverdue

travel banverification

travelrecording

local travelrecording

LogicTier #2

LogicTier #1

subscriptionoverdue

travel banverification

travelrecording

local travelrecording

LocalDatabase

Server

SOAP/XMLWeb Service

<?xml>

Page 13: PostgreSQL...MSSQL PostgreSQL 2D Barcode Generator Measurement Device product part number bar code generation measurement data PostgreSQL Abstraction Layer Logic Tier #1 Logic Tier

PostgreSQLAbstraction Layer

LogicTier #1

LogicTier #2

SOAP/XMLWeb Service

<?xml>

travel banverification

sharedobject

gSOAP

SOAP/XMLWeb Service

<?xml>

travelrecording

sharedobject

gSOAP

subscriptionoverdue

Local Table

local travelrecording

Local Table

SQL: SELECT ...

Page 14: PostgreSQL...MSSQL PostgreSQL 2D Barcode Generator Measurement Device product part number bar code generation measurement data PostgreSQL Abstraction Layer Logic Tier #1 Logic Tier

Case Study 2: 

MSSQL, 2D Barcode

Page 15: PostgreSQL...MSSQL PostgreSQL 2D Barcode Generator Measurement Device product part number bar code generation measurement data PostgreSQL Abstraction Layer Logic Tier #1 Logic Tier

productpart number

bar codegeneration

LogicTier #2

LogicTier #1

measurementdata

MSSQL

PostgreSQL

2D BarcodeGenerator

MeasurementDevice

productpart number

bar codegeneration

measurementdata

Page 16: PostgreSQL...MSSQL PostgreSQL 2D Barcode Generator Measurement Device product part number bar code generation measurement data PostgreSQL Abstraction Layer Logic Tier #1 Logic Tier

PostgreSQLAbstraction Layer

LogicTier #1

LogicTier #2

measurementdata

dbi­link

bar codegeneration

sharedobject

productpart number

Local Table

SQL: SELECT ...

MSSQLMeasurementDevice

2D BarcodeGenerator

iec16022ImageMagickunixODBC

Page 17: PostgreSQL...MSSQL PostgreSQL 2D Barcode Generator Measurement Device product part number bar code generation measurement data PostgreSQL Abstraction Layer Logic Tier #1 Logic Tier

MailServer

ManufacturingControl Accounting

OnlinePurchasingHRMS

Case Study 3: 

OpenLDAP User Authentication

OpenLDAPUser Authentication

Page 18: PostgreSQL...MSSQL PostgreSQL 2D Barcode Generator Measurement Device product part number bar code generation measurement data PostgreSQL Abstraction Layer Logic Tier #1 Logic Tier

datatransaction

LogicTier #2

LogicTier #1

userauthentication

PostgreSQL

datatransaction

userauthentication

OpenLDAPServer

mailserver

Page 19: PostgreSQL...MSSQL PostgreSQL 2D Barcode Generator Measurement Device product part number bar code generation measurement data PostgreSQL Abstraction Layer Logic Tier #1 Logic Tier

PostgreSQLAbstraction Layer

LogicTier #1

LogicTier #2

userauthentication

sharedobject

datatransaction

Local Table

SQL: SELECT ...

OpenLDAPclient

OpenLDAPServer

mailserver

Page 20: PostgreSQL...MSSQL PostgreSQL 2D Barcode Generator Measurement Device product part number bar code generation measurement data PostgreSQL Abstraction Layer Logic Tier #1 Logic Tier

Summary

Simpler Network Configuration

Simpler Client Library Integration

Page 21: PostgreSQL...MSSQL PostgreSQL 2D Barcode Generator Measurement Device product part number bar code generation measurement data PostgreSQL Abstraction Layer Logic Tier #1 Logic Tier

Summary

Simpler Heterogenous Data Source Integration

Page 22: PostgreSQL...MSSQL PostgreSQL 2D Barcode Generator Measurement Device product part number bar code generation measurement data PostgreSQL Abstraction Layer Logic Tier #1 Logic Tier

Future Work

Standardized SQL/MED

(Management of External Data)


PostgreSQL 9 · PostgreSQL 9.5 Postgres Open 2015 Dallas, TX Magnus Hagander [email protected]. Magnus Hagander •PostgreSQL •Core Team member •Committer •PostgreSQL Europe

pgpool: Features and Development€¦ · to avoid deadlock problem pgpool PostgreSQL PostgreSQL Query packet pgpool PostgreSQL PostgreSQL Wait until something returns ... pgpool SELECT

PostgreSQL: Introduction and Concepts - justpainjustpain.com/eBooks/Databases/PostgreSQL/PostgreSQL Introductio… · Title: PostgreSQL: Introduction and Concepts Author: Bruce Momjian

PostgreSQL: Introduction and Concepts - sgbdr.frsgbdr.fr/SGBDR/PostgreSQL/Documentation/PostgreSQL Concepts.pdf · PostgreSQL: Introduction and Concepts Creating Joined Tables Performing

Crunchy Data PostgreSQL Operator · 2017-09-07 · PostgreSQL 9.5+ Container (crunchy-postgres) PostgreSQL Backup Container (crunchy-backup) PostgreSQL Upgrade Container (crunchy-upgrade)

Bienvenue chez le Ch’ti JUGchtijug.org/wp-content/uploads/2009/05/chtijug... · Business Logic Tier JTA 1.1 Persistence Tier Interoperability Tier Java EE 6 JCDI 1.0. Ch’tiJUG

PostgreSQL 9.2 efektivneˇ - PostgreSQL - PostgreSQL · PostgreSQL 9.2 efektivneˇ Programovan´ ´ı ulo zenˇ ych procedur´ Pavel Stehuleˇ 21. 1. 2013 Pavel Stehule ()ˇ

Documentation PostgreSQL 9.6 · Documentation PostgreSQL 9.6 ... Préface xix

WebSphere Application Server - WebSphere Application Server Family ... 2007 IT Specialist ... The Business Logic Tier provides a framework for executing business logic and

Migration to PostgreSQL - preparation and … · Overview Oracle to PostgreSQL Informix to PostgreSQL MySQL to PostgreSQL MSSQL to PostgreSQL Replication and/or High Availability

Documentation PostgreSQL 9.2 · Documentation PostgreSQL 9.2 ... Préface xxi

Review. Focused concept Week 1: Three separate types of functionality: Data Management Application logic Presentation Single-tier, client-server, three-tier

Manually Upgrading PostgreSQL 9.1to PostgreSQL 9.4

Availability of PostgreSQL in the Datacenter - PostgreSQL wiki

01 - Uvod · 1. PHP 2. ASP 47 Typical Layers of the Middle Tier The middle tier usually has parts related to the front-end, business logic and back -end: Presentation Logic Implements

Postgresql High Availability. - thebuild.com · Postgresql High Availability. Christophe Pettus PostgreSQL Experts, Inc. FOSDEM PGDay 2016

Crunchy Enterprise PostgreSQL Support R2...PostgreSQL Support and Open Source Solutions Secure, high-availability PostgreSQL deployments Elastic, hybrid cloud PostgreSQL solutions

Mastering PostgreSQL · Mastering PostgreSQL In Application Development Dimitri Fontaine PostgreSQL Major Contributor 1st Edition !

Documentation PostgreSQL 10 · Documentation PostgreSQL 10 ... Préface xix

DB2 UDB To PostgreSQL Conversion Guide - PostgreSQL wiki

Hacking PostgreSQL · PostgreSQL Source Code Hacking PostgreSQL Final Code PostgreSQL Subsystems Hacking the PostgreSQL Way Top Level Backend Code Backend Code - Down the Rabbit Hole

Business logic with PostgreSQL and Python

pgpool: Features and Development · to avoid deadlock problem pgpool PostgreSQL PostgreSQL Query packet pgpool PostgreSQL PostgreSQL Wait until something returns ... pgpool SELECT

Securing PostgreSQL Exploring the PostgreSQL STIG · PDF fileSecuring PostgreSQL { Exploring the PostgreSQL STIG and ... $ systemctl restart postgresql-9.5 ... Securing PostgreSQL

What’s New in PostgreSQL 9.6, by PostgreSQL contributor · Hive PostgreSQL 9.1.3 PostgreSQL 9.6.0 •Comparing DBT-3 benchmark result with Hive (SF1 - SF100) •Single PostgreSQL

New The PostgreSQL Replication Protocol - Hagander PostgreSQL Replication... · 2020. 9. 10. · PostgreSQL Replication Added in PostgreSQL 9.0 Based on streaming WAL (Transaction

PostgreSQL S511. SLIS Postgresql server PHP PGAdmin – – Get

C3 PostgreSQL 運用テクニック・レベルアップ編 · PostgreSQL Conference 2012 1 【 C3 】 PostgreSQL 運用テクニック・レベルアップ編 PostgreSQL Conference

Data warehousing with PostgreSQL - PostgreSQL wiki

PostgreSQL for developers · PostgreSQL for developers Dimitri Fontaine PostgreSQL Major Contributor A BOOK ABOUT POSTGRESQL BY DIMITRI FONTAINE

Расширяемость PostgreSQL для хакеров и архитекторовmegera/postgres/talks/PostgreSQL... · Расширяемость PostgreSQL для хакеров

Moving Video Mapper and City Recorder with Geo-Referenced ...wolfson/other_ps/wise_videomapper_15.pdfThe logic tier processes data between presentation tier and data tier. The his-torical

25 Interesting features of PostgreSQL 12 · 1 © 2019 Percona Jobin Augustine 25 Interesting features of PostgreSQL 12 PostgreSQL 12 Senior Support Engineer - PostgreSQL Percona PostgreSQL

Migration to PostgreSQL Preparation and · PDF fileMigration to PostgreSQL Preparation and Methodology ... Data types PostgreSQL supported Data ... your PostgreSQL application ugly

Step by step Exercises · Exercises 1. Create Data Tier (Database) 2. Create Logic Tier (Database Communication Logic) Create Presentation Tier (User Interface Logic): 3. WebApp: