Showing posts with label oracle 10g. Show all posts
Showing posts with label oracle 10g. Show all posts

Monday, December 26, 2016

Oracle version

Version of Oracle:


In 1986, oracle Corp released its first commercial database i.e. oracle 7
Oracle-7: It is a stand alone RDBMS, it is not supporting online processing.

Oracle-8: It is stand alone RDBMS and it having indexes.
Note: these 2 database are unable to process business data in online process.

Oracle-8i: it is supporting internet application like webpages(html & java) supports online data processing.
   i stands for internet application from this version oracle supporting online data processing.

Oracle-9i: It also supporting Internet application
   it Support online data processing.
   It supports e-buz development tools(ERP-Enterprises resources planet)

Oracle-10g: (grid technology)
   a grid is nothing but a mesh like architecture.
   each consecutive point in the mesh, is considered as server.
   each server connected with atleast one server within the grid.
-  g for grid technology, within database grid, any server is easily communicating with any other server. i.i. supporting centralized
data processing.

Oracle-11g: It is having in built data warehouse builder.
    It is having OLTP development tools & OLAP development tools-(Oracle Warehouse Builder)

Oracle-12c: Cloud Computing
    It provides a facility to connect with any technology cloud without installing technology in the personal system.

Oracle

Oracle:

It is an RDBMS from oracle corporation.
Any RDBMS is used to store and process Business Data.

Database Concept:

------------------------------
1. Data : Collection of Information of one entity is known an Data
ex: any one employee data, any one product data etc

2. Database: collection of Information of all objects with in the business, technically a database is a software to automate business activities.

3. DBMS(database management system): a database, which is providing management system services like:
A. Entity new data or inserting new data.
B. Updating data
C. Deleting unwanted data
D. Authentication or authenticating user
E. Providing security

4. RDBMS(relational database management System): It is a collection of inter-related data of all inter related objects within the business.
Note:
A. generally data is generated from each business object & business transaction.
B. as a database developer, we need to develop database application program(Stored procedures, functions, packages & triggers). each database application program is responsible for at least one business activity.