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

[Rodrigo Silva (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4658?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rodrigo Silva updated TEIID-4658:
---------------------------------
    Description: 
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.

  was:
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:
SELECT * FROM TABLE PERSON WHERE ID=1;

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.



> 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)