Contents

Popular

Backup of Analytics Data can be scheduled to be stored in the format and time frame as specified. This feature is used to improve performance by managing memory. Since the data stored based on minutes/hours occupy a larger memory space than it takes to store data in days.

After setting values, click the Start Monitor button to start the scheduled backup of analytics data.

  • The Save option helps to save the configuration set. The analysis based on this configuration can be started any time.
  • The Stop Monitor button stops the scheduled backup of analytics data.

Once the configurations are saved, notice the related logs in the Logs section.

Icon

Reports generated from the Analytics  section will be based on the properties configured in this section.

PropertyDescription
Server GroupThe environment from which the data needs to be backed up.
Enable Analytics Backup Aggregation MonitorEnables to configure Scheduling.
PostSQL Installation bin pathLocation of the "bin" directory in the Postgre installation path.
Backup Folder PathLocation where the backup data needs to be stored.
No. of months to retain Minute-wiseData pertaining to those months that needs to be backed up on the basis of minutes.
No. of months to retain HourlyData pertaining to those months that needs to be backed up on the basis of hours.
No. of months to retain DailyData pertaining to those months that needs to be backed up on the basis of days.
Schedule everyThe number of month's interval when the data needs to be backed up.
Day of Month

The day of the month (based on the Schedule every property value) when the data back up needs to be scheduled to start.

Icon

If the value is "31", it takes the last day of the month for those months, including February, which do not have 31 days.

Time of Day(format HH:mm)The time of the day (based on the Day of Month property value) when the data back up needs to be scheduled to start.
Icon

When a data backup is performed after scheduling, it retrieves only the data available in minutes, because the Development/Production table carries only the data which is based on minutes. Rest of the data is segregated in Hourly, Daily and Monthly basis.


Backup Analytics Data page with sample values entered

Example

Consider to schedule the analytics data backup on the 18th of every month with the following values (refer the figure above):

Server Group - Production
Enable Analytics Backup Aggregation Monitor - Enabled
PostSQL Installation bin path - /usr/pgsql-9.6/bin
Backup Folder Path - /root/APIBackups
No. of months to retain Minute-wise - 2
No. of months to retain Hourly - 3
No. of months to retain Daily - 4
Schedule every - 1
Day of Month - 18
Time of Day(format HH:mm) - 12:31

Assuming that this is configured on the month of November (scheduled for the 18th of December), data will be backed up and are available for generating reports in the following manner:

October and November - Minutes
July, August, and September - Hours
March, April, May, and June - Daily
Till March - Monthly


Icon

Tables used for Analytics Aggregation

Following are the important tables involved in analytics data backup:

TablesDescription
"FIORANO_API"."BACKUP_MONITORING_DETAILS"

This table have the following columns:

  • environment: Stores the Server Group where the analytics data needs to be backed up.

    Example

    Icon

    Development, Testing, Production.

  • starttime: The date and time from which the analytics data needs to be backed up.
  • nexttime: The date and time the analytics data needs to be backed up the next time.
  • lasttime: The date and time when the analytics data was backed up on the previous occasion.
"FIORANO_API"."API_ANALYTICS_PRODUCTION_BY_DAY"This table stores data based on day. 
"FIORANO_API"."API_ANALYTICS_PRODUCTION_BY_HOUR"This table stores data based on hour. 
"FIORANO_API"."API_ANALYTICS_PRODUCTION_BY_MONTH"This table stores data based on month.

 

Stored Procedures

Following are the major Stored Procedures based on which the data segregation has to be done:

FunctionDescription
"FIORANO_API"."AggregateDaysToMonths"Converts data based on days to based on months.
"FIORANO_API"."AggregateHoursToDays"Converts data based on hours to based on days.
"FIORANO_API"."AggregateMinsToHours"Converts data based on minutes to based on Hours. 
Adaptavist ThemeBuilder EngineAtlassian Confluence