150 likes | 284 Views
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
E N D
JSQL Edit v1.0Requirements PresentationJSQL Edit Team | 03.15.02 >Introduction JSQL Edit team Kanwar Hazrah & Rana Khartabil & Irwin Kwan & Benson Chan
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)
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
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
JSQL Edit v1.0Requirements PresentationJSQL Edit Team | 03.15.02 >GUI_Scenario Use-case scenario
JSQL Edit v1.0Requirements PresentationJSQL Edit Team | 03.15.02 >GUI_Scenario
JSQL Edit v1.0Requirements PresentationJSQL Edit Team | 03.15.02 >GUI_Scenario
JSQL Edit v1.0Requirements PresentationJSQL Edit Team | 03.15.02
JSQL Edit v1.0Requirements PresentationJSQL Edit Team | 03.15.02 >GUI_Scenario
JSQL Edit v1.0Requirements PresentationJSQL Edit Team | 03.15.02
JSQL Edit v1.0Requirements PresentationJSQL Edit Team | 03.15.02 >Architecture high-level view
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
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
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
JSQL Edit v1.0Requirements PresentationJSQL Edit Team | 03.15.02 >Q&A