Default language.

Using relational databases with AR System

 can use any of the following database platforms:

  • Microsoft SQL Server
  • Oracle
  • PostgreSQL

Each type of relational database behaves differently with regard to search qualifications, wildcards, and so forth. The following topics describe these differences:

In general,  hides the underlying database from the user. The  interacts with the database and provides information to the user independent of the underlying database. All access through the API supplied with the product goes through this server and is independent of the database.

If you upgrade from a previous version of , the data dictionary is restructured. Remedy reserves the right to change the structure of the  database in any release. If the structure is changed, the database version number is updated to indicate a change.
 supports read access directly from the tables but does not support update access to any of the  tables directly through SQL. You must go through the  API for update access.

Other than  data,  and its installation do not interact with or affect other data in the database. The only exception is data referenced by using the Direct SQL capability within workflow or by using a view form. For more information about this function, see the Developing section.

Warning

Because  passes SQL commands to the database without checking the syntax, all commands are submitted to the database. Make sure all submitted commands achieve the desired result. Your SQL commands should comply with ANSI SQL standards so that single quotation marks are reserved for strings and double quotation marks are reserved for use with database object names only.

You can perform any system administrator activity on the database or on any of the tables it contains. This includes performing regular backups, creating more tablespaces to be added to the AR System database, and adding more containers to tablespaces.

After the  database is created,  creates a series of tables that form its data dictionary. See The-AR-System-data-dictionary.

For information about different behaviors and requirements for installing  with specific databases, see Preparing for installation in  Deployment documentation.

For information about configuration options and parameters associated with specific databases, see ar-cfg-or-ar-conf.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*