Matches in SemOpenAlex for { <https://semopenalex.org/work/W2108932068> ?p ?o ?g. }
- W2108932068 abstract "SQL is a classical and powerful tool for querying relational databases. However, it is rather hard for inexperienced users to pose SQL queries, as they are required to be proficient in SQL syntax and have a thorough understanding of the underlying schema. To give users gratification, we propose SQLSUGG, an effective and user-friendly keyword-based method to help various users formulate SQL queries. SQLSUGG suggests SQL queries as users type in keywords, and can save users' typing efforts and help users avoid tedious SQL debugging. To achieve high suggestion effectiveness, we propose queryable templates to model the structures of SQL queries. We propose a template ranking model to suggest templates relevant to query keywords. We generate SQL queries from each suggested template based on the degree of matchings between keywords and attributes. For efficiency, we propose a progressive algorithm to compute top-k templates, and devise an efficient method to generate SQL queries from templates. We have implemented our methods on two real data sets, and the experimental results show that our method achieves high effectiveness and efficiency." @default.
- W2108932068 created "2016-06-24" @default.
- W2108932068 creator A5022852316 @default.
- W2108932068 creator A5068538399 @default.
- W2108932068 creator A5083848380 @default.
- W2108932068 date "2011-04-01" @default.
- W2108932068 modified "2023-09-23" @default.
- W2108932068 title "Interactive SQL query suggestion: Making databases user-friendly" @default.
- W2108932068 cites W1981585544 @default.
- W2108932068 cites W1988937516 @default.
- W2108932068 cites W2022987501 @default.
- W2108932068 cites W2044009024 @default.
- W2108932068 cites W2059453880 @default.
- W2108932068 cites W2066636486 @default.
- W2108932068 cites W2067047206 @default.
- W2108932068 cites W2075657963 @default.
- W2108932068 cites W2077556543 @default.
- W2108932068 cites W2082611830 @default.
- W2108932068 cites W2096076988 @default.
- W2108932068 cites W2098388305 @default.
- W2108932068 cites W2117461391 @default.
- W2108932068 cites W2117658379 @default.
- W2108932068 cites W2121350579 @default.
- W2108932068 cites W2125510575 @default.
- W2108932068 cites W2134206624 @default.
- W2108932068 cites W2148942721 @default.
- W2108932068 cites W2154161546 @default.
- W2108932068 cites W2157054705 @default.
- W2108932068 cites W2168859760 @default.
- W2108932068 cites W2169624745 @default.
- W2108932068 doi "https://doi.org/10.1109/icde.2011.5767843" @default.
- W2108932068 hasPublicationYear "2011" @default.
- W2108932068 type Work @default.
- W2108932068 sameAs 2108932068 @default.
- W2108932068 citedByCount "47" @default.
- W2108932068 countsByYear W21089320682012 @default.
- W2108932068 countsByYear W21089320682013 @default.
- W2108932068 countsByYear W21089320682014 @default.
- W2108932068 countsByYear W21089320682015 @default.
- W2108932068 countsByYear W21089320682016 @default.
- W2108932068 countsByYear W21089320682017 @default.
- W2108932068 countsByYear W21089320682018 @default.
- W2108932068 countsByYear W21089320682019 @default.
- W2108932068 countsByYear W21089320682020 @default.
- W2108932068 countsByYear W21089320682021 @default.
- W2108932068 countsByYear W21089320682022 @default.
- W2108932068 crossrefType "proceedings-article" @default.
- W2108932068 hasAuthorship W2108932068A5022852316 @default.
- W2108932068 hasAuthorship W2108932068A5068538399 @default.
- W2108932068 hasAuthorship W2108932068A5083848380 @default.
- W2108932068 hasBestOaLocation W21089320682 @default.
- W2108932068 hasConcept C141589383 @default.
- W2108932068 hasConcept C150451098 @default.
- W2108932068 hasConcept C154420247 @default.
- W2108932068 hasConcept C164120249 @default.
- W2108932068 hasConcept C179531526 @default.
- W2108932068 hasConcept C194222762 @default.
- W2108932068 hasConcept C199360897 @default.
- W2108932068 hasConcept C206384180 @default.
- W2108932068 hasConcept C23123220 @default.
- W2108932068 hasConcept C32145003 @default.
- W2108932068 hasConcept C41008148 @default.
- W2108932068 hasConcept C510870499 @default.
- W2108932068 hasConcept C55596503 @default.
- W2108932068 hasConcept C77088390 @default.
- W2108932068 hasConcept C82714645 @default.
- W2108932068 hasConcept C97854310 @default.
- W2108932068 hasConceptScore W2108932068C141589383 @default.
- W2108932068 hasConceptScore W2108932068C150451098 @default.
- W2108932068 hasConceptScore W2108932068C154420247 @default.
- W2108932068 hasConceptScore W2108932068C164120249 @default.
- W2108932068 hasConceptScore W2108932068C179531526 @default.
- W2108932068 hasConceptScore W2108932068C194222762 @default.
- W2108932068 hasConceptScore W2108932068C199360897 @default.
- W2108932068 hasConceptScore W2108932068C206384180 @default.
- W2108932068 hasConceptScore W2108932068C23123220 @default.
- W2108932068 hasConceptScore W2108932068C32145003 @default.
- W2108932068 hasConceptScore W2108932068C41008148 @default.
- W2108932068 hasConceptScore W2108932068C510870499 @default.
- W2108932068 hasConceptScore W2108932068C55596503 @default.
- W2108932068 hasConceptScore W2108932068C77088390 @default.
- W2108932068 hasConceptScore W2108932068C82714645 @default.
- W2108932068 hasConceptScore W2108932068C97854310 @default.
- W2108932068 hasLocation W21089320681 @default.
- W2108932068 hasLocation W21089320682 @default.
- W2108932068 hasOpenAccess W2108932068 @default.
- W2108932068 hasPrimaryLocation W21089320681 @default.
- W2108932068 hasRelatedWork W1565225458 @default.
- W2108932068 hasRelatedWork W2002315713 @default.
- W2108932068 hasRelatedWork W2003251288 @default.
- W2108932068 hasRelatedWork W2007324466 @default.
- W2108932068 hasRelatedWork W2057513751 @default.
- W2108932068 hasRelatedWork W2077556543 @default.
- W2108932068 hasRelatedWork W2080795333 @default.
- W2108932068 hasRelatedWork W2083619093 @default.
- W2108932068 hasRelatedWork W2096076988 @default.
- W2108932068 hasRelatedWork W2098388305 @default.
- W2108932068 hasRelatedWork W2100852567 @default.
- W2108932068 hasRelatedWork W2121350579 @default.
- W2108932068 hasRelatedWork W2127018826 @default.