{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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 Document Right Arrow Icon
2 Outline rhombus6 What is a database rhombus6 What is a DBMS rhombus6 Relational Database rhombus6 The Hierarchy of Data rhombus6 Relationships rhombus6 Queries and Operations on Tables rhombus6 S tructured Q uery L anguage ( SQL ) rhombus6 File Processing versus Database
Background image of page 2
3 Data and Information rhombus6 Data square6 Raw facts, figures, and symbols rhombus6 Information square6 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 Document Right Arrow Icon
4 Questions rhombus6 What kinds of companies/organizations usually need to handle enormous data daily? rhombus6 What data will we see in a bank ? In a library ? In a hospital ? In a company ? rhombus6 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 rhombus6 Each application defines and manages its own files rhombus6 File : collection of records containing logically-related data rhombus6 Tight integration between program and data (file) square6 Physical storage structure visible in application code square6 Changes are difficult
Background image of page 5

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

View Full Document Right Arrow Icon
6 Limitations of File-based Approach rhombus6 Separated files barb4right redundancy in defining and storing data rhombus6 Difficult to capture inter-file relationships rhombus6 Labor intensive rhombus6 Difficult to maintain data integrity rhombus6 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 Document Right 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 Document Right Arrow Icon
10 Data Model rhombus6 Every database or DBMS is based on a specific
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.

{[ snackBarMessage ]}