Topic 4.1.4: Types of Database created
Farm Database
The farm database is a configuration database, basically used to map repositories, support Enterprise Server configuration, and so on. The database may grow when there is a massive usage of communication activities, such as email and SMS.
Repository Database
The repository database is a database for the repository related data. All the operational data required for the application exists in the database to keep the database healthy. Data such as various activities related information, the list data, forms definition, and workflow definitions is stored in the repository database. The database growth always relates to the features, such as list and queue, used by the application.
BI Database
The BI database is a placeholder for future development on business intelligence reports and does not occupy any space.
Parameters that affect the performance of an application include the environment, various databases involved, kind of workflow, and number and types of activities. For database sizing, the prospective data is captured to show the database growth pattern based on a typical workflow having 72 activities with a combination of engine and human activities. The information of the environment on which the data is captured along with the workflow used is included