the database environment
DESCRIPTION
The Database Environment. W here is the wisdom we have lost in knowledge? Where is the knowledge we have lost in information. ~ T.S. Eliot ~. Learning Objectives. Concretize the concepts of data, information, data management and metadata - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: The Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022062410/568152ce550346895dc0ea19/html5/thumbnails/1.jpg)
THE DATABASE ENVIRONMENT
Where is the wisdom we have lost in knowledge? Where is the knowledge we have lost in information.
~ T.S. Eliot ~
![Page 2: The Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022062410/568152ce550346895dc0ea19/html5/thumbnails/2.jpg)
Learning Objectives
Concretize the concepts of data, information, data management and metadata
Explain what a database is and why databases are important
Describe a database management system Differentiate between the DBMS and a database Describe the different data models and abstraction
layers Explain the similarities and differences among
DBMS products Explain DBMS history and modern uses Describe how data is physically stored in primary
and secondary storage
![Page 3: The Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022062410/568152ce550346895dc0ea19/html5/thumbnails/3.jpg)
Before we begin…What’s…
Data?
Information?
Data Management?
Metadata?
Query?
![Page 4: The Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022062410/568152ce550346895dc0ea19/html5/thumbnails/4.jpg)
Data or Information?
![Page 5: The Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022062410/568152ce550346895dc0ea19/html5/thumbnails/5.jpg)
Where’s theData?Where’s the Metadata?
![Page 6: The Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022062410/568152ce550346895dc0ea19/html5/thumbnails/6.jpg)
Where is the:
Data?Meta-Data?
![Page 7: The Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022062410/568152ce550346895dc0ea19/html5/thumbnails/7.jpg)
Activity: Data or Meta-Data?
1. A Zip Code: 132442. A Zip Code is 5 Characters XXXXX3. A List of First Names: Tom, Dick, Harry4. A Picture, Like This One:5. The Name of the Picture
file FrostTrees.jpg6. When you place an order, the quantity
of the item ordered must be a number >0
![Page 8: The Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022062410/568152ce550346895dc0ea19/html5/thumbnails/8.jpg)
Something strange and confusing:
Data can be information: $5 (the amount of money in my wallet)
Information can be data: I calculate student final grades, then place
them on a form sent to the registrar’s office.
Metadata can be data: The names of MP3 files in your personal
collection.
Actually it’s all about context!
![Page 9: The Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022062410/568152ce550346895dc0ea19/html5/thumbnails/9.jpg)
What is it, part duex!
Database
Database Management System (DBMS)
![Page 10: The Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022062410/568152ce550346895dc0ea19/html5/thumbnails/10.jpg)
Elements of a Database
Meta-Data
Data
DatabaseData-Management
Data “In”
Information “Out”
End-User
DBMS is software. It stores the data/meta data and “enables” data-management
![Page 11: The Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022062410/568152ce550346895dc0ea19/html5/thumbnails/11.jpg)
Clarification via Family Guy
Brian can write his novel on a typewriter or w/pen and paper.
But there are obvious advantages to using word processing software.
Most databases use DBMS’s just like most papers are written with word processors
Database Brian’s NovelDBMS WP Software
![Page 12: The Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022062410/568152ce550346895dc0ea19/html5/thumbnails/12.jpg)
Build Database Applications to solve business problems.For example…LeadDist, Rebranding, inout, my.ischool,
What Can You Do with a DBMS?
![Page 13: The Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022062410/568152ce550346895dc0ea19/html5/thumbnails/13.jpg)
Is this: Database or DBMS?
![Page 14: The Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022062410/568152ce550346895dc0ea19/html5/thumbnails/14.jpg)
Database or DBMS?
![Page 15: The Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022062410/568152ce550346895dc0ea19/html5/thumbnails/15.jpg)
Database or DBMS?
![Page 16: The Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022062410/568152ce550346895dc0ea19/html5/thumbnails/16.jpg)
SQL Server: Database or DBMS?
![Page 17: The Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022062410/568152ce550346895dc0ea19/html5/thumbnails/17.jpg)
Database or DBMS?
![Page 18: The Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022062410/568152ce550346895dc0ea19/html5/thumbnails/18.jpg)
Database or DBMS?
Four Ways to Slice Obama’s 2013 Budget Proposalhttps://www.nytimes.com/interactive/2012/02/13/us/politics/2013-budget-proposal-graphic.html?_r=0
![Page 19: The Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022062410/568152ce550346895dc0ea19/html5/thumbnails/19.jpg)
Database or DBMS?
![Page 20: The Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022062410/568152ce550346895dc0ea19/html5/thumbnails/20.jpg)
Fundamental Axioms of DBMSs
Users communicate with computer applications (websites, etc)
Computer applications communicate with DBMSs.
Users do not communicate with DBMSs directly.
As a result DBMSs although they can be used interactively, are not used interactively.
A DBMS is not a replacement for sound database design principles.
![Page 21: The Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022062410/568152ce550346895dc0ea19/html5/thumbnails/21.jpg)
First of many examples for the semester
https://my.ischool.syr.edu
Db using Relational Model
YouWebsit
e
User Interface
and Business
Logic (HTML/C#)
Data access
logic and Data (SQL)
Web Browser
Web Server (IIS) SQL Server
ApplicationComponents
![Page 22: The Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022062410/568152ce550346895dc0ea19/html5/thumbnails/22.jpg)
More Examples, with Stories.
![Page 23: The Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022062410/568152ce550346895dc0ea19/html5/thumbnails/23.jpg)
Data or Metadata?
Database?
DBMS?
![Page 24: The Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022062410/568152ce550346895dc0ea19/html5/thumbnails/24.jpg)
Data or Metadata?
Database?
DBMS?
![Page 25: The Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022062410/568152ce550346895dc0ea19/html5/thumbnails/25.jpg)
History: There are Other DBMSs
![Page 26: The Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022062410/568152ce550346895dc0ea19/html5/thumbnails/26.jpg)
Enterprise DBMS Market Share
Product Share
Oracle 44.4%
IBM (DB2) 21.2%
Microsoft (SQL Server) 18.6%
Others: (Sybase, NCR Terdata, etc…) 5.9%Open Source (MySQL, PostgreSQL, etc…)
9.9%* Source: Computerworld 2007
![Page 27: The Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022062410/568152ce550346895dc0ea19/html5/thumbnails/27.jpg)
DBMS deployment plans 2008
* source: gartner
![Page 28: The Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022062410/568152ce550346895dc0ea19/html5/thumbnails/28.jpg)
An employable skill in the future.
Source BLS: 2008http://www.bls.gov/oes/current/oes151061.htm
![Page 29: The Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022062410/568152ce550346895dc0ea19/html5/thumbnails/29.jpg)
THE DATABASE ENVIRONMENT
Questions?
Reminder(s):
Quiz Wednesday on Unit 1
We meet in Hinds 010