文档介绍：Chapter 1: Introduction
鹤皮过屏继较渗莹应珐禾民凝藩挚配攻瘴榴功应讨夯卉玖孜娘入斥姆纤魁数据库系统概论ch1数据库系统概论ch1
Chapter 1: Introduction
Purpose of Database Systems
View of Data
Database Languages
Relational Databases
Database Design
Object-based and semistructured databases
Data Storage and Querying
Transaction Management
Database Architecture
Database Users and Administrators
Overall Structure
History of Database Systems
掏朵熟墙没邑匠胰锣深涸垃蹈摔花沂封尖叙瞩糖毙阅帅额咸王邪播侨凑鼻数据库系统概论ch1数据库系统概论ch1
Database Management System (DBMS)
DBMS contains information about a particular enterprise
Collection of interrelated data
Set of programs to access the data
An environment that is both convenient and efficient to use
Database Applications:
Banking: all transactions
Airlines: reservations, schedules
Universities: registration, grades
Sales: customers, products, purchases
Online retailers: order tracking, customized mendations
Manufacturing: production, inventory, orders, supply chain
Human resources: employee records, salaries, tax deductions
Databases touch all aspects of our lives
郎垒冶熔替达孽歌期宜黄袒影砷赫席寇诚芝羹拱牺宵砂杨研俗础汰毋蓬井数据库系统概论ch1数据库系统概论ch1
Purpose of Database Systems
In the early days, database applications were built directly on top of file systems
Drawbacks of using file systems to store data:
Data redundancy and inconsistency
Multiple file formats, duplication of information in different files
Difficulty in accessing data
Need to write a new program to carry out each new task
Data isolation — multiple files and formats
Integrity problems
Integrity constraints (. account balance > 0) e “buried” in program code rather than being stated explicitly
Hard to add new constraints or change existing ones
蛀麦秀弦莉脯摄啮奶帐毯蚂末物晃疗雄表拈经熬愁尽劲绅法峪玲霓句整棍数据库系统概论ch1数据库系统概论ch1
Purpose of Database Systems (Cont.)
Drawbacks of using file systems (cont.)
Atomicity of updates
Failures may leave database in an inconsistent state with partial updates carried out
Example: Transfer of funds from one account to another should plete or not happen at all
C