Extending the UML concepts to transform natural language queries with fuzzy semantics into SQL |
| |
| Affiliation: | 1. Department of Information Management, National Kaohsiung First University of Science and Technology, 1 University Road, YenChao, Kaohsiung 824, Taiwan, ROC;2. Department of Computer Science and Information Engineering, National Chiao Tung University, HsinChu 300, Taiwan, ROC;1. School of Information Engineering and Automation, Kunming University of Science and Technology, Kunming 650500, PR China;2. School of Mechanical and Electrical Engineering, Kunming University of Science and Technology, Kunming 650500, PR China;3. Yunnan Key Laboratory of Artificial Intelligence, Kunming University of Science and Technology, Kunming 650500, PR China;4. Department of Automation, Tsinghua University, Beijing 100084, PR China;5. Alliance Manchester Business School, The University of Manchester, Manchester M15 6PB, United Kingdom;1. Department of Electrical Engineering and Automation, Shaoxing University, Shaoxing 312000, PR China;2. Key Laboratory of Smart Manufacturing in Energy Chemical Process, Ministry of Education, East China University of Science and Technology, Shanghai 200237, PR China;1. Enterprise Information & Analytics, University of Arizona, USA;2. Department of Management Information Systems, University of Arizona, USA;3. Division of Management Information Systems, University of Oklahoma, USA |
| |
| Abstract: | Database applications tend toward getting more versatile and broader to comply with the expansion of various organizations. However, naïve users usually suffer from accessing data arbitrarily by using formal query languages. Therefore, we believe that accessing databases using natural language constructs will become a popular interface in the future. The concept of object-oriented modeling makes the real world to be well represented or expressed in some kinds of logical form. Since the class diagram in UML is used to model the static relationships of databases, in this paper, we intend to study how to extend the UML class diagram representations to capture natural language queries with fuzzy semantics. By referring to the conceptual schema throughout the class diagram representation, we propose a methodology to map natural language constructs into the corresponding class diagram and employ Structured Object Model (SOM) methodology to transform the natural language queries into SQL statements for query executions. Moreover, our approach can handle queries containing vague terms specified in fuzzy modifiers, like ‘good’ or ‘bad’. By our approach, users obtain not only the query answers but also the corresponding degree of vagueness, which can be regarded as the same way we are thinking. |
| |
| Keywords: | |
| 本文献已被 ScienceDirect 等数据库收录！ |
|
