首页>
外国专利>
Automatic generation of logical database schemas from physical database tables and metadata
Automatic generation of logical database schemas from physical database tables and metadata
展开▼
机译:从物理数据库表和元数据自动生成逻辑数据库模式
展开▼
页面导航
摘要
著录项
相似文献
摘要
Automatic generation of logical database schemas from physical database tables and metadata is disclosed. One exemplary method for automatic generation of logical database schemas from physical database tables and metadata includes identifying physical fact tables in a data repository. The method further includes identifying physical dimension tables in the data repository. The method includes mapping the physical fact tables to logical fact tables. The method further includes mapping the physical dimension tables to logical dimension tables. The method further includes determining relationships between the physical fact and dimension tables. The method further includes logically joining the logical tables based on the identified relationships between the physical tables to form a logical database schema. The method further includes outputting the logical database schema to the user.
展开▼