1 / 21

CSCI 6838.1 Research Project and Seminar Team #1 11/13/2007

CSCI 6838.1 Research Project and Seminar Team #1 11/13/2007. Team Information. Mentor Mr. Todd Guillory Faculty Advisor Dr. Kwok Bun Yue yue@cl.uh.edu. Team Members Amruta Mehendale (Team Leader) amrutamehendale@gmail.com Abhisheik Deo abhisheikdeo@yahoo.com Aiyaz Paniwala

lukas
Download Presentation

CSCI 6838.1 Research Project and Seminar Team #1 11/13/2007

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. CSCI 6838.1 Research Project and SeminarTeam #1 11/13/2007

  2. Team Information Mentor Mr. Todd Guillory Faculty Advisor Dr. Kwok Bun Yue yue@cl.uh.edu Team Members Amruta Mehendale (Team Leader) amrutamehendale@gmail.com Abhisheik Deo abhisheikdeo@yahoo.com Aiyaz Paniwala aiyaz.paniwala@gmail.com Sanjeev Gowda Sanjeev.gowda@gmail.com

  3. Customer Information Chevron Information Technology Corporation Global Consulting & Applications Solutions/Data Access/Exploration Department Information Technology Company (ITC) provides the Internet-enabled infrastructure to achieve Chevron's business and technology strategy Contact Person: Mr. Todd GuillorySoftware EngineerChevron Information Technology CompanyGlobal Consulting & Applications Solutions (GCAS)Houston, Texas 77002Tel 713 754 5017tguillory@chevron.com

  4. Table of Contents

  5. Project Overview • Developed for Chevron Information Technology Corporation • The department deals with a huge data repository which is of different structures distributed across different data stores. • Integrate data from different sources and build a trusted dataset • The application deals with the scenario in which the customer may have to access data of different structures distributed across different data stores.

  6. Application Features The user will select the data source and will be prompted to provide the parameters depending on the type of data source selected For flat files, Excel sheets and Access database, user will specify the location of the data source file For flat files : User has to specify the delimiter used in the file By default data in a single line (i.e. separated by a new line) is considered to be a new row User will have to specify whether the first row in the file is the column header

  7. Application Features (contd) • For Access database : • All the tables in the selected database file will be displayed and the user can select one data table at a time as the data source and the user can view the data present in that table • The primary key of the selected table would be displayed to the user

  8. Application Feature (contd) • For Excel file : • All the worksheets in the Excel file are displayed and the user can select one of the worksheets as the data source and the user can view the data present in that worksheet • User will have to specify whether the first row in the file is the column header

  9. Application Features (contd) • Select Rows: • The user can select rows from the various data sources • Check/Uncheck open data sources for preview • Preview the selected rows • Clear the selected rows from specific table or all tables • Delete unwanted rows present in the preview • Export the finalized selection to a desired Excel file

  10. Use Case Diagram

  11. Architecture Diagram Client GUI User Forms User Forms User Forms Data Base Logic Data Base Connector Database

  12. Class Diagram for Project

  13. Class Diagram for UI

  14. Project Demo

  15. Implementation Issues • Exporting the data to Access • Limitation of Access does not allow an alternative • Exporting data to an Excel file • Write the data as XML and save it to an Excel file

  16. Project Tasks Completed by Team • Selecting data from MS Access 2003, MS Excel 2003 and Flat File. • Selecting multiple rows from each of the individual data sources Performing Join operation • Clear Selection

  17. Project Tasks Completed by Team (contd) • Export data to an Excel sheet • On clicking ‘Export data preview’ allow the user to check/uncheck selected tables • Show the preview of the selected rows • Delete unwanted rows from the preview

  18. Future Enhancements • Support for data sources with mismatching data structure • Displaying visual cues for matching rows • Performing Join operation • Resolving conflicts of duplicate rows before exporting the resolved data • Add paging mechanism to data grids

  19. Development Team

  20. Conclusion • Discussed the various application features required by the user • The project design has been covered • Project demo was given

  21. References • Chevron Information Technology Corporation: http://www.chevron.com/technology/info_technology/ • MSDN forums http://forums.microsoft.com/msdn

More Related