Data mining in dbms

Data mining in dbms Generally, data mining in dbms (sometimes referred to as data or data discovery) is that the process of analyzing data from totally different views and summarizing it into helpful info – info which will be accustomed increase revenue, cuts...

Data warehouse in dbms

Data warehouse in dbms A data warehouse in dbms may be a federate repository for all the information that associate degree enterprise’s numerous business systems collect. The repository is also physical or logical. The data hold on within the warehouse is...

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...