1 / 15

Database Systems Engineering for Enterprise Applications

This course covers conceptual, logical, physical, and user interface design for database management systems with a focus on enterprise applications and software engineering. Students will learn about object-oriented models, model-driven development, object-relational mapping, and database GUI components. They will also complete small programming assignments using Java and Oracle JDeveloper and work on a project. The course is relevant for students pursuing a Master of Science or Master of Software Engineering degree. Prerequisites include general introductory courses on design, database, and SQL.

sherril
Download Presentation

Database Systems Engineering for Enterprise Applications

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 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, hankley@cis.ksu.edu http://people.cis.ksu.edu/~hankley/ (follow link to CIS764) http://www.cis.ksu.edu

  2. 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 EngineeringSoftware 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. http://www.cis.ksu.edu

  3. 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. http://www.cis.ksu.edu

  4. 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 http://www.cis.ksu.edu

  5. 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 http://www.cis.ksu.edu

  6. 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 http://www.cis.ksu.edu

  7. 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) http://www.cis.ksu.edu

  8. 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. http://www.cis.ksu.edu

  9. CIS 764 Database Systems Engineering … what is Emeritus * http://www.cis.ksu.edu

  10. 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 ] http://www.cis.ksu.edu

  11. 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. http://www.cis.ksu.edu

  12. 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 ) http://www.cis.ksu.edu

  13. 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 http://www.cis.ksu.edu

  14. 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. http://www.cis.ksu.edu

  15. CIS 764 Database Systems Engineering end http://www.cis.ksu.edu

More Related