CIS 764 Database Systems EngineeringSlide 2Slide 3Slide 4Slide 5Slide 6Slide 7Slide 8Slide 9Slide 10Slide 11Slide 12Slide 13Slide 14Slide 15Fall 2008http://www.cis.ksu.edu1CIS 764 Database Systems EngineeringL1: Introduction to …CIS 764 Enterprise Database Systems Engineering:Software Engineering focus for Shared DB Applications.Fall 2008Bill Hankley, [email protected]://people.cis.ksu.edu/~hankley/ (follow link to CIS764)Fall 2008http://www.cis.ksu.edu2CIS 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 2008http://www.cis.ksu.edu3CIS 764 Database Systems EngineeringPerspective: 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 2008http://www.cis.ksu.edu4CIS 764 Database Systems EngineeringPerspective: 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 & evaluationCIS 761 .. Data Base Management Systems (more formal view, for MS)CIS 860, 864 .. don’t count on these to be offeredFall 2008http://www.cis.ksu.edu5CIS 764 Database Systems EngineeringEnterprise applications: shared applicationsnetwork access (likely Web, also smart client)DB dependentnominally 3 tier:client middleware server:managed objectsDB serverFall 2008http://www.cis.ksu.edu6CIS 764 Database Systems EngineeringEnterprise 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, PHPFall 2008http://www.cis.ksu.edu7CIS 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 2008http://www.cis.ksu.edu8CIS 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 2008http://www.cis.ksu.edu9CIS 764 Database Systems Engineering … what is Emeritus *Fall 2008http://www.cis.ksu.edu10CIS 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 2008http://www.cis.ksu.edu11CIS 764 Database Systems EngineeringCourse structure: minimal lectures ; lecture = guide to study subjectsGrading: * 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 2008http://www.cis.ksu.edu12CIS 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 2008http://www.cis.ksu.edu13CIS 764 Database Systems Engineering Assignments: H2: Set up a home page in the CIS directory. (see guidelines to be listed on the index page:
View Full Document