Chapter1 - CSIS0278A Introduction to Database Management...

  • Notes
  • 26
  • 100% (1) 1 out of 1 people found this document helpful

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

Click to edit Master subtitle style CSIS0278A Introduction to Database Management Systems Module 1: Introduction Dr. Reynold C. K. Cheng 1st September, 2010
Image of page 1

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

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.
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
Image of page 3

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

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
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?
Image of page 5

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

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.
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?
Image of page 7

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

Image of page 8
This is the end of the preview. Sign up to access the rest of the document.
  • Spring '10
  • DR
  • Database management system

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern