{"id":"https://openalex.org/W2125232649","doi":"https://doi.org/10.1145/2002951.2002955","title":"Dynamic invariant detection for relational databases","display_name":"Dynamic invariant detection for relational databases","publication_year":2011,"publication_date":"2011-07-18","ids":{"openalex":"https://openalex.org/W2125232649","doi":"https://doi.org/10.1145/2002951.2002955","mag":"2125232649"},"language":"en","primary_location":{"is_oa":false,"landing_page_url":"https://doi.org/10.1145/2002951.2002955","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false},"type":"article","type_crossref":"proceedings-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/A5049342490","display_name":"Jake Cobb","orcid":null},"institutions":[{"id":"https://openalex.org/I130701444","display_name":"Georgia Institute of Technology","ror":"https://ror.org/01zkghx44","country_code":"US","type":"education","lineage":["https://openalex.org/I130701444"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jake Cobb","raw_affiliation_strings":["[Georgia Institute of Technology.]"],"affiliations":[{"raw_affiliation_string":"[Georgia Institute of Technology.]","institution_ids":["https://openalex.org/I130701444"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5008140976","display_name":"James A. Jones","orcid":"https://orcid.org/0000-0002-5359-7934"},"institutions":[{"id":"https://openalex.org/I204250578","display_name":"University of California, Irvine","ror":"https://ror.org/04gyf1771","country_code":"US","type":"education","lineage":["https://openalex.org/I204250578"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"James A. Jones","raw_affiliation_strings":["[University of California, Irvine]"],"affiliations":[{"raw_affiliation_string":"[University of California, Irvine]","institution_ids":["https://openalex.org/I204250578"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5084185098","display_name":"Gregory M. Kapfhammer","orcid":null},"institutions":[{"id":"https://openalex.org/I120506574","display_name":"Allegheny College","ror":"https://ror.org/02jgzjj54","country_code":"US","type":"education","lineage":["https://openalex.org/I120506574"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Gregory M. Kapfhammer","raw_affiliation_strings":["Allegheny College"],"affiliations":[{"raw_affiliation_string":"Allegheny College","institution_ids":["https://openalex.org/I120506574"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5038406724","display_name":"Mary Jean Harrold","orcid":null},"institutions":[{"id":"https://openalex.org/I130701444","display_name":"Georgia Institute of Technology","ror":"https://ror.org/01zkghx44","country_code":"US","type":"education","lineage":["https://openalex.org/I130701444"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Mary Jean Harrold","raw_affiliation_strings":["[Georgia Institute of Technology.]"],"affiliations":[{"raw_affiliation_string":"[Georgia Institute of Technology.]","institution_ids":["https://openalex.org/I130701444"]}]}],"institution_assertions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.164,"has_fulltext":true,"fulltext_origin":"ngrams","cited_by_count":22,"citation_normalized_percentile":{"value":0.848014,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":91},"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T10260","display_name":"Software Engineering Research","score":0.9995,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T10260","display_name":"Software Engineering Research","score":0.9995,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T10743","display_name":"Software Testing and Debugging Techniques","score":0.9989,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/T10126","display_name":"Logic, programming, and type systems","score":0.998,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/schema","display_name":"Schema (genetic algorithms)","score":0.59556216}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7656967},{"id":"https://openalex.org/C190470478","wikidata":"https://www.wikidata.org/wiki/Q2370229","display_name":"Invariant (physics)","level":2,"score":0.7367255},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.725053},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.65849876},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.59556216},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.51599956},{"id":"https://openalex.org/C56310702","wikidata":"https://www.wikidata.org/wiki/Q2269281","display_name":"Semi-structured model","level":4,"score":0.49449512},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.4930732},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.47818354},{"id":"https://openalex.org/C5968703","wikidata":"https://www.wikidata.org/wiki/Q267136","display_name":"Database model","level":3,"score":0.44908},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.41360068},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.33515978},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.26558703},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.13007903},{"id":"https://openalex.org/C37914503","wikidata":"https://www.wikidata.org/wiki/Q156495","display_name":"Mathematical physics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"is_oa":false,"landing_page_url":"https://doi.org/10.1145/2002951.2002955","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false}],"best_oa_location":null,"sustainable_development_goals":[],"grants":[],"datasets":[],"versions":[],"referenced_works_count":11,"referenced_works":["https://openalex.org/W139112911","https://openalex.org/W139810517","https://openalex.org/W2065227490","https://openalex.org/W2101058980","https://openalex.org/W2107751709","https://openalex.org/W2110908283","https://openalex.org/W2121376435","https://openalex.org/W2751199251","https://openalex.org/W2753439427","https://openalex.org/W3106729728","https://openalex.org/W3200788958"],"related_works":["https://openalex.org/W3020852678","https://openalex.org/W279222092","https://openalex.org/W2585880425","https://openalex.org/W2460926837","https://openalex.org/W2007556552","https://openalex.org/W1998046157","https://openalex.org/W1823508141","https://openalex.org/W1588786827","https://openalex.org/W108313336","https://openalex.org/W1016652228"],"abstract_inverted_index":{"Despite":[0],"the":[1,23,53,57,90,124],"many":[2,148],"automated":[3],"techniques":[4],"that":[5,45,55,109,136],"benefit":[6],"from":[7],"dynamic":[8,20,35],"invariant":[9,36,84],"detection,":[10],"to":[11,16],"date,":[12],"none":[13],"are":[14,130,142],"able":[15],"capture":[17],"and":[18,28,42,49,70,76,82,101,112,121,147],"detect":[19],"invariants":[21,114,125,141],"at":[22],"interface":[24],"of":[25,52,73,92,123,138],"a":[26,34,64,116],"program":[27,74],"its":[29],"databases.":[30],"This":[31],"paper":[32,87],"presents":[33,89],"detection":[37],"method":[38,62],"for":[39,43,127],"relational":[40,47,67,117],"databases":[41,48,146,153],"programs":[44],"use":[46],"an":[50],"implementation":[51],"approach":[54],"leverages":[56],"Daikon":[58],"dynamic-invariant":[59],"engine.":[60],"The":[61,86,105,132],"defines":[63],"mapping":[65],"between":[66],"database":[68,118],"elements":[69],"Daikon's":[71],"notion":[72],"points":[75],"variable":[77],"observations,":[78],"thus":[79],"enabling":[80],"row-level":[81],"column-level":[83],"detection.":[85],"also":[88],"results":[91],"two":[93],"empirical":[94],"evaluations":[95],"on":[96],"four":[97],"fixed":[98],"data":[99],"sets":[100],"three":[102],"subject":[103,129],"programs.":[104],"first":[106],"study":[107,134],"shows":[108],"dynamically":[110],"detecting":[111],"inferring":[113],"in":[115],"is":[119],"feasible":[120],"55%":[122],"produced":[126],"each":[128],"meaningful.":[131],"second":[133],"reveals":[135],"all":[137],"these":[139],"meaningful":[140],"schema-enforceable":[143],"using":[144],"standards-compliant":[145],"can":[149],"be":[150],"checked":[151],"by":[152],"with":[154],"only":[155],"limited":[156],"schema":[157],"constructs.":[158]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2125232649","counts_by_year":[{"year":2023,"cited_by_count":4},{"year":2022,"cited_by_count":2},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":4},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":2},{"year":2013,"cited_by_count":3},{"year":2012,"cited_by_count":1}],"updated_date":"2025-01-22T13:26:35.371556","created_date":"2016-06-24"}