How Tools are classified as per User Roles in MaxDB?
MaxDB has a lot of tools that are not only meant for multiple functionalities but also to maintain database integrity by defining user roles. Unlike most other databases that use a same console for administration, data query, tuning etc, MaxDB provides separate tools for performing these actions in a much better and simple way. Functionalities like administrative tasks, data manipulation, database analysis, are well identified and separate processing tools have been provided by MaxDB. For example an user with administrative role has a separate set of tools that will perform administrative tasks and for the user who normally manipulates data, there is nothing to do with administrative tasks and hence he has his set of tools for data manipulation only. In this weblog the classification of MaxDB tools is explained.
Classification of MaxDB tools
The above picture gives a clear idea about the MaxDB tools and its classification.
MaxDB tools and their usage
1. Database Manager
|1.1 DBM GUI
The DBM GUI is tool used to manage database instances. You can use it to create, monitor, back up, and restore database instances.The DBM GUI works only on Windows platforms. This can be used to manage database instances that are running on a local as well as a remote computer with a different operating system.
The DBMCLI is a command line tool similar to DBM GUI used to manage database instances. This can be used on a local as well as a remote computer and can be used with all the operating system.
|1.3 Web DBM
The Web DBM is a tool similar to DBM GUI or DBMCLI used to manage database instances. This can be run only on web browsers and can be used on a local as well as a remote computer running any operating system.
2. SQl Clients
|2.1 SQL Studio GUI
The SQL Studio database tool is used to access the data in database instances using SQL statements. SQL Studio can be used only in Windows platform. SQL Studio can be used to access databases from local as well as a remote computer running a different operating system.
SQLCLI is a command line tool similar to SQL Studio in operation and can be used in all operating systems by the database system. You can access database instances on your local computer and on remote computers. This tool has an added advantage of reading the commands from files and also transporting the results to the files.
|2.3 Web SQL Studio
The Web SQL Studio is a tool similar to SQL Studio or SQLCLI used to access the data in database instances using SQL statements. This can be run only on web browsers and can be used on a local as well as a remote computer running any operating system.
|3. Database Analyzer
The Database Analyzer database tool is used to analyze the performance of database instances. It identifies the problems associated with Database configuration, Synchronization Processing of SQL statements, Hardware configuration etc. You can use Database Analyzer on all operating systems supported by the database system. You can analyze all database instance types and versions of the database software and also access database instances on a remote computer.
|4. Synchronization Manager
The Synchronization Manager is a tool for synchronizing the contents of tables of two or more database instances. The data is transferred using an asynchronous messaging system. Both sides involved in the data transfer do not necessarily have to be online at the same time. The full synchronization scenario is defined using the Synchronization Manager GUI and it is stored in the master instance.
|5. Loader Tool
The Loader is a command line tool and can be used on all operating systems supported by the database system. The Loader database tool to import or export application data and the database catalog to or from a MaxDB database instance. You can import or export the data for all users in a database instance, all tables relating to a specific user, one table relating to a specific user, or a number of qualified columns in a table or several tables. But using Loader tool data can only be imported to the MaxDB database instance.
XCONS is a command line tool used to find the status of the active database sessions.It can be used on all operating systems.
XPU is a command line tool used to analyzes the state of the database instance. It can be used on all operating systems.
The XUSER database tool is used to define XUSER entries for users. You can define XUSER entries for database users and DBM operators. XUSER entries make it easier for database tools to connect to the database instance. XUSER can also be used in SAP systems. XUSER is a command line tool and can be used on all operating systems supported by the database system. An operating system user can define up to 32 user keys.
The X Server is the communication server of the database system. It listens for connection requests from database applications and tools at service port sql6/TCP.
|6.5 Web Server
The Web Server when started enables Web Tools like Web SQL to communicate with a MaxDB database instance. The Web Server can be used on all operating systems supported by the database system. The Web Server can be made to start automatically provided if we have administrative rights.
|6.6 Web Server Manager
The Web Server Manager is a browser based tool used to manage the Web Server and the Web Tools.It can be used on all operating systems supported by the database system.