b)Oracle Client tools
a).Oracle Server tools:
Oracle is company that produces the most widely used, Server based, Multi user RDBMS. The Oracle Server is a program installed on the server’s hard disk drive. This program must be loaded in RAM so that it can process user requests.
This Oracle Server product is either called Oracle Work group Server or Oracle Enterprise Server.
The functionality of both these products is identical. However, the Oracle Work-group Server restricts the number of concurrent users who can query the Server. Oracle Enterprise Server has no such restrictions. Either product must be loaded on a multi-user operating system.
The Oracle Server takes care of the following:
• Updating the database.
• Retrieving information from the database.
• Accepting query language statements.
• Enforcing security specifications.
• Enforcing data integrity specifications.
• Managing data sharing.
• Enforcing transaction consistency.
• Optimizing queries.
• Managing system catalogs.
Oracle Database Administrator (DBA) :
Anyone who logs onto the multi-user operating System as ‘internal’ or ‘system’ with the appropriate ‘password’ is recognized by the o/s as the legitimate owner of ‘Oracle’ resources on the Hard disk drive. This person them becomes the Oracle DBA.
Oracle’s Resource Control tool :
The tool set is generally called Oracle Enterprise Manager. It include the Server Manager Tool, which is used to startup the Oracle Engine, security Manager that allows the DBA to create user and grant users permissions to use resources of the Oracle database.
The tool protected :
The tools included in the Oracle Enterprise Manager can be installed on different Operating Systems. The user authentication for starting these tools varies from Operating System to Operating System.
The user authentication varies based on the tool invoke from the Oracle Enterprise Manager tool set.
Oracle Server Manager Tool :
The Server Manager Tool is used to load the Oracle engine from the Server’s hard disk drive into the Server’s memory. Oracle users will be allowed to access Oracle resources only when the Oracle engine is loaded in memory.
Oracle Security Manager Tool :
Once the Oracle engine is running, the Security Manager tool can be used by the DBA to create user accounts and grant permission to the user accounts. Creation of a user account will provide user’s with:
i. Login identity.
ii. A password.
iii. Permission to use Oracle resources
The login identity and the password will allow a user to connect to the Oracle Database. Once connected to the Oracle Database, a user can create or use the Oracle Resources like tables, views etc. Depending on the permission granted by the DBA.
b).Oracle Client Tools:
Once the Oracle Engine is loaded into a Server’s memory, users would have to log into the engine to get work done. Oracle Corporation has several client-based tools that facilitate this. The client tool most commonly used for Commercial Application Development.
A Data Storage System:
All commercial applications manipulate data. Prior the manipulation of data, it has to be stored . hence logically the lowest layer in any commercial applications is a data storage system. The data storage product, create and marketed by Oracle is either Oracle Work group Server or Oracle Enterprise Server.
A Menu System:
It is impossible to create an entire commercial application using a single data capture and validation, from object. This is because a data capture and validation, from object, used to capture.
Some of the data can be better represented in the form of pictures. The Oracle Graphics Tool allows programmers to prepare graphs using data from Oracle Structures like tables, views etc. Oracle Graphics can also be considered as a part of the reporting section of a commercial application.