Database

Database Languages in DBMS – DDL, DML, DCL, DQL

Programming languages which are used to create and operate database, known as database language like Structured Query language aka SQL etc. Most of database languages are non-procedural, means the language focus on “what to do instead of how to do?” We can further divide database languages in these 4 categories as per the type of …

Database Languages in DBMS – DDL, DML, DCL, DQL Read More »

Parallel Database Architecture in DBMS – Advantages & Disadvantages

In this kind of architecture multiple processors, memory drives, and storage disks are associated to collaborate with each other and work as a single unit. In this type of database system, the hardware profile is designed to fulfill all the requirements of the database and user transactions to speed up the process. The arrangement of …

Parallel Database Architecture in DBMS – Advantages & Disadvantages Read More »

OLTP vs OLAP – Difference between OLTP and OLAP

While OLTP is an acronym for online transaction processing (OLTP), OLAP is an acronym for online analytical processing (OLAP). Both OLTP and OLAP are online processing systems. There is a fundamental distinction between OLTP and OLAP in that while OLTP is concerned with transaction processing, OLAP is much more concerned with analytical processing. Transactions are …

OLTP vs OLAP – Difference between OLTP and OLAP Read More »

Difference between Data Warehousing and Data Mining

Data warehousing and data mining are two popular and essential techniques to store and analyze data. Data warehousing refers to the compiling and organizing of the stored data in the company’s database. However, data mining represents extracting essential and relevant data from the database. So, the marketing or other departments can get some crucial insights …

Difference between Data Warehousing and Data Mining Read More »