{"title":"使用模式匹配技术将受控的自然语言查询转换为SQL查询","authors":"Rajender Kumar, M. Dua","doi":"10.1109/I2CT.2014.7092161","DOIUrl":null,"url":null,"abstract":"Database is a prime source of information. This information is accessed by a common man who is not able to write complex SQL query. Enabling common users to query databases using natural language and retrieve information from them has been a promising research area. A system is proposed to retrieve data from the database using Hindi language. Our system uses morphological analyzer and word group analyzer to extract the keyword from input Hindi query. Then it uses pattern matching technique to find the type of keyword. Also, it uses the controlled Hindi language interface and suggested query feature to reduce ambiguity and time for entering the Hindi query.","PeriodicalId":384966,"journal":{"name":"International Conference for Convergence for Technology-2014","volume":"124 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2014-04-06","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"10","resultStr":"{\"title\":\"Translating controlled natural language query into SQL query using pattern matching technique\",\"authors\":\"Rajender Kumar, M. Dua\",\"doi\":\"10.1109/I2CT.2014.7092161\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"Database is a prime source of information. This information is accessed by a common man who is not able to write complex SQL query. Enabling common users to query databases using natural language and retrieve information from them has been a promising research area. A system is proposed to retrieve data from the database using Hindi language. Our system uses morphological analyzer and word group analyzer to extract the keyword from input Hindi query. Then it uses pattern matching technique to find the type of keyword. Also, it uses the controlled Hindi language interface and suggested query feature to reduce ambiguity and time for entering the Hindi query.\",\"PeriodicalId\":384966,\"journal\":{\"name\":\"International Conference for Convergence for Technology-2014\",\"volume\":\"124 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2014-04-06\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"10\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"International Conference for Convergence for Technology-2014\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/I2CT.2014.7092161\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"International Conference for Convergence for Technology-2014","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/I2CT.2014.7092161","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
Translating controlled natural language query into SQL query using pattern matching technique
Database is a prime source of information. This information is accessed by a common man who is not able to write complex SQL query. Enabling common users to query databases using natural language and retrieve information from them has been a promising research area. A system is proposed to retrieve data from the database using Hindi language. Our system uses morphological analyzer and word group analyzer to extract the keyword from input Hindi query. Then it uses pattern matching technique to find the type of keyword. Also, it uses the controlled Hindi language interface and suggested query feature to reduce ambiguity and time for entering the Hindi query.