Contents x
      Type mappings
      • 17 Feb 2023
      • 2 Minutes to read
      • Print
      • Dark
        Light
      • PDF
      Contents

      Type mappings

      • Updated on 17 Feb 2023
      • 2 Minutes to read
      • Print
      • Dark
        Light
      • PDF
      Article Summary

      Type mapping allows an existing column in the catalog table with a basic type to be mapped(cast) to a higher-level type provided by Data Explorer. For example, let us consider a catalog table with a float type of column named confidence that stores the prediction confidence produced by an inference model. This column can be mapped to a new column of a higher level type provided by Data Explorer named AKD_ConfidenceScore. The higher level type enables a few additional capabilities, as below.

      1. The query results are validated to have values between 0 and 1.
      2. The type can be used to define higher-level types like 'boundingbox2dpred' that represent a prediction from an object detection model consisting of a bounding box, prediction class and prediction confidence.

      In the 'Create View' wizard, a type mapping is available as the second step, as shown below.

      1. Click on the 'Add Type Mapping' button at the top right, as shown above.
      2. Select the type to be mapped to from the drop-down list shown below.
      3. In the 'Column Name' drop-down list, select the column name that must be mapped to the target type. Only the columns with an eligible type for the chosen target type are presented in the drop-down list.
      4. The 'Mapped Column Name' is auto-filled with a unique name that can be edited to a more friendly name.
      5. Click on the '+' button to add more type-mapped columns.
      6. Click 'Next' to go to the next step in the wizard.

      Click 'Preview' to preview a few entries from the view whose creation is in progress. This screen will have an additional column with the 'Mapped Column Name' as shown below.

      Available type mappings

      Type mapping(s)Description
      Usage
      AKD_ConfidenceScoreMaps a floating point number column to a prediction confidence score type of a column. Runs a validation of values to be between 0-1 when returning query results.Used to construct composite types for a prediction that consists of (class label, confidence score) for object classification and (class label, confidence score, bounding box) for object detection.
      AKD_ClassLabelGTMaps a VARCHAR(string) column to a ground truth class label.Used to construct composite types for a prediction that consists of (class label, confidence score) for object classification and (class label, confidence score, bounding box) for object detection.
      AKD_ClassLabelPredMaps a VARCHAR(string) column to a prediction class label.
      		Used to construct composite types for a prediction that consists of (class label, confidence score) for object classification and (class label, confidence score, bounding box) for object detection.
      AKD_ImageFileJPEG, AKD_ImageFilePNGMaps a VARCHAR(string) column type to a type that allows Data Explorer to infer that the string is a path to an image file name.No current usage. Provision for future enhancements.
      AKD_PointCloudFilePCD, AKD_PointCloudFileFLS,
      AKD_PointCloudFileLAS      		Maps a VARCHAR(string) column type to a type that allows Data Explorer to infer that the string is a path to a point cloud(RADAR/LIDAR) file name.

      No current usage. Provision for future enhancements.
      Was this article helpful?
      What's Next