|
|
|
|
O racle 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:
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
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.
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 INTERNET
NO.1 IN DATABASE
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 |
