Home » Developer & Programmer » Designer » Basic terminology problems!
Basic terminology problems! [message #90620] Wed, 26 May 2004 02:55 Go to next message
Ach
Messages: 26
Registered: April 2004
Junior Member
Hi all,

 Can anybody direct me on the exact meaning of these terms in Oracle,it seems these are a little different with related terms in Database theory:

 1.Schema

2.Database

3.Database engine

4.instance

-thanks in advance
Re: Basic terminology problems! [message #90623 is a reply to message #90620] Mon, 31 May 2004 15:24 Go to previous message
William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK
Senior Member
A schema is the set of objects belonging to an account. It is often used as another way to refer to an Oracle account.

A database is a set of data. In Oracle it is physically located in a set of OS files.

"Database Engine" is used sometimes to refer to the various processes and tools that interpret commands, retrieve and modify data etc. I'm not sure there is a precise definition for this without further context.

An Oracle Instance is the set of processes and memory you get when you start and mount a database. An instance only exists while it is up and running. Although most installations have only one instance per database, it is possible to configure multiple instances using "Real Application Clusters" - the idea is to allow multiple servers to share the load.
Previous Topic: DB Model for auditing and versioning
Next Topic: Save Designer ERD-diagram as a picture
Goto Forum:
  


Current Time: Thu Aug 06 14:50:14 CDT 2020