BCA Notes (Pokhara University): Unit IX: Database Application Types

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

Database Application
Online Transaction Processing (OLTP)
Example of OLTP System
Benefits of OLTP Method, Drawbacks of OLTP Method
Online Application Processing (OLAP)
Example of OLAP
Benefits of Using OLAP Services, Drawbacks of OLAP Service
Difference between OLTP and OLAP
Data Warehouse
How Data Warehouse Works?
Types of Data Warehouse
Enterprise Data Warehouse (EDW), Operational Data Store, Data Mart
General Stages of Data Warehouse
Offline Operational Database, Offline Data Warehouse, Real-time Data Warehouse, Integrated Data Warehouse
Components of Data Warehouse
Load Manager, Warehouse Manager, Query Manager, End-User Access Tools
Applications of Data Warehouse
Steps to Implement Data Warehouse
Enterprise strategy, Phased delivery, Iterative Prototyping
Advantages of Data Warehouse (DWH), Disadvantages of Data Warehouse
Data Mining
Data Mining Implementation Process
Business Understanding, Data Understanding, Data Preparation, Data Transformation, Modelling, Evaluation, Deployment
Data Mining Techniques
Classification, Clustering, Regression, Association Rules, Outer Detection, Sequential Patterns, Prediction
Benefits of Data Mining, Disadvantages of Data Mining
Data Mining Applications
Database Backup and Recovery
Failure Classification
Types of Backup
Importance of Backups
Methods of Backup
Methods of Database Recovery
Log-Based Recovery, Checkpoint, Shadow Paging
Database Security and Threats
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 bcanotespu@gmail.com. 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.