Oracle 11G
The Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system (ORDBMS) produced and marketed by Oracle Corporation.
Larry Ellison and his friends and former co-workers Bob Miner and Ed Oates started the consultancy Software Development Laboratories (SDL) in 1977. SDL developed the original version of the Oracle software. The name Oracle comes from the code-name of a CIA-funded project Ellison had worked on while previously employed by Ampex.
General View of Oracle
Introduction to DBMS::
DBMS-Collection of Integrated Interrelated data i.e.in DBMS the data which we are going to store is interrelated.unlike general notepad were data is not related.
Database records the data only once but reads it many times.
Oracle stores the data in the form of records.Each Record maintain 1000 fields.
1 Field can accommodate up to 4 GB
Entity
Entity can be anything in real world which has some properties through which it can identified uniquely form others.
Ex- Let as take student as an entity and Roll Number,Section,Class can be treated as his properties.this properties are called as attributes in database terminology.
Database is used to maintain entity and in RDBMS it is in Tabular form.
Table is a 2 dimensional here.Table consists of rows and colums.
In oracle we can have maximum of 1000 columns and there is no limit of rows.
The Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system (ORDBMS) produced and marketed by Oracle Corporation.
Larry Ellison and his friends and former co-workers Bob Miner and Ed Oates started the consultancy Software Development Laboratories (SDL) in 1977. SDL developed the original version of the Oracle software. The name Oracle comes from the code-name of a CIA-funded project Ellison had worked on while previously employed by Ampex.
General View of Oracle
DBMS-Collection of Integrated Interrelated data i.e.in DBMS the data which we are going to store is interrelated.unlike general notepad were data is not related.
Database records the data only once but reads it many times.
Oracle stores the data in the form of records.Each Record maintain 1000 fields.
1 Field can accommodate up to 4 GB
Entity
Entity can be anything in real world which has some properties through which it can identified uniquely form others.
Ex- Let as take student as an entity and Roll Number,Section,Class can be treated as his properties.this properties are called as attributes in database terminology.
Database is used to maintain entity and in RDBMS it is in Tabular form.
Table is a 2 dimensional here.Table consists of rows and colums.
In oracle we can have maximum of 1000 columns and there is no limit of rows.
No comments:
Post a Comment