Database Administration Tools
Workshop 4
Database Administration Tools
There are three types of Database Administration Tools, Oracle Enterprise Manger, Microsoft SQL Server Enterprise Manager and Sybase Central. This paper will discuss each one.
The database tool and utility applications are the primary administrative components of Oracle Enterprise Manager. You can use these applications to perform most of your DBA administration tasks. Some of the design features of the applications allows you to use the graphical interface to execute the commands quickly and conveniently by pointing and clicking with the mouse rather than manually entering the SQL commands to perform these tasks. Concurrently perform multiple tasks in multiple Oracle Enterprise Manager windows. Administer multiple databases simultaneously in multiple windows.
It also centralizes database administration tasks for both local and remote databases running on any Oracle platform in any location worldwide. In addition, these Oracle platforms can be connected by any network protocols supported by SQL Net and the MultiProtocol Interchange. Perform DBA administrative tasks using Oracle Enterprise Manager's line mode interface when a graphical user interface is unavailable or undesirable and the line mode option is available on all platforms.
Another Database Administration tool is Sybase Central. Sybase Central is a graphical management tool. It implements the Sybase enterprise management strategy, which calls for a single management console, seamlessly integrated, across all server and middleware products. Sybase Central can run on Microsoft Windows 95 and Microsoft NT. It connects to and manages Sybase products running on any Sybase-supported platform.
Some of the functions Sybase Central uses are visual representation of objects, easy point and click interface, management of multiple servers from one console, OmniConnet management, code editor, generation of data definition language (DDL), object...
View Full Essay