[teiid-issues] [JBoss JIRA] (TEIID-4658) Data scramble feature

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4658?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13340957#comment-13340957 ] 

Steven Hawkins commented on TEIID-4658:
---------------------------------------

This is one form of anonymizing/pseudonymised data.  For this to be performant it would have to be based upon a materialization based upon appropriate shuffling or not consistent - that is each query could return different random values.

> Data scramble feature
> ---------------------
>
>                 Key: TEIID-4658
>                 URL: https://issues.jboss.org/browse/TEIID-4658
>             Project: Teiid
>          Issue Type: Feature Request
>            Reporter: Rodrigo Silva
>            Assignee: Steven Hawkins
>
> I have a customer asking for a feature to do data scramble. 
> The need is change the production data to be used in another environments without the user know the original data.
> e.g:
> Give the person table:
> {code:java}
> CREATE TABLE person (
>   id INT PRIMARY KEY,
>   name VARCHAR(256) NOT NULL,
>   age INT,
>   height INT,
>   weight DOUBLE
> );
> {code}
> {code:java}
> SELECT * FROM TABLE PERSON WHERE ID=1;
> {code}
> Result:
> The *name* is from row with *ID#15*, the *age* is from row with *ID#3*, the *height* is from row with *ID#5*.
> On this way the customer can work with consistent and natural data, but unreal.



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