The platform supports a robust range of visualization tools. The product includes libraries that support the most modern infographics and charting capabilities out of the box. The following is a short list of what is available. Please note that the product supports over 360 different chart types and cannot be listed in full here: Pie Charts, Area Charts, Line Charts, Range Series Charts, Column Charts, Angular Gauges, Tree Maps, Heat Maps, Bar Charts, Area-spline Charts, Waterfall Charts, Time Series Charts, and Map Charts.

Note that the visualization tools chosen will depend on client data and industry needs. As an example, heat maps and location maps are used for clients in the intelligence and investigation industry.

All chart types can be supported in a single dashboard. In addition, users have the ability to select what chart type best suits their view of the data.

The platform does not support portlet web technology directly. Instead, it treats each area of the screen as a separate panel. This allows users to include or remove panels based on relevance. These preferences can be saved for future use. In effect, a user can build a completely different screen from other users by just selecting the panels that are relevant to them. That said, the platform exposes all its functionality as services, which means that a client’s developer can extract data from the platform and use this to build a portlet component as required. The point here is to provide clients with interfaces that do not restrict skills or need for knowledge of languages in order to interact with data.

Mathematical Functions
The CST platform supports the following mathematical functions out of the box:

  • sin(a) – Returns the trigonometric sine of an angle.
  • cos(a) – Returns the trigonometric cosine of an angle.
  • tan(a) – Returns the trigonometric tangent of an angle.
  • asin(a) – Returns the arc sine of a value.
  • acos(a) – Returns the arc cosine of a value.
  • atan(a) – Returns the arc tangent of a value.
  • toRadians(angdeg) – Converts an angle measured in degrees to an approximately equivalent angle measured in radians
  • toDegrees(angrad) – Converts an angle measured in radians to an approximately equivalent angle measured in degrees.
  • exp(a) – Returns Euler’s number e raised to the power of value.
  • log(a) – Returns the natural logarithm (base e) of a value.
  • log10(a) – Returns the base 10 logarithm of a value.
  • sqrt(a) – Returns the correctly rounded positive square root of a value.
  • cbrt(a) – Returns the cube root of a double value.
  • IEEEremainder(f1, f2) – Computes the remainder operation on two arguments as prescribed by the IEEE 754 standard.
  • ceil(a) – Returns the smallest (closest to negative infinity) value that is greater than or equal to the argument and is equal to a mathematical integer.

  • floor(a) – Returns the largest (closest to positive infinity) value that is less than or equal to the argument and is equal to a mathematical integer.
  • rint(a) – Returns the value that is closest in value to the argument and is equal to a mathematical integer.
  • atan2(y, x) – Returns the angle theta from the conversion of rectangular coordinates (x, y) to polar coordinates (r,theta).
  • pow(a, b) – Returns the value of the first argument raised to the power of the second argument.
  • round(a) – Returns the closest int to the argument.
  • random() – Returns a random double value.
  • abs(a) – Returns the absolute value of a value.
  • max(a, b) – Returns the greater of two values.
  • min(a, b) – Returns the smaller of two values.
  • ulp(d) – Returns the size of an ulp of the argument.
  • signum(d) – Returns the signum function of the argument.
  • sinh(x) – Returns the hyperbolic sine of a value.
  • cosh(x) – Returns the hyperbolic cosine of a value.
  • tanh(x) – Returns the hyperbolic tangent of a value.
  • hypot(x, y) – Returns sqrt(x2 + y2) without intermediate overflow or underflow.

Aggregation Functions
The CST platform supports the following mathematical functions out of the box:
ATTR(expression)

Returns the value of the expression if it has a single value for all rows. Otherwise returns an asterisk. Null values are ignored.

AVG(expression)

Returns the average of all the values in the expression. AVG can be used with numeric fields only. Null values are ignored.

COUNT(expression)

Returns the number of items in a group. Null values are not counted.

COUNTD(expression)

Returns the number of distinct items in a group. Null values are not counted.

MAX(expression)

Returns the maximum of an expression across all records. If the expression is a string value, this function returns the last value where last is defined by alphabetical order.

MEDIAN(expression)

Returns the median of an expression across all records. Median can only be used with numeric fields. Null values are ignored.

MIN(expression)

Returns the minimum of an expression across all records. If the expression is a string value, this function returns the first value where first is defined by alphabetical order.

PERCENTILE(expression, number)

Returns the percentile value from the given expression corresponding to the specified number. The number must be between 0 and 1 (inclusive)— for example, 0.66, and must be a numeric constant. This function is available for non-legacy Microsoft Excel and text file connections, extracts, extract-only data sources (for example, Google Analytics, OData, and Salesforce), Sybase IQ 15.1 and later data sources, and Oracle 10 and later data sources.

STDEV(expression)

Returns the statistical standard deviation of all values in the given expression based on a sample of the population.

STDEVP(expression)

Returns the statistical standard deviation of all values in the given expression based on a biased population.

SUM(expression)

Returns the sum of all values in the expression. SUM can be used with numeric fields only. Null values are ignored.

VAR(expression)

Returns the statistical variance of all values in the given expression based on a sample of the population.

VARP(expression)

Returns the statistical variance of all values in the given expression on the entire population. In addition, the platform also supports the types of the following function. A full list is available on request:

  • Number functions
  • String manipulation functions
  • Date functions
  • Logical functions
  • User functions
  • Table calculation functions
  • Type conversion functions

Solution Administration:

The platform provides a separate dashboard for monitoring of resources both for the application and the infrastructure environment. The platform itself is deployed in a distributed architecture. The monitoring tools provided will monitor all aspects of the platform, its deployed containers, and the underlying resource usage. It will also provide first line support capabilities like restarting a node or container where applicable.

Other system monitors are provided. As an example, the platform provides the ability to monitor all elements of the application and its service on a color-coded dashboard.

The below are examples of what the platform provides. There are over 60 different monitoring tools in different dashboards for both the infrastructure and the platform itself. As an example, the green monitors monitor application components in real time and will change color to red where a component fails.

System Audit

The platform provides robust audit monitoring for both users and the application usage…including detailed information on queries and reporting requests made. For each Audit information admin users are able to drill down both in data and infographics to see timelines and trends of application usage: Note that the audit trail is searchable and can be time customised. It can also be configured to alert nominated resources based on set thresholds.

System Deployment

The CST platform is deployed as a set of distributed containers. In effect, each container is separately deployable. As an example, it is possible to deploy services on different machines/servers based on security considerations. While CST will prefer to install and configure the application in the first instance, the knowledge required to allow a customer to perform the install themselves is minimal. Configuration of the platform is intentionally made easy so that customers can handle configuration. Full documentation is also provided.

The following steps are required to install the CST platform:

  • Operating system installation (if required)
  • Cluster initialisation
  • Automated deployment of containers

All the above can be done by a set of scripts run against the environment.

Once the full platform is installed, updates and upgrades are as simple as replacing the deployed container on the fly. This is made possible by the platform’s microservice architecture and the containerized approach to deployment. It means individual containers can be tested and replaced without the overhead of full platform deployment.

The admin section of the platform will allow for Metadata configuration. This will include the ability to configure users, application settings, autonomy, and any other data required by the system. The management tool will allow on the fly (audited) changes to be made to system Metadata including all levels of data configuration.

The platform is clustered and supports real-time replication and both Active/Active and Active/Passive failover. This means there is no need for scheduled or nightly backups as this occurs in real time. The Platform

leverages best of breed technologies to achieve this. The result is that if one node of the system goes down, another node is automatically activated without user knowledge. Also, if one data center is down the real-time replication of data comes into effect by pointing the remaining nodes in the cluster to a new failover center with minimal impact on the users and the system stability. The Active/Active approach provides high availability in real terms.

As the system supports an active/active failover approach which eliminates the need for manual intervention or even nightly backups.