Show TOC

BR*Tools Studio for Oracle DBALocate this document in the navigation structure

Use

BR*Tools Studio is a graphical web-based front end for BR*Tools. You can use BR*Tools Studio for all Oracle database administration tasks.

BR*Tools Studio has a three-tier architecture in which BR*Tools users no longer directly control jobs, but instead create job packages on the client and pass these packages over to BR*Tools Studio server. The server in turn executes the jobs independently on the target database instance. This architecture meets the requirements for quick-start favorite tasks and role-based, user-specific contexts. The BR*Tools Studio engine executes and keeps track of these items.

Integration

We have designed BR*Tools Studio as follows:

  • Multi-instance three-tier architecture

    BR*Tools Studio is a browser-based, three-tier application, which uses the internet browser for the graphical display on the client. The advantage is that you do not need to install software on the client. All you need is a normal internet browser. This means you can run the client anywhere, on any regular PC or workstation.

    In addition, there is no need to install BR*Tools Studio multiple times - that is, for each of your database instances. You only need to install BR*Tools Studio once. A single instance of BR*Tools Studio server can handle all your database instances simultaneously.

    The BR*Tools Studio architecture is configured like a star with multiple clients logging in to a single central server, which in turn connects to multiple database instances.

    Figure 1: BR*Tools Studio Architecture

  • Role-based multiuser concept

    BR*Tools Studio has a full multiuser concept. For each database instance you administer with BR*Tools Studio, you can create multiple, password-protected administration user accounts in BR*Tools Studio.

    You can personalize all users with a special role that defines their administration privileges throughout the database instance and BR*Tools Studio server. The different roles enable full auditing of operations in BR*Tools Studio.

  • Clients

    A user logs on as a client to BR*Tools Studio server. Not only does BR*Tools Studio allow several users to be logged in at the same time, it even allows any individual user to be connected to BR*Tools Studio server in multiple client sessions at the same time. In this case, you can see any changes you make in one client session in all other client sessions of your user.

  • Server

    The BR*Tools Studio server is the engine room of BR*Tools Studio. It executes incoming jobs and administers all items. If the server is down, all jobs scheduled for the downtime period fail. No clients can connect or log on to BR*Tools Studio until the server is up again.

  • Job queue, history, and scheduling

    With completion of a job on the client, the job is sent over to BR*Tools Studio server, which then handles the job autonomously:

    • If the job is scheduled for immediate execution, BR*Tools Studio server starts the job at once.

    • If the job is scheduled for execution at a later time, the server keeps the job in the job queue and automatically executes it at the requested point in time.

    With the recurrence option, you can instruct the server to keep repeating the same job with the specified recurrence interval. You can always keep track of executed jobs as BR*Tools Studio server maintains a full history of all jobs that have been executed on the server.

  • Favorite tasks

    You can save any preconfigured job that you want to keep for frequent use as a favorite task in BR*Tools Studio. You can then call and submit the job with one click, without having to reenter all the job parameters.

  • Auto-update status display

    A special status display in the BR*Tools Studio console informs you in one glance about the state of the database instance at any time. The status display is automatically refreshed so you do not need to trigger a manual refresh.

  • Reconnect

    When the client sends an instruction to the server to perform an operation, the BR*Tools Studio server takes over and executes the operation autonomously. The client does not need to wait for the end of the operation. This means you can log off the client and log on again later - at a different location, if required - to see the status of the operation.

  • Secure connection

    To guarantee security of your data, BR*Tools Studio uses connections based on Secure Socket layer (SSL)/HTTPS between the server and its individual clients.

Features

BR*Tools Studio is divided into these main areas: