Managing acronyms and abbreviations used in the naming of physical database objects

摘要

A method and system are provided. The method includes extracting, ranking, and annotating content in (i) forms used on websites, (ii) a source code, and (iii) existing data design projects that include mappings between logical data model objects and physical data model objects. The content is selected from the group consisting of terms and abbreviations for the terms. An extracted term is annotated using an abbreviation for the extracted term, and an extracted abbreviation is annotated using a term for the extracted abbreviation. The method further includes storing, in a knowledge base, the content, respective annotations for the content, and respective ranks for the content. The method also includes, given an input data structure that lacks identifiers of a given type for data objects therein, automatically generating suggested identifiers of the given type for the data objects based on the content, respective annotations, and respective ranks.