Level Three database technology: Exercise notes (2) One, database application system analysis and Planning 1. Database application Lifecycle 2. Database development methods and implementation tools 3. Database application Architecture Ii. design and implementation of database 1. Conceptual design 2. Logical design 3. Physical Design Iii. Database storage technology 1. Data storage and file Structure 2. Indexing technology Four, database programming technology 1. Some advanced query functions 2. Stored procedure 3. Trigger 4. function 5. Cursor v. Management of things 1. Parallel control Technology 2. Backup and Recovery database technology Vi. database management and Maintenance 1. Data integrity 2. Database security 3. Database Reliability 4. Monitoring Analysis 5. Parameter adjustment 6. Query optimization
1. Database operating environment and parameter adjustment
- External adjustment (CPU, network)
- Memory allocation
- Disk I/O
- Adjust the competition
2. Mode adjustment and optimization
3. Storage optimization
- Materialized view
- Gathered
4. Query optimization
7. Space management Vii. Development and new technologies of database Technology 1. Object Database 2. Data Warehouse and Data mining 3.XML database 4. Cloud computing Database 5. Spatial database
Level Three database technology: Exercise notes (2)