Theoretical Paper
- Computer Organization
- Data Structure
- Digital Electronics
- Object Oriented Programming
- Discrete Mathematics
- Graph Theory
- Operating Systems
- Software Engineering
- Computer Graphics
- Database Management System
- Operation Research
- Computer Networking
- Image Processing
- Internet Technologies
- Micro Processor
- E-Commerce & ERP
- Numerical Methods Tutorial
Practical Paper
- C Programming
- C
- Data Structure Using C, C ++
- Programming in R
- Programming with Python
- Machine Learning
- Swift
- Firebase
- Android
- iOS Development
- Django
- PHP
- Arduino
- Internet of Technology
- IOT Projects
- Dart Programming
- Flutter
- Flutter Tutorials
- Kotlin Tutorial
- Laravel Tutorial
- VueJS Tutorial
- Go Lang
- Rust
- Apex
Industrial Training
mca SyllabusDistributed database management Distributed DBMS features and needs. Reference architecture. Levels of distribution transparency, replication. Distributed database design – fragmentation, allocation criteria. Storage mechanisms. Translation of global queries. / Global query optimisation. Query execution and access plan. Concurrency control – 2 phases locks. Distributed deadlocks. Time based and quorum based protocols. Comparison. Reliability- non-blocking commitment protocols. Partitioned networks. Checkpoints and cold starts. Management of distributed transactions- 2 phase unit protocols. Architectural aspects. Node and link failure recoveries. Distributed data dictionary management. Distributed database administration. Heterogeneous databases-federated database, reference architecture, loosely and tightly coupled. Alternative architecture. Development tasks, Operation- global task management. Client server databases-SQL server, open database connectivity. Constructing an application. Books: |