X

Pat Shuff's Blog

  • November 7, 2006

what databases are offered?

Ok, some times I am simple minded. I need to write this down so that I don't forget this. If I put it in a blog I should be able to access when I need it (hopefully). Oracle offers a variety of database technologies. The databases that exist are:

  • BerkeleyDB - free
  • TimesTen - embedded memory database. It can sync with the other types of database and effectively be a cache front end to the other databases.
  • Lite Edition - cost. used for mobile devices with a database on the back end.
to compare these three http://www.oracle.com/database/embedded-compare.html
  • Express Edition - free. no CPU limit but runs on 1 CPU, 1G Ram, 4G data, support through online forum.
  • Standard Edition One - minimal cost. 1-2 CPUs, no memory limits. support available. Priced per CPU or per user
  • Standard Edition - 1-4 CPUs, can be clustered with RAC. no memory limits. support available. Prices per CPU or per user
  • Personal Edition - minimal cost. single user environment, no processor limit
  • Enterprise Edition - 4+ CPUs, no memory limits. support available, can be clustered with RAC. Prices per CPU or per user
The extended features and options supported and not supported are
Feature Database
Berkeley DB
Times Ten
Express Edition
Standard Edition One
Standard Edition
Personal Edition
Enterprise Edition
Data Guard
No
No
No
No
No
No
Yes
Rolling Upgrades
No
No
No
No
No
No
Yes
Fast start recovery
No
No
No
No
No
No
Yes
Schema reorg/redefine
No
No
No
No
No
No
Yes
Flashback Query
No
No
Yes
Yes
Yes
Yes
Yes
Flashback
No
No
No
No
No
No
Yes
RAC
No
No
No
No
Yes (free)
No
Yes (cost)
Security and Auditing
No
No
No
No
No
No
Yes
XML support
Yes
No
Yes
Yes
Yes
Yes
Yes
.NET and Active Dir
?
Yes
Yes
Yes
Yes
Yes
Yes
Management Packs
No
No
No
No
No
No
Yes
Enterprise Manager
No
No
Yes
Yes
Yes
Yes
Yes
Streams
No
No
No
No
No
No
Yes
Replication
Yes
Yes
Yes
Yes
Yes
Yes
Advanced
Spatial
No
No
No
No
No
No
Yes
ETL - Warehouse Builder
No
No
No
Std (free)
Std (free)
Std (free)
Enterprise (cost)

http://www.oracle.com/database/product_editions.html


Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.