17.Database.Basics - Database Basics With thanks to Dr....

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

View Full Document Right Arrow Icon
1 Database Basics With thanks to Dr. Haipeng Guo and Dr. Sunny Jeong Lecture 17
Background image of page 1

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

View Full DocumentRight Arrow Icon
2 Outline r What is a database r What is a DBMS r Relational Database r The Hierarchy of Data r Relationships r Queries and Operations on Tables r S tructured Q uery L anguage ( SQL ) r File Processing versus Database
Background image of page 2
3 Data and Information r Data s Raw facts, figures, and symbols r Information s organized, meaningful, and more useful to people data information computer + program
Background image of page 3

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

View Full DocumentRight Arrow Icon
4 Questions r What kinds of companies/organizations usually need to handle enormous data daily? r What data will we see in a bank ? In a library ? In a hospital ? In a company ? r How can we organize the data (especially when the data is enormous) in a way such that we can store, update and retrieve the data easier ?
Background image of page 4
5 Traditional File-based Approach r Each application defines and manages its own files r File : collection of records containing logically-related data r Tight integration between program and data (file) s Physical storage structure visible in application code s Changes are difficult
Background image of page 5

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

View Full DocumentRight Arrow Icon
6 Limitations of File-based Approach r Separated files b redundancy in defining and storing data r Difficult to capture inter-file relationships r Labor intensive r Difficult to maintain data integrity r Program-data dependency Solution: database approach
Background image of page 6
7 What is a database? Add, change, and delete data Add, change, and delete data Create database Create database Sort and retrieve data Sort and retrieve data Create forms and reports Create forms and reports Database software allows you to Database software allows you to Collection of related data organized so you can access, retrieve, and use it Collection of related data organized so you can access, retrieve, and use it Database software also called database management system (DBMS) Database software also called database management system (DBMS)
Background image of page 7

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

View Full DocumentRight Arrow Icon
8 Database Management System ( DBMS ) Examples: DB2, SQL Server, Oracle, Sybase, MySQL The management software that provides some convenient ways to the users to manipulate ( add , update , delete ), retrieve and present the data
Background image of page 8
9 Popular DBMS
Background image of page 9

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

View Full DocumentRight Arrow Icon
10 Data Model r Every database or DBMS
Background image of page 10
Image of page 11
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/28/2010 for the course COMPUTER H 2012 taught by Professor Dave during the Spring '10 term at Quebec Abitibi-Temiscamingue.

Page1 / 38

17.Database.Basics - Database Basics With thanks to Dr....

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

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