{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,4,28]],"date-time":"2026-04-28T12:59:51Z","timestamp":1777381191153,"version":"3.51.4"},"reference-count":37,"publisher":"Elsevier BV","license":[{"start":{"date-parts":[[2026,7,1]],"date-time":"2026-07-01T00:00:00Z","timestamp":1782864000000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.elsevier.com\/tdm\/userlicense\/1.0\/"},{"start":{"date-parts":[[2026,7,1]],"date-time":"2026-07-01T00:00:00Z","timestamp":1782864000000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.elsevier.com\/legal\/tdmrep-license"},{"start":{"date-parts":[[2026,3,27]],"date-time":"2026-03-27T00:00:00Z","timestamp":1774569600000},"content-version":"vor","delay-in-days":0,"URL":"http:\/\/creativecommons.org\/licenses\/by\/4.0\/"}],"content-domain":{"domain":["elsevier.com","sciencedirect.com"],"crossmark-restriction":true},"short-container-title":["Array"],"published-print":{"date-parts":[[2026,7]]},"DOI":"10.1016\/j.array.2026.100793","type":"journal-article","created":{"date-parts":[[2026,4,1]],"date-time":"2026-04-01T15:42:36Z","timestamp":1775058156000},"page":"100793","update-policy":"https:\/\/doi.org\/10.1016\/elsevier_cm_policy","source":"Crossref","is-referenced-by-count":0,"special_numbering":"C","title":["Scalable conversion of Stack Exchange network-based question answering sites\u2019 data dump to SQL Server database \u2013 A case of Stack Overflow data dump"],"prefix":"10.1016","volume":"30","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-2909-0017","authenticated-orcid":false,"given":"Arjumand","family":"Fatima","sequence":"first","affiliation":[]},{"given":"Onaiza","family":"Maqbool","sequence":"additional","affiliation":[]}],"member":"78","reference":[{"key":"10.1016\/j.array.2026.100793_bib1","unstructured":"Stack Overflow \u2013 Where Developers Learn, Share & Build Careers, (https:\/\/stackoverflow.com\/), Accessed: 2025-December-1."},{"key":"10.1016\/j.array.2026.100793_bib2","unstructured":"All sites \u2013 stack exchange, (https:\/\/stackexchange.com\/sites#percentanswered), Accessed: 2025-December-1."},{"key":"10.1016\/j.array.2026.100793_bib3","unstructured":"How do I access a data dump for a stack exchange site (https:\/\/stackoverflow.com\/help\/data-dumps), Accessed: 2025-December-1."},{"key":"10.1016\/j.array.2026.100793_bib4","unstructured":"Stack exchange data explorer (https:\/\/data.stackexchange.com\/), Accessed: 2025-December-1."},{"key":"10.1016\/j.array.2026.100793_bib5","unstructured":"Stack exchange API (https:\/\/api.stackexchange.com\/), Accessed: 2025-December-1."},{"key":"10.1016\/j.array.2026.100793_bib6","unstructured":"Academic papers using stack exchange data (https:\/\/meta.stackexchange.com\/questions\/134495\/academic-papers-using-stack-exchange-data), Accessed: 2025-December-2."},{"issue":"2","key":"10.1016\/j.array.2026.100793_bib7","first-page":"190","article-title":"A survey on mining Stack Overflow: question and answering (Q&A) community","volume":"52","author":"Ahmad","year":"2018","journal-title":"Data Technol Appl"},{"key":"10.1016\/j.array.2026.100793_bib8","unstructured":"What is the fastest way to load up the data dump into SQL server? (https:\/\/meta.stackexchange.com\/questions\/3481\/what-is-the-fastest-way-to-load-up-the-data-dump-into-sql-server), Accessed: 2025-December-2."},{"key":"10.1016\/j.array.2026.100793_bib9","unstructured":"How do I dump the Stack Overflow database? (https:\/\/meta.stackexchange.com\/questions\/26557\/how-do-i-dump-the-stack-overflow-database), Accessed: 2025-December-3."},{"key":"10.1016\/j.array.2026.100793_bib10","unstructured":"Fast multi platform data dump import for SQL server (2000\/2005\/2008), SQLite and MySQL, (https:\/\/stackapps.com\/questions\/2511\/fast-multi-platform-data-dump-import-for-sql-server-2000-2005-2008-sqlite-and) , Accessed: 2025-December-3."},{"key":"10.1016\/j.array.2026.100793_bib11","unstructured":"Scripts to convert data-dump to other formats, (https:\/\/meta.stackexchange.com\/questions\/28221\/scripts-to-convert-data-dump-to-other-formats), Accessed: 2026-02-17-03."},{"key":"10.1016\/j.array.2026.100793_bib12","unstructured":"Is there a SQLite data dump for the latest release? (https:\/\/meta.stackexchange.com\/questions\/28136\/is-there-a-sqlite-data-dump-for-the-latest-release), Accessed: 2025-December-3."},{"key":"10.1016\/j.array.2026.100793_bib13","unstructured":"Importing creative commons data dump into MySQL, (https:\/\/meta.stackexchange.com\/questions\/3223\/importing-creative-commons-data-dump-into-mysql?noredirect=1&lq=1), Accessed: 2025-December-3."},{"key":"10.1016\/j.array.2026.100793_bib14","unstructured":"Desktop operating system market share worldwide | StatCounter GlobalStats (https:\/\/gs.statcounter.com\/os-market-share\/desktop\/worldwide\/), Accessed: 2026-January-30."},{"key":"10.1016\/j.array.2026.100793_bib15","unstructured":"Database schema documentation for the public data dump and SEDE (https:\/\/meta.stackexchange.com\/questions\/2677\/database-schema-documentation-for-the-public-data-dump-and-sede), Accessed: 2026-January-30."},{"key":"10.1016\/j.array.2026.100793_bib16","unstructured":"How to download the Stack Overflow database?, (https:\/\/www.brentozar.com\/archive\/2015\/10\/how-to-download-the-stack-overflow-database-via-bittorrent\/), Accessed: 2025-December-3."},{"key":"10.1016\/j.array.2026.100793_bib17","unstructured":"Stack exchange directory listing, (https:\/\/archive.org\/download\/stackexchange), Accessed: 2025-December-5."},{"key":"10.1016\/j.array.2026.100793_bib18","doi-asserted-by":"crossref","DOI":"10.1016\/j.dib.2025.111972","article-title":"LegitPhish: a large-scale annotated dataset for URL-based phishing detection","volume":"63","author":"Potpelwar","year":"2025","journal-title":"Data Brief"},{"key":"10.1016\/j.array.2026.100793_bib19","series-title":"Proceedings of the 19th international conference on mining software repositories","article-title":"SOSum: a dataset of Stack overflow post summaries","author":"Kou","year":"2022"},{"key":"10.1016\/j.array.2026.100793_bib20","series-title":"Proceedings of the 2018 world wide web conference","article-title":"Staqc: a systematically mined question-code dataset from stack overflow","author":"Yao","year":"2018"},{"key":"10.1016\/j.array.2026.100793_bib21","series-title":"2015 IEEE\/ACM 12th working conference on mining software repositories","article-title":"Stormed: stack overflow ready made data","author":"Ponzanelli","year":"2015"},{"key":"10.1016\/j.array.2026.100793_bib22","doi-asserted-by":"crossref","DOI":"10.1016\/j.dib.2022.107942","article-title":"Dataset of network simulator related-question posts in stack overflow","volume":"41","author":"Nugroho","year":"2022","journal-title":"Data Brief"},{"key":"10.1016\/j.array.2026.100793_bib23","series-title":"2019 IEEE\/ACM 16th international conference on mining software repositories (MSR)","article-title":"Sotorrent: studying the origin, evolution, and usage of stack overflow code snippets","author":"Baltes","year":"2019"},{"key":"10.1016\/j.array.2026.100793_bib24","unstructured":"The SOTorrent dataset \u2013 empirical software engineering (https:\/\/empirical-software.engineering\/sotorrent\/), Accessed: 2026-01-30."},{"key":"10.1016\/j.array.2026.100793_bib33","series-title":"Proceedings of the 15th international conference on mining software repositories","article-title":"Sotorrent: reconstructing and analyzing the evolution of stack overflow posts","author":"Baltes","year":"2018"},{"key":"10.1016\/j.array.2026.100793_bib27","unstructured":"Which tools and technologies are used to build the stack exchange network? (https:\/\/meta.stackexchange.com\/questions\/10369\/which-tools-and-technologies-are-used-to-build-the-stack-exchange-network), Accessed: 2026-January-30."},{"key":"10.1016\/j.array.2026.100793_bib34","doi-asserted-by":"crossref","first-page":"150","DOI":"10.1016\/j.procs.2025.08.268","article-title":"Performance comparison of relational database management systems for processing large amount of text data","volume":"269","author":"Andrea","year":"2025","journal-title":"Procedia Comput Sci"},{"key":"10.1016\/j.array.2026.100793_bib35","unstructured":"Scholar, P. G. \"Comparative performance analysis of MySQL and SQL server relational database management systems in windows environment.\"."},{"key":"10.1016\/j.array.2026.100793_bib36","unstructured":"MySQL: MySQL 8.4 reference manual 15.2.10 LOAD XML statement, (https:\/\/dev.mysql.com\/doc\/refman\/8.4\/en\/load-xml.html), Accessed 20256-03-10."},{"key":"10.1016\/j.array.2026.100793_bib25","unstructured":"Git \u2013 install for windows, (https:\/\/git-scm.com\/install\/windows), Accessed: 2025-December-5."},{"key":"10.1016\/j.array.2026.100793_bib37","unstructured":"How to split large text file in Windows? (https:\/\/s tackoverfl ow.com\/qu estions\/31786 287\/how-to-split-large-text-file-in-windows), Accessed: 2025-December-5."},{"key":"10.1016\/j.array.2026.100793_bib26","unstructured":"Create a database \u2013 SQL server | microsoft learn, (https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/databases\/create-a-database?view=sql-server-ver17), Accessed: 2025-December-5."},{"key":"10.1016\/j.array.2026.100793_bib28","unstructured":"What is SQL server on Linux? (https:\/\/learn.microsoft.com\/en-us\/sql\/linux\/sql-server-linux-overview?view=sql-server-ver17), Accessed: 2026-February-17."},{"key":"10.1016\/j.array.2026.100793_bib29","unstructured":"Input\/output \u2013 Pandas-3.0.0 documentation (https:\/\/pandas.pydata.org\/docs\/reference\/io.html), Accessed: 2026-February-17."},{"key":"10.1016\/j.array.2026.100793_bib30","unstructured":"Quick start: backup and restore a database by using SSMS \u2013 SQL server (https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/backup-restore\/quickstart-backup-restore-database?view=sql-server-ver17&tabs=ssms), Accessed: 2026-February-17."},{"key":"10.1016\/j.array.2026.100793_bib31","unstructured":"How to back up a table in SQL server? (https:\/\/sqlbak.com\/blog\/how-to-backup-a-table-in-sql-server\/), Accessed: 2026-February-17."},{"key":"10.1016\/j.array.2026.100793_bib32","unstructured":"Download Anaconda Distribution | Anaconda (https:\/\/www.anaconda.com\/download), Accessed: 2026-February-15."}],"container-title":["Array"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:S2590005626001165?httpAccept=text\/xml","content-type":"text\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:S2590005626001165?httpAccept=text\/plain","content-type":"text\/plain","content-version":"vor","intended-application":"text-mining"}],"deposited":{"date-parts":[[2026,4,28]],"date-time":"2026-04-28T09:20:10Z","timestamp":1777368010000},"score":1,"resource":{"primary":{"URL":"https:\/\/linkinghub.elsevier.com\/retrieve\/pii\/S2590005626001165"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2026,7]]},"references-count":37,"alternative-id":["S2590005626001165"],"URL":"https:\/\/doi.org\/10.1016\/j.array.2026.100793","relation":{"is-supplemented-by":[{"id-type":"doi","id":"10.6084\/m9.figshare.31361758","asserted-by":"subject"},{"id-type":"uri","id":"https:\/\/figshare.com\/articles\/dataset\/Stack_Overflow_Recommendations_Dataset_SORD_-_Version_1_0_based_on_Stack_Overflow_Data_Dump_-_October_2025\/30948506","asserted-by":"subject"}]},"ISSN":["2590-0056"],"issn-type":[{"value":"2590-0056","type":"print"}],"subject":[],"published":{"date-parts":[[2026,7]]},"assertion":[{"value":"Elsevier","name":"publisher","label":"This article is maintained by"},{"value":"Scalable conversion of Stack Exchange network-based question answering sites\u2019 data dump to SQL Server database \u2013 A case of Stack Overflow data dump","name":"articletitle","label":"Article Title"},{"value":"Array","name":"journaltitle","label":"Journal Title"},{"value":"https:\/\/doi.org\/10.1016\/j.array.2026.100793","name":"articlelink","label":"CrossRef DOI link to publisher maintained version"},{"value":"article","name":"content_type","label":"Content Type"},{"value":"\u00a9 2026 The Authors. Published by Elsevier Inc.","name":"copyright","label":"Copyright"}],"article-number":"100793"}}