A Schema Mapping project solves the task of mapping attributes into a single unified schema. A unified schema allows disparate data sources to be consolidated into one dataset with consistent attributes.
A unified schema is a list of attributes or fields associated with an entity (customer, organization, patient, etc.) across multiple datasets. In simple terms, it is the set of column headers into which Unify will consolidate data.
A common use case for schema mapping is the biopharmaceuticals realm. Unify's schema mapping can be used, for example, to converge records from hundreds or thousands of clinical trials into a single standard CDSIC SDTM version. Having standardized data not only allows companies to comply with FDA standards but also allows easier implementation of projects such as building integrated, curated data hubs. Clean data is vital to driving scientific insight across many trials.
Overall workflow is as follows:
- Add datasets
- Unify attributes
- Map source attributes to unified schema
- Generate attribute mapping recommendations