DB2 Information Integrator Software ???? ?????? IBM EE/A

1
DB2 Information Integrator Software???? ??????
IBM EE/A
2
???? ??????????

• ?????????? ??????????? - Portal
• ?????????? ?????????? - WS BI Server
• ?????????? ??????
• ????????? ??????
• Information Integrator

3
??? ??????? ? ?????????? ??????

• ???????????? ?????? ??? ?????????? ??????? (DW)
• ??????? ?????????????????? ? ??????????? (HA) ???
  ????????????? ??????.
• ????? ?? ????? ??????, ? ????????????? ?? ??????
  ?????? ??????? ??????
• ??? ????????????? ??????????????? ?????? ?????
  ??????? ?????????????? (ETL)
• Production applications, data warehouses,
  operational data stores
• ?????? ???????????? ETL (Extract, Transform, and
  Load) ??? ??????????
• ????? ???????????? ??????
• ??????? ?????? ??????
• ????????????????? ??????
• ??????????????? ?????? ? ??????????????
  ?????????? (II)
• ??????????????????? ??????? ? ???????? ?????
  ???????????? ? ????? ???????? ? ???????? ????
• ????? ????? ?????? ??????
• ???????? ????????????, ?????????????? ???
  ?????????? ??????? ???????????? ???????????
  ??????????? ??????
• ???????? ???????? ??????, ???????? customer ODS
  ? ??????????? ????????? ??? ???????????
• ?????? ????? ????? ? ??? ?????? ?? ??????? ? DW
• ?????????? ?????? ??? ?????????? ????? ????????

4
DB2 Information Integrator - ??????

• ???????????? ?????? ?????? ???????? ?
  ??????????????? ??????? ???, ??? ????? ???
  ????????? ? ????? ????????? ??????
• ??????? ??????????????? ?????? ?? ???????????
  ?????????????? ??????
• ??????? ???????? ?????????? ?????? ? ????????
• ????????????? ?? ????? ????????? ??????
• ????????? ??? ?? ?? ??????? ?????????
• ???????????? ??????????? SQL ??????? ? SQL
  ?????????
• ???????????? ??????????? ?????
• ??????????? ?????????????????? ??????? ? SQL
• ???????????? ??????????? ???????? ? ???????????
• ???????? ? XML ???????????
• ????????????? ????????? ?????????
• ???????????? DTDs ??? XML ?????
• ?????? ????????, ??????????? ??????????

Integrated SQLView
DB2, Oracle, SQL Server, Sybase, Teradata, OLE
DB, ODBC, Excel, XML, message queues, Web
services, flat files, document repositories,
content repositories, LDAP directories, WWW,
email databases, and more.
5
???????? ????????????? II

• Business Intelligence
• ?????????? ?????? ????????? ??????? ???????
• ?????? ?? ??? ?????? ???????????
• ??????????? ?????????? DW ??????? ???????

• Portal
• ?????? ????????? ? ?????? ??????????
• ?????? ? ?????? ??????
• ?????? ????????
• ?????? ?????

• Migration/Coexist
• ??????? ? ????????????
• ???????? ????? ??
• ????????????? ??

6
?????????? Data Warehouse ???????????? ???????
DB2 z/OS
Historical Data Data Warehouse
SQL
Federated Server
SQL Server

• Analysis
• Transformation
• Optimize query
• Cache

Real-time Data Operational Data Store
7
??????????? ??????? ??????? ?? ?????? ????????

• ??????????? ??????? ??????? ?? ???????? ?
  ?????????, ?????????? ? ?????? ????????
• ?????? ? ?????? ?? ????? ???????? ?? ???? ??
  ??????????

Oracle
Financial Services
SQL
Federated Server
Sybase

• Analysis
• Transformation
• Optimize query
• Cache

Retail Bank
?????????, ?????????, ??????? ???
8
????????? ?????????? ???????

• ??????????? ??????? ??????????? ??????? ?
  ????????? ????????????????? ? ???????????????????
  ?????????? ??????
• ????????? ?????????? ? ?????????????

Oracle
Account Status
SQL
Federated Server

• Analysis
• Transformation
• Optimize query
• Cache

Reference Documents E-mail
?????? ? ????? ?????
9
??????????????? ????????? ????

• ?????????? ????????? ???????? ? ??????????? ????
  ?? ????? ??????????????? ? ????????

• Analysis
• Transformation
• Optimize query
• Cache

Federation Server
Oracle, IMS
DB2 UDB
Legacy Store
Strategic Store
Replication Server

• Consolidation
• Transformation
• Manage Copies

• ?????????? ??? ????????????? ??????

10
IBM DB2 Information Integrator ????????????

• ????????????? ??????
• ??????????? ????? ???????
• SQL, XQuery, Content, Search
• ?????? ?? ??????/?????? ? ????????? ??????????
  ?????? ? ????????
• ?????????? ???????
• Data placement
• ???????????, ?????????? ? ????????, ??????????
  ??????????? ??????????
• ?????????????? ??????
• ???????? ???????? ??????
• Data analysis and mining
• SQL, XML, Web services
• Advanced search
• ?????????? ???????????
• Data publishing
• Publishing changed data events from diverse
  sources
• MQ ??????????

Metadata management and interchange
Federate Place Transform Publish

Information Integration
IBM Confidential
11
???????????? ?????? ? ?????????????? ??????
DB2 UDB
DB2 UDB on MVS
Integrated SQL View
DB2 Information Integrator
Sybase
VSAM
SQL, SQL/XML
O D B C
IMS
Federation Engine
Informix
Wrappers and functions
Software AG Adabas
SQL Server
CA-Datacom

New
Oracle
CA-IDMS
Teradata
Packaged apps
IBM Extended Search
Web services
ODBC
Text
WebSphere MQ
Excel
WWW, email,
XML
12

• Data sources accessible by IBM Lotus Extended
  Search
• Lotus Notes, Lotus Domino.doc, Lotus Discovery
  Server, Lotus QuickPlace, Lotus Sametime
• IBM WebSphere Portal Search Engine, Microsoft
  Index Server, Microsoft Site Server, Microsoft
  Exchange, LDAP Directories,
• 18 Web search engines (Yahoo!, Lycos, Excite,
  HotBot, Google, Alta Vista, ABCNews.com, AOL.com
  Search, Business Wire, CNN, Canada.com, EuroSeek,
  FAST Search, GoTo.com, NBCi, PR Newswire
  WebCrawler, and Yahoo News)
• Documentum, FileNet, DB2 Content Manager

13
Federated Sources
SQL
Content
SQL
Content Imaging
Workflow systems
Relational databases
Web Other
Collaboration Systems
XML Web services
Packaged applications
Mainframe files
Mainframe databases

• VSAM
• Sequential

• IMS
• Adabas
• CA-Datacom
• CA-IDMS

• DB2 UDB
• Informix
• Oracle
• Sybase
• Teradata
• Microsoft SQL Server
• ODBC

• OLE DB
• Excel
• Flat files
• IBM Lotus Extended Search
• Web search
• LDAP
• Custom-built

• DB2 CM
• Family
• Domino.doc
• Documentum
• FileNet
• Open Text
• Stellent
• Interwoven
• Hummingbird

• WebSphere
• FileNet

• WebSphere BI Adaptors
• SAP
• PeopleSoft
• Siebel

• Lotus Notes
• Microsoft Index Server
• IBM Lotus Extended Search
• Sametime
• QuickPlace
• Microsoft Exchange

????????????? ??????????? BP ????????????? ??????
? ???????? ???-?? ??????????
14
?????????
Wrapper ?????????, ?????????????? ?????? ?
?????????? ?????? ?????????? ?????? ???
?????????? (Net8...). ???????? ?????????? ?
??????????????? ????????? Server ????????????
?????????? ???????? ?????? Nickname ?????????
????? ??? ?????? ??????, ????????????? ??
????????? ??????? (???????????? ? ?????? ?
???????)
Global optimizer
Nickname
Nickname
Nickname

• ?????????? ??? ?
• ?????????? ?????????
• ???????? ?????????
• ???????? ?????????
• ???????? ??????? ? ????

Server
Server
Wrapper

• ????????? ??????
• ?????????? ???????
• ????????? ???????
• MQTs
• ???????????????? ??????

15
Wrappers

• ????????? 4 ???????? ??????
• ????????????? ??????
• ?????????? ???????? ?????? ?????? ? ???????????
  ?????? ?????? (??????? ? ????????? ? ?????????)
• ?????????? ??????? ? SQL ????????
• ???????????? ???????
• ????????????? ?????????? ?? ?????????
• ??????????? ?? ????????? ??? ????? ?????? ??????
• ?????????? ???????, ????????????? ?? ?????????
  (?? ???????????? II)
• ???????????? ?????????? ??? ???????????? (cost
  and cardinality)
• Connection and transaction management
• ?????????? ???????? ? ?????????? ??????
• ????????? ????? ??????? ???????????? ?? ?????????
  ?????????? ??????

16
Nicknames, Push down and Compensation
(??? ? ????????)
(?????????? ??????)

• Push down ????????? ??????, ???? ????????
  ??????????????????
• ??????????? ??? ??????????? ??????? (sort)

17
????????????????? Control Center

• Create nickname wizard
• ???????? ??????? nickname
• ????????/??????? wrapper, server, nickname
• Create cache table wizard
• ???????? ??????? ??? ???????.
• ????????/??????? nickname, cache table ?
  ????????????? ??????????
• Export/ Deploy
• ?????????? ???????? control center ? ??????????
  ?? ? ??????. ????????? ????????????? ??????? ?
  ????????? ?? ? Task Center
• Monitoring
• ????????? ????? nicknames, ????? ??????????
  ????????? ? ????? ??????, ??????? ????? ????????
  ?? ??? ???????? nickname
• ?????????? ????????? ???????? (???????? ???
  ??????????)
• ????????? ??????????
• ????????? ?? ?????????? ?????????? ?????????? ???
  nickname
• Server discovery
• ???????????????? II

18
????????? ???????? ? ???????????? ??????

• ?????? ? ?????????
• Query Rewrite
• ????????????? ??????? ?? ?????? ???????? ? ??????
  ?? ?????????
• Pushdown ??????
• ??????????? ??? ??????????????? ??????
• Cost-Based Optimization
• ?????????? ??????????? ???? ?????????? ???????,
  ????????? ?????? ?? ????????? database
  statistics, indexes, source functions, server
  capacity, network capacity
• ????????? SQL
• ?????????? ??????????? ??? ??????????? ?????????
  ?????? SQL (??? SQL ??????????)
• ????????? ?????? ??? ?????????? ? ???????????????
  ???????
• ????????? ??????????? ??????? ? virtual database
  view

19
???????????? ???????????

• ???????? ?????????????????? ? ??????????
  ?????????? ???????
• ????????????? ????????? Materialized Query Table
• ??????? ??????????? ??? ????? ????????????
  ????????
• ????? ?????? ?? ???????????? ???????????
  ??????????
• ??????? ??? ????? ????????????? (automatic
  routing)
• ??????????? ???????? ????????????? ????
• ???? ???????? ?????? ?? ????, ????? ? ????????
• ???? ????????? ???????? ???????? ? ??????????
• ?????????? ????
• ???????
• ??????????
• ????????? ????????? ?????????? ???????? ???
  ??????????????

User Application
Read
Write
Read
20
DB2 Information Integrator OmniFind Edition
New

• ??????? ?????
• ??????? ????????? ??? ?????????????? ????????
• Intranet, file systems, collaboration systems,
  content managers, and databases
• Stemming, lexical analysis, anchor point
  analysis, dynamic summary, highlighted text
• ????? ???????????? ? ??????????
• Java APIs
• Document level security
• ????? ???????? ? ???????? ????????
• 500K ?????????? ? ?????
• ?????? ????????????? ?????????????

Crawl Index Search
21
OmniFind Crawlers
New

• Web content
• HTTP/HTTPS
• News groups (NNTP)
• WebSphere Portal web content sources
• Collaboration
• Lotus Notes databases
• MS Exchange public folders
• File systems
• Content management systems
• DB2 Content Manager
• Relational Data sources
• DB2 family (DB2, Informix, DB2 for z/OS)
• DB2 Information Integrator relational data
  sources (Oracle)

22
DB2 Information Integrator 8.1

• A Replication Server
• ??????????? ?????? ????? ???????????? ????
• DB2, Informix, Microsoft, Oracle, Sybase,
  Teradata
• ???????????? ?????? ?????????
• ??????????? ???? ?? ??????
• ???????????? ?????? ? ??????
• ????????? ?????? ??????????
• Table-at-a-time (???????????) ??? ????????
  ???????? DW ? ???????????? ?????
• ?????????????-????????????? ??? ???????????
  ??????
• ????? ????????????? ????????
• ?? ??????????, ????? ????????, ???????????
• ?????????? ?????????????? ?? ????
• ??????????? SQL ????????? ??? ?????????? ????????
  ????????

23
????????? ???????????? ??????????
Log based
Staging tables
Trigger based

• ?????? ??????-??????? ???????? ????????? ???
  ????? ???????? ???????
• ?????? ??????-?????? ??????????? ??? ????????
  ?????????????

External application
24
?????????? ??????????? ??????????
New

• ????? ????????, ??????? ?????????? ???????????
• ??????? ??????????
• Database event publishing

Federation Engine
Parallel
Log based
WebSphere MQ

• ?????? ????????? ???????????? ??????????
• XML ?????? ?????????
• ?????? ???????????? apply process
• ??????????? ? ?????????? ?????????? ??????????
• ???????????? ????????? ? ??????????
• Wizard ??? ????????????????

25
?????? ? Web Services
ServiceProviders
Web
Airline Fare
SELECT l.city, t.degreesFahr FROM location l,
temperature t WHERE t.cityl.city

• ??????????? SQL ??????????? ? ????? Web Service
• ???? ???????? ????? ???????? ? ?????????? ?
  ?????????? ??????? ? ? web services
• ????????? ????????? SQL ??????? ? ?????????
  UDFs, ?? ?????? WSDL web service description (
  WebSphere Studio)

26
????????????? Web Services

• ????? Web Service ?????????? ???????? ???
  ?????????? ??????

27
?????????? ??????? (??? ?????? ????????? ? ??????)
New
WebSphere Business Integration
Workflow
JDBC Client
ODBC Client
??????????? ???????????? ????? ????? ?????? ?
????? ??????????
DB2 Information Integrator Classic Federation for
z/OS
28
New
????? ? ????????? ????????????

• ???????????? ????????? ??????? ??????????? ????
  ??? ?????? ???????? ???????? ??????????.
• ?????? ????? SQL.
• ????? ??????????? ? ??????? ???????????? ? ??.

Websphere MQ
WBI Adapter
WBI Adapter
WBI Adapter
29
Information Integration
???? ? ??? XML
XML world

• XML wrapper
• ?????? ? XML ?????????? ??? ?? ????????
• ?????????? XML ? ??????? ???????
• XML Extender
• ????????-??????????? ??????????
• ???????, ?????????, ?????????, ???????? XML
• ????????? ?? DTD ??? ?????
• ?????????, ???????????????
• ????????
• ??????
• ?????????? ?? ????????
• XML ?????????? ? SQL
• ??????????? ???????????? ?????? ??? XML ?????????

30
?????????? ? WebSphere MQ

• ?????? ?? ?????????? ? ???????? WebSphere MQ ?
  ??????? SQL
• ?????? ??????? (destructively or
  non-destructively)
• ??????? ?????????
• ???????????? ????????? ?? ???????????? ????
• ???????????????? ??????? ? ???????????? ????
• Two-phase commit integrity

Insert into PENDING_ORDERS select t.msg from
table(MQRECEIVEALL())
31
??????????????

• ????? ??????? DB2 Information Integrator
  ?????????? ??? ??????? ??????????
• DB2 Centers ( Control Center, Development Center,
  etc)
• ????????? ??? ??? ? ????????????? ?????????
  ??????????
• WebSphere Studio (Eclipse Platform)
• Web ????????????, J2EE ????????????, Data
  ????????????, XML ???????????? ? ? ?
• DB2 Microsoft Visual Studio
• ????????? ????????????? ?????????? ??? DB2
• Business Intelligence Tools
• ?????????????? ?. Crystal Decisions, Business
  Objects, MicroStrategy, Brio, Cognos

32
???????? DB2 Information Integrator

• ????????? ?????? ?? ????????? ??????????
• ???????? ? ???????????? ???????????????
• ????????????? ?????? ? ???????????? ?????? ?
  ?????????????? ??????, ??????? ?????? ???????,
  ???, ??? ????? ??? ????????? ? ????? ?????????
  ??????
• ?????????? ???????????? ?????? ? ???????
• ?????????? ???????? SQL ??????????? ?????? ?
  ???????????? ???????? ??????????
• ???????? ?? ??????????? ?????????
• ????????? ????? ?????????? ??????? ??????????
• ????????? ?????? ??????????? 40-65
• ????????? ?????????? ? ???????????? ?????????????
• ?????????? ????????? ????? ??????????