1 / 15

JSQL Edit v1.0 Requirements Presentation JSQL Edit Team | 03.15.02

JSQL Edit v1.0 Requirements Presentation JSQL Edit Team | 03.15.02. >Introduction. JSQL Edit team. Kanwar Hazrah & Rana Khartabil & Irwin Kwan & Benson Chan. JSQL Edit v1.0 Requirements Presentation JSQL Edit Team | 03.15.02. >Customer & Problem. The Customer

elden
Download Presentation

JSQL Edit v1.0 Requirements Presentation JSQL Edit Team | 03.15.02

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. JSQL Edit v1.0Requirements PresentationJSQL Edit Team | 03.15.02 >Introduction JSQL Edit team Kanwar Hazrah & Rana Khartabil & Irwin Kwan & Benson Chan

  2. JSQL Edit v1.0Requirements PresentationJSQL Edit Team | 03.15.02 >Customer & Problem The Customer - Cognos Inc., business intelligence software maker - Gururaj Deshpande, user-interface manager The Problem -Developers are using an array of SQL editors - Need to simplify the process of working on the diverse databases (consistent GUI)

  3. JSQL Edit v1.0Requirements PresentationJSQL Edit Team | 03.15.02 >Solution overview System Description - Java and JDBC-based SQL editor - Connectivity to Oracle & MySQL (for final deliverable) - Provides consistent easy-to-use GUI Value to customer - Streamlined database-querying for different DBMS’ - Shorter learning-curve for developers working on different DBMS’ -Proof-of-concept for use of JDBC capabilities

  4. JSQL Edit v1.0Requirements PresentationJSQL Edit Team | 03.15.02 >Requirements Main Functional Requirements - Connectivity to Oracle & MySQL through JDBC - Intuitive GUI - Edit SQL statements - Query databases - View results in tabular form - Tree-view of database

  5. JSQL Edit v1.0Requirements PresentationJSQL Edit Team | 03.15.02 >GUI_Scenario Use-case scenario

  6. JSQL Edit v1.0Requirements PresentationJSQL Edit Team | 03.15.02 >GUI_Scenario

  7. JSQL Edit v1.0Requirements PresentationJSQL Edit Team | 03.15.02 >GUI_Scenario

  8. JSQL Edit v1.0Requirements PresentationJSQL Edit Team | 03.15.02

  9. JSQL Edit v1.0Requirements PresentationJSQL Edit Team | 03.15.02 >GUI_Scenario

  10. JSQL Edit v1.0Requirements PresentationJSQL Edit Team | 03.15.02

  11. JSQL Edit v1.0Requirements PresentationJSQL Edit Team | 03.15.02 >Architecture high-level view

  12. JSQL Edit v1.0Requirements PresentationJSQL Edit Team | 03.15.02 >Details Technologies used - Java 1.4 w/ Swing - JDBC 2.0 - SourceForge.net for project management tools

  13. JSQL Edit v1.0Requirements PresentationJSQL Edit Team | 03.15.02 >Testing QA process description - Unit testing, System testing, GUI evaluation & manual testing - Built-in testing in code for automation - Test data/validation data design based on requirements & dummy data from customer - Testing/regression testing in every project phase - Usability test sessions at Cognos

  14. JSQL Edit v1.0Requirements PresentationJSQL Edit Team | 03.15.02 >Project Plan Brahma Phase (Creator God) May 2002 V.02 Alpha 1 Client prototype Connectivity & basic querying Vishnu Phase (Preserver God) September 2002 V.06 Beta 1 Release GUI: Basic Tree-view, tool bar SQL parsing for edit box Mahesh Phase (Giver God) December 2002 V.1 Client Release GUI: Complete Tree-view, drag & drop

  15. JSQL Edit v1.0Requirements PresentationJSQL Edit Team | 03.15.02 >Q&A

More Related