Make your own free website on Tripod.com

Oracle History
Back Home Up Next

 

  Theory

Projects

Articles

 Written Books

Report

Technical Report

Survey Reports

Workshop

Presentations

Tutorials

Algorithms

Contact Me

Yourself

 

Oracle Corporation is the world’s second largest reputed software company, and the largest supplier of Relational Database Management Software. With the database as the cornerstone of its product line, Oracle has evolved into more than just a database company, complementing its RDBMS server with a rich offering of well-integrated products that are designed specifically for distributed processing and client/server applications.

Oracle software is the world’s favorite solution for client/server computing, mainframe downsizing, and corporate re-engineering. Oracle software runs on almost every popular computer, from the smallest laptop to the very largest super computer.

With the annual revenues of $7.5 billion, the company offers its database, tools and applications products, along with related consulting, education, and support services, in more than 140 countries around the world.

Head quartered in Redwood Shore, California, Oracle employs over 36000 employees and is one of the first software companies to implement Network Computing capable database products, and the first major software company to make full-featured products available electronically on the Internet.

Oracle Products

The Oracle products suite includes the following tools and utilities:

Oracle Special Data Cartridge
Oracle Security
Oracle Network Computing Architecture
Oracle Communication Industries
Oracle Developer Program
Oracle Contest Cartridge
Oracle Finance
Oracle Online Analytical Processing
Oracle Networked Systems
Oracle Industry
Oracle Production
Oracle Energy

 Application Development Tools

 SQL Plus

A command line tool used to manipulate tables and other database objects in an Oracle database.

 Developer/2000

A suite of application development tools including Forms, Reports and Graphics.

 Oracle Forms

A screen based tool used to develop data entry forms and menus that access tables in an Oracle database.

 Oracle Reports

A screen based tool used to develop reports that access tables in an Oracle database.

 Oracle Graphics

A graphical tool used to develop charts and reports that access tables in an Oracle database.

 Oracle Designer/2000

A graphical tool used to create and display models contained in the CASE Dictionary.

 CASE Dictionary

A repository for business rules, functional models and data models used for organizing and documenting an application development effort.

 CASE Generator

A code generating tool that uses information stored in CASE Dictionary to develop data entry forms, reports and graphics.

 Oracle Book

A graphical tool used to develop on-line documentation with hypertext capabilities.

 Database Utilities

 Enterprise Manager

A GUI based collection of utilities for managing Oracle Databases.

 SQL DBA and SVRMGR

A utility that allows the database administrator (DBA) to monitor database activity and to tune the database for optimal performance.

 Export/Import

Command line utilities that allow a user or the DBA to export data from an Oracle database into a machine readable file or to import data from a machine readable file into an Oracle database.

 SQL Loader

A command line utility to load ASCII or binary data files into an Oracle database.

 Oracle Terminal

A utility program used to customize the user interface and keyboard mappings for all Oracle tools.

 Personal Oracle 8.0

 

Assistant Common Files

V1.0.0.0.0

Java Runtime Environment

V1.1.1.0.0

Oracle Call Interface

V8.0.3.0.1

Client Configuration Manager

V3.2.2.0.2

Oracle Client Software Agent

V3.2.2.0.2

Oracle Data Migration Assistant

V8.0.3.0.1

Oracle Installer

V3.2.2.0.2

Oracle Net 8

V8.0.3.0.0

Oracle 7 Utilities

V7.3.3.0.0

Oracle 8 Navigator

V8.0.3.0.1

Personal Oracle 8

V8.0.3.0.0

SQL Net Client

V2.3.3.0.1

SQL Plus

V8.0.3.0.0

Oracle Developer/2000

Developer/2000 primarily consists of three distinct products: Oracle Forms, Oracle Reports, and Oracle Graphics. These products can all be used individually or as an integrated application development platform. Although each has a separate purpose, there are many similarities that enable to create consistent and powerful applications. New versions are available on compact diskettes. Some of the tools and utilities are listed below in a tabular chart.

Database Table

V2.0.0.0.0

Forms

V5.0.6.8.0

Graphics

V3.0.3.10.0

Open Interfaces

V2.0.1.4.0

Procedure Builder

V2.0.1.4.0

Project Builder

V1.0.5.4.0

Query Builder

V2.5.4.1.0

Reports

V3.0.5.8.0

Translation Builder

V3.1.0.3.0

GUI Common Files

V2.5.6.25.0

Inter Solv Data Direct Driver

V2.12.0.1

Oracle Configuration Manager

V3.2.2.1.1

Oracle Client Software Agent

V3.2.2.1.1

Oracle File Packager

V1.0.0.1.1

Oracle Book

V2.2.3.0.1

Oracle Installer

V3.2.2.1.1

Oracle OCX Pack

V1.3.0.4.0

Oracle ODBC Driver for RDB

V2.10.11.0.0

Oracle Open Client ODBC

V2.0.2.15.0

Oracle Terminal

V2.5.6.25.0

Required Support Files

V7.3.4.0.0

SQL Net Client

V2.3.4.0.0

SQL Plus

V3.3.4.0.0

System Support Files

V2.1.0.0.0

Tool Utilities

V3.0.3.11.0

Connectivity and Middleware Products

SQL Net and Net8

A communications driver that allows an Oracle tool running on a client machine to access Oracle data on a separate server machine.

SQL Connect and Oracle Gateways

A communications driver that allows an Oracle tool running on a client machine to access Non-Oracle data on a server machine such as data residing in a DB2 database or MS SQL Server database.

ORACLE Server

Typically a part of the Oracle RDBMS running on a database server, this component receives requests from client machines and submits them to the Oracle RDBMS. The results are then passed back to the client machines.

Oracle ODBC Drivers

Open Database Connectivity drivers for connecting software to Oracle databases using the ODBC standard.

Core Database Engine

ORACLE RDBMS

The Oracle Relational Database Engine. Now called the Oracle Universal Server with several options in addition to managing relational data. These options are now called Cartridges:

Oracle Web Applications Server

A WWW Server (HTTP server) linked into the Oracle RDBMS. Allows web based applications using HTML forms and JAVA to access and manipulate data.

Spatial Data Cartridge

Allows storage of temporal and spatial data in the Oracle RDBMS. Useful for Geographic Information Systems (GIS).

Video Cartridge

Provides storage and real-time serving of streaming video.

ConText Cartridge

Provides storage and retrieval of text documents.

Messaging Option

A groupware architecture built on top of the RDBMS.

OLAP Option

Tools and database support for On-Line Analytical Processing.

Objects Option

Allows complex objects to be modeled and stored in the DBMS. Includes Object Oriented features such as encapsulation, inheritance, server and client side methods, etc.

Integrated Data Dictionary

Stores and manages access to all of the tables owned by all users in a system.

SQL

The language used to access and manipulate database data.

PL/SQL

A procedural extension to the SQL language unique to the Oracle line of products.

Typical Development Environments

Developing applications using an Oracle database requires access to a copy of the Oracle RDBMS (or a central Oracle RDBMS server), and one or more of the development tools. Third party development tools such as PowerBuilder, Visual Basic or Java can also be used for applications development.

 

ORACLE THE WORLD’S SECOND LARGEST SOFTWARE COMPANY IS……

 

NO.1 ON THE INTERNETwpe7.jpg (7692 bytes)

NO.1 IN DATABASE         wpe8.jpg (9140 bytes)

Oracle Liaison Office In Pakistan

Oracle Systems South West Asia (Pvt.) Limited

Mezzanine Floor, Holiday Inn Crown Plaza, Sharah-e-Faisal, Karachi –Pakistan

Tel:+9221 5673357

Tel/Fax: 9221-5673317

E-mail: Oracle@it-warehouse.com

 

Ora-Tech Systems (Pvt.) Ltd.

Karachi

9-A Block-6 P.E.C.H.S, Shahrah-e-Faisal, Karachi- 75400

Tel: 92-21-4535993-95

Fax: 92-21-4535994

E-Mail: mktg@ora-tech.com

Islamabad

Riaz Arcade, Block 13-A, Markaz F-7, Islamabad

Tel: 92-51-818835- 818320

Fax: 92-51-270401

E-mail: mktg@oratech.sdnpk.undp.org

Lahore

89 Main Boulevard, Calvalry Grounds, Lahore Cantt

Tel: 92-21-6674598

Fax: 92-21-6660598

E-mail: mktg@oratech.edunet.sdnpk.undp.org