Transcript 764_3_ReverseEng

CIS 764 Database Systems Engineering
L3:
Status
Reverse Engineering Assignment
JDeveloper Assignment
Fall 2007
http://www.cis.ksu.edu
1
CIS 764 Database Systems Engineering
Discussion items:
* bios were edited for style and consistency
* please include first & last names in emails
* KSU email was almost dead on Tuesday (it will recover)
* only 14 people have submitted URL for homework page:
that link should not be visible on your CIS page;
the homework page should contain links to your homework items;
it should not have an obvious name.
* to find J2EE Overview slides:
google ( “J2EE Overview Ian Cole “ )
* post the J2EE conceptual graph :
with a link from your homework web
with image as jpg or gif format
Fall 2007
http://www.cis.ksu.edu
2
CIS 764 Database Systems Engineering
We reviewed two conceptual graphs in class today:
one follows, the other will be posted later,
comments follow
(see if you can spot the issues before you view the comments).
Fall 2007
http://www.cis.ksu.edu
3
CIS 764 Database Systems Engineering
Fall 2007
http://www.cis.ksu.edu
4
CIS 764 Database Systems Engineering
Issues:
* missing relationship names on several arrows
(as J2EE defines server_architecture)
Note: Tomcat, OC4J, JBoss are instances of J2EE_Server ,
but that information would not be in the J2EE definition.
* no items shown belonging to Web_Container (spelling )
* Session, Entity, Message beans are kinds of EJB
(show extends arrow)
* Server does not directly “connect to” JDBC;
EJB_container uses JDBC
* missing several key components: JAAS, JNDI, others
* there are several kinds of clients (use extends arrow);
html is not a kind of client (it is a format)
Fall 2007
http://www.cis.ksu.edu
5
CIS 764 Database Systems Engineering
About your review of usability of two web sites:
After approval of your selection of two sites,
post your review of usability as an html page
(and post the link on your homework page):
Include:
your name
links to two sites
screen snapshots of features discussed
specific description of issues, as
“too complex” … too vague
but “because it has 183 buttons” explains why.
You do not have to review the whole site,
just discuss one bad feature and one good feature.
Fall 2007
http://www.cis.ksu.edu
6
CIS 764 Database Systems Engineering
If you did not get an Oracle account
(either late enrollment of no CIS account)
contact system staff directly.
Default password was announced in class
(and sent by email of off-campus folks).
Change the password now.
You can use “isqlplus” … web interface for sql commands to Oracle
currently older versions of Mozilla do not connect
IE seems to work
leave the “connect” field blank
JDeveloper … contains tools for sqlplus
currently the old version does not connect
currently, the firewall seems to block off-campus access!
See http://support.cis.ksu.edu/FrequentlyAskedQuestions
…-> “how to Connect to Oracle”
-> connecting from web
Fall 2007
http://www.cis.ksu.edu
7
CIS 764 Database Systems Engineering
We now start two threads of homework:
(1) reverse engineering of a model from tables +
(2) Use of JDeveloper for forward development of enterprise apps
Fall 2007
http://www.cis.ksu.edu
8
CIS 764 Database Systems Engineering
Reverse Engineering:
A sample enterprise application (from Morisseau-LeRoy book).
It deals with people, departments, items, purchase orders (PO’s), etc.
Download:
http://people.cis.ksu.edu/~hankley/d764/book/introduction.zip
which contains:
loadPO.sql
…. Sample data
OracleAQS
… not used now
poexamples.sql … table definitions
use case …..
Narrative text
Fall 2007
http://www.cis.ksu.edu
9
CIS 764 Database Systems Engineering
assignment steps & items to post:
a.
b.
c.
d.
e.
Load tables in your Oracle account (fix the sql problems)
Report explanation of sql problems
Generate a table model diagram
Reverse engineer an object model (UML), using the use cases
Write specification assertions for the P.O. cases
These steps and their relation to the design process will
be discusses on Thursday.
For now, start steps a and b.
Fall 2007
http://www.cis.ksu.edu
10
CIS 764 Database Systems Engineering
Beginning JDeveloper:
Find the Oracle JDeveloper Tutorials page at the Oracle site.
Browse the “Introduction to JDeveloper IDE.
Note that only trivial classes with text I/o to the console are presented!
Some snapshots of a GUI application are shown at
http://people.cis.ksu.edu/~hankley/d764/JDev/SimpleApp/
The snapshots illustrate concepts:
workspace, application, project, package;
project browser, code editor, attribute viewers,
GUI builders, selection of GUI components, component attributes and events.
All of these carry over in some way for web applications and middleware
(for which there are Oracle step-by-step tutorials).
Fall 2007
http://www.cis.ksu.edu
11
CIS 764 Database Systems Engineering
Assignment:
Build a simple GUI (Swing) application that will
accept some input and generate some result based upon the input:
eg. Enter Age: 40 -> [compute_button] -> result = “you are middle aged”.
Post screen snapshots to show use of the IDE and builder
and execution of the program.
Fall 2007
http://www.cis.ksu.edu
12
CIS 764 Database Systems Engineering
end.
Do you need sound annotations for these slides?
If yes, please send email.
Fall 2007
http://www.cis.ksu.edu
13