Chapter1

Chapter1 - CSIS0278A Introduction to Database Management...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon
Click to edit Master subtitle style CSIS0278A Introduction to Database Management Systems Module 1: Introduction Dr. Reynold C. K. Cheng 1st September, 2010
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2DB010:2 Introduction l Let’s start with our course’s name: Introduction to Database Management Systems An introductory course Database – A large collection of data How to manage those data System – Not simple programs, but complete systems.
Background image of page 2
3DB010:3 Overview l What is database and database management system (DBMS)? l Why do we need DBMS? l What does DBMS provide to us? l Different types of DB users
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
4DB010:4 What is a Database? l Database (DB) l a large collection of inter-related data l Data l Some values referring to real world facts l may be in different formats, e.g., text, image, sound file, video, etc. l A database usually l contains info. about the enterprise l contains info. the enterprise cares about
Background image of page 4
5DB010:5 Database Applications l Many daily applications involve databases l e.g., l Banking : customers, transactions, loans, branches l Airlines : reservations, schedules l Universities : registration, grades l Sales : customers, products, purchases l Manufacturing : production, inventory, orders, supply chain l Humanresources : employee records, salaries, tax deductions l Forum : users, posts, advertisements, short messages l Real-life example? http://www.imdb.com
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
6DB010:6 6 Drawbacks of using a file system to manage databases? (1) l In the early days, application programs were built on top of file systems (e.g., DOS, Windows file explorer) l 6 drawbacks of storing DB in file systems: 1. Data inconsistency l Data got updated in one place but forget to update the other one. 2. Difficulty in accessing the data l May be inefficient to locate a piece of information 3. Platform dependence l Programmers need to write different programs over different platforms to perform the same task.
Background image of page 6
7DB010:7 4. Integrity l Inconsistent data are not allowed (e.g., account balance > 0) 5. Atomicity of updates l How can we ensure that a transfer of money is done completely? l
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 26

Chapter1 - CSIS0278A Introduction to Database Management...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online