{"id":"https://openalex.org/W2090298688","doi":"https://doi.org/10.4018/jdm.2002010101","title":"Common Sense Reasoning in Automated Database Design","display_name":"Common Sense Reasoning in Automated Database Design","publication_year":2002,"publication_date":"2002-01-01","ids":{"openalex":"https://openalex.org/W2090298688","doi":"https://doi.org/10.4018/jdm.2002010101","mag":"2090298688"},"language":"en","primary_location":{"id":"doi:10.4018/jdm.2002010101","is_oa":false,"landing_page_url":"https://doi.org/10.4018/jdm.2002010101","pdf_url":null,"source":{"id":"https://openalex.org/S73024538","display_name":"Journal of Database Management","issn_l":"1063-8016","issn":["1063-8016","1533-8010"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Database Management","raw_type":"journal-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/A5002282690","display_name":"Veda C. Storey","orcid":"https://orcid.org/0000-0002-8735-1553"},"institutions":[{"id":"https://openalex.org/I181565077","display_name":"Georgia State University","ror":"https://ror.org/03qt6ba18","country_code":"US","type":"education","lineage":["https://openalex.org/I181565077"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Veda C. Storey","raw_affiliation_strings":["Georgia State University, USA","(Georgia State University, USA)"],"raw_orcid":"https://orcid.org/0000-0002-8735-1553","affiliations":[{"raw_affiliation_string":"Georgia State University, USA","institution_ids":["https://openalex.org/I181565077"]},{"raw_affiliation_string":"(Georgia State University, USA)","institution_ids":["https://openalex.org/I181565077"]}]},{"author_position":"middle","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":["University of British Columbia, Canada","University of British Columbia, Canada ,"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of British Columbia, Canada","institution_ids":["https://openalex.org/I141945490"]},{"raw_affiliation_string":"University of British Columbia, Canada ,","institution_ids":["https://openalex.org/I141945490"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5103525559","display_name":"Jason Ding","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jason Ding","raw_affiliation_strings":["Pharm2B, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Pharm2B, China","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.389,"has_fulltext":false,"cited_by_count":6,"citation_normalized_percentile":{"value":0.87748175,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"13","issue":"1","first_page":"3","last_page":"14"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9810000061988831,"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/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9810000061988831,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9593999981880188,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9463000297546387,"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.817256510257721},{"id":"https://openalex.org/keywords/semantic-reasoner","display_name":"Semantic reasoner","score":0.8105596303939819},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.6412538290023804},{"id":"https://openalex.org/keywords/knowledge-base","display_name":"Knowledge base","score":0.5952841639518738},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5710680484771729},{"id":"https://openalex.org/keywords/database-testing","display_name":"Database testing","score":0.45671430230140686},{"id":"https://openalex.org/keywords/task","display_name":"Task (project management)","score":0.4238378405570984},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.4017971456050873},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.3336471915245056},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.23635870218276978},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.20303991436958313},{"id":"https://openalex.org/keywords/systems-engineering","display_name":"Systems engineering","score":0.10022297501564026}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.817256510257721},{"id":"https://openalex.org/C9616225","wikidata":"https://www.wikidata.org/wiki/Q3929429","display_name":"Semantic reasoner","level":2,"score":0.8105596303939819},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.6412538290023804},{"id":"https://openalex.org/C4554734","wikidata":"https://www.wikidata.org/wiki/Q593744","display_name":"Knowledge base","level":2,"score":0.5952841639518738},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5710680484771729},{"id":"https://openalex.org/C78161392","wikidata":"https://www.wikidata.org/wiki/Q5227414","display_name":"Database testing","level":4,"score":0.45671430230140686},{"id":"https://openalex.org/C2780451532","wikidata":"https://www.wikidata.org/wiki/Q759676","display_name":"Task (project management)","level":2,"score":0.4238378405570984},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.4017971456050873},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.3336471915245056},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.23635870218276978},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.20303991436958313},{"id":"https://openalex.org/C201995342","wikidata":"https://www.wikidata.org/wiki/Q682496","display_name":"Systems engineering","level":1,"score":0.10022297501564026},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.4018/jdm.2002010101","is_oa":false,"landing_page_url":"https://doi.org/10.4018/jdm.2002010101","pdf_url":null,"source":{"id":"https://openalex.org/S73024538","display_name":"Journal of Database Management","issn_l":"1063-8016","issn":["1063-8016","1533-8010"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Database Management","raw_type":"journal-article"},{"id":"pmh:oai:RePEc:igg:jdm000:v:13:y:2002:i:1:p:3-14","is_oa":false,"landing_page_url":"http://services.igi-global.com/resolvedoi/resolve.aspx?doi=10.4018/jdm.2002010101","pdf_url":null,"source":{"id":"https://openalex.org/S4306401271","display_name":"RePEc: Research Papers in Economics","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I77793887","host_organization_name":"Federal Reserve Bank of St. Louis","host_organization_lineage":["https://openalex.org/I77793887"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W1560442284","https://openalex.org/W2129469317","https://openalex.org/W1501673548","https://openalex.org/W2357102580","https://openalex.org/W1603016012","https://openalex.org/W1588786827","https://openalex.org/W2591891926","https://openalex.org/W2015535627","https://openalex.org/W1558507836","https://openalex.org/W1533863182"],"abstract_inverted_index":{"A":[0],"great":[1,149],"deal":[2,150],"of":[3,73,89,109,151,229],"work":[4],"on":[5],"automating":[6],"systems":[7,31],"design":[8,25,95,128,215],"and":[9,137,204,225],"development":[10],"has":[11,75,194],"been":[12,28,77],"carried":[13,221],"out,":[14],"especially":[15],"in":[16,34],"the":[17,23,41,53,58,62,87,107,161,166,202,227,231,237],"database":[18,24,45,111,120,127,154,214],"area.":[19],"Systems":[20],"that":[21,35,52,60,105,173,193],"semi-automate":[22],"process":[26],"have":[27],"developed.":[29],"These":[30],"are":[32,131],"interactive":[33],"they":[36],"may":[37],"need":[38],"to":[39,57,83,168,208,212,223,236],"ask":[40],"user":[42,59,116,167],"(usually,":[43],"a":[44,80,94,110,115,141,148,185,195,205,213],"designer)":[46],"for":[47],"clarification.":[48],"The":[49,97,145],"result":[50],"is":[51,101,190,220],"system":[54,63,104,146],"asks":[55],"questions":[56],"make":[61],"look":[64],"less":[65],"intelligent":[66],"than":[67],"it":[68,85],"should.":[69],"This":[70,164],"general":[71,199],"type":[72],"problem":[74],"long":[76],"recognized":[78],"with":[79],"proposed":[81],"approach":[82],"overcoming":[84],"being":[86,191],"incorporation":[88],"common":[90],"sense":[91],"knowledge":[92,152,196,200,211],"into":[93,140],"system.":[96],"View":[98,238],"Creation":[99,239],"System":[100],"an":[102,134],"expert":[103],"plays":[106],"role":[108],"designer.":[112,180],"With":[113],"it,":[114],"knowing":[117],"little":[118],"about":[119,153,160,201],"technology":[121],"can":[122],"express":[123],"his":[124],"or":[125],"her":[126],"requirements,":[129],"which":[130],"represented":[132],"by":[133,177],"entity-relationship":[135],"model":[136],"then":[138],"translated":[139],"normalized":[142],"relational":[143],"model.":[144],"contains":[147],"design,":[155],"but":[156],"little,":[157],"if":[158],"any,":[159],"user\u2019s":[162],"application.":[163],"forces":[165],"specify":[169],"many":[170],"trivial":[171],"facts":[172],"would":[174],"be":[175],"known":[176],"any":[178],"human":[179],"To":[181],"overcome":[182],"this":[183,210],"limitation,":[184],"Common":[186,232],"Sense":[187,233],"Business":[188,234],"Reasoner":[189,235],"developed":[192],"base":[197],"containing":[198],"world":[203],"reasoning":[206],"tool":[207],"apply":[209],"task.":[216],"An":[217],"empirical":[218],"study":[219],"out":[222],"simulate":[224],"assess":[226],"effectiveness":[228],"adding":[230],"System.":[240]},"counts_by_year":[{"year":2021,"cited_by_count":1}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}