{"id":"https://openalex.org/W2114471852","doi":"https://doi.org/10.1016/0169-023x(95)00035-q","title":"Semantic integrity constraints in knowledge-based database design systems","display_name":"Semantic integrity constraints in knowledge-based database design systems","publication_year":1996,"publication_date":"1996-06-01","ids":{"openalex":"https://openalex.org/W2114471852","doi":"https://doi.org/10.1016/0169-023x(95)00035-q","mag":"2114471852"},"language":"en","primary_location":{"id":"doi:10.1016/0169-023x(95)00035-q","is_oa":true,"landing_page_url":"https://doi.org/10.1016/0169-023x(95)00035-q","pdf_url":null,"source":{"id":"https://openalex.org/S136993123","display_name":"Data & Knowledge Engineering","issn_l":"0169-023X","issn":["0169-023X","1872-6933"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Data & Knowledge Engineering","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://doi.org/10.1016/0169-023x(95)00035-q","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5002282690","display_name":"Veda C. Storey","orcid":"https://orcid.org/0000-0002-8735-1553"},"institutions":[{"id":"https://openalex.org/I5388228","display_name":"University of Rochester","ror":"https://ror.org/022kthw22","country_code":"US","type":"education","lineage":["https://openalex.org/I5388228"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Veda C. Storey","raw_affiliation_strings":["Wm. E. Simon Graduate School of Business Administration, University of Rochester, Rochester, NY 14627, USA"],"affiliations":[{"raw_affiliation_string":"Wm. E. Simon Graduate School of Business Administration, University of Rochester, Rochester, NY 14627, USA","institution_ids":["https://openalex.org/I5388228"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5014046245","display_name":"Heng\u2010Li Yang","orcid":"https://orcid.org/0000-0001-7014-4374"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Heng-Li Yang","raw_affiliation_strings":["Department of Management Information Systems, National Cheng-Chi University, Taipei, Taiwan"],"affiliations":[{"raw_affiliation_string":"Department of Management Information Systems, National Cheng-Chi University, Taipei, Taiwan","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5086547440","display_name":"Robert C. Goldstein","orcid":"https://orcid.org/0000-0002-9634-3344"},"institutions":[{"id":"https://openalex.org/I141945490","display_name":"University of British Columbia","ror":"https://ror.org/03rmrcq20","country_code":"CA","type":"education","lineage":["https://openalex.org/I141945490"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Robert C. Goldstein","raw_affiliation_strings":["Faculty of Commerce & Business Administration, University of British Columbia, Vancouver Canada V6T 1Z2","Faculty of Commerce and Business Administration, University of British Columbia, Vancouver, Canada V6T 1Z2"],"affiliations":[{"raw_affiliation_string":"Faculty of Commerce & Business Administration, University of British Columbia, Vancouver Canada V6T 1Z2","institution_ids":["https://openalex.org/I141945490"]},{"raw_affiliation_string":"Faculty of Commerce and Business Administration, University of British Columbia, Vancouver, Canada V6T 1Z2","institution_ids":["https://openalex.org/I141945490"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5002282690"],"corresponding_institution_ids":["https://openalex.org/I5388228"],"apc_list":{"value":2590,"currency":"USD","value_usd":2590},"apc_paid":{"value":2590,"currency":"USD","value_usd":2590},"fwci":0.0,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.24410843,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"20","issue":"1","first_page":"1","last_page":"37"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9997000098228455,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9997000098228455,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9986000061035156,"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"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.996999979019165,"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.7703273296356201},{"id":"https://openalex.org/keywords/data-integrity","display_name":"Data integrity","score":0.686593770980835},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.5465466976165771},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.49613937735557556},{"id":"https://openalex.org/keywords/task","display_name":"Task (project management)","score":0.42891746759414673},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.41175195574760437},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.392940878868103},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.331621378660202},{"id":"https://openalex.org/keywords/systems-engineering","display_name":"Systems engineering","score":0.12420770525932312},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.0907788872718811}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7703273296356201},{"id":"https://openalex.org/C33762810","wikidata":"https://www.wikidata.org/wiki/Q461671","display_name":"Data integrity","level":2,"score":0.686593770980835},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.5465466976165771},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.49613937735557556},{"id":"https://openalex.org/C2780451532","wikidata":"https://www.wikidata.org/wiki/Q759676","display_name":"Task (project management)","level":2,"score":0.42891746759414673},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.41175195574760437},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.392940878868103},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.331621378660202},{"id":"https://openalex.org/C201995342","wikidata":"https://www.wikidata.org/wiki/Q682496","display_name":"Systems engineering","level":1,"score":0.12420770525932312},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0907788872718811}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1016/0169-023x(95)00035-q","is_oa":true,"landing_page_url":"https://doi.org/10.1016/0169-023x(95)00035-q","pdf_url":null,"source":{"id":"https://openalex.org/S136993123","display_name":"Data & Knowledge Engineering","issn_l":"0169-023X","issn":["0169-023X","1872-6933"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Data & Knowledge Engineering","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1016/0169-023x(95)00035-q","is_oa":true,"landing_page_url":"https://doi.org/10.1016/0169-023x(95)00035-q","pdf_url":null,"source":{"id":"https://openalex.org/S136993123","display_name":"Data & Knowledge Engineering","issn_l":"0169-023X","issn":["0169-023X","1872-6933"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Data & Knowledge Engineering","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":90,"referenced_works":["https://openalex.org/W20474690","https://openalex.org/W67197778","https://openalex.org/W74995103","https://openalex.org/W75134691","https://openalex.org/W92559066","https://openalex.org/W113675512","https://openalex.org/W117724134","https://openalex.org/W118327627","https://openalex.org/W123930785","https://openalex.org/W139313190","https://openalex.org/W139773734","https://openalex.org/W163917331","https://openalex.org/W165875069","https://openalex.org/W173153821","https://openalex.org/W201128564","https://openalex.org/W325143868","https://openalex.org/W589111820","https://openalex.org/W1484633057","https://openalex.org/W1492626646","https://openalex.org/W1492988898","https://openalex.org/W1510137518","https://openalex.org/W1525376319","https://openalex.org/W1529648123","https://openalex.org/W1549617594","https://openalex.org/W1552346309","https://openalex.org/W1577880763","https://openalex.org/W1588808690","https://openalex.org/W1655990431","https://openalex.org/W1817458194","https://openalex.org/W1902347403","https://openalex.org/W1963118906","https://openalex.org/W1963506920","https://openalex.org/W1967022935","https://openalex.org/W1970468344","https://openalex.org/W1979078782","https://openalex.org/W1998046157","https://openalex.org/W2053913299","https://openalex.org/W2063640365","https://openalex.org/W2066734883","https://openalex.org/W2069323107","https://openalex.org/W2077777521","https://openalex.org/W2097203724","https://openalex.org/W2098733151","https://openalex.org/W2099293367","https://openalex.org/W2104771072","https://openalex.org/W2113617564","https://openalex.org/W2119672088","https://openalex.org/W2120639329","https://openalex.org/W2126591553","https://openalex.org/W2140037779","https://openalex.org/W2144192824","https://openalex.org/W2146722716","https://openalex.org/W2151165380","https://openalex.org/W2153520189","https://openalex.org/W2165609342","https://openalex.org/W2168098409","https://openalex.org/W2244808476","https://openalex.org/W2268009556","https://openalex.org/W2341204729","https://openalex.org/W2352490338","https://openalex.org/W2588808342","https://openalex.org/W2611245576","https://openalex.org/W2753710282","https://openalex.org/W2945526390","https://openalex.org/W2970113856","https://openalex.org/W3007348407","https://openalex.org/W3189142755","https://openalex.org/W4248340394","https://openalex.org/W6602756920","https://openalex.org/W6602996023","https://openalex.org/W6603770062","https://openalex.org/W6604603210","https://openalex.org/W6605037515","https://openalex.org/W6606598371","https://openalex.org/W6606890340","https://openalex.org/W6608216678","https://openalex.org/W6611273541","https://openalex.org/W6629568065","https://openalex.org/W6631152419","https://openalex.org/W6631587795","https://openalex.org/W6633835174","https://openalex.org/W6634425381","https://openalex.org/W6635461938","https://openalex.org/W6638485465","https://openalex.org/W6640983107","https://openalex.org/W6675249881","https://openalex.org/W6681715893","https://openalex.org/W6684489113","https://openalex.org/W6693502598","https://openalex.org/W7071489825"],"related_works":["https://openalex.org/W2129469317","https://openalex.org/W2188578519","https://openalex.org/W2130474477","https://openalex.org/W3162115094","https://openalex.org/W2508256214","https://openalex.org/W3184093474","https://openalex.org/W2529888092","https://openalex.org/W120281288","https://openalex.org/W318284924","https://openalex.org/W2349570899"],"abstract_inverted_index":{"Semantic":[0],"integrity":[1,80,95,143],"constraints":[2,35,87,96,144],"are":[3,88,120],"used":[4,109,125],"to":[5,75,84,114,126],"help":[6],"ensure":[7],"that":[8,99],"a":[9,29,40,90],"database":[10,21,48,147],"accurately":[11],"reflects":[12],"the":[13,111,118],"real":[14],"world":[15],"in":[16,145],"structure":[17],"and":[18,36,59,78,140],"content.":[19],"Existing":[20],"design":[22,49,148],"methodologies,":[23],"however,":[24],"do":[25],"not":[26],"often":[27],"include":[28],"comprehensive":[30],"procedure":[31],"for":[32,47,72],"identifying":[33],"such":[34],"incorporating":[37,139],"them":[38],"into":[39],"design.":[41],"A":[42,64],"number":[43],"of":[44,56,67,93,117],"knowledge-based":[45,146],"systems":[46,69,113,149],"have":[50],"been":[51],"developed":[52],"with":[53],"varying":[54],"degrees":[55],"emphasis":[57],"on,":[58],"approaches":[60,130],"to,":[61],"this":[62],"task.":[63],"representative":[65],"sample":[66],"these":[68],"is":[70,106,124,150],"reviewed":[71],"their":[73],"ability":[74],"identify,":[76],"represent":[77],"validate":[79],"constraints.":[81],"In":[82],"order":[83],"examine":[85],"how":[86],"represented,":[89],"six-dimensional":[91],"model":[92],"semantic":[94,142],"based":[97],"on":[98,138],"proposed":[100],"by":[101,110],"Fernandez":[102],"et":[103],"al.":[104],"[32]":[105],"presented.":[107],"Mechanisms":[108],"prototype":[112],"implement":[115],"each":[116],"dimensions":[119],"examined.":[121],"This":[122],"analysis":[123],"identify":[127],"apparently":[128],"successful":[129],"as":[131,133],"well":[132],"areas":[134],"where":[135],"further":[136],"research":[137],"representing":[141],"needed.":[151]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}