CIS 764 Database Systems Engineering

seedjaggedInternet και Εφαρμογές Web

12 Νοε 2013 (πριν από 3 χρόνια και 8 μήνες)

97 εμφανίσεις

Fall 2007

http://www.cis.ksu.edu

1

CIS 764 Database Systems Engineering


L10: About Homeworks



Struts …


EJB3 … (maybe)



Step
-
by
-
step Tutorial


Presentation



ADF




Jobs review




Fall 2007

http://www.cis.ksu.edu

2

CIS 764 Database Systems Engineering


Note about schedule:


Monday, October 1 is a student holiday,


but we will meet Oct. 2 ed.



but, no class Oct 23 & 25.


(should be:


OOPSLA Conference, Oct. 21
-
25

,
Montreal


speakers: Guy Steel (Sun),




Fred Brooks,


John McCarthy


David Parnas


Patti Maes (MIT)


others


Design Fest: teams attack at problem using different methods



http://designfest.acm.org/

Fall 2007

http://www.cis.ksu.edu

3

CIS 764 Database Systems Engineering


Step
-
by
-
step tutoral:



Requires prior approval of topic.


Focus on enterprise web
-
DB applications;



( "better" topics should relate to the newer / emerging technologies)



You do some development / management;


write web page or ppt guide with some screen snapshots




( 10


20 images, cropped).



You may extend (or correct) versions of older tutorials. (Several are weak.)




Note: There are 33 people in the class;



there may be some overlap or coordination of work.






Fall 2007

http://www.cis.ksu.edu

4

CIS 764 Database Systems Engineering


Example topics

(suggestions , not restrictions):

JDeveloper:



Servlet filters



more JSF features,





Ajax validation



Web DB app



more ADF examples <<<



Ora "business intelligence" rules



OR mapping : toplink


, Hibernate



mySQL



Web services (fwd & backward)



BEPL


… other Oracle tutorials (many)


*Oracle Designer / HeadStart



Enterprise Manager



Oracle DBMS


install , manager

* ADF "Service Company"


install & demo

* JUnit testing of middleware components





… next slide



Fall 2007

http://www.cis.ksu.edu

5

CIS 764 Database Systems Engineering

Other:



Spring



Ruby
-
rails



WonderMachine (WMEE)



myFaces



mapViewer



JBoss
-
Seam



Eclipse
-

Tomcat



VS / webServices



data mining tool



DB data generator



use of Google or Amazon web services




examples from other books, other on
-
line tutorials







Fall 2007

http://www.cis.ksu.edu

6

CIS 764 Database Systems Engineering

Class presentation:


Requires prior approval of topic.

Focus on enterprise web
-
DB applications;



( "better" topics should relate to the newer / emerging technologies.)



…. may relate to your tutorial, but not required topic.


…. should focus on concepts, not step
-
by
-
step instructions



( may show some steps from your step
-
by
-
step tutorial).


There are many rich topics, but not for step
-
by
-
step tutorials .


… should last for 5 to 10 minutes , with time for questions afterwards.


… Prepare Powepoint slides:




either attach voice annotations or record video w Tegrity or Wimba .



Fall 2007

http://www.cis.ksu.edu

7

CIS 764 Database Systems Engineering

Also submit a short overview paper (2 to 5 pages), with references.


… may be submitted after the talk.


… may include 1 or 2 images, but not all from the presention.


… should have a title, your name;




… written in the 3ed person ( no "I"


or "you" ).


… Word, HTML, or PDF format.














Fall 2007

http://www.cis.ksu.edu

8

CIS 764 Database Systems Engineering



Example topics:




enterprise technologies:



CRM


ERP ( ugh)



workflow management



reporting tools;









dashboard tools



compliance


data warehousing, business intelligence/ mining



web technologies:





portals, portlets,



CMS



web services, SOA



Ajax



Ruby , Ruby, Spring, WonderMachine (WMEE) , others









security






…. next slide

Fall 2007

http://www.cis.ksu.edu

9

CIS 764 Database Systems Engineering


DBMS technologies:



back
-
up and recovery



data integrity and cleansing



Google DB technologies



image DB's; geographic DBs



other:



Oracle Application Server



dotNet vs J2EE architecture and features



component and performance testing



ontologies as related to 764











Fall 2007

http://www.cis.ksu.edu

10

CIS 764 Database Systems Engineering



So far:


Name




Tutorial


Presentation


B.


RonR


same

A.


OQL


same

K.


EJB3


??














Fall 2007

http://www.cis.ksu.edu

11

CIS 764 Database Systems Engineering
















Fall 2007

http://www.cis.ksu.edu

12

CIS 764 Database Systems Engineering


Homework:


Oracle tutorial:


“ Web Application with ADF Business Components and JSF”


includes master
-
detail page, a search page, and edit page.



do “in essence” to show employee + PO’s


http://www.oracle.com/technology/obe/obe1013jdev/


masterdetail_adf_bc/master
-
detail_pagewith_adf_bc.htm




see images next:














Fall 2007

http://www.cis.ksu.edu

13

CIS 764 Database Systems Engineering
















Fall 2007

http://www.cis.ksu.edu

14

CIS 764 Database Systems Engineering
















Fall 2007

http://www.cis.ksu.edu

15

CIS 764 Database Systems Engineering
















Fall 2007

http://www.cis.ksu.edu

16

CIS 764 Database Systems Engineering


Homework: Report of 2 Job ads related to 764:



Search for ad’s for 2 jobs related to 764.


(one may be local, at least one in major technical city)



Report:


-

job title


-

brief description (one line)


-

key pre
-
requisites (degree, yrs exp, kind of exp)


-

technology area ( J2EE, sql, dotNet, ???)


-

source name & URL


-

salary (if mentioned)






Fall 2007

http://www.cis.ksu.edu

17

CIS 764 Database Systems Engineering


end