Indexing

Discuss DBMS

Discuss DBMS Advertisements Previous Page Next Page   Database Management System or DBMS in short refers to the technology of storing and retrieving users’ data with utmost efficiency along with appropriate security measures. This tutorial explains the basics of DBMS such as its architecture, data models, data schemas, data independence, E-R model, relation model, relational…

DBMS – Useful Resources

DBMS – Useful Resources Advertisements Previous Page Next Page   The following resources contain additional information on DBMS. Please use them to get more in-depth knowledge on this topic. Useful Links on DBMS DBMS at Wikipedia – This is information about DBMS at Wikipedia. SQL at tutorialspoint – This is Tutorialspoint tutorial for SQL. Encyclopedia…

DBMS – Quick Guide

DBMS – Quick Guide Advertisements Previous Page Next Page   DBMS – Overview Database is a collection of related data and data is a collection of facts and figures that can be processed to produce information. Mostly data represents recordable facts. Data aids in producing information, which is based on facts. For example, if we…

DBMS – Data Recovery

DBMS – Data Recovery Advertisements Previous Page Next Page   Crash Recovery DBMS is a highly complex system with hundreds of transactions being executed every second. The durability and robustness of a DBMS depends on its complex architecture and its underlying hardware and system software. If it fails or crashes amid transactions, it is expected…

DBMS – Data Backup

DBMS – Data Backup Advertisements Previous Page Next Page   Loss of Volatile Storage A volatile storage like RAM stores all the active logs, disk buffers, and related data. In addition, it stores all the transactions that are being currently executed. What happens if such a volatile storage crashes abruptly? It would obviously take away…