Chapter 2 - Chapter 2 Data Databases and the Database...

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

View Full Document Right Arrow Icon
Data, Databases, and the Database Environment Chapter 2
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
Database Characteristics Ordered collections Contain related or linked data elements Designed for specific information needs Shared
Background image of page 2
Data Access Operations Only four! Insert (Create or Add new records) Retrieve or Read (view data without making changes) Update (modify existing data) Delete (remove existing records)
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
Database Environment User Engine Processes to: Backup data Recovery /Restart Process Multiple users Produce Audit trails Database Management System Developer ProdID Name Desc Cost EmpID Last DOB Dept Data stored in Database DBA Application Application Application Data Repository (User Data) Data Dictionary (Metadata- structure, indexes, users, etc.) Auxiliary Files—Audit, Backup, etc. Database (data) DBMS (software processes) Users (people) Applications (Client Hardware & Software to interface with users) Hardware (storage devices, processors, network) System Software (operating system, network OS) Procedures (govern use of system)
Background image of page 4
Database Environment User Engine Processes to: Backup data Recovery /Restart Process Multiple users Produce Audit trails Database Management System Developer ProdID Name Desc Cost EmpID Last DOB Dept Data stored in Database DBA Application Application Application Data Repository (User Data) Data
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
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 20

Chapter 2 - Chapter 2 Data Databases and the Database...

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

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