A New Approach for Representing and Querying Textual Attributes in Databases

In this paper, a new approach to deal with textual attributes in databases is presented. The basic idea is to give a new representation for these attributes, so that it allows us to treat them together with and in the same way than the other database attributes in querying, data warehousing, data mining processes, etc. Additionally, the transformation process of the textual attribute implies the obtaining of a global representation, which includes a great part of the attribute meaning. Moreover, this representation can be improved by using an ontology during the querying process, which enables the semantic queries. The formal representation model is presented in the paper, as well as the mathematical bases for dealing with it. The whole implementation process is also described by using a medical database to show the experimental results. Finally, a set of semantic query examples are offered to explain the advantages of this new approach.