An Oracle database is a relational database management system which was developed by the Oracle corporation in 1977 by Lawrence Ellison and other developers. Oracle DB is a widely-used relational database engines. It is a collection of data treated as unit. The main reason of using database is storing and retrieving user related information.
Every Oracle database contains
Logical and Physical Structures.
- A Logical Structures consists of tablespaces, schema objects, extents and segments.
- A Physical Structures are data files, redo log files, control file.
Oracle database services provides many more functionalities like data architecture, data modelling, data analysis, backup and recovery etc, which is shown in the below diagram.
A database is divided into logical storage units called
tablespaces, which group related logical structures together. Each tablespace in turn consists of one are more data files.
All the tables and other objects in oracle are stored in tablespace logically, but physically they are stored in the data files associated with the tablespace.
The whole process is built in a relational database framework in which data objects may be directly accessed by users through structured query language (SQL). Oracle is fully scalable, reliable and secure relational database architecture and is often used by global enterprises, which manage and process data across wide and local area networks. The Oracle database has its own network component to allow communications across networks. Oracle DB is also known as Oracle RDBMS.
Features of oracle database
- Scalability
- Robust, reliable, available, secure architecture.
- One development model.
- One management interface for all application.
- Industry standard technologies.
Relational Database
Oracle provides a flexible RDBMS and using its features we can store and manage data with all the advantages of a relational structure plus PL/SQL, an engine that provide you with the ability to store and execute program units. Oracle server provides a features retrieval of data based on optimization techniques. It includes the security features that control how a database is accessed and used.
In relational databases, which consist of our information in tables with rows and columns in organized manner, relation in a table which means that it is a collection of objects of the same types(rows). Data in different tables are related with a common key and retrieving related data from a table is the basic term of relational databases. Data base management systems mainly focus on the way of storing the data, maintained the data and retrieve the data. But in the case of Relational Database Management System data is stored in well-structured manner with the relation in the database.
A relational database can be regarded as containing a set of two dimensional tables ("relations") with each table comprising rows ("tuples") and columns ("domains"). Relationships between database tables are created when one table has a column with the same meaning as a column in another table. The names and values of the two columns are irrelevant but they must refer to mean to the same thing.
The relational database is a database that conforms to the relational model. The relational model has the following major aspects:
- Structures – A well defined objects stores.
- Operations –A defined action enable applications to manipulate the data.
- Integrity Rules –Governs the operation on the data and structure of the database