Umbrella 0.5Project Report #1课件.ppt

Umbrella 0.5Project Report #1 Heterogeneous Data Source Access Using Standard SQL Queries Eric Matson – MSE Kansas State University 精品文档 Agenda Overview Methods Tools Requirements Project Management and Control GUI Walkthrough/Prototyping Summary 精品文档 Overview Purpose Goals Description Architecture Key Elements Process Test Lab Scope Future Directions Literature Search Results 精品文档 Purpose Query heterogeneous data sources using standard SQL statements Achieve database integration and access at the query level Allow the data to be “black box” whereas users don’t need to have understanding to source, architecture, or technical details 精品文档 Goals Complete the Requirements of CIS895 Successfully Navigate Software Engineering Process Prove Umbrella Concept Prove Ability to Process Umbrella Queries Split the query into to process heterogeneous sources Manage the connection processing with the data sources Return and create new relation(s) Create easy to use Graphical User Interface (GUI) 精品文档 Description Enter queries using standard SQL statements Query heterogeneous data sources Text Files Formatted Delimited Relational Databases PostgreSQL MySQL Informix Knowledge Base Formats Prolog Rules CLIPS Deftemplate facts Non-relational Databases ODBC Data Sources Unify Data together as single relation 精品文档 Description – Architecture Parser Umbrella GUI Splitter Router Unifier Profile Engine TCP/IP Data Sources Relational Database Object Database Text File KB File Data Server API D a t a C o n n e c t o r s 精品文档 Description – Key Elements GUI: User Interface Umbrella Engine Agent Parser: Checks the query for correctness and validity Splitter: Splits query to appropriate data sources Router: Manages routing and connection to data source Unifier: Unites data upon return Profile: Database to manage data source information Data Connector: Interface to data sources Data Server: Text: “Wraps” data and serves the Umbrella Engine KB: “Wraps” fact and serves the Umbr