CIS 764 Database Systems Engineering

CIS 764 Database Systems Engineering L3: Two Assignments Relating to J2EE http://www.cis.ksu.edu

CIS 764 Database Systems Engineering L3: Two Assignments : 0. Set up a homeworks web site and directory (with obscure access) and send the link (to help instructor keep track of homeworks). 1. Construct a conceptual graph (in the form of a UML object / class model) for some major words of the J2EE model (to practice UML, UML tools, and to better know J2EE model). 2a. Download + install (or use the version in the CIS labs) Oracle JDeveloper (a J2EE development IDE) and post the small Swing-Hello-”name” program (to begin familiarity with JDev). … details follow. http://www.cis.ksu.edu

CIS 764 Database Systems Engineering Your homework submission web site and directory: (Prefer to install this folder on CIS machines ….faster for grading): Some_folder: <<< perhaps not in your 764 directory Index.html <<< without ref to the homeworks file Homework_folder (perhaps with an obscure name) Index.html <<< page with links to homework items homework_items <<< best as html pages or small jpgs email the link: http://www.cis.ksu.edu/~you/.../Some_folder/Hmwk_folder/Index.html … as live link, absolute, not relative link. http://www.cis.ksu.edu

CIS 764 Database Systems Engineering Index.html: Homework for Bill Hankley <<< your name (so not credited to wrong person) Week: Item: <<< the week you posted the work 2 Conceptual Graph (comments if needed) 2 Hello app using JDev link 3 Discussion of tables errors link …. … relatively small submissions … include your name within each document (and key images). … remember .. Each page should have a title. … simple black on white for text … perhaps also send an email (w link), when you post http://www.cis.ksu.edu

CIS 764 Database Systems Engineering Background … what is a conceptual graph (CG): … a semantic model for the meaning of words … … words “characterized” by attributes and relations. … based on work by John Sowa (http://conceptualgraphs.org/ ) …. can be represented in visual form (http://www.jfsowa.com/cg/cgexamp.htm ) http://www.cis.ksu.edu

CIS 764 Database Systems Engineering In a more simple form, a CG can be viewed as a UML object model (specific words) or a UML class model (kinds, without distinction of instances) or an ER data model where words are instances of various kinds words are objects / entities words may have attributes and relationships are explicitly named. <<<< Verbs (and other kinds) have binary (or higher relations); Nouns typically have unary relations with other nouns. Most key words for J2EE can be viewed as nouns. http://www.cis.ksu.edu

CIS 764 Database Systems Engineering CG as a UML object model: http://www.cis.ksu.edu

CIS 764 Database Systems Engineering Second homework: (a) review J2EE Tutorial or equivalent (b) build a UML conceptual graph of some number of the terms (related to this course) (c) post CG as UML object / class model as an machine generated image (watch for relations, aggregation, composition) “grading” will be “yes/no” evaluation (sample solutions will be discussed in later class) http://www.cis.ksu.edu

CIS 764 Database Systems Engineering OK to hand draw and print and scan draft diagram; but use some UML tool for final version: e.g. JDeveloper does UML class models (but not sequence models  ) I have used Visual Paradigm (Community version) . What UML tool do you recommend? If you have a strong recommendation, please send email. (I will report views to the class.) http://www.cis.ksu.edu

CIS 764 Database Systems Engineering Preparation forhomework: find, download and install Oracle JDeveloper or browse the Oracle site , but use JDev installed in CIS labs. (Version 10.1.3.3 worked in 2007 newer version is 11g … I have not tried it yet) Why? will use JDev for Oracle on-line tutorials.  often the Oracle tutorials will not work exactly with newer versions ! http://www.cis.ksu.edu

CIS 764 Database Systems Engineering What is JDev ? free, IDE, Java based, supported by Oracle IDE = development “environment” for middleware software default configuration for Oracle DB includes: syntax directed editors for JSP, Java page flow generator, GUI builder w JSF UML class builder + reverse engineer from tables, code forward generation of beans, tables (TopLink OR mapper) table editor and viewer local container server (OC4J) option to install copy of Java VM (10.1.3 has separate tool for web services flow) … it is also very big, very slow, … issue of learning curve ! http://www.cis.ksu.edu

CIS 764 Database Systems Engineering equivalent to: NetBeans JBuilder enterprise Eclipse enterprise config Visual Studio Enterprise version typically contains: provision for DB connection object –relational mapping tool UML tool local web server (for testing) deployment tool http://www.cis.ksu.edu

CIS 764 Database Systems Engineering • First Jdev homework: • Build a simple Swing application: • it has some input, • it has some control (a button) • it uses the input in some way • it has some output. • Present a few, small screen snapshot: • show some step in Jdev • show some steps of execution of the app. • post a link to the code. • For example: Aghsan Hello App • Note: images about 40K each . http://www.cis.ksu.edu

CIS 764 Database Systems Engineering • End http://www.cis.ksu.edu

CIS 764 Database Systems Engineering