Shared database dictionaries
AssigneeSap SE
InventorsToni Fabijancic, Sebastian Mietke
Life of this patent
Estimating the term…
Abstract
A system includes determination of a match between a first table column of a plurality of table columns of database tables and a second table column of the plurality of table columns, determination, based on stored metadata, of a first data dictionary associated with the first table column and a second data dictionary associated with the second table column, merging of the first data dictionary and the second data dictionary to generate a merged data dictionary, and modification of the stored metadata to associate the first data dictionary with the merged data dictionary and to associate the second data dictionary with the merged data dictionary.
Claims18
A system comprising:
- a data storage device storing:
- one or more database tables, the one or more database tables comprising a plurality of table columns;
- and
- a database management system to:
- determine a match between a first one of the plurality of table columns and a second one of the plurality of table columns, wherein determination of the match comprises determination that an overlap of values of the first one of the plurality of table columns and values of the second one of the plurality of table columns is greater than a threshold;
- determine, based on stored metadata, a first data dictionary associated with the first one of the plurality of table columns and a second data dictionary associated with the second one of the plurality of table columns;
- merge the first data dictionary and the second data dictionary to generate a merged data dictionary;
- and
- modify the stored metadata to associate the first data dictionary with the merged data dictionary and to associate the second data dictionary with the merged data dictionary.
A computer-implemented method comprising:
- determining a match between a first table column of a plurality of table columns of database tables and a second table column of the plurality of table columns, wherein determining the match comprises determining that an overlap of the values of the first one of the plurality of table columns and the values of the second one of the plurality of table columns is greater than a threshold;
- determining, based on stored metadata, a first data dictionary associated with the first table column and a second data dictionary associated with the second table column;
- merging the first data dictionary and the second data dictionary to generate a merged data dictionary;
- and
- modifying the stored metadata to associate the first data dictionary with the merged data dictionary and to associate the second data dictionary with the merged data dictionary.
A non-transitory computer-readable medium storing processor-executable process steps, the process steps executable by a processor to:
- determine a match between a first table column of a plurality of table columns of database tables and a second table column of the plurality of table columns, wherein determination of the match comprises determination that an overlap of values of the first one of the plurality of table columns and values of the second one of the plurality of table columns is greater than a threshold;
- determine, based on stored metadata, a first data dictionary associated with the first table column and a second data dictionary associated with the second table column;
- merge the first data dictionary and the second data dictionary to generate a merged data dictionary;
- and
- modify the stored metadata to associate the first data dictionary with the merged data dictionary and to associate the second data dictionary with the merged data dictionary.
Dependencies are inferred from the claim text.