Database Objects used for Simphony

The reporting database grows at rate of approximately 20 MB per 1000 checks. Those numbers are approximate values and may vary depending on individual setup and configuration.

The following databases/schemas/tablespaces* are used in a Simphony environment.

Table 1-1 Simphony Tablespaces

Database/Schema Name	Purpose	Auto Extend	Max Size	Initial Size	Growth Expectation
** TRANSACTIONDB	Transaction staging DB	Yes	Unlimited	128MB	*** Medium
** SECURITYDB	Security Key Storage	Yes	Unlimited	128MB	Negligible
COREDB	Configuration of Users and Organizations (Reporting & Analytics)	Yes	Unlimited	128MB	Negligible
LOCATION_ACTIVITY_DB	Historical data DB (Reporting & Analytics)	Yes	Unlimited	128MB	Significant
PORTALDB	Configuration of the Portal Website (Reporting & Analytics)	Yes	Unlimited	128MB	Negligible
RTA	RTA agent DB (Reporting & Analytics)	Yes	Unlimited	128MB	Negligible

When working with Oracle Database, the schema is the name of the logical place where tables are stored, the tablespace is the definition of the physical file that is given size parameters.

** Names of these databases (schemas) are chosen during installation. There is no standard naming convention.

*** The size of the TRANSACTIONDB remains relatively consistent as older transactions are purged; adding workstations or revenue centers typically causes the size to grow to a new consistent level.