What is Oracle? A Visual Definition
Putting
the Pieces of .NET Together - 8 Part Video Series | ||||
| Introduction |  | |||
| Videos 1-4 | 1. Servers (3 minutes) | 2. .NET Framework (10 minutes) | 3. Security (8 minutes) | 4. Monitoring Tools (10 minutes) |
| Videos 5-8 | 5. Web Servers (6 minutes) | 6. SQL Server (6 minutes) | 7. Software Develop Tools (10 minutes) | 8. Languages (2 minutes) |
| Download PDF | Putting the Pieces of .NET Together - 48-page PDF | |||
By: Wade Harvey
Historical Origins
In 1977, Larry Ellison and two of his friends, Bob Miner and Ed Oates, began a company named Software Development Laboratories, and they developed the original Oracle DBMS (Database Management System). They named the product Oracle after a code name project that they had worked on at a company called Ampex. In 1979, Software Development Laboratories was renamed to Relational Software Inc (RSI), and the RSI company was later renamed to Oracle Corporation in 1984.
Major Components of Oracle DBMS
An Oracle consists of a database and an instance.
A database includes all of the physical data files, control files, and redo log files that hold Oracles metadata and your data. Data files hold your actual data and indexes. Redo logs contain records of all changes that have been made. Control files hold important Oracle metadata. Control files contain all the information that instance needs to access a database.
An instance is a combination of the pool of physical memory (RAM) allocated to Oracle and the background processes that Oracle creates to use this memory pool. The RAM is called the SGA (System Global Area). RAM is used to cache data because RAM is about one thousand times faster that disk I/O. Here are the major processes that run in the background:
1. DBWR process that copies data in the RAM to the disk files
2. LGWR records changes applied to data in the redo log for recovery purposes in the event of a problem.
3. PMON Performance Monitor performs cleanup of failed user and server processes.
4. SMON System Monitor performs instance recovery in case server shuts down improperly.
5. CKPT Takes account whenever DBWR writes information from memory to disk.
Versions
The "i" in the version name emphasizes the internet functionality and the "g" emphasizes that the version is "grid-computing" ready.
| Date | Version | Features |
| 1979 | Oracle V2 | SQL queries and joins |
| 1983 | Oracle V3 | Commit, Rollback, Unix, Rewritten in C |
| 1984 | Oracle V4 | Read Consistency |
| 1985 | Oracle V5 | Distributed Queries |
| 1989 | Oracle V6 | ERP Financials, PL/SQL , row-level locking, hot backups |
| 1992 | Oracle V7 | referential integrity, stored procedures, triggers |
| 1997 | Oracle V8 | object-oriented and multimedia |
| 1999 | Oracle 8i | incorporated a native Java Virtual Machine (JVM) |
| 2001 | Oracle 9i | XML, Real Application Clusters (RAC), cluster database |
| 2003 | Oracle 10g | grids |
| 2007 | Oracle 11g |
Editions
| Edition | Features | Price |
| Standard Edition | Licensed by users or processors; 1-4 cpus | $15,000 per CPU |
| Enterprise Edition | Increased performance and security | $40,000 per CPU |
| Standard Edition One | Scaled-down Standard Edition | $5,000 per CPU or $149 per user |
| Express Edition | Max of 4GB user data; single CPU, requires 150MB | Free |
| Oracle Personal Edition | Same functionality as Enterprise Edition, but licensed to single-user developers | |
| Oracle Database Lite | Intended to run on mobile devices |
Client-Side Utilities
SQL*Plus – for creating and testing command-line SQL Queries and executing PL/SQL procedural programs.
Oracle Developer Suite – for developing database applications including the following developer tools:
- Forms Builder – for creating custom user applications
- Reports Builder – for creating reports for displaying, printing, and distributing summary data.
- Enterprise Manager – for performing database administration tasks such as creating new user accounts and configuring how the DBMS stores and manages data.
Further Study
There is an excellent set of study guide workbooks from Oracle University that you can get by clicking on this link: Oracle University Workbooks
Related posts:
- What is Java? A Visual Definition Article discusses Java's historical origins and key features. Java is...
- What is .NET Framework? A Visual Definition The .NET applications and services operate within the .NET Framework...
- What is MySQL? A Visual Definition MySQL is an RDBMS (relational database) that is used in...
- Visual Studio, Visual Basic.NET, C# Database, SQL Server, and ASP.NET Video Tutorials – August 23, 2009 Visual Studio 2010 and .NET Framework 4 Beta 1...
- Programming News Dynamically generate C# data access code for MS SQL...
Related posts brought to you by Yet Another Related Posts Plugin.
I thought an oracle was a soothsayer. Shows how much I know.
Another good article, with explanatory diagrams. Thanks. I did not realise how expensive this was though. Surely there must be cheaper options than Oracle?
Mr Rudy,
Thanks for your question about Feedburner. I do not think that you need feedburner. You just need a feedreader to read the feeds that you create from idealprogrammer.com I just created a new navigation link in the menu called RSS feeds that will hopefully help explain RSS a little better. Let me know if you still have problems or if there is any other way I might assist. Thanks, Wade Harvey
I want more………….. about dot net
sorry about oracle
Once again, I can't say Thanks enougth for the good work you have done for free. May God abundantly bless you.