Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4622

Adding new data quality functions from osDQ

XMLWordPrintable

    • Icon: Feature Request Feature Request
    • Resolution: Done
    • Icon: Major Major
    • 9.2
    • Open To Community
    • Common
    • None

      Following functions have been added into osdq-core for integration with teiid.

      String functions :

      // Encrypting a string using key and AES encryption
      String encrypt ( String val, String key)
      String decrypt ( String val, String key)

      // Fuzzy distance - similarity between two strings
      float levestheindistance ( String a, String b)
      float jarowinklerdistance( String a , String b)
      float cosinedistance (String a, String b)

      // Format check for PII ( personal information)
      boolean isCreditCardFormat(String a)
      boolean isSSNFormat(String a)
      boolean isPhoneFormat(String a)
      boolean isEmailFormat(String a)
      boolean hasWhiteSpace(String a )

      Date Functions

      // converting date into universal recognized format
      long dateToEpoch(java.util.Date date)
      Date epochToDate(long epoch)
      Date epochToDate(long epoch, String TimeZone)
      long diffInSec(date a, date b)
      String convertToFormat ( Date a, String Format)

      Numerical Functions

      // Statistical functions
      double stdDev(Number[] numSeries)
      double range(Number[] numSeries)
      double median(Number[] numSeries)

        1. DateUtil.java
          2 kB
        2. NumberUtil.java
          1 kB
        3. StringUtil.java
          4 kB

            kylinsoong.1214@gmail.com Kylin Soong (Inactive)
            osdq_jira vivek singh (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: