ADM

Fahim Fuard
Mind Map by Fahim Fuard, updated more than 1 year ago
Fahim Fuard
Created by Fahim Fuard over 5 years ago
6
0

Description

Advanced Database Managment

Resource summary

ADM
1 Learning Resources (Books)

Annotations:

  • -Ramakrishnan, R. and Gehrke, J., Database Management Systems, 3rd Ed., McGraw-Hill, 2003. Elmasri, R. and Navathe, S.B., Fundamentals of Database Systems, 4th Ed. Addison-Wesley, 2004. Silberschatz A., Korth H.F. and Sudarchan S., Database Systems Concepts, 3rd Ed., McGrawHill , 1996. Garicia-Molina H., Ullman J.D. and Widom J., Database Systems: The Complete Book, Prentice Hall, 2002. Stonebraker ed., Readings in Database Systems, 2nd Ed., Morgan Kaufmann, 1994.  SQL Server 2008 Documentation  Oracle 11g Documentation
2 1. DB Design: Relational Model
3 2. DB Design: Schema Refinement
3.1 Armstrong's Axioms
3.2 Attribute closure algorithm
3.3 Minimal cover
3.4 Normalization forms (1NF, 2NF, 3NF and BCNF)
3.5 Multivalued Dependencies
3.6 4NF and 5NF
4 3. XML Integration and XML Query languages
4.1 Xpath
4.2 XQuery
5 4. Database Design: Object Relational Model
5.1 ADTs
5.2 Inheritance
6 5. Database Design: Object Relational Model
6.1 Member methods
6.2 Release Assignment 2
7 6. Data Storage: Disks and Files
7.1 Disk
7.2 RAID
7.3 SSD
7.4 Database page and record formats
8 7. File Organization & Indexes
8.1 B+ tree
8.2 Hashing (EH and LH)
8.3 Bitmap
9 8. Query Processing
9.1 Sorting
9.2 Joins
9.3 I/O based cost model
10 9. Transaction Management and Concurrency Control
10.1 Transaction properties
10.2 Transaction conflicts
10.3 Transaction schedules
10.4 Lock based Concurrency control protocols
11 10. Concurrency Control
11.1 Multiple-Granularity Locking
11.2 Deadlocks
11.3 Optimistic Concurrency Control Protocol
11.4 Timestamp-Based Concurrency Control Protocol
12 11. Crash Recovery
12.1 Stealing Frames & Forcing Pages
12.2 Logging: Record REDO and UNDO information
12.3 Write-Ahead Logging
12.4 ARIES algorithms
13 Revision and group discussions for research related activities
14 Research paper presentations
15 Research Papers
16 Additional Resources
16.1 PL/SQL
16.2 NoSQL
16.3 Basic Database Conspets
17 Assignments
Show full summary Hide full summary

Similar

Salesforce ADM 201
mito_zgb
ADM201 Set 1
Iris Alipio
ADM201 Set 2
Iris Alipio
ADM201 Testbank
student kilo
Salesforce ADM 201 II
mito_zgb
ADM201 Set 3
Iris Alipio
Sustentabilidade Corporativa
Luiz Felipe Este
Descuentos Naturales Incapacidades
lilia aire de la cruz muñoz
Administración como psicología
renato.bellidog
TASAS DE INTERES Y VALORACION DE BONOS
janeth rosario vargas hidalgo
ADM201 Testbank
Laura Chen