Automated refinement and validation of data warehouse star schemas

摘要

An automated system for validating and refining a template warehouse star schema for a customized data source. The system based on automatically gathered information from the data source such as custom entities and constituent columns, data type and length of custom columns, custom entity keys, relationships of custom entities with other entities, relationships within custom entities, contribution of custom entities to specialized entities, update frequency of custom entities and columns including grouping of updates, frequently used expressions on custom columns and contribution of custom entities and columns to workflow and correlated attributes automatically determines facts, dimensions, dimension hierarchies, measures, workflow specific measures (if data source has workflows) and workflow correlated attribute specific measures (if data source has temporal, priority, ownership and progress tracking workflow correlated attributes) to validate and refine the star schema of the template warehouse to accommodate customizations of the data source.