by admin | Jun 9, 2015 | sem3
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...
by admin | Jun 9, 2015 | sem3
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...
by admin | Jun 9, 2015 | sem3
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...
by admin | Jun 8, 2015 | sem3
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...
by admin | Jun 7, 2015 | sem3
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...
by admin | Jun 7, 2015 | sem3
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...
