Types of data
=============
We have two types of data.
1) Unstructured Data
2) Structured Data
1) Unstructured Data
---------------------
Data which is not in readable format is called unstructured data.
In general, meaningless data is called unstructured data.
ex:
204 Lakemba SYD NSW AUS
2) Structured Data
------------------
Data which is in readable format is called structured data.
In general, meaningful data is called structured data.
ex:
unit Locality city state country
---- -------- ---- ----- -------
204 Lakemba SYD NSW AUS
Oracle
=======
It is one of the database which is used to store structured data.
,It is a RDBMS(Relational Database Management System) database.
It is a product of Oracle corporation.
It is classified into two types.
Oracle
|
|-------------------------------------------------|
SQL PL/SQL
(Structured Query Language) (Procedural Language extension to Structured Query Language)
Management System
==================
Management system is a software which is used to manage the database.
Using management system we can perform following activities very easily.
1) Adding the new data
2) Modifying the existing data
3) dropping the unnecessary data
4) selecting required data
Q) What is the difference between DBMS vs RDBMS?
DBMS RDBMS
--------- --------
,It is a database management system. It is a relational database management system.
It stores the data in files. It stores the data in tables.
It is not designed to store large It is designed to store large amount of data.
amount of data.
It provides facility to connect single It provides facility to connect multiple users
user at a time. at a time.
There is no data security. There is high data security.
It does not support normalization. It supports normalization.
Client/Server Architecture
==========================
In this architecture we will see how our frontend data will store in a backend.
Diagram: oracle1.1
FrontEnd
, ---------
The one which is visible to the enduser to perform some operations is called frontend.
ex:
Java,.Net,Python,Perl,Ruby,D2K and etc.
Communication Channel
---------------------
Communication channel acts like a bridge between frontend and backend.
ex:
JDBC- Java Database Connectivity
ODBC- Open Database Connectivity
PDBC- Python Database Connectivity
BackEnd
-------
The one which is not visible to the enduser but it performs operations based on the instructions
given by frontend is called backend.
ex:
Oracle
MySQL
Teradata
sybase
MongoDB
NoSQL
PostgreSQL
and etc
SQL
=====
SQL stands for Structured Query Language which is pronounce as SEQUEL.
This language is used to interact with oracle database.
=============
We have two types of data.
1) Unstructured Data
2) Structured Data
1) Unstructured Data
---------------------
Data which is not in readable format is called unstructured data.
In general, meaningless data is called unstructured data.
ex:
204 Lakemba SYD NSW AUS
2) Structured Data
------------------
Data which is in readable format is called structured data.
In general, meaningful data is called structured data.
ex:
unit Locality city state country
---- -------- ---- ----- -------
204 Lakemba SYD NSW AUS
Oracle
=======
It is one of the database which is used to store structured data.
,It is a RDBMS(Relational Database Management System) database.
It is a product of Oracle corporation.
It is classified into two types.
Oracle
|
|-------------------------------------------------|
SQL PL/SQL
(Structured Query Language) (Procedural Language extension to Structured Query Language)
Management System
==================
Management system is a software which is used to manage the database.
Using management system we can perform following activities very easily.
1) Adding the new data
2) Modifying the existing data
3) dropping the unnecessary data
4) selecting required data
Q) What is the difference between DBMS vs RDBMS?
DBMS RDBMS
--------- --------
,It is a database management system. It is a relational database management system.
It stores the data in files. It stores the data in tables.
It is not designed to store large It is designed to store large amount of data.
amount of data.
It provides facility to connect single It provides facility to connect multiple users
user at a time. at a time.
There is no data security. There is high data security.
It does not support normalization. It supports normalization.
Client/Server Architecture
==========================
In this architecture we will see how our frontend data will store in a backend.
Diagram: oracle1.1
FrontEnd
, ---------
The one which is visible to the enduser to perform some operations is called frontend.
ex:
Java,.Net,Python,Perl,Ruby,D2K and etc.
Communication Channel
---------------------
Communication channel acts like a bridge between frontend and backend.
ex:
JDBC- Java Database Connectivity
ODBC- Open Database Connectivity
PDBC- Python Database Connectivity
BackEnd
-------
The one which is not visible to the enduser but it performs operations based on the instructions
given by frontend is called backend.
ex:
Oracle
MySQL
Teradata
sybase
MongoDB
NoSQL
PostgreSQL
and etc
SQL
=====
SQL stands for Structured Query Language which is pronounce as SEQUEL.
This language is used to interact with oracle database.
