Loading patent…
AssigneeOracle International Corporation
InventorMichael Sassin
Estimating the term…
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.
A method for automatic generation of logical database schemas from physical database tables and metadata, the method comprising:
A system for automatic generation of logical database schemas from physical database tables and metadata, the system comprising:
A non-transitory computer readable medium having stored thereon executable instructions that when executed by the processor of a computer control the computer to perform steps comprising:
Dependencies are inferred from the claim text.