データ移行・文字コード変換編

PostgreSQL 󥿩`ץ饤?󥽩` g WG#2

ǩ`?֥`ɉQ

N DBMS PostgreSQL ؤ

u

I

ʽ祢

Σţå`󥤥Υ٩`ʽ

? 2014 PostgreSQL Enterprise Consortium

ӆĚs



ӆ



1.0

2014/04/17

Ҏ

饤

Ʒ CC-BY 饤󥹤ˤäSZƤޤ

饤󥹤ݤ֪ꤿ Ǥ_J

ĕݡӛv`ꡢҪȤˤĤޤƤϡ PGECons ΥȤͨƤĤޤ

褦ޤ

URL

Eclipse ϡ Eclipse Foundation Inc ׹Ӥιˤ̘ˤ⤷ϵh̘ˤǤ

IBM DB2 ϡζयιǵh줿 International Business Machines Corporation ̘ˤǤ

Intel ƥ뤪 Xeon ϡ׹Ӥιˤ Intel Corporation ̘ˤǤ

Java ϡ Oracle Corporation Ӥӻ硢vB׹Ӥιˤh̘ˤǤФƷȤϸ̘ˤޤϵh̘ˤǤϤޤ

Linux ϡ Linus Torvalds ϤձӤιˤh̘ˤޤ̘ˤǤ

Red Hat Shadowman logo ϡ׹Ӥιˤ Red Hat,Inc. ̘ˤޤϵh̘ˤǤ

Microsoft Windows Server SQL Server ׹ Microsoft Corporation ׹Ӥιˤh̘ˤޤ̘ˤǤ

MySQL ϡ Oracle Corporation Ӥӻ硢vB׹Ӥιˤh̘ˤǤФƷȤϸ̘ˤޤϵh̘ˤǤϤޤ

Oracle ϡ Oracle Corporation Ӥӻ硢vB׹Ӥιˤh̘ˤǤФƷȤϸ̘ˤޤϵh̘ˤǤϤޤ

PostgreSQL ϡ PostgreSQL Community Association of Canada Υʥˤh̘ˤӤιˤ̘ˤǤ

Windows ׹ Microsoft Corporation ׹Ӥιˤh̘ˤǤ

TPC, TPC Benchmark,TPC-C, TPC-E, tpmC, TPC-H, QphH ׹ Transaction Processing Performance Council ̘ˤǤ

YϤӛdƤƷϤ줾礬̘ˤޤϵh̘ˤȤʹäƤϤޤ

2/48

? 2014 PostgreSQL Enterprise Consortium

Ϥ

YϤθҪĿ

YϤǤϡȴήN DBMS PostgreSQL ؤΥǩ`Фvơ֥`ɉQˤĤǰжϤ

βοYϤȤä뤳Ȥ붨Ƥޤ

YڤӛˤĤ

YϤǤϡԪήN DBMS Ȥ Oracle DatabaseMicrosoft SQL ServerDB2 붨N DBMS

PostgreSQL إǩ`ФH֥`ɉQˤĤơ혤헤ӛdޤϤˡԽθ

¤vƤϡΤΥե`헷Ƥˏӛޤ

1: YϤ

1. PostgreSQL ֥åȤˤĤ

2. N DBMS PostgreSQL إǩ`Еrע

3. Еrע

4. N DBMS Υǩ`ˤĤ

5. ǩ`Q

6. ǩ`Ͷ뷽 PostgreSQL

7. N DBMS(SJIS)PostgreSQL(UTF8 EUC) Хƥ

ETL ˤĤƤ‡Τ褦ʸȤʤꡢYϤǤϡ5.ǩ`QעӛdƤޤ

Extract

CSV եʤ

4. N DBMS Υǩ`ˤĤ

N DBMS

5. ǩ`Q

6. ǩ`Ͷ뷽 (PostgreSQL)

Transform

PostgreSQL

Ͷʽ

Load

PostgreSQL

2: ETL θȸ¤Υޥåԥ

3/48

? 2014 PostgreSQL Enterprise Consortium

YϤǒQZζx

YϤǤϡζȤƤȤ館뤳ȤǤZäޤΤΤ褦ζӛdƤޤ

1: Zx

No.

Z

ζ

1

DBMS

ǩ`ө`न

ǩ`٩`ƥָޤǤϡPostgreSQL ӮN

DBMS ξtƤȤäޤ

2

N DBMS

PostgreSQL Υǩ`٩`ƥָޤ

YϤǤϡOracle Database Microsoft SQL ServerDB2 ԓ



3

ETL

`Ƥ`룩

Ԫ顢ǩ`ExtractͶܤʽˉQTransform

ЌΥǩ`٩`Ͷ루Load뤳Ȥν^֤Ϥ碌ƺ

롢һBЄIָޤ

4

֥`

YϤǤϡ֤x뤿ä 16 Mָޤ

5

֥å

YϤǤϡDBMS äǤּϤȤƺƤޤ

6

֥󥳩`ǥ

YϤǤϡDBMS ዤǤּϤ򥳥ԥ`Ϥηţ֥`

ɣˌꤵַŻʽȶxޤ

7

֥

PostgreSQL ȡQǩ`ͤ DBMS ȤξtƤȤäޤ

8

Oracle

ǩ`٩`ƥ Oracle Databae ָޤ

9

SQL Server

ǩ`٩`ƥ Microsoft SQL Server ָޤ

YϤǒQեȥ

YϤǤϡΤΥեȥäƥޥ^Ȥ򒤤Ƥޤ¥եȥЩ`Ȯʤ륽եȥ

Ϥ䡢؄eOȤƌgФϤϡgнYӛd¤ä륽եȥOˤĤƽB餷



2: h

No.

h

gװ

Щ`

1

^ DBMS

PostgreSQL

9.3.3

2

Ԫڥ`ƥ󥰥ƥ

Windows

Windows 2012 Standard 64bit

3

ȥڥ`ƥ󥰥ƥ

Linux

RedHat Enterprise Linux 6.5

64bit

3: N DBMS һE

N

o.

h

1 Oracle

Database

2

Microsoft SQL

Server

3 DB2

Щ`

ԪURI

12c Standard Edition



2012 Express Edition



Express-C v10.5



4/48

? 2014 PostgreSQL Enterprise Consortium

4: ޥ?ĩ`һE

No.

ޥ?ĩ`

Щ`

饤

ԪURI

Ҫ

The PostgreSQL

Lincense

PostgreSQL ͬ

y

PostgreSQL ˤƥե

Ʃ`֥gΥǩ`򥳥ԩ`

뤿Υޥɡ

YϤǤϡǩ`В

Ƥե뤫Ʃ`֥

ǩ`뤹Hä롣

2

psql

9.3.3

ԩ`??`?룩

The PostgreSQL

Lincense

PostgreSQL ͬ

y

PostgreSQL ͬyƤ롢

`ߥʥͥեȥɡե

뤫izळȤ

ܤǤ롣

3

pg_bulkload

3.1

ԩ``?Ф뤯`ɣ

The BSD 3-Clause

License

PostgreSQL 򤱤θ٥ǩ`

.projects.pgfoundr Ͷĩ`롣һĤ COPY



٤˄롣

4

nkf

̤`գ

The zlib/libpng

License

ͥåȥ`h֥`ɥե륿



YϤǤ֥`ɉQ

e.jp/projects/nkf/

롣

2.12

GNU General

Public License,

version 3

International Codeset

Conversion Libraryʤ



֥`g໥QФ

rg/software/libico

YϤǤϡiconv ޥɤ

nv/

ơ֥`ɉQФH

ä롣

1

COPY

ԩ`

(PostgreSQL

˜ SQL

ޥ)

2.0.8

5

iconv

֣

6

spool

ש`룩

12.1.0.1.0

Oracle Technology

Network

Oracle Database

Development and ͬy

Distibution License

7

bcp

ө`?`?ԩ`

2012

Microsoft EULA

Microsoft SQL

Server ͬy

ǩ`٩`ȥեg

ǩ`һԩ`Ȥ

롣

8

DB2 EXPORT

ǩ`ө`ĩ`

ݩ`ȣ

10.5

IPLA

DB2 ͬy

ǩ`٩`ե˥ǩ`

򥨥ݩ`ȤϤä

롣

5/48

ϤνYե˸{

Ϥä롣

? 2014 PostgreSQL Enterprise Consortium

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download

To fulfill the demand for quickly locating and searching documents.

It is intelligent file search solution for home and business.

Literature Lottery

Related download
Related searches

    ©2024 5y1.org, Inc. All rights reserved.