Unit IX: Database Application Types – Database Management System

BCA 4th Semester DBMS (Database Management System) Notes Pdf, Database Application Types – Database Management System

Database Application Types – Database Management System

In this unit named Database Application Types – Database Management System” readers and viewers will get information regarding the following topics:

  1. Database Application
  2. Online Transaction Processing (OLTP)
  3. Example of OLTP System
  4. Benefits of OLTP Method, Drawbacks of OLTP Method
  5. Online Application Processing (OLAP)
  6. Example of OLAP
  7. Benefits of Using OLAP Services, Drawbacks of OLAP Service
  8. Difference between OLTP and OLAP
  9. Data Warehouse
  10. How Data Warehouse Works?
  11. Types of Data Warehouse
  12. Enterprise Data Warehouse (EDW), Operational Data Store, Data Mart
  13. General Stages of Data Warehouse
  14. Offline Operational Database, Offline Data Warehouse, Real-time Data Warehouse, Integrated Data Warehouse
  15. Components of Data Warehouse
  16. Load Manager, Warehouse Manager, Query Manager, End-User Access Tools
  17. Applications of Data Warehouse
  18. Steps to Implement Data Warehouse
  19. Enterprise strategy, Phased delivery, Iterative Prototyping
  20. Advantages of Data Warehouse (DWH), Disadvantages of Data Warehouse
  21. Data Mining
  22. Data Mining Implementation Process
  23. Business Understanding, Data Understanding, Data Preparation, Data Transformation, Modelling, Evaluation, Deployment
  24. Data Mining Techniques
  25. Classification, Clustering, Regression, Association Rules, Outer Detection, Sequential Patterns, Prediction
  26. Benefits of Data Mining, Disadvantages of Data Mining
  27. Data Mining Applications
  28. Database Backup and Recovery
  29. Failure Classification
  30. Types of Backup
  31. Importance of Backups
  32. Methods of Backup
  33. Methods of Database Recovery
  34. Log-Based Recovery, Checkpoint, Shadow Paging
  35. Database Security and Threats
  36. Cryptography

This article Database Application Types – Database Management System is contributed by Rashita Gurung, a student of LA GRANDEE International College.

If you like to contribute, you can mail us BCA Notes, BCA Question Collections, BCA Related Information, and Latest Technology Information at See your article appearing on BCA Notes (Pokhara University) main page with your designation and help other BCA Students.

Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above.

BCA 4th Semester DBMS (Database Management System) Notes:

Unit I: Operating System Overview - Database Management System

Unit II: Designing A Database - Database Management System

Unit III: Data Normalization - Database Management System

Unit IV: Queries In Database - Database Management System

Unit V: Advanced Queries In Database - Database Management System

Unit VI: Developing Stored Procedures - Database Management System

Unit VII: Creating DML Triggers - Database Management System

Unit VIII: Physical Design - Database Management System

Unit X: Distributed Database System - Database Management System

Unit XI: Object Oriented Database - Database Management System

No comments

Post a Comment

Share your honest opinion and feedback about this website, through the comment box.

Don't Miss
© 2019 - All Rights Reserved
Lots of BCA Notes (Pokhara University)