{"id":"https://openalex.org/W2000976313","doi":"https://doi.org/10.1145/15833.15836","title":"An event/trigger mechanism to enforce complex consistency constraints in design databases","display_name":"An event/trigger mechanism to enforce complex consistency constraints in design databases","alternate_titles":[],"publication_year":1986,"publication_date":"1986-09-01","ids":{"openalex":"https://openalex.org/W2000976313","doi":"https://doi.org/10.1145/15833.15836","mag":"2000976313"},"language":"en","primary_location":{"id":"doi:10.1145/15833.15836","doi":"https://doi.org/10.1145/15833.15836","is_oa":true,"landing_page_url":"https://doi.org/10.1145/15833.15836","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/15833.15836","source":{"id":"https://openalex.org/S47508943","display_name":"ACM SIGMOD Record","issn_l":"0163-5808","issn":["0163-5808","1943-5835"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","dongbi-c","jufo-1","norway-1","poland-70","russia-white-list-2","vabb-shw"],"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM SIGMOD Record","raw_type":"journal-article"},"parent_works":[],"lineage":["https://openalex.org/W2000976313"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"bronze","oa_url":"https://dl.acm.org/doi/pdf/10.1145/15833.15836","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5096949387","display_name":"Klaus R. Dittrich","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I143379178","display_name":"FZI Research Center for Information Technology","ror":"https://ror.org/04kdh6x72","country_code":"DE","type":"nonprofit","lineage":["https://openalex.org/I143379178"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Klaus R. Dittrich","raw_affiliation_strings":["Forschungszentrum Informatik an der Universit6t Karlsruhe Haid-und-Neu-Strasse 10-14, D--7500 Karlsruhe, West Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Forschungszentrum Informatik an der Universit6t Karlsruhe Haid-und-Neu-Strasse 10-14, D--7500 Karlsruhe, West Germany","institution_ids":["https://openalex.org/I143379178"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5046081362","display_name":"Angelika M. Kotz","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I143379178","display_name":"FZI Research Center for Information Technology","ror":"https://ror.org/04kdh6x72","country_code":"DE","type":"nonprofit","lineage":["https://openalex.org/I143379178"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Angelika M. Kotz","raw_affiliation_strings":["Forschungszentrum Informatik an der Universit6t Karlsruhe Haid-und-Neu-Strasse 10-14, D--7500 Karlsruhe, West Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Forschungszentrum Informatik an der Universit6t Karlsruhe Haid-und-Neu-Strasse 10-14, D--7500 Karlsruhe, West Germany","institution_ids":["https://openalex.org/I143379178"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5042264017","display_name":"Jutta A. Mulle","orcid":"https://orcid.org/0000-0002-5515-7756","observed_orcids":["https://orcid.org/0000-0002-5515-7756"]},"institutions":[{"id":"https://openalex.org/I143379178","display_name":"FZI Research Center for Information Technology","ror":"https://ror.org/04kdh6x72","country_code":"DE","type":"nonprofit","lineage":["https://openalex.org/I143379178"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Jutta A. M\u00fclle","raw_affiliation_strings":["Forschungszentrum Informatik an der Universit6t Karlsruhe Haid-und-Neu-Strasse 10-14, D--7500 Karlsruhe, West Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Forschungszentrum Informatik an der Universit6t Karlsruhe Haid-und-Neu-Strasse 10-14, D--7500 Karlsruhe, West Germany","institution_ids":["https://openalex.org/I143379178"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I143379178"],"apc_list":null,"apc_paid":null,"fwci":4.702,"has_fulltext":true,"cited_by_count":46,"citation_normalized_percentile":{"value":0.94727541,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":88,"max":95},"biblio":{"volume":"15","issue":"3","first_page":"22","last_page":"36"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9901999831199646,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9901999831199646,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.00930000003427267,"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/T11719","display_name":"Data Quality and Management","score":9.999999747378752e-05,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/consistency-constraints","display_name":"consistency constraints","score":0.7639999985694885},{"id":"https://openalex.org/keywords/design-database","display_name":"design database","score":0.8550000190734863},{"id":"https://openalex.org/keywords/computer-aided-design","display_name":"computer-aided design","score":0.828000009059906},{"id":"https://openalex.org/keywords/exception-handling","display_name":"exception handling","score":0.6650000214576721},{"id":"https://openalex.org/keywords/transaction-management","display_name":"transaction management","score":0.5299999713897705},{"id":"https://openalex.org/keywords/inconsistency-tolerance","display_name":"inconsistency tolerance","score":0.5410000085830688},{"id":"https://openalex.org/keywords/complex-data-structures","display_name":"complex data structures","score":0.4830000102519989},{"id":"https://openalex.org/keywords/constraint-checking","display_name":"constraint checking","score":0.4230000078678131},{"id":"https://openalex.org/keywords/database-triggers","display_name":"database triggers","score":0.3930000066757202}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8541074991226196},{"id":"https://openalex.org/C2776436953","wikidata":"https://www.wikidata.org/wiki/Q5163215","display_name":"Consistency (knowledge bases)","level":2,"score":0.8455474376678467},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.6811614036560059},{"id":"https://openalex.org/C93361087","wikidata":"https://www.wikidata.org/wiki/Q4426698","display_name":"Data consistency","level":2,"score":0.61161869764328},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5465173721313477},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.5216703414916992},{"id":"https://openalex.org/C34422012","wikidata":"https://www.wikidata.org/wiki/Q6125872","display_name":"Eventual consistency","level":4,"score":0.5002884864807129},{"id":"https://openalex.org/C33762810","wikidata":"https://www.wikidata.org/wiki/Q461671","display_name":"Data integrity","level":2,"score":0.48163145780563354},{"id":"https://openalex.org/C2779662365","wikidata":"https://www.wikidata.org/wiki/Q5416694","display_name":"Event (particle physics)","level":2,"score":0.47156116366386414},{"id":"https://openalex.org/C145428669","wikidata":"https://www.wikidata.org/wiki/Q471748","display_name":"Exception handling","level":2,"score":0.43705254793167114},{"id":"https://openalex.org/C122377713","wikidata":"https://www.wikidata.org/wiki/Q4422799","display_name":"Weak consistency","level":4,"score":0.42954692244529724},{"id":"https://openalex.org/C31388003","wikidata":"https://www.wikidata.org/wiki/Q7624548","display_name":"Strong consistency","level":3,"score":0.3892216086387634},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3868482708930969},{"id":"https://openalex.org/C37279795","wikidata":"https://www.wikidata.org/wiki/Q2492305","display_name":"Consistency model","level":3,"score":0.35506483912467957},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.08513090014457703},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C185429906","wikidata":"https://www.wikidata.org/wiki/Q1130160","display_name":"Estimator","level":2,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/15833.15836","doi":"https://doi.org/10.1145/15833.15836","is_oa":true,"landing_page_url":"https://doi.org/10.1145/15833.15836","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/15833.15836","source":{"id":"https://openalex.org/S47508943","display_name":"ACM SIGMOD Record","issn_l":"0163-5808","issn":["0163-5808","1943-5835"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","dongbi-c","jufo-1","norway-1","poland-70","russia-white-list-2","vabb-shw"],"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM SIGMOD Record","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1145/15833.15836","doi":"https://doi.org/10.1145/15833.15836","is_oa":true,"landing_page_url":"https://doi.org/10.1145/15833.15836","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/15833.15836","source":{"id":"https://openalex.org/S47508943","display_name":"ACM SIGMOD Record","issn_l":"0163-5808","issn":["0163-5808","1943-5835"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core","dongbi-c","jufo-1","norway-1","poland-70","russia-white-list-2","vabb-shw"],"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM SIGMOD Record","raw_type":"journal-article"},"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2000976313.pdf","grobid_xml":"https://content.openalex.org/works/W2000976313.grobid-xml"},"referenced_works_count":15,"referenced_works":["https://openalex.org/W16161818","https://openalex.org/W34424392","https://openalex.org/W760082382","https://openalex.org/W1498203057","https://openalex.org/W1500930938","https://openalex.org/W1509195621","https://openalex.org/W1535886478","https://openalex.org/W1570983218","https://openalex.org/W1595151077","https://openalex.org/W1996809012","https://openalex.org/W2003509178","https://openalex.org/W2059801644","https://openalex.org/W2071136304","https://openalex.org/W2153649450","https://openalex.org/W4246592204"],"related_works":["https://openalex.org/W1497711202","https://openalex.org/W2557904716","https://openalex.org/W2137971391","https://openalex.org/W1498203057","https://openalex.org/W4230246079","https://openalex.org/W7098929192","https://openalex.org/W2111371688","https://openalex.org/W2033327017","https://openalex.org/W2151493309","https://openalex.org/W1978603435"],"abstract_inverted_index":{"Data":[0],"objects":[1],"in":[2,42,61,69,126,146,151],"engineering":[3],"applications,":[4],"especially":[5],"computer":[6],"aided":[7],"design,":[8],"show":[9],"highly":[10],"complex":[11],"structures":[12],"and":[13,71,88,97,157],"a":[14,20],"lot":[15],"of":[16,23,52,76,90,106,111],"intricate":[17],"dependencies.":[18],"Hence":[19],"large":[21],"amount":[22],"variably":[24],"composed":[25],"consistency":[26,60,75,107,125],"constraints":[27],"have":[28,92],"to":[29,45,58,93,123,155],"be":[30,82,94],"dealt":[31],"with.":[32],"Furthermore,":[33],"long":[34,50],"transactions":[35],"which":[36],"are":[37,113,141],"typical":[38],"for":[39,135],"CAD":[40],"result":[41],"the":[43,77,101,104,131,153],"need":[44],"tolerate":[46],"inconsistencies":[47],"over":[48],"unpredictably":[49],"periods":[51],"time.":[53],"The":[54,86,138],"demands":[55],"on":[56],"mechanisms":[57,133],"enforce":[59,124],"design":[62,78,127],"database":[63],"systems":[64],"thus":[65],"differ":[66],"from":[67,143],"those":[68],"business":[70],"administrative":[72],"applications.":[73,137],"Comprehensive":[74],"data":[79],"can":[80],"only":[81],"attained":[83],"by":[84,100],"degrees.":[85],"time":[87],"extent":[89],"checking":[91],"determined":[95],"dynamically":[96],"under":[98],"control":[99],"user.":[102],"In":[103,115],"case":[105],"violations,":[108],"flexible":[109],"kinds":[110],"reaction":[112],"necessary.":[114],"this":[116],"paper":[117],"we":[118],"propose":[119],"an":[120,167],"event/trigger":[121],"mechanism":[122],"databases":[128],"that":[129,169],"complements":[130],"transaction-oriented":[132],"suitable":[134],"traditional":[136],"underlying":[139],"ideas":[140],"derived":[142],"exception":[144],"handling":[145],"programming":[147],"languages.":[148],"We":[149,164],"present":[150,166],"detail":[152],"requirements":[154],"meet":[156],"how":[158],"our":[159],"concept":[160],"copes":[161],"with":[162],"them.":[163],"also":[165],"implementation":[168],"provides":[170],"reasonable":[171],"performance.":[172]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2000976313","counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2016-06-24T00:00:00"}
