Difference Between Database and Data Warehouse

• 
• 
• 

PrevNext

Database vs Data WarehouseThe basis for the difference between a database and a data warehouse arises from the fact that a data warehouse is a type of database that is used for data analysis. A database is an organized collection of data stored on a computer system. Information...

Continue reading

Difference between Control Structure and Control Statement

• 
• 

PrevNext

1. Control Structure :Control Structure, as name suggests, is basically a set of statements and control statements that are controlling their execution.2. Control Statement :Control Statement, as name suggests, is basically a statement that is used to determine control flow of set of statements. It makes decision on...

Continue reading

Upgrade Non-CDB to Oracle Database 21c (Manual)

This article provides an overview of a manual upgrade of an existing non-CDB database to Oracle 21c.◉ AssumptionsThis article assumes your source database is of a version supported for direct upgrade to 21c.19c, 18c, 12.2The non-CDB architecture is desupported in Oracle 21c, so we have two choices when upgrading...

Continue reading

Difference Between DBMS and File System

DBMS vs File SystemDBMS (Database Management System) and File System are two ways that could be used to manage, store, retrieve and manipulate data. A File System is a collection of raw data files stored in the hard-drive whereas DBMS is a bundle of applications that is dedicated...

Continue reading

Difference Between DDL and DML

• 
• 

PrevNext

Key Difference – DDL vs DMLA database is used to store data. There are various types of databases. One common database type is Relational Databases. In these databases, data is stored in tables. Tables consist of rows and columns. A row is a record, and a column is...

Continue reading

Oracle Database 21c Installation On Oracle Linux 8 (OL8)

Oracle 21c is an innovation release, so it may not be suitable for most production systems.This article describes the installation of Oracle Database 21c 64-bit on Oracle Linux 8 (OL8) 64-bit. The article is based on a server installation with a minimum of 2G swap and secure Linux...

Continue reading

Difference Between Classification and Prediction

• 
• 

PrevNext

Key Difference – Classification vs PredictionClassification and predication are two terms associated with data mining. Data is important to almost all the organization to increase profits and to understand the market. Plain data does not have much value. Therefore, the data should be processed in order to get...

Continue reading

Oracle Database 21c Installation On Oracle Linux 7 (OL7)

This article describes the installation of Oracle Database 21c 64-bit on Oracle Linux 7 (OL7) 64-bit. The article is based on a server installation with a minimum of 2G swap and secure Linux set to permissive.◉ Download SoftwareDownload the Oracle software from OTN or MOS depending on your...

Continue reading

Difference Between RDBMS and Hadoop

• 
• 

PrevNext

The key difference between RDBMS and Hadoop is that the RDBMS stores structured data while the Hadoop stores structured, semi-structured, and unstructured data.The RDBMS is a database management system based on the relational model. The Hadoop is a software for storing data and running applications on clusters of...

Continue reading