Data Masking/Protection
Hashing and encryption are distinct disciplines. Indeed, the differenced between hashing and encryption can be stark:
According to the SSL Store, “encryption is a two-way function where information is scrambled in such a way that it can be unscrambled later. Read More
Test Data
Realistic test data has a number of advantages over real data for anyone creating or changing a database, prototyping ETL operations, or testing applications. First, synthetic data do not expose personally identifiable information (PII) like credit card, social security numbers, birth dates, etc. Read More
Data Transformation
Big data integration activities can happen outside the database in an extract, transform, load (ETL)Â environment, or inside the database in ELT:
http://www.iri.com/blog/data-transformation2/etl-vs-elt-we-posit-you-judge/
One example of an ELT operation would be Informatica’s Pushdown Optimization option, in which users transform data in a relational database like Oracle, or in Teradata. Read More