What is DBMS :
DATABASE MANAGEMENT SYSTEM(DBMS)
IS A SOFTWARE, IT ALLOWS TO DEFINE A DATABASE, MAINTNING, MANAGING AND MANIPULATING THE DATABASE
MANIPULATION MEANS ADDING DATA, DELETING DATA, MODIFYING DATA, SELECTING DATA
History of oracle (Larry ellison)
The First name of oracle corporation was R.S.I (Relational Software Incorporated)
1983 — ORACLE CORPORATION
EXPANSION OF ORACLE
O : OAK
R : RIDGE
A : ANLYSE
C : COMPUTING
L : LOGICAL
E : ENGINE
ORACLE
IS A DATABASE SOFTWARE
or
IS A RDBMS
or
IS A BACK-END
POPULER BACK-ENDS (RDBMS)
- SYBASE
- INGRES
- INFORMIX
- DB2
- MS-ACCESS
- SQL SERVER
- ORACLE
(ORACLE IS A UN-BEATABLE DATABASE SOFTWARE)
TYPES OF RDBMS
1)RDBMS (ORACLE 7.3)
2)ORDBMS (OOPS) (ORACLE 8.0)
3)OORDBMS
NOTE:
As of oracle 8.o RDBMS extended to ordbms and oordbms, because they can introduced a new concept OOP
Oracle Tools
1)sql*plus
2)sql
3)pl/sql
4)developer 2000 (default front-end)
front-end is an application development environment software. this software allows to create and design user friendly screens.
Populer front-ends
- d2k (oracle corporation)
- visual basic (microsoft)
- active server pages (microsoft)
- java (sun microsystems)
- power builder (power soft)
sql*plus
sql*plus is the main software, this software integrated with sql, sql*net and pl/sql.
sql*plus will accept user typed commands, and it will generated formated results.
EX: HANSUJA SOLUTIONS COMPANY HYDERABAD
| ENO | ENAME | DESG |
|---|---|---|
| 101 | VENAKTESHWARLU | SOFTWARE ENGINEER |
| 102 | RAMYA KRISHNA | HR |
