Instructor | Announcements | Course Info | Class Material | Schedule | Project | Grade | General Policy | Related Links
| CmpE 226 |
Database
Systems
|
Fall 2002
|
||
|
||||
Richard Sinn
Email: sinn@openloop.com
Office Hours: After class, by appointment or email only
Class time: Monday, 7:30pm (The first class is at 6:00pm)
Class room: IS 216
Aug 24, 2002: Initial Creation.
Sept 15, 2002:
IMS= Information Management System. It started out as a purely heirarchical database manager, then logical relationships were added to make it sort-of a network database manager. There is the "fast path" product, which has restrictions but uses optimistic locking and memory techniques to make it blazing fast (way, way faster than relational) and the "full function" product, which I suppose you could call "IMS Classic". I programmed on the full function IMS when I first started IBM. I bet I still have a couple of books on IMS.
IMS, and it's DL/1 language, is much more difficult to use than SQL. Segments (similar to rows) have pointers, which your application picks up and uses as search arguments to find the referenced segments (similar to joining with rows in other tables). In other words, you application comes up with the index access path, not the DBMS.
IMS was first developed by Rockwell to manage the parts inventory of the Saturn-V rockets built for the Apollo space program. Previously, there was no large scale random-access disk-based data storage systems, only tape-based scanning. IBM then took over IMS to make it into a commercial product.
Todo:
Update project
Objectives
This course presents an accelerated approach to database concepts and architecture. We will cover both basic topics and advanced topics.
Basic topics includes the following:
Advanced Topics includes:
Grading
Apart from big term project(s) and presentation, there are homework assignments, a mid-term exam and a final exam. Exams might be take-home. The weightings for grading are: Term Project(s) 30%, Homework 30%, Midterm 10%, Final Exam 20%, and Term Presentation 10%. Optional research paper on selected topics (10%).
No Late Assignment Submission
Lecture Notes
Reading material will be online on this web site before every lecture. Please email sinn@openloop.com if you experience any download problem.
Required Textbook
Ramez Elmasri and Shamkant Navathe, Fundamentals of Database Systems, Benjamin/Cummings, 1994.
Reference
Openloop.com (http://www.openloop.com)
More will be added as the semester goes
IntroductionAug 26, 2002-Mon
Data ModelingSept 2, 2002-Mon:
Sept 9, 2002-Mon:
Sept 16, 2002-Mon:
Sept 23, 2002-Mon:
SQL Sept 30, 2002-Mon:
Oct 7, 2002-Mon:
Advanced Topics I Oct 14, 2002-Mon:
Oct 21, 2002-Mon:
Oct 28, 2002-Mon:
Mid-term Nov 4, 2002-Mon:
Advanced Topics II Nov 11, 2002-Mon:
Nov 18, 2002-Mon:
Nov 25, 2002-Mon:
Final and PresentationDec 2, 2002-Mon:
Dec 9, 2002-Mon:
- |
Please refer to the following page for topics.
Email sinn@openloop.com to check your grade if necessary.
The university and departmental policies and deadlines for course drop will be applied. Makeup exams cannot be offered, except under exceptional conditions, such as documented serious illness/accident, etc., and only at the professor's discretion.
Each student is responsible for his/her individual assignment, and must not copy anyone else's work. Students who borrow solutions from others will find themselves unable to pass the course. The minimum penalty for every student involved in the duplication of individual assignments or exams will be receiving a zero score on the submitted work.
For group project, all the work has to be done by your OWN group. Do not try to download "free code" from the Internet and hand in as a project. WE WILL FIND OUT. Do not share your work with others. So DO YOUR OWN WORK and EARN your grade.
|
|
|
Instructor | Announcements | Course Info | Class Material | Schedule | Project | Grade | General Policy | Related Links