In EDS ansehen

Natural Language SQL Query Processing using Fuzzy Matching and Elimination Technique

Gespeichert in:
Bibliographische Detailangaben
Titel: Natural Language SQL Query Processing using Fuzzy Matching and Elimination Technique
Quelle: International Journal of Innovative Technology and Exploring Engineering. 9:222-228
Verlagsinformationen: Blue Eyes Intelligence Engineering and Sciences Engineering and Sciences Publication - BEIESP, 2019.
Publikationsjahr: 2019
Beschreibung: In Structured Query Language (SQL), complex queries are difficult to write or understand by a user, because every user is not familiar with SQL. A common user can able to retrieve the information from the query databases using natural language is considered as an important research area. To improve the communication between databases application and naive user, an enhanced application with intelligent interface are needed. A fuzzy system with matching and elimination technique is designed in this research study, where SQL queries are formed from the input given by the user through several steps like noise removal, lexicon normalization and query formation. Then, the system uses the Latent Dirichlet Allocation (LDA) to extract the keywords from the input query. Finally, matching and elimination techniques are used to find the data, which is related to the input query given by end-user. When compared with the existing SQL techniques, the proposed fuzzy method achieved 91% and 90.5% accuracy, 95% and 93% precision, and 0.10 and 0.12 error rate for both 28 and 50 queries.
Publikationsart: Article
Sprache: English
ISSN: 2278-3075
DOI: 10.35940/ijitee.b1132.1292s19
Dokumentencode: edsair.doi...........099bf0d69ed6004d2b85d25cb2bae367
Datenbank: OpenAIRE
FullText Text:
  Availability: 0
CustomLinks:
  – Url: https://www.webofscience.com/api/gateway?GWVersion=2&SrcApp=EBSCO&SrcAuth=EBSCO&DestApp=WOS&ServiceName=TransferToWoS&DestLinkType=GeneralSearchSummary&Func=Links&author=
    Name: ISI
    Category: fullText
    Text: Nájsť tento článok vo Web of Science
    Icon: https://imagesrvr.epnet.com/ls/20docs.gif
    MouseOverText: Nájsť tento článok vo Web of Science
Header DbId: edsair
DbLabel: OpenAIRE
An: edsair.doi...........099bf0d69ed6004d2b85d25cb2bae367
RelevancyScore: 872
AccessLevel: 3
PubType: Academic Journal
PubTypeId: academicJournal
PreciseRelevancyScore: 872.384887695313
IllustrationInfo
Items – Name: Title
  Label: Title
  Group: Ti
  Data: Natural Language SQL Query Processing using Fuzzy Matching and Elimination Technique
– Name: TitleSource
  Label: Source
  Group: Src
  Data: <i>International Journal of Innovative Technology and Exploring Engineering</i>. 9:222-228
– Name: Publisher
  Label: Publisher Information
  Group: PubInfo
  Data: Blue Eyes Intelligence Engineering and Sciences Engineering and Sciences Publication - BEIESP, 2019.
– Name: DatePubCY
  Label: Publication Year
  Group: Date
  Data: 2019
– Name: Abstract
  Label: Description
  Group: Ab
  Data: In Structured Query Language (SQL), complex queries are difficult to write or understand by a user, because every user is not familiar with SQL. A common user can able to retrieve the information from the query databases using natural language is considered as an important research area. To improve the communication between databases application and naive user, an enhanced application with intelligent interface are needed. A fuzzy system with matching and elimination technique is designed in this research study, where SQL queries are formed from the input given by the user through several steps like noise removal, lexicon normalization and query formation. Then, the system uses the Latent Dirichlet Allocation (LDA) to extract the keywords from the input query. Finally, matching and elimination techniques are used to find the data, which is related to the input query given by end-user. When compared with the existing SQL techniques, the proposed fuzzy method achieved 91% and 90.5% accuracy, 95% and 93% precision, and 0.10 and 0.12 error rate for both 28 and 50 queries.
– Name: TypeDocument
  Label: Document Type
  Group: TypDoc
  Data: Article
– Name: Language
  Label: Language
  Group: Lang
  Data: English
– Name: ISSN
  Label: ISSN
  Group: ISSN
  Data: 2278-3075
– Name: DOI
  Label: DOI
  Group: ID
  Data: 10.35940/ijitee.b1132.1292s19
– Name: AN
  Label: Accession Number
  Group: ID
  Data: edsair.doi...........099bf0d69ed6004d2b85d25cb2bae367
PLink https://erproxy.cvtisr.sk/sfx/access?url=https://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsair&AN=edsair.doi...........099bf0d69ed6004d2b85d25cb2bae367
RecordInfo BibRecord:
  BibEntity:
    Identifiers:
      – Type: doi
        Value: 10.35940/ijitee.b1132.1292s19
    Languages:
      – Text: English
    PhysicalDescription:
      Pagination:
        PageCount: 7
        StartPage: 222
    Titles:
      – TitleFull: Natural Language SQL Query Processing using Fuzzy Matching and Elimination Technique
        Type: main
  BibRelationships:
    IsPartOfRelationships:
      – BibEntity:
          Dates:
            – D: 31
              M: 12
              Type: published
              Y: 2019
          Identifiers:
            – Type: issn-print
              Value: 22783075
            – Type: issn-locals
              Value: edsair
            – Type: issn-locals
              Value: edsairFT
          Numbering:
            – Type: volume
              Value: 9
          Titles:
            – TitleFull: International Journal of Innovative Technology and Exploring Engineering
              Type: main
ResultId 1