ArDB Feature List

ArDB is packed with features designed to make it easier for you to get to the stories hidden in your data. Some of those features are big, others are small, but everyone of them will help you get on and generate the datasets that you have been working towards. Here is a list of all the features in ArDB. 

Connections

• Store connection details for multiple servers
• Securely log in / out of a server (SSL)
• Quick link to server portal

Permissions

• Account
  •  Can Manage Account Permissions
  •  Can Add Databases
• Database
  • Can Manage Database Permissions
  • Can Manage Fields
  • Can Add Samples
  • Can Remove Samples
  • Can Update Samples
  • Can Publish Samples
  • Can View Draft Samples
  • Can View Deleted Samples
  • Can Permanently Delete Samples

Automatic Updates

• Deployable by Server

Accounts

• Access multiple accounts within a server

Database

• Create databases with customizable fields and samples
• Permissions
• Audit

Fields

• Common Fields
  • ID (auto-incrementing and unique for any given account)
  • Created By
  • Created Date
  • Updated By
  • Updated Date
  • Is Deleted
  • Status
  • Version
• Customizable Fields
  • Add, Edit, Delete
  • Text
  • Whole Number
  • Numeric
  • Date
  • Time
  • Date & Time
  • Duration
  • True / False
  • 2D Coordinate
  • 3D Coordinate
  • Normal Distributed Result
• Auto-population of subfields which can be queried independently
  • Date and Date Time
    • Year
    • Month
    • Day
    • Year, Month
    • Month, Day
  • Time, Date Time and Duration
    • Hour
    • Minute
    • Second
    • Millisecond
  • 2D Coordinate
    • Longitude
    • Latitude
  • 3D Coordinate
    • Longitude
    • Latitude
    • Altitude
• Aggregation Options
  • Optionally aggregate numeric fields when grouping
• Auto-populate GPS from address fields

Audit Log

• Record all changes of a record
• Record all changes to a database (samples added, updated or removed)
• Record versions
• Records can have Draft or Published status

Sample Templates

• Default selected values
• Default values

Workspaces

• Contains many tabs
• Save/load workspace using a convenient workspace file

Sharing

• Share workspaces with colleagues (by email address)
• Give read-only access
• Give read/write access

Tab

• Save/Load Tab 
  • View state (Grid, Chart, Map)
  • Filter
  • Sort
  • Grouping
  • Paging
  • Name
• Grid View
  • Display sample fields and results within a grid
  • Customize column position and size
  • Pin columns so that they are always visible
  • Click column headers to sort
  • Export to excel
    • Including column visibility and order
• Chart View
  • Display multiple charts
  • Categorize points based on one or more common field
  • 2D
    • Scatter
    • Line
    • Column
    • Area
    • Confidence ellipses
    • Multiple X axes
    • Multiple Y axes
  • 3D
    • Scatter
    • Line
    • Column
  • Zoom
  • Pan
  • Overview Pane
  • Selection
  • Save Image as BMP, JPG, PNG
  • Save Vector Image as SVG
  • Copy Image
  • Show / Hide Legend
  • Hide data points
• Map View 
  • Display multiple maps
  • Color spectrum range (editable) for plotted results
    • Dataset min and max
    • Adjustable rendered min and max
    • Scatter
    • Area (interpolated, triangulation)
  • Zoom
  • Pan
  • Overview Pane
  • Save Image as BMP, JPG, PNG
  • Copy Image
  • Hide data points
  • Layers
    • Install ESRI Shape files and customize
      • Color
      • Conditionally visible based on zoom range
      • Resolution
      • Shape description field
      • Type
    • Database specific customizations and defaults
  • Record default (local) zoom preference
• Paging
  • Go to first, next, previous and last page
  • Go to specific page
  • Definable page size
  • Display currently visible record numbers and total records
  • Warn if not all records are currently being displayed
• Filter
  • Smart Date
    • Allow quick “steps” of time from within a view
    • E.g. Days, Weeks, Months, Seasons, Years, etc.
    • Definable “Range”
    • Definable “Step”
  • Group By
    • Select one or more fields to group data
    • Fields that support aggregation will be automatically aggregated
    • Easy visibility of current groupings
    • Sort by grouped fields
  • Advanced Filter
    • Add criteria based on sample fields or subfields.
    • Add multiple groupings of criteria several levels deep
      • AND
      • OR
    • Include draft samples
    • Include deleted samples
  • Sort by fields
    • Ascending
    • Descending
  • View selected samples in new Tab
• Sample Management
  • Import from excel
    • Auto-populated import profile
    • Sheet selector
    • Insert or Update
    • Ignore the number of Header Rows
    • Publish or Draft
    • Ignore empty rows
    • Columns to Fields mapping
      • One - One
      • Many – One (E.g. Latitude, Longitude => Coordinate)
      • Mark as required
      • Required fields
      • Explicit values
    • A fully interactive preview of excel file being imported
      • Straight-forwardly remove rows that you do not want to import
    • Save import configuration (import/export)
  • Add, Edit
    • Automatic lookup, search and suggestions when populating fields
      • Reduce near value duplication
  • Light Delete and Restore
  • Permanently Delete
  • Fully audited
    • Viewable audit log
• Calculations
  • Multiple instances of the same calculation can be added
  • Calculations can use the output of previous calculations as their inputs
  • Principal Component Analysis (PCA)
    • Scree Plot
    • Define fields to populate data model
    • Definable number of components reported
    • Correlation or Covariance matrix
    • Results visible in the grid and rendered on to charts and maps
    • One click chart visualization
      • Categorize points based on one or more fields
      • Plot confidence ellipses
  • Linear Discriminate Analysis (LDA)
    • Scree Plot
    • Define fields to group data by for model training
    • Define fields to populate data model
    • Definable number of components reported
    • Correlation or Covariance matrix
    • Results visible in the grid and rendered on to charts and maps
    • Categorize and score based on the trained model
    • One click chart visualization
      • Categorize points (automatically) based on model group by fields
      • Plot confidence ellipses
  • Calculated Columns (R Scripts)
    • Extend in-built statistical functionality using powerful R scripts
    • Define scripts that run whenever the data is updated
      • Input vectors
      • Data Frames
      • Output vectors
  • Quality Control Statistics
    • Report N, Mean, SD, CV, and Z-Scores
    • Visualize distance from mean in standard deviations
    • Customizable control limits
    • Shewhart Tests
      • Order By
    • Group by
• R Scripts
  • Create one-click commands to send data to R for processing
  • Display R visualizations directly from within R scripts
• Test Samples
  • Submit test samples to be processed by predefined statistical models
  • Categorize and score test samples relative to the LDA model
  • Visualize components (PCA, LDA) on charts or maps for quick comparisons to known data
• IonOS
  • Seamless integration with IonOS
    • Send fully calibrated results directly from IonOS to ArDB