Database Java Bean

Feng Chen

Outline

• Tools and approaches

• Project overview

• Major contribution

• Project plan

• Cost estimate

• References

• Acknowledgment

Tools and Approach

• Zaurak Oracle8i used to hold database

• Java, JDK1.3, Win-XP/win-NT used for development

• JBuilder used as tool GUI, etc development

Overview

Why Java Bean?

-100% pure java programs.

-simple to develop and easy to use.

-enable well-formed objects to be manipulated in a builder tool during the design time

Overview

Why Jbuilder?- “best of breed” in the rapid application development tool market.

- fully support for building reusable components- visually design GUIs and rapidly build application.

Overview

JavaApplication

DatabaseConnection bean

Database Transaction bean

List Database Items Bean

Oracle8i

Contribution

• The implementation of this project will have positive impacts on CIS 501 and CIS560 teachings and will help students to easily implement database java bean without having further knowledge of using advanced swing complements and latest JDBC technology.

Project Plan

• Phase I: Specification Expected to finish by 9/15/2002 1. Topics selection and literature search. (8/30/2002)

2. Overview of project (9/5/2002) 3. Project plan (9/08/2002) 4. Cost estimation (9/10/2002)

5. Requirement (9/12/2002)

Project Plan

• Phase II: Design Expected to finish by 10/20/20021. Design. (9/30/2002)2. Software quality assurance plan. (10/5/2002)3. Test plan: (10/10/2002) 4. Formal technical inspection.(10/15/2002)

Project Plan

• Phase III: Implementation, Testing and Documentation: Expected to finish by 11/30/2002 1. Coding: (11/15/2002) 2. Testing: (11/20/2002) 3. Project Evaluation.(11/25/2002) 4. Documentation: (11/25/2002) 5. Prepare presentation III(11/30/2002)

Cost Estimates

• The total loc for this project is around

2200 - 2800.

Cost Estimates- Unadjusted function points

  Simple Average Complex  

Sub-TotalCount Weights Count Weights Count Weights

Inputs 3 4 6 6 3 8 72

Outputs 3 4 0 6 0 7 12

Inquiries 0 4 3 6 0 7 18

Files 0 5 2 6 0 15 12

Interfaces 0 5 1 6 0 10 6

Total             120

Cost Estimates- Adjusted function points (cont’)

• Adjusted FP = FPunadjusted * (0.65 + 0.01 * (sum of ratings))= 120 * (0.65+0.01*41)= 127.2

Cost Estimate- COCOMO

• KDSI = 2.8 KLOCPM = 2.4 * (KDSI) ^ 1.05 = 2.4 * 2.8^1.05 = 7.1 (person-month) TDEV = 2.5 * (PM) ^ 0.38 = 2.5 * 7.1 ^ 0.38 = 5.2 (month)

Reference

[1]http://www.borland.com/[2] http://java.sun.com/products/javabeans/[3] L. Bernstein and A. Lubashevsky, "Living with Function Points", in Software Management, 5th Edition, 1997 [4] R. D. Stutzke, "Software Estimating Technology: A Survey", in Software Management, 5th Edition, 1997 [5] R. S. Pressman, "Software Engineering: A practitioner's approach", 4th Edition, 1997

Acknowledgement

Committee:

• Dr. Bill Hankley

• Dr. Dan Andresen

• Dr.Mitchell Neilsen

Questions ?