International Business Machines Corporation
Heuristic dimension reduction in metadata modeling

Abstract:

Methods, computer program products, and systems are presented. The methods include, for instance: metadata on respective datasets from a plurality of data sources. An enhanced metadata is prepared with semantic information, available data statistics, and search index associated with items of the metadata. The metadata is also classified based on ontology rules. An intent phrase to search the datasets from the plurality of data sources is obtained from a user. The enhanced metadata is searched with a semantic search query formed from the intent phrase, and search result is classified into semantic element classes generated from the intent phrase. A metadata model that satisfies the intent phrase is produced by identifying join columns and respective join relationships from the search result.