Introduction to Oracle Database www.kerneltraining.com/oracle-dba 3-tier Architecture DATABASE Network End-User Network Application Server Application Softwares Application Logic Websites DATA www.kerneltraining.com/oracle-dba DATA Every organization has some information needs. • A library keeps a list of members, books, due dates, and fines. • A company needs to save information about its employees, departments, and salaries. These pieces of information are called data. www.kerneltraining.com/oracle-dba www.kerneltraining.com/oracle-dba Database • A database is an organized collection of data for one or more purposes, usually in digital form. www.kerneltraining.com/oracle-dba Oracle Database DB2 ORACLE 50% of Market Share INFORMIX SYBASE SQL SERVER www.kerneltraining.com/oracle-dba Relational Database • A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E.F. Codd. www.kerneltraining.com/oracle-dba www.kerneltraining.com/oracle-dba Relational Database DATABASE SQL End-User • Retrieve Data • Insert Data • Modify Data • Remove Data DATA Tables www.kerneltraining.com/oracle-dba www.kerneltraining.com/oracle-dba www.kerneltraining.com/oracle-dba History of Oracle Database ORACLE www.kerneltraining.com/oracle-dba History Oracle Database • In 1977, Larry Ellison, Bob Miner and Ed Oates founded Software Development Laboratories • After reading a paper by Codd in IBM Journal of Research & Development, they created Oracle. (written in Assembly languag • Version 2.0 of Oracle was released in 1979 & The company changed its name to Relational Software Inc. (RSI) • In 1982, RSI was renamed to Oracle Corporation. • In 1983, Oracle released version 3.0, which was rewritten in C. • In 1984, Oracle 4.0 & In 1985 version Oracle 5.0 released. www.kerneltraining.com/oracle-dba • In 1986, Oracle goes public on the NASDAQ exchange. • In 1988, Oracle version 6.0 was released. (It provided row-level locking, hot backup and PL/SQL) • In 1992, Oracle 7.0 released. It provided better performance, administrative utilities, application development tools, secu stored procedures, triggers and declarative integrity. • In 1997, Oracle released Oracle 8.0. It started embracing Java. Partitioning, support for images, large text, external data etc.( *Started support for Object in database (Object-Relational DB • By 1999, Oracle released Oracle 8i. Supported for XML, Java V Machine (JVM) to run Java program in Database and also sc which was required for internet databases. www.kerneltraining.com/oracle-dba History Oracle Database • In 2001, Oracle9i was released. Allows Oracle to run on RAC. • In 2003, Oracle10g was released, where g stands for Grid comp • In 2007, Oracle has released Oracle11g. Employing nearly 1,08,000 people worldwide as of 31 May 2011. www.kerneltraining.com/oracle-dba Responsibilities of Administrator Enforcing Data INTEGRITY ASSIST PROGRAMMERS Maintaining SECURITY RECOVERING DATA DATABASE Providing AVAILABILITY PERFORMANCE www.kerneltraining.com/oracle-dba Questions? www.kerneltraining.com/oracle-dba THANK YOU for attending Demo ofOracle DBA