Dataset from Zenodo · Claudiu Ion
A Static-Based Approach to Detect SQL Semantic Bugs Dataset
- License
- CC BY 4.0commercial use allowedLicense text
- This license allows commercial use. Usually you must credit the author; read the license for the exact terms.
- Formats
- SQL, PNG
- Size
- 142 MB
- Updated
- Jul 19, 2024
Description
The dataset used for our study: A Static-Based Approach to Detect SQL Semantic Bugs. This dataset contains more than 172,000 queries extracted from StackOverflow posts. It was built for analysing the prevalence of semantic bugs in SQL queries. For more information about our study and tools see our GitHub repository: https://github.com/SERG-Delft/sql-bug-finder Description of included files: sql db.png: database ER diagram homedb queries.sql: contains queries extracted from StackOverflow posts homedb questions.sql: contains SQL related question posts extracted from StackOverflow homedb answers.sql: contains the answers to SQL related question posts extracted from StackOverflow homedb bugs.sql: contains queries with semantic bugs extracted from StackOverflow posts homedb owners.sql: contains data related to the owners (users) of SQL StackOverflow posts homedb pages.sql: artifact from book-keeping script, tracking the StackOverflow pages from which SQL queries were extracted (SQL tagged pages, ordered by votes in descending order)
Description from Zenodo, shortened.
Files (7)
- SQLhomedb_queries.sql75 MB
- SQLhomedb_answers.sql26 MB
- SQLhomedb_questions.sql27 MB
- SQLhomedb_owners.sql13 MB
- SQLhomedb_bugs.sql2.6 MB
- SQLhomedb_pages.sql22 kB
- PNGsql_db.png40 kB
DataHunter does not store or host these files: every link leads to the original source. Check the license there before using the data.