Transcript 764_10_Tut+Talk

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
1
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
2
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
3
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
4
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
5
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
6
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
7
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
8
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
9
CIS 764 Database Systems Engineering
So far:
Name
B.
A.
K.
Fall 2007
Tutorial
RonR
OQL
EJB3
Presentation
same
same
??
http://www.cis.ksu.edu
10
CIS 764 Database Systems Engineering
Fall 2007
http://www.cis.ksu.edu
11
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
12
CIS 764 Database Systems Engineering
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
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
16
CIS 764 Database Systems Engineering
end
Fall 2007
http://www.cis.ksu.edu
17