Association Rules in dbms

Association Rules in dbms Association Rules in dbms are explained clearly as follows: Wal-Mart customers who purchase Barbie dolls have a 60% likelihood of also purchasing one of three types of candy bars [Forbes, Sept 8, 1997] Customers who purchase maintenance...

Types of Privileges in dbms

Types of Privileges in dbms Types of privileges in dbms are explained below : The account level: At this level, the DBA specifies the particular privileges that each account holds independently of the relations in the database. The relation level (or table level): At...

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