Transcript 764_1_Intro

CIS 764 Database Systems Engineering
L1: Introduction to …
CIS 764 Enterprise Database Systems Engineering:
Software Engineering focus for Shared DB Applications.
Fall 2008
Bill Hankley, [email protected]
http://people.cis.ksu.edu/~hankley/ (follow link to CIS764)
Fall 2008
http://www.cis.ksu.edu
1
CIS 764 Database Systems Engineering
Syllabus page:
http://people.cis.ksu.edu/~hankley/d764/764Syllabus.html
Note course description:
Catalog: Conceptual, logical, physical, and user interface design
for database management systems. Pr.: CIS 501
Actual: Enterprise Database System Design and Engineering
Software engineering for enterprise (web based) database applications,
with specific focus on Oracle tools and J2EE architecture.
Object-oriented models, model-driven development, object-relational mapping;
DB GUI components, data access patterns.
Small programming assignments (using Java and Oracle JDeveloper),
project, and student presentation.
Grading based upon performance and timely progress
in both assignments and project.
Fall 2008
http://www.cis.ksu.edu
2
CIS 764 Database Systems Engineering
Perspective: Two CIS Master’s degree programs:
Master of Science:
more theory oriented (automata or formal languages)
required for most PhD studies,
CIS764 is a free elective,
requires investigative project or thesis
(often with supporting implementation CIS690)
Master of Software Engineering:
concepts and technologies for building software systems
required “theory” course is 771 (verification)
CIS764 counts as the “one SE elective”
requires MSE Project (6 hours credit, full life cycle)
But … most companies do not distinguish !
CIS 764 is oriented toward MSE project.
Fall 2008
http://www.cis.ksu.edu
3
CIS 764 Database Systems Engineering
Perspective: related courses
CIS501 .. undergrad prereq .. general intro to design, UML
CIS560 .. undergrad prereq ... general intro to DB and SQL
CIS 748 .. Software Management … oriented to MSE project
CIS 726 ... Advanced WWW Technology (Sp, companion course)
CIS 895 .. MSE Project .. 3 presentations:
requirements
design
implementation & evaluation
CIS 761 .. Data Base Management Systems (more formal view, for MS)
CIS 860, 864 .. don’t count on these to be offered
Fall 2008
http://www.cis.ksu.edu
4
CIS 764 Database Systems Engineering
Enterprise applications:
shared applications
network access (likely Web, also smart client)
DB dependent
nominally 3 tier:
client
middleware server:
managed objects
DB server
Fall 2008
http://www.cis.ksu.edu
5
CIS 764 Database Systems Engineering
Enterprise technologies:
Oracle:
(1) JDeveloper, OC4J middle-ware server, Oracle DB server
(2) forms tools
Java: Eclipse w enterprise config: Tomcat, ORM, MySQL, ..
dotNet: Visual Studio, C# or VB, MS SQL server
Frameworks:
(1) Ruby + Rails
(2) Content management systems
(3) … others
LAMP: Linux, Apache, MySQL, PHP
Fall 2008
http://www.cis.ksu.edu
6
CIS 764 Database Systems Engineering
Syllabus page:
http://people.cis.ksu.edu/~hankley/d764/764Syllabus.html
Note links (and non-posted):
Old links …. from F07 class … just for comparison, non-binding
F08:
Log …. Outline/record of topic for each day
Slides … posted lectures (posted after the class)
Assignments … brief statement of each assignment
(see slides for more details)
Tutorials … from students
Students08 … picture and brief biography
( Homework, Projects, Grading .. not public links)
Fall 2008
http://www.cis.ksu.edu
7
CIS 764 Database Systems Engineering
Syllabus page:
Bill Hankley,
Professor Emeritus *
http://people.cis.ksu.edu/~hankley/
“Office hours”
general consulting …. None
class discussion …. Immediately after class
by appointment … some Wed., some Fri. AM
send email
for off-campus students:
send email or call cell number (evenings)
* will serve on MSE Committees related to CIS764
Prov 9:10 The fear of the LORD is the beginning of wisdom,
and knowledge of the Holy One is understanding.
Fall 2008
http://www.cis.ksu.edu
8
CIS 764 Database Systems Engineering
… what is Emeritus *
Fall 2008
http://www.cis.ksu.edu
9
CIS 764 Database Systems Engineering
Course structure:-----------------------------------------|
V
V
install tools
Case studies
M-L files
JDev tutorials
Pet store
OOPSLA example
V
?? recent MS projects
|
V
student contributions:
group design+implementation project
(1) tutorial + demo
(2) paper +
“executive overview” presentation
------------------------------------------------V
final wrapup questions (overview, eval)
[ no exams, no work into exam week ]
Fall 2008
http://www.cis.ksu.edu
10
CIS 764 Database Systems Engineering
Course structure:
minimal lectures ;
lecture = guide to study subjects
Grading:
* completion & timeliness of assignments
* timeliness and evaluation of constructive items:
+ tutorial
+ short paper
+ design + implementation project
* “class contribution” / personal interaction#
# do something to introduce yourself to the instructor.
Fall 2008
http://www.cis.ksu.edu
11
CIS 764 Database Systems Engineering
Assignments:
H1: Send a contact email. Due: Today !
Send a 4-digit ID for grading (usually last 4 of SID )
General email guidelines:
short, meaningful subject
correct grammar & punctuation
business English
sign your name ( first last)
name any attached files as:
LastName_Subject ( not H1 … )
large files … send zip or URL
docs … send Word, PDF, or HTML
check for relative links
pictures … send smallish file (jpg)
diagrams .. Send jpg or gif (with readable text )
Fall 2008
http://www.cis.ksu.edu
12
CIS 764 Database Systems Engineering
Assignments:
H2: Set up a home page in the CIS directory.
(see guidelines to be listed on the index page:
http://www.cis.ksu.edu/people/students )
Send email with page link .
Guidelines:
minimal size,
minimal blinking, animation, flash, etc.
include your name, email link, background, smallish picture.
links to other pages: your courses, project, committee, …
correct page title,
last-update date.
remove any dead links
Fall 2008
http://www.cis.ksu.edu
13
CIS 764 Database Systems Engineering
Assignments:
H3: email:
(a) brief biography: Due: Today !
Name, background education (school, degree, yr),
work, degree program, estimated completion,…
Use 3ed person.
See F07 examples.
(b) jpg picture : Due: soon
LastName_pic ,
approx. 1.5 in x 1.0 in; 150 x 100 pixel
e.g. Kxxx Xxxxx received his Bachelors degree in Computer Science and
Engineering from Jawaharlal Nehru Technological University, INDIA in May 2007.
He is enrolled in the M.S. program Computer Science. He expects to graduate in
May 2009. He worked as a student intern in Tata Consultancy Services Ltd. His
areas of interest are compiler designing, database systems and datawarehousing.
Fall 2008
http://www.cis.ksu.edu
14
CIS 764 Database Systems Engineering
end
Fall 2008
http://www.cis.ksu.edu
15