Use ArDB to fulfill your Quality Control requirements

ArDB provides an easy to use mechanism for enabling a full set of Quality Control Statistics calculations.

Quality Control.png 

As well as provide a useful visualization of results and control limits, ArDB can report the calculation breakdown (N, Mean, SD, CV and Z-Score). Simply move the mouse over any result or opt to show the calculation breakdowns in additional columns.

ArDB can straightforwardly run a set of tests ("Shewhart Tests") to detect and highlight potential problems. Simply move the mouse of any highlighted test failures to see exactly which tests have failed.

The visualization

The Quality Control visualization can be configured to highlight any multiple of the group standard deviation with different colors.

Long-term monitoring of standards and instrument performance

These Quality Control Statistics coupled with ArDB enable many use cases.

A single ArDB database can be used to record your calibration/monitoring standard results and other performance metrics from one or more instruments across multiple laboratories.

By recording additional meta-data against each record, you can organize your results by sample type, run date, instrument type/identifier, and laboratory name - to name a few.

This extra level of organization allows you to keep all your records in a single database for easy collation and analysis.

Reference database validation checks

When building a reference database of known samples for comparisons with unknown samples, it is important to be confident that the results in your database are consistent.

The Quality Control Statistics calculations and other built-in statistical calculations can be used to verify that new sample submissions are consistent with other results within your database.

Shewhart Tests

ArDB can be configured to run any number of the standard set of "Shewhart Tests" as outlined below.

  1. 1 point is outside the control limits (3 standard deviations). A large shift.
  2. 9 points on the same side of the mean. A small sustained shift.
  3. 6 consecutive points are steadily increasing or decreasing. A trend of drift up or down.
  4. 14 consecutive points are alternating up and down. Non-random systematic variation.
  5. 2 consecutive points are more than 2 standard deviations from the mean on the same side of the mean. A medium shift.
  6. 4 out of 5 consecutive points are more than 1 standard deviation from the center line on the same side of the mean. A small shift.
  7. 15 consecutive points are within 1 standard deviation of the mean. Stratification.
  8. 8 consecutive points on either side of the mean, all more than 1 standard deviation away from the mean. A mixture pattern.

Each test can be individually enabled or disabled.

The "Shewhart Tests" internally use the 1, 2 and 3 standard deviation control limits and are not influenced by customizations made to the visualization.

Treating Different Results Differently

It is not always desirable to apply the same control limits and tests to all results.

One or more Quality Control Statistics calculations can be created, each with their own independent settings.

This allows for different control limits and tests to be applied to different results within the same database.

Grouping Records

ArDBs unique Group By setting within the Quality Control Statistics calculation allows for records to be grouped together and Quality Control Statistics to be calculated for each group independently of each other.

This allows for;

  • Comparison of results across discrete time periods
    • E.g. Group by day, week, month, year, etc.
  • Comparison of instrument performance
    • E.g. Group by instrument serial numbers,  laboratory name, etc. 

You can, therefore, utilize a single ArDB database for all of your monitoring needs, which takes the hassle out of designing and maintaining multiple databases.

Ordering Records

For the purpose of performing tests, an Order By option can be applied to ensure that the tests are performed consistently no matter how the data grid is visually ordered.

Features Overview
ArDB allows you to quickly group, filter and organize your analytical results, making it simple and fast to visualize your data on 2D Charts, 3D charts, and geographical maps (GIS).
ArDB makes challenging statistical analysis simple, with its intuitive offering of statistical tools (PCA, LDA, etc.).
ArDB utilizes a client-server architecture giving remote access to all collaborators whilst maintaining data integrity.
Monitor the quality of your databases using easy to use built-in statistics and tests.
ArDB directly integrates into your workflow when generating results using Elementar instruments.
ArDB utilizes a robust security model ensuring that your data is securely stored and transmitted.
ArDB provides a central database for all your analytical results.
Here is a list of all the features in ArDB.
Overview of how lyticOS and ArDB interact with each other. Describes how to define sample lists within ArDB and send them to lyticOS for acquisition. It is then easy to send the calibrated and corrected aggregated results back to ArDB.


Rest assured we are always on hand to help. If you would like to get in touch about our software, or just  chat, then please fill in the form below.  Alternatively, visit our Contact Page for further ways to get in touch.

Captcha Code