Advanced Topics: Object-Oriented and Object Relational databases. Module IV - Storage Strategies: Indices, B-Trees, Hashing, Transaction processing: Recovery and Concurrency Control, Locking and Timestamp based Schedulers, Multiversion and Optimistic Concurrency Control Schemes.Module III - Query Processing and Optimization: Evaluation of Relational Algebra Expressions, Query Equivalence, Join strategies, Query Optimization Algorithms. Relational Database Design: Domain and Data dependency, Armstrong's Axioms, Normal Forms, Dependency Preservation, Lossless design, Comparison of Oracle & DB2. Module II - Relation Query Languages, Relational Algebra, Tuple and Domain Relational Calculus, SQL and QBE.Relational and Object Oriented Data Models, Integrity Constraints and Data Manipulation Operations. Data models, Entity Relationship (ER), Mapping ER Model to Relational Mode, Network.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |