csci 6838.1 research project and seminar team #1 10/02/2007
DESCRIPTION
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 [email protected]. Team Members Amruta Mehendale (Team Leader) [email protected] Abhisheik Deo [email protected] - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007](https://reader035.vdocuments.us/reader035/viewer/2022070404/56813b87550346895da4b3a6/html5/thumbnails/1.jpg)
CSCI 6838.1 Research Project and Seminar
Team #110/02/2007
![Page 2: CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007](https://reader035.vdocuments.us/reader035/viewer/2022070404/56813b87550346895da4b3a6/html5/thumbnails/2.jpg)
2
Table of ContentsTopic Slide Number
Team information ………………………………………………3
Customer Information ………………………………………………4
Overview ………………………………………………5
End User ………………………………………………6
Application Features …………………………………………..7-12
Use Case Diagram ……………………………………………..13
Architecture Diagram ……………………………………………..14
Class Diagram ……………………………………………..15
Technology ……………………………………………..16
Project Timeline ………………………………………….17-18
Development Team ……………………………………………..19
Screenshots ………………………………………….20-29
Conclusion ……………………………………………..30
References ……………………………………………..31
![Page 3: CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007](https://reader035.vdocuments.us/reader035/viewer/2022070404/56813b87550346895da4b3a6/html5/thumbnails/3.jpg)
3
Mentor
Mr. Todd Guillory
Faculty Advisor
Dr. Kwok Bun Yue
Team MembersAmruta Mehendale (Team Leader)
Abhisheik Deo
Aiyaz Paniwala
Sanjeev Gowda
Team Information
![Page 4: CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007](https://reader035.vdocuments.us/reader035/viewer/2022070404/56813b87550346895da4b3a6/html5/thumbnails/4.jpg)
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 [email protected]
![Page 5: CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007](https://reader035.vdocuments.us/reader035/viewer/2022070404/56813b87550346895da4b3a6/html5/thumbnails/5.jpg)
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.
![Page 6: CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007](https://reader035.vdocuments.us/reader035/viewer/2022070404/56813b87550346895da4b3a6/html5/thumbnails/6.jpg)
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
![Page 7: CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007](https://reader035.vdocuments.us/reader035/viewer/2022070404/56813b87550346895da4b3a6/html5/thumbnails/7.jpg)
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
![Page 8: CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007](https://reader035.vdocuments.us/reader035/viewer/2022070404/56813b87550346895da4b3a6/html5/thumbnails/8.jpg)
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
![Page 9: CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007](https://reader035.vdocuments.us/reader035/viewer/2022070404/56813b87550346895da4b3a6/html5/thumbnails/9.jpg)
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
![Page 10: CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007](https://reader035.vdocuments.us/reader035/viewer/2022070404/56813b87550346895da4b3a6/html5/thumbnails/10.jpg)
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
![Page 11: CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007](https://reader035.vdocuments.us/reader035/viewer/2022070404/56813b87550346895da4b3a6/html5/thumbnails/11.jpg)
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
![Page 12: CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007](https://reader035.vdocuments.us/reader035/viewer/2022070404/56813b87550346895da4b3a6/html5/thumbnails/12.jpg)
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.
![Page 13: CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007](https://reader035.vdocuments.us/reader035/viewer/2022070404/56813b87550346895da4b3a6/html5/thumbnails/13.jpg)
13
Use Case Diagram
![Page 14: CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007](https://reader035.vdocuments.us/reader035/viewer/2022070404/56813b87550346895da4b3a6/html5/thumbnails/14.jpg)
14
Architecture Diagram
Data Base Logic
Client GUI
Data Base Connector
User Forms
User Forms
User Forms
Database
![Page 15: CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007](https://reader035.vdocuments.us/reader035/viewer/2022070404/56813b87550346895da4b3a6/html5/thumbnails/15.jpg)
15
Class Diagram
![Page 16: CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007](https://reader035.vdocuments.us/reader035/viewer/2022070404/56813b87550346895da4b3a6/html5/thumbnails/16.jpg)
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
![Page 17: CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007](https://reader035.vdocuments.us/reader035/viewer/2022070404/56813b87550346895da4b3a6/html5/thumbnails/17.jpg)
17
Project Timeline
Tasks Assigned To
Week
# 1
#2
#3
#4
#5
#6
#7
#8
#9
# 10
# 11
# 12
# 13
# 14
# 15
Team setup and establishing logistical arrangement.
All
Setting up project Website
Aiyaz Week #1 – Week #3
High level architecture diagram
Sanjeev Week #2 – Week #5
Software Requirements Specification
Amruta, Sanjeev Week #2 – Week #5
User Interface Abhisheik
![Page 18: CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007](https://reader035.vdocuments.us/reader035/viewer/2022070404/56813b87550346895da4b3a6/html5/thumbnails/18.jpg)
18
Project Timeline (contd)
Tasks Assigned ToWeek
# 1
#2
#3
#4
#5
#6
#7
#8
#9
# 10
# 11
# 12
# 13
# 14
# 15
Maintaining the project website
Aiyaz Week #1 – Week #15
Connector Logic AllWeek #5 – Week #9
Data resolution Abhisheik, Amruta
Week #4 – Week #10
Data joinAbhisheik, Amruta, Sanjeev
Week #9 – Week #13
Algorithm for percentage matching
Sanjeev, AiyazWeek #10 – Week #13
Documentation AllWeek #2 – Week #6
Week #13 – Week #15
![Page 19: CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007](https://reader035.vdocuments.us/reader035/viewer/2022070404/56813b87550346895da4b3a6/html5/thumbnails/19.jpg)
19
Development Team
Role Team Member(s)
Team Leader Amruta Mehendale
Research and Design All
Webmaster Aiyaz Paniwala
Testing and Debugging All
Developers
- Front End Logic Amruta Mehendale, Aiyaz Paniwala
- Back End Logic Abhisheik Deo, Sanjeev Gowda
Documentation All
![Page 20: CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007](https://reader035.vdocuments.us/reader035/viewer/2022070404/56813b87550346895da4b3a6/html5/thumbnails/20.jpg)
20
DI&R Screen Shots
![Page 21: CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007](https://reader035.vdocuments.us/reader035/viewer/2022070404/56813b87550346895da4b3a6/html5/thumbnails/21.jpg)
21
First Screen : First window form will always remain open, for the user to select menu options.
![Page 22: CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007](https://reader035.vdocuments.us/reader035/viewer/2022070404/56813b87550346895da4b3a6/html5/thumbnails/22.jpg)
22
Select Data source : User selects Open command from File menu and then selects the type of data source to connect to
![Page 23: CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007](https://reader035.vdocuments.us/reader035/viewer/2022070404/56813b87550346895da4b3a6/html5/thumbnails/23.jpg)
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
![Page 24: CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007](https://reader035.vdocuments.us/reader035/viewer/2022070404/56813b87550346895da4b3a6/html5/thumbnails/24.jpg)
24
Select Access Data source: If the Selected Access file is password protected, the user is prompted to enter a username and password
![Page 25: CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007](https://reader035.vdocuments.us/reader035/viewer/2022070404/56813b87550346895da4b3a6/html5/thumbnails/25.jpg)
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.
![Page 26: CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007](https://reader035.vdocuments.us/reader035/viewer/2022070404/56813b87550346895da4b3a6/html5/thumbnails/26.jpg)
26
Select Excel Data source: Based on user selection of data source, input parameters for MS Excel 2003 are requested
![Page 27: CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007](https://reader035.vdocuments.us/reader035/viewer/2022070404/56813b87550346895da4b3a6/html5/thumbnails/27.jpg)
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
![Page 28: CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007](https://reader035.vdocuments.us/reader035/viewer/2022070404/56813b87550346895da4b3a6/html5/thumbnails/28.jpg)
28
Select Flat File Data source: Based on user selection of data source input parameters for Flat File are requested
![Page 29: CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007](https://reader035.vdocuments.us/reader035/viewer/2022070404/56813b87550346895da4b3a6/html5/thumbnails/29.jpg)
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
![Page 30: CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007](https://reader035.vdocuments.us/reader035/viewer/2022070404/56813b87550346895da4b3a6/html5/thumbnails/30.jpg)
30
Display Data Tables: Once the data sources get connected corresponding data grids are populated with the data
![Page 31: CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007](https://reader035.vdocuments.us/reader035/viewer/2022070404/56813b87550346895da4b3a6/html5/thumbnails/31.jpg)
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
![Page 32: CSCI 6838.1 Research Project and Seminar Team #1 10/02/2007](https://reader035.vdocuments.us/reader035/viewer/2022070404/56813b87550346895da4b3a6/html5/thumbnails/32.jpg)
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