(Complexity Issue) (Explosion Issue) DW RFID (Optimization Need) /

Size: px

Start display at page:

Download "(Complexity Issue) (Explosion Issue) DW RFID (Optimization Need) /"

きみかずいさやま
5 years ago
Views:

1 2003 IBM Corpor IBM Software Group

2 (Complexity Issue) (Explosion Issue) DW RFID (Optimization Need) /

3 Web DB2Web DB SQL DB DB2 II DB2 II, AVAKI SAN Volume Controller, (SAN File System)

4 1 RDB WebMQ Excel Information Integration <XML> text <XML> XML WebData

5 (Federation) API XML Web

6 Wrapper UDF FROM Web MQOLE DB SELECT ETL

7 nformation Integrator DB2/PCUNIX DB2Client Informix DB2/zOS,4 DB2Connect Informix Connect Net8 SQL Client SQL Server <XML> text <XML> XML Oracle BLAST MQ Web

8 B2 Information Integrator V8.1 SQL Xquery II DB Informix Informix Connect Net8 Oracle SQL*Net MS SQL Client DB2/PCUNIX DB2 DRDA DB2Connect XML BLAST Informix SQL Server <XML> text <XML> XML DB2/zOS,40 Oracle Web Web MQ BLAST MQ Web

9 Application Websphere Query Tool Other vendor SW C,Java, Cobol,RPG JDBC/ODBC, Embedded SQL DB2 interface DDF - z/os RDB - iseries DB2 RT Client UNIX, Linux, Windows DB2 instance federated server DB2 database wrapper server user mappings nicknames Wrappers DRDA NET8 CTLIB INFORMIX TERADATA DJXMSSQL3 ODBC Operating system Windows 2000, AIX, Solaris, HP-UX, Linux/Intel Client DB2 Connect - built-in Oracle client Sybase Open Client Informix Client SDK Teradata CLI ODBC Drivers Config File/Directory DB2 DB Directory tnsnames.ora interfaces sqlhosts /etc/hosts odbc.ini/system DSN Data Source DB2 z/os iseries LUW (UDB) VM and VSE Oracle Sybase Informix Teradata SQL Server ODBC Sources

10 RDB DRDA DB2/PCUNIX DB2Connect DB2/ OS DB2/iSeries DB2/VM and VSE Infomix Oracle MS SQL Server Sybase TeraData ODBC OLE DB(Wrapper+UDF

11 Application Websphere Query Tool Other vendor SW C,Java, Cobol,RPG JDBC/ODBC, Embedded SQL DB2 interface DDF - z/os RDB - iseries DB2 RT Client UNIX, Linux, Windows DB2 instance federated server DB2 database wrapper server user mappings nicknames Wrappers Flatfile XML BLAST Excel Documentum HMMER Entrez BioRS Extended Search Excel 97/2000 Dctm client ES client Operating system (limited support) Windows 2000, AIX, Solaris, HP-UX, Linux/Intel BLAST daemon HMMER daemon Table-Structured File XML file BLAST data source Excel file Documentum data store HMMER data source NCBI Website BioRS Server ES Server

12 NonRDB ( ) CSV XML Excel IBM Lotus Extended Search NotesYahoo Documentum BLAST BioRS Entrez HMMER Web (UDF) MQ(UDF)

13 CONNECT TO MWDB SELECT * FROM MYTABLE WHERE CONNECT RESET Information Integration CREATE NICKNAME MYTABLE FOR SYBASE SCOTT.TAB1 Sybase

14 CONNECT TO IIDB - - SELECT YEAR (ORDERDATE) FROM O_ORDERS Information Integratior SQLCompensation Oracle SELECT TO_NUMBER (TO_CHAR( ORDERDATE, YYYY )) SQL YEAR II

15 (Federation) /DBMS Oracle SQL DB2SQL DB

16 RDB RDB RDB DB2UDB CONNECT TO IIDB SELECT * FROM WHERE Clients Information Integrator / CPU I/O

17 MQT Join RDB A B C A B C DB2 Microsoft

19 RDBMS DB2, Informix Dynamic Server Microsoft SQL Server Oracle Sybase NCR-Teradata GUI

20 nformation Integrator

21 DB2/PCUNIX DB2/iSeries DB2/zOS LOG DB2/PCUNIX DB2/iSeries DB2/zOS Sybase SQL Server IBM Informix Sybase SQL Server IBM Informix Oracle ANY source Oracle Teradata

22 eb

23 SQL MQ MQ SQL MQ XML INSERT INTO pending_orders SELECT t.msg FROM table(mqreceiveall()); 1 XML DTDXML MQ MQSend(followup.service,a.custid ' ' a.ord

25 eb Web II WSAD IBM DB2 Information Integrator V8.1

26 eb DB2V8 HTML II DB2V8 HTML DB2V8 HTML me&fn=c htm DB2V8 HTML

27 B2V8 HTML

28 B2V8 HTML

29 (Relational Wrapper)

30 (Non-Relational Wrapper)

31 2bit GA

32 4bit GA

36 DB2 DB2 XML XML <XML> Text </XML> Web Web ID EXCEL EXCEL Oracle Oracle

37 SQL Information Integrator DB Net8 Oracle SQL*Net DB2 Oracle SQL EXCEL XML Web UDF EXCEL <XML> Text </XML> XML Web

38 ederationexcel EXCEL Oracle Oracle DB2 DB2ID IDselect customer_id from members where genre = select_id select customer_tour_id, customer_id, city from tour_sales_2002 select id, city from tour_info where tour_id = customer_tour_id

39 ederation DB Information Integrator DB2 Select tour_name, count(*) as num, area from federaed_table where Caching DB Oracle DB JOIN SORT SQL EXCEL

40 racle DB Federation create wrapper "NET8" library 'net8.dll' create server "ORASALES" type ORACLE VERSION 8.1 wrapper "NET8" options (node 'ORCL.ARISTOTLE') create user mapping for "DB2ADMIN" server "ORASALES" options( remote_authid 'scott', remote_password 'tiger') create nickname SALES2002 for ORASALES.SCOTT.SALES2002

41 xcel Federation create wrapper "Excel_2000_Wrapper" library 'liblsexcel2k.dll' create server "EXCLTOUR" type Excel_2000 VERSION '2000' wrapper "Excel_2000_Wrapper" options (node 'FEDDEMO') create nickname TOURINFO ( ID integer not null, TITLE varchar(30), GENRE integer, AREA varchar(10), COUNTRY varchar(20), CITY varchar(60) ) for server EXCLTOUR options(file_path 'c: ii demo tables tourinfo.xls');

42 B2 II (Grid) (SQL&XML ODBC JDBC SQLJ Web Tools CLI API Discovery Service DB2 Information Integrator Data Buffer Data Definition Lang. Mgt. Utility Catalog (Nickname) Storage Mgt. Replication Authorization Service Table Data Control Lang. Federated Access Service Relational Data Sys Data Mgt. Lang. Global Optimizer Federated Management Service Wrappers Data RDBMS Table

43 DB2 OGSA (Open Grid Services Architecture) OGSA-DAI (Database Access and Integration IBMOracle OGSA Globus Toolkit XML Query XML SQL XQuery Web Svc Informix Informix Connect DRDA Net8 Oracle SQL*Net Open Sybase Client MS SQL Client Informix DB2 Oracle Sybase MS SQL Information Integrator XTables XQuery Informix DB2 SQL RDB <?xml version="1.0?> <query> <row> <column name="col1"> <value>val1</value> </column> </row> </query> GRID OGSA Intern et GRID GRID GRID Web Web GRID

TotalStorage SAN (StorageTank) TotalStorage SAN 2003 Grid Storage ( ) WAN StorageTank Storage Tank Server Cluster IP Network for Client/Metadata Cluster Communications AIX VFS w/cache Solaris VFS

45 TotalStorage SAN (StorageTank) TotalStorage SAN 2003 Grid Storage ( ) WAN StorageTank Storage Tank Server Cluster IP Network for Client/Metadata Cluster Communications AIX VFS w/cache Solaris VFS w/cache StorageTank HP/UX VFS w/cache Linux VFS w/cache Windows IFS w/cache External Client Adm Clien Metadata Server Metadata Server Metadata Store Storage Network Metadata Server Shared Storage Devices Data Store Multiple Storage Pools

46 FTP Globus ToolkitGridFTP AVAKI Data Grid UNIX File System Cambridge, MA D at a Primary GDC Sha re Ser ver D at a D at a Sha re Ser ver D at a User Machines No Avaki software Browser access Web GUI Grid Server Sha re Serv er D at a D at a Execution Machines Mount DGAS Standard NFS access to data Single log-on for data access Access client is standard NFS client Princeton, NJ Acces s Server Acces s Client NFS Mount Avaki Data Grid

IBM Software Group DB2 Information Management Software DB2 V8 XML SQL/XML 2 XML XML UDF XMLExtender XML XML XMLCollection, XMLColumn XML UDF Informati

IBM Software Group XML Features in DB2 UDB V8 IBM Software Group DB2 Information Management Software DB2 V8 XML SQL/XML 2 XML XML UDF XMLExtender XML XML XMLCollection, XMLColumn XML UDF Information Integrator