csci 6838.1 research project and seminar team #1 11/13/2007
DESCRIPTION
CSCI 6838.1 Research Project and Seminar Team #1 11/13/2007. 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] Aiyaz Paniwala - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: CSCI 6838.1 Research Project and Seminar Team #1 11/13/2007](https://reader036.vdocuments.us/reader036/viewer/2022062816/56814d80550346895dbadd9e/html5/thumbnails/1.jpg)
CSCI 6838.1 Research Project and Seminar
Team #111/13/2007
![Page 2: CSCI 6838.1 Research Project and Seminar Team #1 11/13/2007](https://reader036.vdocuments.us/reader036/viewer/2022062816/56814d80550346895dbadd9e/html5/thumbnails/2.jpg)
Mentor
Mr. Todd Guillory
Faculty Advisor
Dr. Kwok Bun [email protected]
Team MembersAmruta Mehendale (Team Leader)[email protected]
Abhisheik [email protected]
Aiyaz [email protected]
Sanjeev [email protected]
Team Information
![Page 3: CSCI 6838.1 Research Project and Seminar Team #1 11/13/2007](https://reader036.vdocuments.us/reader036/viewer/2022062816/56814d80550346895dbadd9e/html5/thumbnails/3.jpg)
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 Guillory
Software EngineerChevron Information Technology CompanyGlobal Consulting & Applications Solutions (GCAS)Houston, Texas 77002Tel 713 754 [email protected]
![Page 4: CSCI 6838.1 Research Project and Seminar Team #1 11/13/2007](https://reader036.vdocuments.us/reader036/viewer/2022062816/56814d80550346895dbadd9e/html5/thumbnails/4.jpg)
Table of ContentsTopic Slide Number
Project Overview ………………………………………………5Application Features …………………………………………….6-9Use Case Diagram ……………………………………………..10Architecture Diagram ……………………………………………..11Class Diagrams …………………………………………12-13Project Demo ……………………………………………..14Implementation Issues ……………………………………………..15Project Tasks …………………………………………16-18Development Team ……………………………………………..19Conclusion ……………………………………………..20References ……………………………………………..21
![Page 5: CSCI 6838.1 Research Project and Seminar Team #1 11/13/2007](https://reader036.vdocuments.us/reader036/viewer/2022062816/56814d80550346895dbadd9e/html5/thumbnails/5.jpg)
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.
![Page 6: CSCI 6838.1 Research Project and Seminar Team #1 11/13/2007](https://reader036.vdocuments.us/reader036/viewer/2022062816/56814d80550346895dbadd9e/html5/thumbnails/6.jpg)
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
![Page 7: CSCI 6838.1 Research Project and Seminar Team #1 11/13/2007](https://reader036.vdocuments.us/reader036/viewer/2022062816/56814d80550346895dbadd9e/html5/thumbnails/7.jpg)
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
![Page 8: CSCI 6838.1 Research Project and Seminar Team #1 11/13/2007](https://reader036.vdocuments.us/reader036/viewer/2022062816/56814d80550346895dbadd9e/html5/thumbnails/8.jpg)
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
![Page 9: CSCI 6838.1 Research Project and Seminar Team #1 11/13/2007](https://reader036.vdocuments.us/reader036/viewer/2022062816/56814d80550346895dbadd9e/html5/thumbnails/9.jpg)
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
![Page 10: CSCI 6838.1 Research Project and Seminar Team #1 11/13/2007](https://reader036.vdocuments.us/reader036/viewer/2022062816/56814d80550346895dbadd9e/html5/thumbnails/10.jpg)
Use Case Diagram
![Page 11: CSCI 6838.1 Research Project and Seminar Team #1 11/13/2007](https://reader036.vdocuments.us/reader036/viewer/2022062816/56814d80550346895dbadd9e/html5/thumbnails/11.jpg)
Architecture Diagram
Data Base Logic
Client GUI
Data Base Connector
User Forms
User Forms
User Forms
Database
![Page 12: CSCI 6838.1 Research Project and Seminar Team #1 11/13/2007](https://reader036.vdocuments.us/reader036/viewer/2022062816/56814d80550346895dbadd9e/html5/thumbnails/12.jpg)
Class Diagram for Project
![Page 13: CSCI 6838.1 Research Project and Seminar Team #1 11/13/2007](https://reader036.vdocuments.us/reader036/viewer/2022062816/56814d80550346895dbadd9e/html5/thumbnails/13.jpg)
Class Diagram for UI
![Page 14: CSCI 6838.1 Research Project and Seminar Team #1 11/13/2007](https://reader036.vdocuments.us/reader036/viewer/2022062816/56814d80550346895dbadd9e/html5/thumbnails/14.jpg)
Project Demo
![Page 15: CSCI 6838.1 Research Project and Seminar Team #1 11/13/2007](https://reader036.vdocuments.us/reader036/viewer/2022062816/56814d80550346895dbadd9e/html5/thumbnails/15.jpg)
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
![Page 16: CSCI 6838.1 Research Project and Seminar Team #1 11/13/2007](https://reader036.vdocuments.us/reader036/viewer/2022062816/56814d80550346895dbadd9e/html5/thumbnails/16.jpg)
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
![Page 17: CSCI 6838.1 Research Project and Seminar Team #1 11/13/2007](https://reader036.vdocuments.us/reader036/viewer/2022062816/56814d80550346895dbadd9e/html5/thumbnails/17.jpg)
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
![Page 18: CSCI 6838.1 Research Project and Seminar Team #1 11/13/2007](https://reader036.vdocuments.us/reader036/viewer/2022062816/56814d80550346895dbadd9e/html5/thumbnails/18.jpg)
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
![Page 19: CSCI 6838.1 Research Project and Seminar Team #1 11/13/2007](https://reader036.vdocuments.us/reader036/viewer/2022062816/56814d80550346895dbadd9e/html5/thumbnails/19.jpg)
Development TeamRole 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 11/13/2007](https://reader036.vdocuments.us/reader036/viewer/2022062816/56814d80550346895dbadd9e/html5/thumbnails/20.jpg)
Conclusion• Discussed the various application features required by
the user
• The project design has been covered
• Project demo was given
![Page 21: CSCI 6838.1 Research Project and Seminar Team #1 11/13/2007](https://reader036.vdocuments.us/reader036/viewer/2022062816/56814d80550346895dbadd9e/html5/thumbnails/21.jpg)
References
• Chevron Information Technology Corporation:
http://www.chevron.com/technology/info_technology/
• MSDN forumshttp://forums.microsoft.com/msdn