[teiid-issues] [JBoss JIRA] (TEIID-4622) Adding new data quality functions from osDQ

[vivek singh (JIRA)]

vivek singh created TEIID-4622:
----------------------------------

             Summary: Adding new data quality functions from osDQ
                 Key: TEIID-4622
                 URL: https://issues.jboss.org/browse/TEIID-4622
             Project: Teiid
          Issue Type: Feature Request
          Components: Common
    Affects Versions: Open To Community
         Environment: osdq-core and its dependency simmetric 3.0.0 is needed to run these functions

maven central location
http://search.maven.org/#search%7Cga%7C1%7Ca%3A%22osdq-core%22

            Reporter: vivek singh
            Assignee: Steven Hawkins
             Fix For: Open To Community
         Attachments: DateUtil.java, NumberUtil.java, StringUtil.java

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)



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)