• Home
  • Search
  • Mining Stack Overflow for discovering error patterns in SQL queries
  • Open Access IconOpen Access
  • Cite Icon16
  • https://doi.org/10.1109/icsm.2015.7332505Copy DOI Icon

Mining Stack Overflow for discovering error patterns in SQL queries

  • Sep 1, 2015
  • Csaba Nagy +1 more
Show More
  • Abstract
  • Literature Map
  • References
  • Citations
  • Similar Papers
Abstract

Constructing complex queries in SQL sometimes necessitates the use of language constructs and the invocation of internal functions which inexperienced developers find hard to comprehend or which are unknown to them. In the worst case, bad usage of these constructs might lead to errors, to ineffective queries, or hamper developers in their tasks. This paper presents a mining technique for Stack Overflow to identify error-prone patterns in SQL queries. Identifying such patterns can help developers to avoid the use of error-prone constructs, or if they have to use such constructs, the Stack Overflow posts can help them to properly utilize the language. Hence, our purpose is to provide the initial steps towards a recommendation system that supports developers in constructing SQL queries. Our current implementation supports the MySQL dialect, and Stack Overflow has over 300,000 questions tagged with the MySQL flag in its database. It provides a huge knowledge base where developers can ask questions about real problems. Our initial results indicate that our technique is indeed able to identify patterns among them.

Similar Papers
  • Research Article
  • Citations29

Post2Vec: Learning Distributed Representations of Stack Overflow Posts

  • Sep 01, 2022
  • IEEE Transactions on Software Engineering
  • Bowen Xu +5
  • PDF
  • Research Article
  • Citations3

Knowledge reuse in software projects: Retrieving software development Q&A posts based on project task similarity.

  • Dec 17, 2020
  • PloS one
  • Glaucia Melo +3
  • PDF
  • Research Article
  • Citations1

SCC-GPT: Source Code Classification Based on Generative Pre-Trained Transformers

  • Jul 07, 2024
  • Mathematics
  • Mohammad D Alahmadi +2
  • Conference Article
  • Citations27

Python Coding Style Compliance on Stack Overflow

  • May 01, 2019
  • Nikolaos Bafatakis +6
  • Conference Article
  • Citations10

Towards Understanding Developers’ Machine-Learning Challenges: A Multi-Language Study on Stack Overflow

  • Sep 01, 2021
  • Alaleh Hamidi +4
  • Conference Article
  • Citations14

Engineering Paper] SCC: Automatic Classification of Code Snippets

  • Sep 01, 2018
  • Kamel Alreshedy +4
  • Conference Article
  • Citations42

Classifying stack overflow posts on API issues

  • Mar 01, 2018
  • Md Ahasanuzzaman +3
  • Conference Article
  • Citations15

Analyzing Comment-Induced Updates on Stack Overflow

  • May 01, 2019
  • Abhishek Soni +1
  • PDF
  • Research Article
  • Citations1

ERF: An Empirical Recommender Framework for Ascertaining Appropriate Learning Materials from Stack Overflow Discussions

  • Jul 20, 2020
  • Computers
  • Ashesh Iqbal +3
  • Conference Article
  • Citations58

A Manual Categorization of Android App Development Issues on Stack Overflow

  • Sep 01, 2014
  • Stefanie Beyer +1
  • Conference Article
  • Citations1

Keen2Act: Activity Recommendation in Online Social Collaborative Platforms

  • Jul 07, 2020
  • Roy Ka-Wei Lee +3
  • Book Chapter
  • Citations50

BERT-Based Sentiment Analysis: A Software Engineering Perspective

  • Jan 01, 2021
  • Himanshu Batra +3
  • Dissertation

Enhancing domain knowledge sharing via mining software engineering related web resources

  • Jan 01, 2022
  • Sa Gao
  • Research Article
  • Citations17

I-Rex

  • Aug 01, 2020
  • Proceedings of the VLDB Endowment
  • Zhengjie Miao +5
  • Conference Article
  • Citations5

Synthesizing Program Execution Time Discrepancies in Julia Used for Scientific Software

  • Sep 01, 2019
  • Effat Farhana +2
Cactus Communications logo

Copyright 2026 Cactus Communications. All rights reserved.