# 4 -- An Overview of Various Oracle Products: 1) Application Development Tools 2) Database Utilities 3) Connectivity and Middleware Products 4) Oracle Core Database Engine 5) Typical Oracle Development Environments 1)` Application Development tools -- a] SQL*Plus -- A Command line tool used to manipulate tables and other database objects in an Oracle database. b] Developer -- A suite of application development tools including Forms, Reports and Graphics. c] Oracle JDeveloper -- A general purpose Java Integrated Development Environment that has been pre-loaded with classes and methods used to connect to and manipulate schemas in Oracle databases. d] Oracle Designer -- A graphical tool used to create and display models contained in the CASE*Dictionary. e] Programmer -- Including the Pro* precompilers – Libraries of routines and utilities that can be linked with “C”, C++, FORTRAN, Java, ADA, COBOL or other host languages to allow access to Oracle databases. 2)` Database Utilities -- a] Enterprise Manager -- A GUI based collection of utilities for managing Oracle Database. b] SQL*DBA and SVRMGR -- A utility that allows the DBA to monitor database activity and to tune the database for optimal performance. c] Export/Import -- Command line utilities that allow a user or 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. d] SQL*Loader -- A command line utility to load ASCII or binary data files into an Oracle Database e] Oracle*Terminal -- A utility program used to customize the user interface and keyboard mappings for all Oracle tools. 3)` Connectivity and Middleware Products -- a] 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. b] 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. c] 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. d] Oracle ODBC Drivers – Open DataBase Connectivity drivers for connecting software to Oracle databases using the ODBC standard. 4)` Oracle Core Database Engine -- a] 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: i} 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. ii} Spatial Data Cartridge -- Allows storage of temporal and spatial data in the Oracle RDBMS. Useful for Geographic Information Systems (GIS). iii} Video Cartridge -- Provides storage and Real-time serving of streaming video. iv} ConText Cartridge -- Provides storage and retrieval of text documents. v} Messaging Option -- A groupware architecture built on top of the RDBMS. vi} OLAP Option -- Tools and database support for On-Line Analytical Processing. vii} 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. b] Integrated Data Dictionary -- Stores and manages access to all the tables owned by all users in a system. c] SQL [V. Imp] -- The language used to access and manipulate database data. d] Pl/Sql -- A Procedural extension to the SQL language unique to the Oracle line of products. 5)` Typical Oracle 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. Stand-alone development in a single user environment can be accomplished using the Personal Oracle or Personal Oracle Lite RDBMS in conjunction with Oracle Developer or a third party development tool. Muli-user development in a shared environment can be accomplished using an Oracle RDBMS server running on a Server machine. Distributed client PCs can develop the applications using any of the tools mentioned above.
Posted on: Thu, 15 Aug 2013 07:00:50 +0000
Trending Topics
Recently Viewed Topics
© 2015