Distributed query processing in an InfoSphere Federation Server associated with Oracle databases

Paweł Drzymała, Henryk Welfle

Abstract


The article describe how to configure the InfoSphere Federation Server associated with the ORACLE database and distributed query processing in this environment. It presents how to create objects associated with distributed database. It presents how to define data sources and the wrappers used for the mapping of usersconnected to the remote server, the definition of nicknames for a remote data source object, the associated tables and stored procedures remotely.

Keywords


InfoSphere Federation Server; IBM DB2; Oracle; distribution query; RDBMS

Full Text:

PDF (Polski)

References


Smarter Planet IBM, http://www.ibm.com/smarterplanet/us/en/overview/ideas/.

Data Federation with IBM DB2 Information Integrator V8.1, http://www.redbooksiibm.com/abstracts/SG247052.html?Open.

Chong R.F., Liu C., Qi S.F., Snow D.R.: Understanding DB2: Learning Visually with Examples.

DB2 Connect - Podręcznik użytkownika: IBM 2007, www.ibm.com No: SC85-0304-00.

Wrembel R., Bębel B.: Oracle. Projektowanie rozproszonych baz danych. Helion, Gliwice 2003.

IBM DB2 dla systemów Linux, UNIX i Windows - Centrum informacyjne, http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp.




DOI: http://dx.doi.org/10.21936/si2011_v32.n2B.315