{"id":"https://openalex.org/W1971789418","doi":"https://doi.org/10.1145/1185448.1185537","title":"Specifying and solving Boolean constraint problems in relational databases","display_name":"Specifying and solving Boolean constraint problems in relational databases","publication_year":2006,"publication_date":"2006-03-10","ids":{"openalex":"https://openalex.org/W1971789418","doi":"https://doi.org/10.1145/1185448.1185537","mag":"1971789418"},"language":"en","primary_location":{"id":"doi:10.1145/1185448.1185537","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1185448.1185537","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 44th annual Southeast regional conference","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/A5101476502","display_name":"James J. Lu","orcid":"https://orcid.org/0000-0001-7888-7412"},"institutions":[{"id":"https://openalex.org/I150468666","display_name":"Emory University","ror":"https://ror.org/03czfpz43","country_code":"US","type":"education","lineage":["https://openalex.org/I150468666"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"James J. Lu","raw_affiliation_strings":["Emory University, Atlanta, GA","Emory university, Atlanta, GA"],"affiliations":[{"raw_affiliation_string":"Emory University, Atlanta, GA","institution_ids":["https://openalex.org/I150468666"]},{"raw_affiliation_string":"Emory university, Atlanta, GA","institution_ids":["https://openalex.org/I150468666"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5063541003","display_name":"M. Jeremy Scoggins","orcid":null},"institutions":[{"id":"https://openalex.org/I150468666","display_name":"Emory University","ror":"https://ror.org/03czfpz43","country_code":"US","type":"education","lineage":["https://openalex.org/I150468666"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"M. Jeremy Scoggins","raw_affiliation_strings":["Emory University, Atlanta, GA","Emory university, Atlanta, GA"],"affiliations":[{"raw_affiliation_string":"Emory University, Atlanta, GA","institution_ids":["https://openalex.org/I150468666"]},{"raw_affiliation_string":"Emory university, Atlanta, GA","institution_ids":["https://openalex.org/I150468666"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5101476502"],"corresponding_institution_ids":["https://openalex.org/I150468666"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.1110742,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"399","last_page":"404"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11596","display_name":"Constraint Satisfaction and Optimization","score":0.9951000213623047,"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"}},"topics":[{"id":"https://openalex.org/T11596","display_name":"Constraint Satisfaction and Optimization","score":0.9951000213623047,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.994700014591217,"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/T11106","display_name":"Data Management and Algorithms","score":0.989300012588501,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7706180810928345},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6477568745613098},{"id":"https://openalex.org/keywords/constraint","display_name":"Constraint (computer-aided design)","score":0.579393208026886},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.545966386795044},{"id":"https://openalex.org/keywords/constraint-programming","display_name":"Constraint programming","score":0.5414329767227173},{"id":"https://openalex.org/keywords/constraint-satisfaction-problem","display_name":"Constraint satisfaction problem","score":0.5329861044883728},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.5010392665863037},{"id":"https://openalex.org/keywords/boolean-satisfiability-problem","display_name":"Boolean satisfiability problem","score":0.49354398250579834},{"id":"https://openalex.org/keywords/extension","display_name":"Extension (predicate logic)","score":0.47678661346435547},{"id":"https://openalex.org/keywords/abstraction","display_name":"Abstraction","score":0.4755772650241852},{"id":"https://openalex.org/keywords/solver","display_name":"Solver","score":0.4700286090373993},{"id":"https://openalex.org/keywords/domain","display_name":"Domain (mathematical analysis)","score":0.4635232090950012},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4550027847290039},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.44600075483322144},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.1466349959373474},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.13543438911437988},{"id":"https://openalex.org/keywords/mathematical-optimization","display_name":"Mathematical optimization","score":0.12119561433792114}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7706180810928345},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6477568745613098},{"id":"https://openalex.org/C2776036281","wikidata":"https://www.wikidata.org/wiki/Q48769818","display_name":"Constraint (computer-aided design)","level":2,"score":0.579393208026886},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.545966386795044},{"id":"https://openalex.org/C173404611","wikidata":"https://www.wikidata.org/wiki/Q528588","display_name":"Constraint programming","level":3,"score":0.5414329767227173},{"id":"https://openalex.org/C199622910","wikidata":"https://www.wikidata.org/wiki/Q1128326","display_name":"Constraint satisfaction problem","level":3,"score":0.5329861044883728},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5010392665863037},{"id":"https://openalex.org/C6943359","wikidata":"https://www.wikidata.org/wiki/Q875276","display_name":"Boolean satisfiability problem","level":2,"score":0.49354398250579834},{"id":"https://openalex.org/C2778029271","wikidata":"https://www.wikidata.org/wiki/Q5421931","display_name":"Extension (predicate logic)","level":2,"score":0.47678661346435547},{"id":"https://openalex.org/C124304363","wikidata":"https://www.wikidata.org/wiki/Q673661","display_name":"Abstraction","level":2,"score":0.4755772650241852},{"id":"https://openalex.org/C2778770139","wikidata":"https://www.wikidata.org/wiki/Q1966904","display_name":"Solver","level":2,"score":0.4700286090373993},{"id":"https://openalex.org/C36503486","wikidata":"https://www.wikidata.org/wiki/Q11235244","display_name":"Domain (mathematical analysis)","level":2,"score":0.4635232090950012},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4550027847290039},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.44600075483322144},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.1466349959373474},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.13543438911437988},{"id":"https://openalex.org/C126255220","wikidata":"https://www.wikidata.org/wiki/Q141495","display_name":"Mathematical optimization","level":1,"score":0.12119561433792114},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0},{"id":"https://openalex.org/C49937458","wikidata":"https://www.wikidata.org/wiki/Q2599292","display_name":"Probabilistic logic","level":2,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"id":"https://openalex.org/C137631369","wikidata":"https://www.wikidata.org/wiki/Q7617831","display_name":"Stochastic programming","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1185448.1185537","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1185448.1185537","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 44th annual Southeast regional conference","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/4","display_name":"Quality Education","score":0.7400000095367432}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":17,"referenced_works":["https://openalex.org/W1518705996","https://openalex.org/W1585537805","https://openalex.org/W1589223644","https://openalex.org/W1667362966","https://openalex.org/W1667614912","https://openalex.org/W2003203425","https://openalex.org/W2044701300","https://openalex.org/W2060440626","https://openalex.org/W2096160379","https://openalex.org/W2105486835","https://openalex.org/W2126256512","https://openalex.org/W2140190241","https://openalex.org/W2145932802","https://openalex.org/W2146662253","https://openalex.org/W2155028447","https://openalex.org/W2279013213","https://openalex.org/W4256238177"],"related_works":["https://openalex.org/W4303044088","https://openalex.org/W2102858635","https://openalex.org/W2097415053","https://openalex.org/W1486916474","https://openalex.org/W1563755460","https://openalex.org/W1531664660","https://openalex.org/W2500041535","https://openalex.org/W1957191361","https://openalex.org/W1820477541","https://openalex.org/W2573939812"],"abstract_inverted_index":{"A":[0,91],"two-part":[1],"approach":[2,81],"for":[3,21,82],"extending":[4],"relational":[5],"database":[6,37],"systems":[7],"to":[8,52,86,100],"solve":[9],"boolean":[10,23],"constraint":[11,24,33],"problems":[12,88],"is":[13,17,29,45,89,94],"presented.":[14],"The":[15,42],"first":[16],"a":[18,30,66,70,79],"SQL-extension":[19],"frontend":[20],"specifying":[22],"problems,":[25],"and":[26,47,69,78],"the":[27,36,40,58,62,76],"second":[28],"coupling":[31],"of":[32,61],"solvers":[34],"with":[35,97],"engine":[38],"in":[39,75],"backend.":[41],"language":[43],"extension":[44],"high-level":[46],"domain-specific,":[48],"thereby":[49],"allowing":[50],"users":[51],"focus":[53],"on":[54],"writing":[55],"specifications":[56],"at":[57],"abstraction":[59],"level":[60],"problem":[63],"domain.":[64],"Both":[65],"stand-alone":[67],"solver":[68,72],"stored-procedure":[71],"are":[73],"integrated":[74],"backend,":[77],"simple":[80],"finding":[83],"\"acceptable":[84],"answers\"":[85],"overly-constrained":[87],"discussed.":[90],"prototype":[92],"system":[93],"described":[95],"along":[96],"an":[98],"application":[99],"scheduling":[101],"tennis":[102],"matches.":[103]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}