{"id":"https://openalex.org/W2460718840","doi":"https://doi.org/10.1145/2949689.2949693","title":"SolveDB","display_name":"SolveDB","publication_year":2016,"publication_date":"2016-07-08","ids":{"openalex":"https://openalex.org/W2460718840","doi":"https://doi.org/10.1145/2949689.2949693","mag":"2460718840"},"language":"en","primary_location":{"id":"doi:10.1145/2949689.2949693","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2949689.2949693","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 28th International Conference on Scientific and Statistical Database Management","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5073908480","display_name":"Laurynas \u0160ik\u0161nys","orcid":"https://orcid.org/0000-0002-1454-4709"},"institutions":[{"id":"https://openalex.org/I891191580","display_name":"Aalborg University","ror":"https://ror.org/04m5j1k67","country_code":"DK","type":"education","lineage":["https://openalex.org/I891191580"]}],"countries":["DK"],"is_corresponding":false,"raw_author_name":"Laurynas \u0160ik\u0161nys","raw_affiliation_strings":["Department of Computer Science, Aalborg University, Denmark"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science, Aalborg University, Denmark","institution_ids":["https://openalex.org/I891191580"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5061064237","display_name":"Torben Bach Pedersen","orcid":"https://orcid.org/0000-0002-1615-777X"},"institutions":[{"id":"https://openalex.org/I891191580","display_name":"Aalborg University","ror":"https://ror.org/04m5j1k67","country_code":"DK","type":"education","lineage":["https://openalex.org/I891191580"]}],"countries":["DK"],"is_corresponding":false,"raw_author_name":"Torben Bach Pedersen","raw_affiliation_strings":["Department of Computer Science, Aalborg University, Denmark"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science, Aalborg University, Denmark","institution_ids":["https://openalex.org/I891191580"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.2763,"has_fulltext":false,"cited_by_count":12,"citation_normalized_percentile":{"value":0.80662562,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"12"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9994999766349792,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9994999766349792,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9991000294685364,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11596","display_name":"Constraint Satisfaction and Optimization","score":0.9987999796867371,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8589646816253662},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7101938724517822},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5939356684684753},{"id":"https://openalex.org/keywords/optimization-problem","display_name":"Optimization problem","score":0.5194010734558105},{"id":"https://openalex.org/keywords/syntax","display_name":"Syntax","score":0.501598596572876},{"id":"https://openalex.org/keywords/workflow","display_name":"Workflow","score":0.46318885684013367},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.4052850604057312},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.33886659145355225},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.1311260461807251},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.09654593467712402}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8589646816253662},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7101938724517822},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5939356684684753},{"id":"https://openalex.org/C137836250","wikidata":"https://www.wikidata.org/wiki/Q984063","display_name":"Optimization problem","level":2,"score":0.5194010734558105},{"id":"https://openalex.org/C60048249","wikidata":"https://www.wikidata.org/wiki/Q37437","display_name":"Syntax","level":2,"score":0.501598596572876},{"id":"https://openalex.org/C177212765","wikidata":"https://www.wikidata.org/wiki/Q627335","display_name":"Workflow","level":2,"score":0.46318885684013367},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.4052850604057312},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.33886659145355225},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.1311260461807251},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.09654593467712402}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/2949689.2949693","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2949689.2949693","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 28th International Conference on Scientific and Statistical Database Management","raw_type":"proceedings-article"},{"id":"pmh:oai:pure.atira.dk:publications/9a2d124c-fdde-4b66-963a-a7a7dde94eda","is_oa":false,"landing_page_url":"https://vbn.aau.dk/da/publications/9a2d124c-fdde-4b66-963a-a7a7dde94eda","pdf_url":null,"source":{"id":"https://openalex.org/S4306401731","display_name":"VBN Forskningsportal (Aalborg Universitet)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I891191580","host_organization_name":"Aalborg University","host_organization_lineage":["https://openalex.org/I891191580"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Siksnys, L & Pedersen, T B 2016, SolveDB: Integrating Optimization Problem Solvers Into SQL Databases. in Proceedings of the 28th International Conference on Scientific and Statistical Database Management., 14, Association for Computing Machinery (ACM), SSDBM 2016 Conference on Scientific and Statistical Database Management , 18/07/2016. https://doi.org/10.1145/2949689.2949693","raw_type":"info:eu-repo/semantics/publishedVersion"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","score":0.6600000262260437,"display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":26,"referenced_works":["https://openalex.org/W102682372","https://openalex.org/W1512039586","https://openalex.org/W1966901553","https://openalex.org/W1972585091","https://openalex.org/W1973156346","https://openalex.org/W1995351367","https://openalex.org/W2001902480","https://openalex.org/W2032376429","https://openalex.org/W2035448420","https://openalex.org/W2044849727","https://openalex.org/W2048864522","https://openalex.org/W2052574909","https://openalex.org/W2060360593","https://openalex.org/W2077913352","https://openalex.org/W2079672838","https://openalex.org/W2080841597","https://openalex.org/W2090850279","https://openalex.org/W2091307607","https://openalex.org/W2127470768","https://openalex.org/W2145456353","https://openalex.org/W2171492933","https://openalex.org/W2250335649","https://openalex.org/W2292438761","https://openalex.org/W2295864763","https://openalex.org/W4301216918","https://openalex.org/W6678861937"],"related_works":["https://openalex.org/W1981780420","https://openalex.org/W2182707996","https://openalex.org/W45233828","https://openalex.org/W2964988449","https://openalex.org/W2397952901","https://openalex.org/W2029380707","https://openalex.org/W188202134","https://openalex.org/W4255934811","https://openalex.org/W2465382974","https://openalex.org/W2356335648"],"abstract_inverted_index":{"Many":[0],"real-world":[1],"decision":[2],"problems":[3,7,18,32,112],"involve":[4],"solving":[5,16,76],"optimization":[6,24,59,74,93,111,126,139],"based":[8,97],"on":[9,98],"data":[10,71],"in":[11,77],"an":[12,122,129],"SQL":[13],"database.":[14],"Traditionally,":[15],"such":[17],"requires":[19],"combining":[20],"a":[21,56,78,114,160],"DBMS":[22,57],"with":[23,152],"software":[25],"packages":[26],"for":[27,58,64,84,125,132,174],"each":[28],"required":[29],"class":[30],"of":[31,91,110,170],"(e.g.":[33],"linear":[34],"and":[35,47,68,73,87,103,107,136,168,176],"constraint":[36],"programming)":[37],"--":[38],"leading":[39],"to":[40,141],"workflows":[41],"that":[42,157],"are":[43],"cumbersome,":[44],"complex,":[45],"inefficient,":[46],"error-prone.":[48],"In":[49],"this":[50],"paper,":[51],"we":[52],"present":[53],"SolveDB":[54,61,95,119,158],"-":[55],"applications.":[60],"supports":[62],"solvers":[63],"different":[65,134],"problem":[66,75],"classes":[67],"offers":[69],"seamless":[70],"management":[72],"pure":[79],"SQL-based":[80,123],"setting.":[81],"This":[82],"allows":[83,104],"much":[85,164],"simpler":[86],"more":[88],"effective":[89],"solutions":[90,109],"database-based":[92],"problems.":[94,178],"is":[96,159],"the":[99,143,153],"3-level":[100],"ANSI/SPARC":[101],"architecture":[102],"formulating,":[105],"solving,":[106],"analysing":[108],"using":[113],"single":[115],"so-called":[116],"solve":[117],"query.":[118],"provides":[120],"(1)":[121],"syntax":[124],"problems,":[127],"(2)":[128],"extensible":[130],"infrastructure":[131],"integrating":[133],"solvers,":[135],"(3)":[137],"query":[138],"techniques":[140],"achieve":[142],"best":[144],"execution":[145],"performance":[146,173],"and/or":[147],"result":[148],"quality.":[149],"Extensive":[150],"experiments":[151],"PostgreSQL-based":[154],"implementation":[155],"show":[156],"versatile":[161],"tool":[162],"offering":[163],"higher":[165],"developer":[166],"productivity":[167],"order":[169],"magnitude":[171],"better":[172],"specification-complex":[175],"data-intensive":[177]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":2},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":2},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2016-07-22T00:00:00"}