Beginning Database Design Solutions

نویسنده :Rod Stephens

Understanding the Importance of Design 4
Information Containers 5
Strengths and Weaknesses of Information Containers 7
Desirable Database Features 8
CRUD 9
Retrieval 9
Consistency 10
Validity 10
Easy Error Correction 11
Speed 11
Atomic Transactions 12
ACID 13
Persistence and Backups 14
Low Cost and Extensibility 16
Ease of Use 16
Portability 16
Security 17
Sharing 18
Ability to Perform Complex Calculations 19
Consequences of Good and Bad Design 19
Summary 21
Exercises 22
Chapter 2: Database Types 23
Why Bother? 24
Flat Files 24
INI Files 26
Windows System Registry 26
Relational Databases 27

Spreadsheets 30
Hierarchical Databases 31
XML 34
XML Basics 34
XML Structures 37
XML Summary 39
Network 40
Object 42
Object-Relational 43
Exotic 44
Document-Oriented 44
Deductive 44
Dimensional 44
Temporal 45
Summary 45
Exercises 47
Chapter 3: Relational Database Fundamentals 49
Relational Points of View 49
Table, Rows, and Columns 50
Relations, Attributes, and Tuples 52
Keys 52
Indexes 54
Constraints 55
Basic Constraints 55
Check Constraints 55
Primary Key Constraints 55
Unique Constraints 56
Foreign Key Constraints 56
Database Operations 57
Summary 59
Exercises 59
Part II: Database Design Process and Techniques
Chapter 4: Understanding User Needs 65
Make a Plan 66
Bring a List of Questions 67
Functionality 67
Data Needs 67
Data Integrity 68