Database Test Data Usage – This blog caught my eye because of its title, Do the right thing when testing with production data. It struck me as oxymoronic, since we know production data should not be used for testing at all …
Of course we know how tempting it is to use production data for testing applications, simulating databases, prototyping ETL operations, and just about anything else that needs to work with the real thing.
Star schema is the simplest and most common database modelling structure used in traditional data warehouse paradigms. The schema resembles a constellation of stars — generally several bright stars (facts) surrounded by dimmer ones (dimensions) where one or more fact tables reference different dimension tables.
It is a common mistake to refer to data masking and data encryption interchangeably to mean the same things. While field-level encryption is considered one of many possible “data masking” functions, we define data masking and encryption as technically distinct processes below.
IRI Voracity is an affordable data management platform that streamlines information architectures and helps enterprises leverage the intrinsic value of data without the cost or complexity of multiple tools.
IRI RowGen automatically builds and populates massive database, file, and report targets with structurally and referentially correct test data that’s also fully customizable. Enjoy the same simple 4GL or free Eclipse GUI to: stress-test ETL environments, outsource development, and benchmark new systems.
IRI FieldShield is the fastest, easiest, and most robust data masking solution available for databases and structured (and some semi-structured) files. DBAs, data security, data governance, and compliance teams use FieldShield to find, classify, and protect personally identifiable information (PII) and other sensitive data using static or dynamic data masking functions.