1 / 12

Tue, 13.00-14.50 -@A.104 (Lect) Tue, 13.00 – 16.00 -@Puskom (Lab)

Tue, 13.00-14.50 -@A.104 (Lect) Tue, 13.00 – 16.00 -@Puskom (Lab) Prof. Dr. –Ing. Kalamullah Ram li. Database System. Objectives. Understand principles of and best practice on designing and analysing database system Capable of designing, initializing and implementing database system.

alcina
Download Presentation

Tue, 13.00-14.50 -@A.104 (Lect) Tue, 13.00 – 16.00 -@Puskom (Lab)

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. Tue, 13.00-14.50 -@A.104 (Lect) Tue, 13.00 – 16.00 -@Puskom (Lab) Prof. Dr. –Ing. Kalamullah Ramli Database System

  2. Objectives • Understand principles of and best practice on designing and analysing database system • Capable of designing, initializing and implementing database system

  3. Syllabus of Course

  4. References • A. Kemper , A. Eickler “Datenbanksysteme – Eine Einführung“, Oldenbourg Verlag, 2004 • Teorey, T., Lightstone, S., Nadeau, T., “Database Modeling & Design: Logical Design”, 4th Ed., Morgan Kaufmann, 2006. ISBN 13: 978-0-12-685352-0, ISBN 10: 0-12-685352-5 • Clare Churcher, “Beginning Database Design: from Novice to Expert”, APress, 2007 • Piattini M., Diaz, O. (ed), “Advanced Database Technology and Design”, Artech House, 2000

  5. Lecture 1 Introduction to Database System 5

  6. Why RDBMS General Problems when no RDBMS: • Redundancy and Inconsistency • Limited Access • Problem of Multiuser operation • Data Lost • Data Disintegrity • Data Insecurity • Further Development expensive & complicated

  7. Abstraction Layer of a Database System ... View 1 View 2 View 3 Logical Layer Physical Layer • Data Independence: • Physical Independence • Logical Indenpendence

  8. Data Modeling Real Problem(Mini World) Manual/Intellectual Modeling Conceptual Scheme (ER-Schema) Semi-otomatic Transformation Relational Schema XML Schema Network Schema Object Oriented Schema

  9. Simple Sample Mahasiswa Dosen Kuliah Mini World: Universitas Conceptual Model NPM NIP Mahasiswa Dosen Nama Nama ambil ajar KodeMK Kuliah NamaMK

  10. Logical Modeling • Network Model • Hierarchical Data Model • Relational Data Model • XML Schema • Object Oriented Data Model • Object Relational Schema • Deductive Data Model

  11. Relational Data Model Select Nama From Mahasiswa, Ambil, Kuliah Where Mahasiswa.NPM = Ambil.NPM and Ambil.KodeMK = Kuliah.KodeMK and Kuliah.NamaMK = `Data Base´; update Kuliah set NamaMK = `Basis Data´ where KodeMK = 5001;

  12. „Simple“ User Advanced User Application Programmer Database Administrator Aplikasi Interactive Query Pre-Compiler Administration Tools DML-Compiler DDL-Compiler Query Processing DBMS Database Manager Schema Management Multiuser Synchronization Error Handling Database Management Data Log Index Data Base Data Dictionary DBMS Architecture Sistem Penyimpanan

More Related