Oracle NOTES
1/what is DATA?
ANSData is unorganized and unrefined or unfiltered row fact that is not sufficient for making decision
.
Its include number ,letter and symbol without meaning.
2/what is information?
ANSinformation is organized and classified data having meaning for making decisions.
Its provide knowledge on particular Object .
3/Database
ANSDatabase is a storage area ,where we store inter-related information of a particular organization
Ex - Banking Database , University Database etc…
there are two type of database are (i).OLTP(Online Transaction process)
(ii).OLAP(Online Analytical process)
OLTPThese database used for storing day to day transaction information .Ex::oracle , mySQL
OLAPThese database used for analyzing historical data trends over time. Ex::
informatica ,powerbi,apache airflow
4/what is database management system(DBMS)
ANSIt is a software ,it is used for managing and maintaining the information within the database and
it allow users to create and modify the information
It act as interface between database and users .
User--->----->--DBMS-----<-------<-----<Database
By using database management system we can perform some operation
Create, insert, update , select , delete and some other .
5/Model of database
there are 3 model in database
(i):: Hierarchical Model: Data is organized into a tree-like structure with a single root and various levels
of hierarchy.
(ii):: Network Model: Data is organized into a graph structure, allowing more complex relationships
between records.
Oracle NOTES
(ii):: Relational Model: Data is organized into tables (relations) with rows and columns, where each table
can be related to others through keys.
(A)/OBJECT RELATIONAL DATABASE MANAGEMENTS SYSTEM (ORDBMS)
(B)/OBJECT ORIENTED DATABASE MANAGEMENTS SYSTEM (OODBMS)
ORDBMS
THESE DB USED TO STORE THE DATA IN FORM OF TABLE
ROW- RECORD ,COLUMN – ATTRIBUTE
THESE DB IS COMPLETLEY DEPEND ON SQL .
EX =ORACLE,MYSQL,POSTGREE
OODBMS
THESE DB USED TO STORE THE DATA IN FORM OF OBJECT
IT IS AL CALLAED AS NOSQL DB
--:Oracle is Ordbms product ,it is invented by oracle corporation in 1979
--:It used to used store data permanently. along with security
