Oracle Corporation is the worlds 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 worlds 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.
The Oracle products suite includes the following tools and utilities:
Application Development Tools
A command line tool used to manipulate tables and other database objects in an Oracle database.
A suite of application development tools including Forms, Reports and Graphics.
A screen based tool used to develop data entry forms and menus that access tables in an Oracle database.
A screen based tool used to develop reports that access tables in an Oracle database.
A graphical tool used to develop charts and reports that access tables in an Oracle database.
A graphical tool used to create and display models contained in the CASE Dictionary.
A repository for business rules, functional models and data models used for organizing and documenting an application development effort.
A code generating tool that uses information stored in CASE Dictionary to develop data entry forms, reports and graphics.
A graphical tool used to develop on-line documentation with hypertext capabilities.
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.
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.
A command line utility to load ASCII or binary data files into an Oracle database.
A utility program used to customize the user interface and keyboard mappings for all Oracle tools.
Personal Oracle 8.0
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.
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.
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 EngineORACLE 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 OptionTools and database support for On-Line Analytical Processing.
Objects OptionAllows 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.
ORACLETHE WORLDS SECOND LARGEST SOFTWARE COMPANY IS
NO.1ON THE INTERNET
Oracle Liaison Office In Pakistan
Oracle Systems South West Asia (Pvt.) Limited
Mezzanine Floor, Holiday Inn Crown Plaza, Sharah-e-Faisal, Karachi Pakistan
Ora-Tech Systems (Pvt.) Ltd.
9-A Block-6 P.E.C.H.S, Shahrah-e-Faisal, Karachi- 75400
Riaz Arcade, Block 13-A, Markaz F-7, Islamabad
Tel: 92-51-818835- 818320
89 Main Boulevard, Calvalry Grounds, Lahore Cantt