1. Database :
A Database is a collection of data that is stored in an organized fashion in a table containing rows and columns using a software package known as Database Management System (DBMS).
DBMS is used to modify, define, manipulate and manage data. Some examples of DBMS are : MySQL, Oracle Database and Microsoft Access.
2. Data Structure :
In computer Programming, Data structure is a way of organizing and storing data so as to ease the accessing and modification of data. There are various types of data structures present for storing the data and different data structures have different and unique features.
Some commonly used data structures are Array, Linked List, Stack, Queue, Heap, Binary Tree and Graph.
Difference between Database and Data Structure :
| Database | Data Structure |
|---|
| It is an organized collection of data. | It is a special format for storing data to serve a particular purpose. |
|---|
| It is used to access the data and manage it easily. | It is used for efficiency and to reduce the complexities of the program. |
|---|
Structured query language (SQL) is used to perform operations on the data in a database. DataBase Management System (DBMS) is used to manage the database.
| Programming languages like C, C++, Java, Python are used to perform operations using data Structures. |
|---|
| It is a Non-volatile memory. | It is a volatile memory. |
|---|
| Relational database, NOSQL database, Centralized database, Hierarchical database are some types of databases. | Linear data structure and non-linear data structure are the types of data structures. |
|---|
| Example : MySQL, Oracle, MongoDB, Sybase etc. | Example : Array, Linked List, Stack, Queue, Tree, Graph. |
|---|
| Store Data in permanent Memory | Store Data in Temporary Memory |
|---|