CIS 764 Database Systems Engineering

pielibraryInternet and Web Development

Dec 4, 2013 (3 years and 8 months ago)

115 views

Fall 2008

http://www.cis.ksu.edu

1

CIS 764 Database Systems Engineering

L14: Mid
-
point:


Status: grading, remaining topics, assignments



good news



other news









Fall 2008

http://www.cis.ksu.edu

2

CIS 764 Database Systems Engineering





2
nd

half:



tutorial, paper >> presentation


team project >> report


project reviews


fall break



Grading will be based on timeliness and content.









Fall
2008

http://www.cis.ksu.edu

3

CIS 764 Database Systems Engineering























ejb2

ID

5

1488

5

5302

5

9047

5

3252

5

8484

4

8888

3

42

3

728

0

7955

0

9471

0

4182

Second grading of ejb’s …

If not done, make arrangements to work with other person


(or with TA).

Fall
2008

http://www.cis.ksu.edu

4

CIS 764 Database Systems Engineering


(1) Your own
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 guide with some screen snapshots




( perhaps 15


25 images, cropped, readable in browser).


Next student should be able to follow your instructions to replicate


your work.



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


(See tutorials07; several are weak.)









Fall 2008

http://www.cis.ksu.edu

5

CIS 764 Database Systems Engineering


Possible technologies (suggestions):



Oracle:


Jdeveloper


Forms


WebLogic server


Eclipse:


mySQL, Tomcat, myFaces


dotNet:


Visual Studio, db controls, MSSQL


other frameworks: *


Ruby
-
Rails,


Content Management systems


WonderMachine (WMEE)


Google, Amazon web services


… next slide



Fall 2008

http://www.cis.ksu.edu

6

CIS 764 Database Systems Engineering


Example topics (suggestions , not restrictions):





more ADF examples, components


graphic components, mapviewers



Ora "business intelligence" rules



OR mapping : Hibernate



Web services (fwd & backward)



BEPL


… other Oracle tutorials (many)




*Oracle Designer



Enterprise Manager



* ADF "Service Company"


install & demo



testing:


data generators,


Jmeter, JUnit testing of middleware components




data mining




… next slide



Fall 2008

http://www.cis.ksu.edu

7

CIS 764 Database Systems Engineering

(2) Short technical paper (nominal 2 pp., 5 pp max):





conceptual (not “how to” );


prior approval of topic



Title,


include you name on paper,


nominal 1 ½ pages of text;


references (more than just URLs):


author, “title”, journal/publisher, date, pages, link


author, “title”, source, (date), size in pp, link, date_viewed


just a few images allowed;


header: title, page number, date


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


or "you" );


spell checked; avoid “sales talk”


key sentence in paragraph


… prefer Word doc.;


may be related to the tutorial topic.






Fall 2008

http://www.cis.ksu.edu

8

CIS 764 Database Systems Engineering



Example topics:




enterprise technologies:



CRM


ERP



workflow management



reporting tools;









dashboard tools



compliance


data warehousing, business intelligence/ mining



web technologies:





portals, portlets,



CMS



other frameworks,










security






…. next slide

Fall 2008

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 WebLogic Server



dotNet vs J2EE architecture and features



component and performance testing



ontologies as related to 764



database / data access patterns


WS patterns










Fall 2008

http://www.cis.ksu.edu

10

CIS 764 Database Systems Engineering

(3) Class presentation:


…of either the paper topic (preferred) or the tutorial


prior approval of topic;

prior scheduling of date;

prior submission of Powerpoint slides (to be posted).


Plan for 8 to 15 minutes , with time for questions afterwards.


(estimate 1 minute per slide , for non
-
trivial slides)


later: attach voice annotations for posting for off
-
campus group


(option to use Camtasia recording)



Grading based on content, speaking performance, visual structure.

Fall 2008

http://www.cis.ksu.edu

11

CIS 764 Database Systems Engineering



Presentation evaluation form (to be provided):


Speaking:


eye contact


“presence”


volume


number of “uh”, “you know”. “OK”


reading of bullets (avoid)


validity of content


handling of questions


time limit



Fall 2008

http://www.cis.ksu.edu

12

CIS 764 Database Systems Engineering



Presentation evaluation form (to be provided):


Slides:


readability … 7 +
-

2 (except of example list of items)


font


colors


bullets (vs narrative)


balance of concept vs details


diagram, image (as appropriate)


title, name





Fall 2008

http://www.cis.ksu.edu

13

CIS 764 Database Systems Engineering





(4) Group project:


enterprise web
-
db application (see next slides),


design (“architecture” model, UML ,


page flow, page design, process model)


and “concept
-
prototype” implementation


(any technology , but match the design;


brief user’s guide, deployment guide;



demo snapshots of use and test)



Design suggestions: minimal features, but good usability;


( “add , but not edit” is ok;


“select” rather than “enter” is preferred)


Set up some test data.


Fall 2008

http://www.cis.ksu.edu

14

CIS 764 Database Systems Engineering





Teams:



about 4 members per team, 5 teams total;


diversity … nationality, gender, current grade



(two+ people be liaison with the 2 off
-
campus groups)



Progress:


post a brief weekly log.


schedule at least two appointments for review


documents and progress.






Fall 2008

http://www.cis.ksu.edu

15

CIS 764 Database Systems Engineering





Grading:



based on …


progress, timeliness (reviews) 15%


design documents 50%


prototype implementation 25%


final presentation (brief report + “demo” ) 10%






Fall 2008

http://www.cis.ksu.edu

16

CIS 764 Database Systems Engineering





















Set up a group web page. (send link )


group name; topic and technology


identify members;


identify any specific roles for members;


keep, post personal report of hours per week


post a brief weekly log

Set up an index page for the report.


(keep images smallish.)

Report = statement of topic, members


summary of logs


design documents


code stats


screen snapshots


manuals (install, use)


self
-
evaluation

Fall 2008

http://www.cis.ksu.edu

17

CIS 764 Database Systems Engineering
























Final submission:


Post zip file of final report (doc + code).


Turn in hard copy report (w index & page numbers).



Brief presentation to the class (week 16):





Fall 2008

http://www.cis.ksu.edu

18

CIS 764 Database Systems Engineering





Option of two topics:



(a) image management for commercial photographer


and magazine publishing.



PhotoSystem.html (in the Slides directory)



(b) reverse engineer and implement the


Java Adventure Builder System


(code is posted at Sun and reengineered at Oracle).


http://www.oracle.com/technology/tech/java/oc4j/ejb3/howtos
-
ejb3/adventurebuilder
-
ejb3
-
wsm/docs/how
-
to
-
adventurebuilder
-
ejb3
-
wsm.html


http://www.oracle.com/technology/tech/java/oc4j/ejb3/howtos
-
ejb3/adventurebuilder
-
ejb3
-
wsm/docs/how
-
to
-
rebuild
-
adventurebuilder
-
ejb3
-
wsm.html




Fall 2008

http://www.cis.ksu.edu

19

CIS 764 Database Systems Engineering




Technology options …



J2EE ( JDev, Eclipse, Forms , …. )



dotNet (VS )



php



CMS (Drupal)



frameworks … ( Ruby )




Fall 2008

http://www.cis.ksu.edu

20

CIS 764 Database Systems Engineering























Roles …



web
-
master



design doc



GUI



beans / database



co
-
ordinator , docs, slides


Fall 2008

http://www.cis.ksu.edu

21

CIS 764 Database Systems Engineering























On
-
campus … form teams


Off
-
campus … contact me with preferences





end