]
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.