摘要 |
PROBLEM TO BE SOLVED: To provide a method of searching in relational database management systems in which a plurality of columns may be searched at the same time.SOLUTION: A method of searching a relational database table includes: providing a relational database table having a plurality of rows and columns such that each of the plurality of columns has a column name descriptive of data in the column; providing a relational database management system (RDBMS) to manage access to the relational database table; providing at least one metadata tag to at least some of the plurality of columns, where the metadata tag is a non-hierarchical keyword or term that is assigned to the at least some of the plurality of columns; in response to selecting at least one metadata tag and in response to selecting a search string, searching by a search and join function of the RDBMS the at least some of the plurality of columns corresponding to the at least one metadata tag in the relational database table to find data matching the search string.SELECTED DRAWING: Figure 3 |