Data management in the AR System database
After implementing AR System in your environment, the data that is created such as filters, escalations, active links, forms, and the relationships between these data are stored in the database as tables.
The AR data dictionary provides the structural definitions of all the forms, filters, escalations, active links, character menus, and containers that are entered into the system. Learn about the tables that are created to hold the information about newly created forms. These tables are indexed by AR System directly or by an administrator. Any modifications that are made to the forms such as changes to certain fields in the form are reflected in the database tables. Information about server groups is also stored in the database tables.
The following topics describe in detail how AR System database manages the data:
Task | Reference |
|---|---|
Understand how the tables store the complete definition of the structures and workflow in your implementation of AR System. | |
Understand how data is stored in AR System database by creating tables for every new form that is created. | |
Learn how indexes are created and updated for AR System tables. | |
Learn how to read data from the database by using SQL views and base tables. | |
Understand how AR System restructures the underlying database to reflect the changes that are made to fields in a form. | |
Learn about the database platform that AR System uses, and understand the differences between these relational databases. | |
Understand how the server group information is stored in AR System database. | |
Learn about the column types used for AR System fields in each database type that is supported by AR System. |