Transaction processing in dbms

Transaction processing in dbms A transaction processing in dbms can be defined as a group of tasks. A single task is the minimum processing unit which cannot be divided anymore. Let’s have an example of a simple transaction processing. Suppose a bank employee...

Distributed database in dbms

Distributed database in dbms A distributed database in dbms storage devices are not all sticked to a common CPU. It may be stored in multiple pc’s located in the same physical location, or may be dispersed over a network of interconnected pc’s. Distributed...

Statistical database in dbms

Statistical database in dbms A statistical database in dbms (Database Management System) is used for this analysis purposes.  Statistical database is an online analytical processing (OLAP), instead of  online transaction processing (OLTP) system. Recent decision, and...

Database access control

Database access control Database access control is responsible for control of rules determined for all direct accesses to the system by security policies . Traditional control systems work with notions subject, object and operation. For better understanding look at...

SQL Standards

SQL Standards Oracle strives to comply with industry-accepted standards and participates actively in SQL standards committees. Industry-accepted committees are the American National Standards Institute (ANSI) and the International Organization for Standardization...

Data Classification Threats and risks

Data Classification Threats and risks Security Database security: degree to which data is fully protected from tampering or unauthorized acts Comprises information system and information security concepts Information Systems Wise decisions require: –Accurate and...