IBM联邦数据库(Infosphere Federation Server)文章集锦
InfoSphere Federation Server V9.7 infocenter: http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp InfoSphere Federation Server V9.5 infocenter: -https://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp WebSphere Federatio
InfoSphere Federation Server V9.7 infocenter:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp
InfoSphere Federation Server V9.5 infocenter:
-https://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp
WebSphere Federation Server V9.1 infocenter:
– http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp
V9.1 Federation Server document pdf version
http://www-1.ibm.com/support/docview.wss?rs=845&uid=swg27008516
V9.5 Federation Server document pdf version
http://www-1.ibm.com/support/docview.wss?rs=3170&context=SS2K5T&uid=swg27011375&loc=en_US&cs=utf-8&lang=en
Administration Guide for Federated Systems
Configuration Guide for Federated Data Sources
Wrapper Developer's Guide
C++ API Reference for Developing Wrappers
Java API Reference for Developing Wrappers
DB2 document pdf version
http://www-1.ibm.com/support/docview.wss?rs=71&uid=swg27009474
For product information on WebSphere Federation Server
– http://www.ibm.com/software/data/integration/federation_server
For the system and data source requirements:
– http://www.ibm.com/software/data/integration/federation_server/requirements.html
Redbooks
- DB2 II: Performance Monitoring, Tuning and Capacity Planning Guide
http://www.redbooks.ibm.com/abstracts/sg247073.html?Open
Some whitepapers on federation technology:
– IBM Federated Database Technology
http://www.ibm.com/developerworks/db2/library/techarticle/0203haas/0203haas.html
- Fundamentals of IBM® DB2® Federated Server and Relational Connect
ftp://ftp.software.ibm.com/software/dw/dm/db2/0206purnell/0206purnell.pdf
– Two-part series on using data federation technology:
-Data federation design and configuration
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0506lin/
-Data federation usage examples and performance tuning
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0507lin/
- Handle distributed transactions with federated two-phase commit in
WebSphere Federation Server Version 9.1
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0611chang/
- Use federated procedures in WebSphere Federation Server
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0605bhatia
-Maximize your query result in WebSphere Federation Server V9.1 with Error
Tolerant Nested Table Expression
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0609huang/
-Asynchronous execution of federated queries in WebSphere FederationServer V9.1
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0611norwood/
-Use WebSphere Federation Server Version 9.1 to integrate XML data
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0703hahnel/
-Understanding the WebSphere Federation Server system catalogs
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0805bhatia/index.html
- Maintain federated data using WebSphere Information Integrator autonomic monitoring tools
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0505erfan/index.html
Preformance
– Maximizing the performance of WebSphere Information Integrator with MQTs
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0605lin/
-Performance enhancements in IBM WebSphere Federation Server V9.1, twopartseries
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0612englert/
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0612englert2/
-Using data federation technology in IBM WebSphere Information Integrator: Data federation usage examples and performance tuning
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0506lin/
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0507lin/index.html
-IBM WebSphere Information Integrator planning and sizing
http://www.ibm.com/developerworks/data/library/techarticle/dm-0411purnell/index.html
Security
-End-to-end federated trusted contexts in WebSphere Federation Server V9.5
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0712baliga/
Develop user mapping plug-ins for WebSphere Federation Server
http://www.ibm.com/developerworks/edu/dm-dw-dm-0804baliga-i.html
Application
- Develop a customized wrapper for WebSphere Information Integrator
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0608li2/index.html
- Integrate Excel and XML documents using WebSphere Information Integrator
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0611wang/
- Hello World: Learn how to easily access and integrate your distributed data with WebSphere Federation Server
http://www.ibm.com/developerworks/edu/dm-dw-db2-hellowfs.html
-Access heterogeneous data with WebSphere Information Integrator:
Part 1, Create EJB components that manipulate federated data
http://www.ibm.com/developerworks/edu/i-dw-db2-ejbs1-i.html
Part 2, Deploy EJB components to a portal environment
http://www.ibm.com/developerworks/edu/i-dw-db2-ejbs2-i.html
– DataStage and Federation Server for T-ETL
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0703harris/
-DB2 and Webservices
http://www.research.ibm.com/journal/sj/414/malaika.pdf
ODBC wrapper
- Configure IBM WebSphere Information Integrator to access a Lotus Notes database
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0511lamba/index.html
- Using MySQL in a federated database environment
http://www-128.ibm.com/developerworks/edu/dm-dw-mysqlfde-i.html
Federation Configuration Wizard
http://www.ibm.com/developerworks/edu/dm-dw-dm-0609erfan-i.html
通过 WebSphere Federation Server 实现 Excel 和关系型数据库的整合
http://www.ibm.com/developerworks/cn/data/library/techarticles/dm-0704xiaozc2/
Other Paper:
Garlic:
http://www.vldb.org/conf/1997/P266.PDF
Datajoiner
http://www.sigmod.org/vldb/conf/1998/p685.pdf
V9.7
IBM InfoSphere Federation Server V9.7 中的新增功能
http://www.ibm.com/developerworks/cn/data/library/techarticles/dm-0908hongzl/
IBM InfoSphere Federation Server V9.7 和 IBM InfoSphere Branded ODBC Dirver的安装与配置
http://www.ibm.com/developerworks/cn/data/library/techarticles/dm-0910douq/
IBM InfoSphere Federation Server V9.7 中 JDBC 包装器的应用
http://www.ibm.com/developerworks/cn/data/library/techarticles/dm-1003liangff/
IBM InfoSphere Federation Server V9.7 中 DECFLOAT 数据类型及相关语义支持
http://www.ibm.com/developerworks/cn/data/library/techarticles/dm-1001laicf/
在 InfoSphere Federation Server V9.7 中连接存储过程返回的结果集
http://www.ibm.com/developerworks/cn/data/library/techarticles/dm-1001like/index.html
InfoSphere Federation Server 中 Wrapper 工作模式的分析与对比
http://www.ibm.com/developerworks/cn/data/library/techarticles/dm-0911yangxq/
联邦数据库的语句中断处理
http://www.ibm.com/developerworks/cn/data/library/techarticles/dm-0908huzt/

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics











Apple's latest releases of iOS18, iPadOS18 and macOS Sequoia systems have added an important feature to the Photos application, designed to help users easily recover photos and videos lost or damaged due to various reasons. The new feature introduces an album called "Recovered" in the Tools section of the Photos app that will automatically appear when a user has pictures or videos on their device that are not part of their photo library. The emergence of the "Recovered" album provides a solution for photos and videos lost due to database corruption, the camera application not saving to the photo library correctly, or a third-party application managing the photo library. Users only need a few simple steps

Hibernate polymorphic mapping can map inherited classes to the database and provides the following mapping types: joined-subclass: Create a separate table for the subclass, including all columns of the parent class. table-per-class: Create a separate table for subclasses, containing only subclass-specific columns. union-subclass: similar to joined-subclass, but the parent class table unions all subclass columns.

How to use MySQLi to establish a database connection in PHP: Include MySQLi extension (require_once) Create connection function (functionconnect_to_db) Call connection function ($conn=connect_to_db()) Execute query ($result=$conn->query()) Close connection ( $conn->close())

To handle database connection errors in PHP, you can use the following steps: Use mysqli_connect_errno() to obtain the error code. Use mysqli_connect_error() to get the error message. By capturing and logging these error messages, database connection issues can be easily identified and resolved, ensuring the smooth running of your application.

Using the database callback function in Golang can achieve: executing custom code after the specified database operation is completed. Add custom behavior through separate functions without writing additional code. Callback functions are available for insert, update, delete, and query operations. You must use the sql.Exec, sql.QueryRow, or sql.Query function to use the callback function.

JSON data can be saved into a MySQL database by using the gjson library or the json.Unmarshal function. The gjson library provides convenience methods to parse JSON fields, and the json.Unmarshal function requires a target type pointer to unmarshal JSON data. Both methods require preparing SQL statements and performing insert operations to persist the data into the database.

Through the Go standard library database/sql package, you can connect to remote databases such as MySQL, PostgreSQL or SQLite: create a connection string containing database connection information. Use the sql.Open() function to open a database connection. Perform database operations such as SQL queries and insert operations. Use defer to close the database connection to release resources.

PHP database connection guide: MySQL: Install the MySQLi extension and create a connection (servername, username, password, dbname). PostgreSQL: Install the PgSQL extension and create a connection (host, dbname, user, password). Oracle: Install the OracleOCI8 extension and create a connection (servername, username, password). Practical case: Obtain MySQL data, PostgreSQL query, OracleOCI8 update record.
