首页>
外国专利>
Input gathering system and method for defining, refining or validating star schema for a source database
Input gathering system and method for defining, refining or validating star schema for a source database
展开▼
机译:用于为源数据库定义,改进或验证星型模式的输入收集系统和方法
展开▼
页面导航
摘要
著录项
相似文献
摘要
An automated input gathering system for defining, refining or validating a data warehouse star schema for a given data source. The automated data input gathering system includes a source metadata analysis module, an operational reporting environment analysis module, a usage analysis module and a data profiling module. To automatically ascertain inputs for warehouse definition, refinement or validation like i) list of entities and most relevant ones ii) entity column types and lengths iii) entity keys iv) relationships between entities v) relationships within entities vi) entity and column update frequencies vii) grouping of entity and column updates viii) specialized entities ix) workflow and correlated attributes and x) commonly used measures the source metadata analysis module programmatically analyzes source metadata documentation or API's; the operational reporting environment analysis module analyzes underlying models, reports and dashboards; the usage analysis module analyzes queries on the source database; and the data profiling module analyzes data in the source database.
展开▼