null
US
Sign In
Sign Up for Free
Sign Up
We have detected that Javascript is not enabled in your browser. The dynamic nature of our site means that Javascript must be enabled to function properly. Please read our
terms and conditions
for more information.
Next up
Copy and Edit
You need to log in to complete this action!
Register for Free
3491465
ADM
Description
Advanced Database Managment
No tags specified
adm
adm
msc information management
Mind Map by
Fahim Fuard
, updated more than 1 year ago
More
Less
Created by
Fahim Fuard
about 9 years ago
18
0
0
Resource summary
ADM
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
1. DB Design: Relational Model
2. DB Design: Schema Refinement
Armstrong's Axioms
Attribute closure algorithm
Minimal cover
Normalization forms (1NF, 2NF, 3NF and BCNF)
Multivalued Dependencies
4NF and 5NF
3. XML Integration and XML Query languages
Xpath
XQuery
4. Database Design: Object Relational Model
ADTs
Inheritance
5. Database Design: Object Relational Model
Member methods
Release Assignment 2
6. Data Storage: Disks and Files
Disk
RAID
SSD
Database page and record formats
7. File Organization & Indexes
B+ tree
Hashing (EH and LH)
Bitmap
8. Query Processing
Sorting
Joins
I/O based cost model
9. Transaction Management and Concurrency Control
Transaction properties
Transaction conflicts
Transaction schedules
Lock based Concurrency control protocols
10. Concurrency Control
Multiple-Granularity Locking
Deadlocks
Optimistic Concurrency Control Protocol
Timestamp-Based Concurrency Control Protocol
11. Crash Recovery
Stealing Frames & Forcing Pages
Logging: Record REDO and UNDO information
Write-Ahead Logging
ARIES algorithms
Revision and group discussions for research related activities
Research paper presentations
Research Papers
Additional Resources
PL/SQL
NoSQL
Basic Database Conspets
Assignments
Show full summary
Hide full summary
Want to create your own
Mind Maps
for
free
with GoConqr?
Learn more
.
Similar
ADM201 Set 1
Iris Alipio
ADM201 Testbank
student kilo
Salesforce ADM 201 II
mito_zgb
Sustentabilidade Corporativa
Luiz Felipe Este
Administración como psicología
renato.bellidog
Descuentos Naturales Incapacidades
lilia aire de la cruz muñoz
TASAS DE INTERES Y VALORACION DE BONOS
janeth rosario vargas hidalgo
ADM201 Testbank
Laura Chen
ADM201 Testbank
Christen Orticari
Salesforce ADM 201
sham Dixit
ADM201 Testbank
Christen Orticari
Browse Library