1 / 26

Federated Database Set Up

Federated Database Set Up. Greg Magsamen ITK478 SIA. Proposed Deliverables. Federated Database and multiple heterogeneous databases and data sources (Excel, XML) accessed via the federated database. Sample SQL Statements via some SQL Query Tool or Reporting Tool.

jcarruth
Download Presentation

Federated Database Set Up

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Federated Database Set Up • Greg Magsamen • ITK478 SIA

  2. Proposed Deliverables • Federated Database and multiple heterogeneous databases and data sources (Excel, XML) accessed via the federated database. • Sample SQL Statements via some SQL Query Tool or Reporting Tool. • Possibly a program extracting data from data source (Net Beans, VS 2005 (.Net) • Reporting Tool (Crystal or Business Objects)

  3. Agenda • Database Middleware • Federated Systems • DB2 and WFS • Setup • Demo • Conclusions

  4. Not Covered • Complex situations • Data Mappings, Function Mappings • Various types of data sources

  5. Purpose • Discover the Architecture • What software do I need? • How do I set it up? • Is this easy, difficult? • How viable for a real world implementation?

  6. Database Oriented Middleware • What is Database Oriented Middleware? • An interface to an application • The ability to convert the application language into something understandable to the target database • The ability to send a query to a database over the network • The ability to process a query on the target database • The ability to move a response set back over the network to the requesting application • The ability to convert a response set into a format understandable by the requesting application

  7. Federated Systems

  8. DB2 / Web Sphere Federated DB • Why DB2? • Other choices? Oracle? • http://www.oracle.com/technology/products/middleware/index.html • SQL Server?

  9. Web Sphere Federated Server

  10. Setup of Federation Database

  11. Special Interest Activity Federated Server Setup • Wrappers • User mappings • Nicknames

  12. Special Interest Activity Setup • IBM DB2-C • IBM DB2 EE (Extended Edition) • IBM Web Sphere Federated Server • Federated Object Setup

  13. Final Architecture

  14. Data Sources for the Special Interest Activity • SQL Server, Oracle, DB2 • Excel • XML

  15. Setting up Each Data Source • SQL Server • Oracle • DB2 • Excel • XML

  16. Wrappers

  17. Outcome of Object Usage • Querying Tool - Command Center • SQL Statements - Command Center of DB2 • Program to ITK478 • Crystal Reporting • Uses Views

  18. Demo • VPN over wireless may be slow • Review what’s been done • Add another data source

  19. Demo • Program Source • Crystal Problem

  20. Learning Curve • Product selection • Database access • File access • Focused on simple tasks • Viable system up and running • Simple data source • Many more issues and components would come into play for a ‘real-world’ system and were not addressed in this SIA

  21. Review of Material • Database Middleware – what it is • Federated Systems – how they fit in • DB2 and WFS – products and usage • Setup – problems and scenarios • Demo – simple set up • Conclusions – coming up

  22. Not Covered • Complex situations • Data Mappings, Function Mappings • Various types of data sources

  23. Conclusions • Ease of Use • Major Problems

  24. Usage Scenarios • Data Mart Versus Federation • Viability found from the SIA

  25. To Be Continued…. • Things not covered • Data Mappings • Mapping Functions • Web Services

  26. Questions?

More Related