1 / 32

CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007

CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007. Table of Contents. 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

molimo
Télécharger la présentation

CSCI 6838.1 Research Project and Seminar Team #1 10/02/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 10/02/2007

  2. Table of Contents

  3. 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

  4. 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

  5. Overview Data Integration & Resolution Component Application is a new, self-contained product. It deals with the scenario in which the user is required to work with data distributed across different data sources. The application enables the user to view, compare, integrate data and build a trusted resultant dataset.

  6. End User The various users of the system have similar data stored in different databases The user of the system would obtain data from other users and would want to visually compare them with the help of cues provided by the application The user would then be able to build a trusted and resolved version

  7. 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 other data sources like Oracle, SQL Server, user would specify a DSN

  8. Application Features (contd) • 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

  9. 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 • The primary key of the selected table would be recommended to the user • The user can either use the recommended key or user can select other fields as primary key

  10. 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 • User will have to specify whether the first row in the file is the column header • By default the first column of the worksheet is considered to be the primary key

  11. Application Features (contd) • Handling of data types • Default data type for data elements is considered of type string • Special characters in the data elements will be handled accordingly • The application integrates data of single, flat tables

  12. Application Features (contd) The GUI uses color and visual cues to identify matching rows The user selects the specific records from the various data sources and can view the ‘resolved’ table The user can then export this single ‘resolved’ table to an Excel Sheet Users can hide/reveal columns by clicking on them.

  13. Use Case Diagram

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

  15. Class Diagram

  16. Technology Used Operating System Windows XP SP2 Programming Language C# Framework .NET 2.0 IDE Visual Studio 2005 Databases: Microsoft Access 2003 Microsoft Excel 2003 Flat Files

  17. Project Timeline

  18. Project Timeline (contd)

  19. Development Team

  20. DI&R Screen Shots

  21. First Screen : First window form will always remain open, for the user to select menu options.

  22. Select Data source : User selects Open command from File menu and then selects the type of data source to connect to

  23. Select Access Data source: Based on selection of MS Access as data source user can either specify database location in string format or use the browse button to select the corresponding file

  24. Select Access Data source: If the Selected Access file is password protected, the user is prompted to enter a username and password

  25. Select Access Data source: Based on selected database, corresponding table names will be populated in a list. User can select any table name and click on connect.

  26. Select Excel Data source: Based on user selection of data source, input parameters for MS Excel 2003 are requested

  27. Select Excel Data source: Based on user selection if multiple sheets are present in single Excel file, the list is displayed for user to select any one sheet. User can specify if the first row contains column headers

  28. Select Flat File Data source: Based on user selection of data source input parameters for Flat File are requested

  29. Select Flat File Data source: The flat file and its delimiter once selected, user can now specify if the first row contains the column headers and click on connect

  30. Display Data Tables: Once the data sources get connected corresponding data grids are populated with the data

  31. Conclusion Discussed the general information, overview and the details about the end user of project application Explained some of the application features as required by user The project design and plan has been covered The project screenshots have been presented

  32. References Chevron Information Technology Corporation: http://www.chevron.com/technology/info_technology/ Use Case story: http://en.wikipedia.org/wiki/Use_case SRS template: www.processimpact.com/process_assets/srs_template.doc

More Related