met cs 779 w4 advanced database management spring 2010 l.
Skip this Video
Loading SlideShow in 5 Seconds..
MET CS 779 W4 Advanced Database Management Spring 2010 PowerPoint Presentation
Download Presentation
MET CS 779 W4 Advanced Database Management Spring 2010

Loading in 2 Seconds...

play fullscreen
1 / 37

MET CS 779 W4 Advanced Database Management Spring 2010 - PowerPoint PPT Presentation

  • Uploaded on

MET CS 779 W4 Advanced Database Management Spring 2010. Prof. Robert Schudy Meets 6-9 PM Thursdays January 14 th through May 6 th at BU North Campus 100 Apollo Drive, Chelmsford MA. A rich learning environment.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'MET CS 779 W4 Advanced Database Management Spring 2010' - Gideon

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
met cs 779 w4 advanced database management spring 2010

MET CS 779 W4Advanced Database ManagementSpring 2010

Prof. Robert Schudy

Meets 6-9 PM ThursdaysJanuary 14th through May 6th

at BU North Campus

100 Apollo Drive, Chelmsford MA

a rich learning environment
A rich learning environment
  • This course brings the learning technologies of an advanced online class to a face-to-face class.
  • Our course web site is based on the online version of this course.
  • You will be able to access Echo360 multimedia lecture recordings made this Fall in our Boston studio classroom.
  • Our assignments and quizzes are all online.
  • The online course includes about 700 pages of lecture material.
  • All slides will be posted online.
  • We will be audio recording this class.
  • One student will be participating remotely.
how to reach me
How to reach me
  • My office is the last one in the row of MET CS faculty offices on the 2nd floor of 808 Commonwealth Avenue. I’m in my office most of the time during the week, except when I am in meetings. I like meeting students; feel free to stop by at any time.
  • My office phone is (617) 358-0009.
  • My email address is
    • I pick up my email many times per day.
  • I will be in the classroom by 5:30 before class every class day to meet with you.
preparation for this class
Preparation for this class
  • If you have taken CS669 or CS579 you will be well prepared. If you haven’t please speak with me.
  • One of the goals of this course is assuring that you understand the basic material in the introductory courses, no matter how long ago you took them.
  • Accordingly the first online module reviews the prerequisite material.
  • The background material is covered in our main Connolly and Begg 5th edition (CB5) text in Chapters 1-19. It is also covered well in the early chapters of the Oracle reference manual by Kevin Loney, and in the first ten chapters of the CS669 text by Rob and Coronel.
you should ideally have studied
You should ideally have studied
  • Basic concepts of databases
  • Relational and Entity-Relationship data models
  • The Structured Query Language (SQL)
  • 1st 2nd, 3rd, and Boyce-Codd normal forms
  • Basic database design and database life cycle
in this course we will study
In this course we will study
  • Distributed Databases and Replication
  • Object-oriented and object-relational databases
    • Object-oriented database concepts and standards
    • Object-relational extensions in Oracle and the ANSI/ISO SQL standards
  • Database technology and design for the web
  • Semi-structured data, XML and databases
  • Basic business intelligence
    • Data warehouses (MOLAP, ROLAP and hybrids; star, snowflake, starflake and constellation schemas)
    • Relational data warehouse design (dimensional design)
    • Introduction to data mining (leading technologies)
  • Database programming, stored procedures and triggers
  • Tuning SQL and databases (fairly advanced)
  • Advanced indexing (with Oracle examples)
what would you like to learn in this class
What would you like to learn in this class?
  • I measure the success of this class by how well this class helps you reach your educational and professional goals.
  • Advanced database technology includes far too much to cover it all in this class. I have identified the core areas, but there is much more useful material.
  • I organize the class with independent projects and extra credit projects to increase your ability to cover what you need.
  • Please let me know what else you want to cover in this class. If it is of general interest I will add it to the lectures and provide references. Regardless, I will help you learn the material. Examples:
    • Internet scale databases
    • ANSI SQL 2003 standards and how different DBMS support them
    • Audit and history design and Sarbanes-Oxley compliance
    • Design of databases that support both transactions and analysis
    • Real time business intelligence and trickle feed
    • Database archiving
    • Very high performance databases
    • Very large databases including hashed and federated databases
    • Database migration
    • Replication details
the term project
The Term Project
  • You must complete a significant term project of your own design, which includes at least some advanced database technology, and present it to the class as slides and/or demonstrations, and to me as a report and source code as appropriate.
  • You may form teams of two or three for larger projects. If you wish to form a team you should obtain my approval and must present separately gradable components, and indicate clearly whose work is in each component.
  • Provide me any source code in machine readable form.
  • Provide me your list of references for your project about half way through the term.
  • You can incorporate open source or other legally obtained software in your projects, but you must clearly identify it in both the textual report and the source code. You should also mention it in your project proposal, or let me know in an email if you discover that you need it after your proposal has been accepted.
  • You do not need to use Oracle for your projects. The projects contribute diversity to the class.
extra credit projects
Extra Credit Projects
  • An extra credit project allows you to explore an advanced database topic of your choice, in addition to the topic of your required term project.
  • An extra credit project may lift your grade in close situations. It will never lower your grade.
  • Write a short proposal if you would like to do an extra credit project, so I can check the reasonableness of the topic and the required effort.
academic conduct policy
Academic conduct policy
  • Boston University takes academic conduct seriously, in part because academic honesty is critical to fostering a good fair learning community.
  • Plagiarism can earn you a hearing before the Student Academic Conduct Review Board.
    • Students may be represented by an attorney.
    • The Board determines guilt or innocence and any punishment, which may include an F in the course, suspension, or expulsion.
  • Our full academic conduct code is at
  • The short form of the code is to never present someone else’s work as your own.
  • We use to verify originality.
the turnitin originality service
The Turnitin Originality Service
  • Go to and create your profile if you haven’t already done so for another class.
  • Enroll using our class ID (3045197) and enrollment password (integrity).
  • Submit material such as your term paper to Turnitin and view the similarity reports.
  • This service is paid for by BU.
researching small topics for the class
Researching small topics for the class
  • In a lecture or discussion a question may arise that you would like to research and present the results to the class. I will sometimes ask for volunteers, or you can volunteer.
  • Usually we will want the answer at the next class session, or posted to the course website.
  • Database is a huge technology and business area, and this is an important part of learning how to answer database questions.
  • I give classroom contribution points for these small research efforts.
  • These should be small efforts; if it turns out to be difficult let me know. That’s OK.
  • Your grade is based on your performance in five areas:
    • ~25% of your grade is based on 6 graded quizzes.
    • ~20% of your grade is based on graded homeworks.
    • ~25% of your grade is based on a comprehensive final exam.
    • ~25% of your grade is based on your term project.
    • ~5% of your grade is based on classroom contributions, including questions, discussion, and small topics that you have researched for the class.
  • It is occasionally possible to earn more than 100% for an exceptional answer or an extra credit problem.
  • I don’t grade on the curve, and would be delighted if everyone earned an A. I will try to help you do that.
individual differences
Individual differences
  • Please let me know soon if you have perceptual, cognitive, learning style or other significant individual differences or disabilities, so that I can better meet your needs.
  • I base your grade on how well you have learned the material. With some disabilities some metrics may not be fair, so I may use other metrics when necessary to assure fairness.
our online course web site
Our online course web site
  • Our course web site is a full online course, with quizzes, review quizzes, discussions, lectures, Live Classrooms, email, and a final exam.
  • The URL for our online course web site is
  • You will need to login to using your Kerberos credentials, which are the same as you use for the Student Link.
  • The online course has a review module, six main modules and a final exam module.
  • Each main module includes a review quiz, a quiz that counts on your grade, two lectures, and discussions.
  • We will cover one main module every two weeks.
  • Each module includes a review quiz and a quiz that counts on your grade.
the graded quizzes
The graded quizzes
  • Our online course web site includes six graded quizzes and six review quizzes.
  • The graded quizzes have a date when they become available and a date by which they are due.
  • You need to take each graded quiz without interruption. You have 90 minutes for each quiz.If you run out of time Blackboard Vista will warn you, but allow you to continue. This is to allow for technical difficulties.
  • Shortly after each quiz is due I will release it, at which time you will be able to see the questions, your answers, the correct answers, and tutorial material for each question, just as in the review quizzes.
  • These are open book and open notes quizzes that you can take at home or anywhere with internet access.
  • I recommend that you take the review quiz for each module before you take the quiz that counts, in part to verify that you can access the graphical content in the quizzes, and that it isn’t blocked by a firewall.

The review quizzes

  • The prerequisite module and each main module includes a tutorial review quiz; students often call these “practice quizzes.”
  • You can take the review quizzes as often as you wish.
  • There is no time limit on the review quizzes.
  • The results of a review quiz are available as soon as you submit the quiz.
  • I recommend that you take the review quiz for each module before you take the quiz that counts, in part to verify that you can access the graphical content in the quizzes. Company firewalls sometimes block image downloads.
a normal class meeting timeline
A normal class meeting timeline

Before-class office hours

5:00 PM

6:00 PM


~6:15 PM

Review of previous week’s material

~6:30 PM

Begin lecture on this week’s new material

~7:45 PM

Five minute break

~7:50 PM

Finish lecture on this week’s new material

9:00 PM

how the classes are organized
How the classes are organized
  • Before each class session, 5:00 to 6 PM, is before-class office time when you can meet with me in the classroom.
  • At 6 PM we will begin class with any questions that you may have.
  • Next we review the previous week’s material for 15-30 minutes. In the first class we review the prerequisite material for an hour or more.
  • Then we begin the first part of the lecture for the week.
  • Then we take a halftime break for about 5 minutes.
  • Then we continue the week’s lecture and discussion.
  • The schedule for the last two classes will be different; each of you will present your term projects for about 30 minutes.
  • There will be a final at 6 PM in the classroom on Thursday May 6th.

Grading standards

  • The grade of “C” is the lowest grade acceptable for credit toward MS degree requirements.
  • MS students must have a grade point average of at least 3.0 to graduate.
about grades
About grades
  • I feel that our students are generally very good, and not average, and there have been more A and B grades than lower grades.
  • I determine the final grades for each of the measures separately, and look at both the individual and collective measures for each student.
  • Feel free to ask about your grades and I will let you know.
ask lots of questions
Ask lots of questions
  • A “dumb question” or answer is one that shows that there is something that you don’t understand.
  • If you don’t understand something it is likely that your classmates don’t understand it too.
  • Dumb questions and answers help everyone, including me.
  • So ask lots of questions, particularly dumb questions, and don’t be afraid to answer my questions.
  • I give extra class participation credit for good questions and answers, particularly good dumb ones.
  • The only stupid question is the one that you don’t ask; there are no bad questions.
why oracle and not mssql db2 udb mysql or another dbms
Why Oracle?(and not MSSQL, DB2/UDB, MySQL or another DBMS)
  • Most of the examples in the course use Oracle.
  • The primary reasons are because Oracle leads the industry in the development and delivery of advanced database technology, and in market share.
  • Oracle has essentially all of the advanced features in any relational or object-relational DBMS.
  • Many of the ANSI/ISO SQL standards are based on Oracle, and Oracle supports the standards comparatively well, so when you learn Oracle you are mainly close to the portable standards.
  • Oracle runs on all common platforms.
  • Oracle is very scalable.
you can use another dbms
You can use another DBMS
  • You don’t need to use Oracle for your exercises or term project.
  • If it is better for you to use another DBMS, for example because that’s all that you use at work, feel free to do so.
  • You will need to map some of the syntax.
  • Some of the advanced material that we cover is not implemented in all DBMS.
  • Most of the functionality in the exercises is supported by Oracle and IBM UDB.
  • Microsoft SQL Server and Sybase support much of the functionality, though with different syntax.
our connolly and begg main text
Our Connolly and Begg Main Text
  • Database Systems: A Practical Approach to Design, Implementation, and Management,5th Edition, by Thomas Connolly and Carolyn Begg,Addison Wesley, 2010 [sic],ISBN-10 0-321-52306-7ISBN-13 978-0-321-52306-8
  • This is one of two required texts.
  • I refer to this text withthe shorthand “CB5.”
  • This course covers the moreadvanced material in CB5,plus additional material.
  • CB5 is available from the BUBarnes and Noble bookstore.It is available used.
oracle database 11g the complete reference required text
Oracle Database 11g: The Complete Reference (required text)
  • Oracle Database 11g: the Complete Reference, by Kevin Loney, Osborne Oracle Press, paperback, 1300+ pages, ISBN-13 978-0-07-159875-0.
  • This is the standard Oracle reference, which also includes excellent general tutorial material and fairly complete coverage of the Oracle 11g advanced features.
  • I refer to this text with the shorthand “Loney11.”
  • Oracle 10g: the Complete Reference (“Loney10”) can also be used.
  • We will cover the Oracle advanced features from Loney.
  • The introductory tutorial and reference material in Loneyis also excellent.
  • This required text is available from the BU bookstore.The Loney11 list price is $69.99. It is available used.
rob and coronel optional text
Rob and Coronel optional text
  • Database Systems: Design, Implementation, and Management 8th edition, by Peter Rob and Carlos Coronel. Thomson 2009.ISBN-13 978-1-4239-0201-0.
  • This is the text for CS669. It is an excellent resource for those who wish to review the prerequisite material.
  • The 9th edition of this text,which is now in print, is verysimilar, and also excellentfor review.
  • The 8th edition is widely availableused.
optional pl sql text by feuerstein
Optional PL/SQL text by Feuerstein
  • Oracle PL/SQL Programming, by Steven Feuerstein and Bill Pribyl, 5th edition, O’Reilly, 2009.
  • This is the best text on PL/SQL, by a leading authority. This text is listed for students who want to learn PL/SQL in depth. You don’t need to purchaseit unless you want to.It is available used.
  • There are no assignmentsfrom this text.
graduate assistantships
Graduate assistantships
  • We have graduate assistantships (GAships) for students who help faculty in their research and teaching.
  • GAships can pay up to $5000 per semester for 20 hours per week.
  • If you are interested in a GAship let me know.
  • I am looking for a GA to help with figures and animations for CS779 OL.
  • Metropolitan College provides all registered students with access to the Microsoft Developer Network Academic Alliance (MSDNAA).
  • This provides you with free access to most Microsoft software free of charge, for academic use. You may wish to download Visio Professional to develop database design diagrams for this class.
  • Information on our MSDNAA program is available by following the MSDNAA link on the Met Computer Science home page, which is The MSDNAA link looks like this:
  • When I request your MSDNAA membership you will receive an email from the MSDNAA E-Academy License Management System (ELMS) at following address: Some spam filters may direct this email to a junk email folder, so you may want to check your junk email folder or add the address above to your contacts or other white list.
class schedule
Class schedule
  • Our initial class schedule follows.
  • The schedule will include essentially all of the remainder of Connolly and Begg 5th edition that you do not already know, plus more material on Oracle advanced features, indexes, and database and SQL tuning.
  • If we have time we will add topics that students request.
  • Readings from Loney in square brackets are optional more advanced Oracle-specific material.
spring 2010 academic calendar
Spring 2010 Academic Calendar
  • Classes Begin Wednesday, January 13, 2010
  • Holiday, Classes Suspended Monday, January 18, 2010
  • Holiday, Classes Suspended Monday, February 15, 2010
  • Substitute Monday Schedule of Classes Tuesday, February 16, 2010
  • Spring Recess Saturday, March 6–Sunday, March 14, 2010
  • Classes Resume Monday, March 15, 2010
  • Holiday, Classes Suspended Monday, April 19, 2010
  • Substitute Monday Schedule of Classes Thursday, April 22, 2010
  • Last Day of Classes Thursday, April 29, 2010
  • Study Period Friday, April 30 to Monday, May 3, 2010
  • Final Exams Begin Tuesday, May 4, 2010
  • Final Exams End Saturday, May 8, 2010
  • Commencement Weekend Friday, May 14 to Sunday, May 16 2010
  • We have 14 regular class meetings plus the final exam.