AR System database server
BMC Remedy AR System uses standard relational database engines for the actual storage and retrieval of data. Architecturally, the database server is an independent set of processes that are completely separate from the AR System server processes. Physically, the database server processes can be running on the same server host as the AR System server or on a different host. The database server can be any platform that the database engine supports.
BMC Remedy AR System can also work with data stored in external databases and other data sources that are not managed by BMC Remedy AR System. BMC Remedy AR System accesses these data sources through view forms . In addition, BMC Remedy AR System can use BMC Remedy AR System database connectivity (ARDBC ) to work with data not stored in databases as if the data were locally owned.
Because the AR System server manages all workflow, applications are independent of the database. Therefore, applications created on an AR System server running one type of database can easily be moved to a server running a different type of database. BMC provides a simple export/import utility for this purpose.
BMC Remedy AR System is not a database application in the typical sense. All of the workflow is managed by the AR System server, so proprietary database features such as triggers and stored procedures are not used. An application created on an AR System server running one type of database engine can easily be moved to a server running a different database engine through a simple export/import process.
The user or administrator of AR System clients does not need to know anything about SQL or the underlying database.
BMC Remedy AR System workflow components can search for records (requests) in the AR System database and act on the results of the search. Clients can use the following types of searches:
- Query-by-example (QBE)
- Advanced search
An administrator can create and store searches that are commonly performed by users. A user can define personal searches for forms to which the user has access.