Oracle Database

1
Oracle Database

• 
  
  
  
  Presenters
• Suranga Ketkar
• Chris Stewart
• Our Website
• http//www.angelfire.com/ca5/stewman/bus119Aint
  ro.html

2
Overview

• Brief History
• Critical Database Concepts
• Market Share
• Competition
• Why Companies should use ORACLE?

3
Oracle Database Brief History

• 1977
• Larry Ellison, Bob Miner and Ed Oates
  found Software Development
• Laboratories and build a new type of
  database called a relational database
• system.Their original project is for the
  government and is titled Oracle. The
• founders believe that Oracle, meaning
  source of wisdom, would be an
• appropriate name for their project.
• 1979
• RSI ships its first commercial SQL
  database- V2 (there was no V1).
• 1983
• Company decides to make RDBMS portable.
  Oracle introduces V3-the first
• portable database to run on PCs,
  minicomputers and mainframes.

4


1987 Oracle officially becomes world's
largest DBMS software company. 1997
Oracle ships Oracle8, its next-generation
database for Network Computing that dramatically
reduces an organizations computing
costs and empowers a new era of low-cost,
personalized information
access. 1999 Oracle Delivers Oracle8i
the world's first internet database and
centerpiece of Oracle's Internet Platform for
business innovation.
5
Relational Database

• A relational Database is an extremely simple way
  of thinking about and managing the data used in a
  business.
• Oracle being a relational database management
  system turns a piece of data into information by
  organizing it.
• Oracle lets you do three things
• Lets you put data into it
• keeps the data
• Lets you get the data out and work with it
• Oracle supports this in-keep-out approach and
  provides clever tools that allow you considerable
  sophistication in how the data is captured,
  edited, modified, and put in how you keep it
  securely
• and how you get it out to manipulate and report
  on it.

6
Why it is called Relational?

• ORACLE stores information in tables.
• Tables can be related to each other if they each
  have a column with a common type of information.
• This relationship is the basis for the name
  relational database.
• Example

7
Three flavors of ORACLE

• An object relational database management system
  ( ORDBMS) extends the capabilities of the RDBMS
  to support object-oriented concepts.You can use
  ORACLE as an RDBMS or take advantage of its
  object oriented features.
• There are three flavors of ORACLE
• Relational
  The traditional ORACLE relational database.
• Object-relational
  The traditional ORACLE relational database,
  extended to include
  object-oriented concepts
  and structures such as abstract datatypes,
• 
  nested tables, and varying arrays.
• Object-oriented An
  object-oriented database whose design is based
  solely on
• 
  object-oriented analysis and
  design.

8
Structured Query Language

• ORACLE was the first company to release a
  product that used the English based Structured
  Query Language (SQL).
• This allowed end users to extract information
  themselves, without using a systems group for
  every little report.
• SQL has rules of grammar and syntax, but they
  are basically the normal rules of English speech
  and can be readily understood. Using SQL does not
  require any programming experience.
• The key words used in a query to ORACLE are
  select, from, where, and order by. They are clues
  to ORACLE to help it understand your request and
  respond with the correct answer.
• A simple ORACLE Query
• If ORACLE had the WEATHER table in its database,
  your first query to it would be simply this
• select city from WEATHER where Humidity 89
• ORACLE would respond
• City
• -------
• Athens
• PL/SQL is Oracles procedural language (PL)
  superset of Structured query language.

9

• Market Share
• Competition
• Why Companies should use ORACLE?

10
(No Transcript)
11
(No Transcript)
12
(No Transcript)
13
Oracle vs. DB2

• In the ever-increasing world of Internet
  business, it is becoming imperative for
  businesses to obtain a competitive advantage by
  adopting technology faster and faster. As a
  result, there has been considerable focus on
  Total Cost of Ownership (TCO) of IT solutions. In
  the new web-enabled environment supporting B2B
  and B2C e-commerce, IT cost of ownership becomes
  of lesser importance than business related
  metrics such as
•       
• 1. Scalability The ability to handle
  high, variable, and non-predictable transaction
  throughput.
• 2. Availability the ability to support
  non-stop (24x7) operations.
• 3. Ease of implementation and
  compatibility with packaged applications.
• I will compare Oracle 8i Enterprise Edition and
  IBMs DB2 Universal Database Enterprise Edition
  for you to make more evident the reason why a
  company should buy Oracle database products over
  other vendors.
• The following statistics were taken from
  www.input.com, a world respected leading provider
  of web-based e-business market research and
  marketing services.

14
Oracle Vs. DB2

• Database Usage and Throughput
• Oracle8i on average supports 60 more users
  than IBM DB2.
• Oracle8i on average supports 16 higher
  transaction throughput than IBM DB2.
• Oracle8i has a slightly higher level of
  scalability and performance than IBM DB2.
• Database Availability
•  On average 78 of applications running on
  Oracle8i achieve availability levels greater than
  99 compared to 62 of applications running on
  IBM DB2.
• Ease of Implementation
• Oracle8i is perceived to score more highly than
  IBM DB2 in terms of ease of implementation and
  compatibility with application package used.
•  

15
8i Vs. DB2 TCO

• Database Availability is Critical in an
  e-business Environment
• Organizations increasingly seek response times
  measured in milliseconds and zero downtime
  twenty-four hours a day and 365 days a year.
  Levels of availability are now arguably the most
  important factor in determining total cost of
  ownership since the cost of downtime to the
  business in a B2B or B2C e-commerce environment
  far outweighs any IT cost components.
• Average Throughout by Database Server
• Metric
• IBM
  DB2 Oracle8i
• Average number of transactions per minute
  37 43
• Peak number of transactions per minute
  127 143
• On average the transaction throughput is
  16 higher for Oracle8i than for IBM DB2.
• Approximately three-quarters of databases
  using Oracle8i exhibit availability levels in
  excess of 99 compared to approximately 60
  of those based on the IBM DB2 database platform.
• The total cost of ownership per name used per
  annum(including the business cost if downtime) is
  28 lower for Oracle8i than for IBM DB2.
•  

16
Why Companies Should use Oracle?

•  
• Scalability Can be used on all windows and
  many different UNIX operating systems.
• Oracle is much more stable and reliable the
  DB2 and SQL Server 7.0
• Oracle delivers the most Java and Internet
  specific features of popular databases. Users can
  create internal database programs like stored
  procedures and triggers in Java
• Oracle is much more suited for large volume
  web site processing due in part to its internal
  programming languages and its incorporation of
  Java and other web-enabled programming languages.
• Oracle has multiversioning concurrency. This
  function avoids making one user wait for another
  user to finish making changes to the database.
  Other databases make database readers wait for a
  database writer to finish making changes, but
  Oracle never does this its readers can always
  read any row in the database without waiting.
  This feature is why Oracle is able to push
  through more transactions per user than other
  database products.
• Has large database partitioning, which helps
  businesses keep monster, gigabyte-size databases
  under control.
• Offers market-leading support for multimedia
  objects

17

• Our Website
• http//www.angelfire.com/ca5/stewman/bus119Aint
  ro.html