CS348 Lecture Notes - Lecture 1: Database, Data Manipulation Language, Database Schema

87 views57 pages

Document Summary

What is a database: data representation of facts, concepts, or instructions, operations on data or data items, volatile vs persistent data supply some information. A large and persistent collection of (more-or-less similar) pieces of information organized in a way that facilitates e cient retrieval and modi cation. Structure of the db determined by the abstract data model used. A program (or set of programs) that manages details related to storage and access for a database. Data model formalism that de nes what the structure of the data are. A database instance is a database (real data) that conforms to a given schema. Why database technology: data constitute an organizational asset. Integrated control: reduction of redundancy, avoidance of inconsistency, data integrity, sharability, improved security, programmer productivity. Data independence: programmers do not have to deal with data organization. Abstracts common functions and creates a uniform well de ned interface for applications accessing data.

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers
Class+
$8 USD/m
Billed $96 USD annually
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
30 Verified Answers

Related Documents