{"id":"https://openalex.org/W56430906","doi":null,"title":"Accommodating exceptions in databases, and refining the schema by learning from them","display_name":"Accommodating exceptions in databases, and refining the schema by learning from them","publication_year":1985,"publication_date":"1985-08-21","ids":{"openalex":"https://openalex.org/W56430906","mag":"56430906"},"language":"en","primary_location":{"id":"mag:56430906","doi":null,"is_oa":false,"landing_page_url":"https://dblp.uni-trier.de/db/conf/vldb/vldb85.html#BorgidaW85","pdf_url":null,"source":{"id":"https://openalex.org/S4306421142","display_name":"Very Large Data Bases","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Very Large Data Bases","raw_type":null},"volume":null,"type":"article","is_traditional":true,"indexed_in":[],"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/A5013856766","display_name":"Alexander T. Borgida","orcid":"https://orcid.org/0000-0003-4507-7805","observed_orcids":["https://orcid.org/0000-0003-4507-7805"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Alexander Borgida","raw_affiliation_strings":[],"raw_orcid":"https://orcid.org/0000-0003-4507-7805","affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5108337256","display_name":"Keith E. Williamson","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Keith E. Williamson","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":4.7844,"has_fulltext":false,"cited_by_count":36,"citation_normalized_percentile":{"value":0.9441877,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":88,"max":93},"biblio":{"volume":null,"issue":null,"first_page":"72","last_page":"81"},"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.9833999872207642,"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.9833999872207642,"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/T11719","display_name":"Data Quality and Management","score":0.00800000037997961,"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.002300000051036477,"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/semantic-integrity-constraints","display_name":"semantic integrity constraints","score":0.781000018119812},{"id":"https://openalex.org/keywords/database-schema-design","display_name":"database schema design","score":0.4830000102519989}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.828040361404419},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.7765820622444153},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.7546569108963013},{"id":"https://openalex.org/C2780660560","wikidata":"https://www.wikidata.org/wiki/Q3951893","display_name":"Schema evolution","level":4,"score":0.6910939812660217},{"id":"https://openalex.org/C153440673","wikidata":"https://www.wikidata.org/wiki/Q7431119","display_name":"Schema migration","level":5,"score":0.6038889288902283},{"id":"https://openalex.org/C150012506","wikidata":"https://www.wikidata.org/wiki/Q6031185","display_name":"Information schema","level":5,"score":0.5276250243186951},{"id":"https://openalex.org/C33762810","wikidata":"https://www.wikidata.org/wiki/Q461671","display_name":"Data integrity","level":2,"score":0.5069444179534912},{"id":"https://openalex.org/C70236469","wikidata":"https://www.wikidata.org/wiki/Q1078262","display_name":"Database administrator","level":2,"score":0.4985237121582031},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.47463831305503845},{"id":"https://openalex.org/C56310702","wikidata":"https://www.wikidata.org/wiki/Q2269281","display_name":"Semi-structured model","level":4,"score":0.4718630015850067},{"id":"https://openalex.org/C145428669","wikidata":"https://www.wikidata.org/wiki/Q471748","display_name":"Exception handling","level":2,"score":0.4163272976875305},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3560687303543091},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.33888834714889526},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3234153985977173}],"mesh":[],"locations_count":1,"locations":[{"id":"mag:56430906","doi":null,"is_oa":false,"landing_page_url":"https://dblp.uni-trier.de/db/conf/vldb/vldb85.html#BorgidaW85","pdf_url":null,"source":{"id":"https://openalex.org/S4306421142","display_name":"Very Large Data Bases","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Very Large Data Bases","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":11,"referenced_works":["https://openalex.org/W47935261","https://openalex.org/W163398301","https://openalex.org/W1596324102","https://openalex.org/W1600175013","https://openalex.org/W2009207944","https://openalex.org/W2020149918","https://openalex.org/W2024490882","https://openalex.org/W2035382654","https://openalex.org/W2071136304","https://openalex.org/W2147869465","https://openalex.org/W2155524311"],"related_works":["https://openalex.org/W2405544841","https://openalex.org/W2082430817","https://openalex.org/W1984967875","https://openalex.org/W2400772165","https://openalex.org/W2155452607","https://openalex.org/W2972821897","https://openalex.org/W4282592169","https://openalex.org/W7067465731","https://openalex.org/W1516896513","https://openalex.org/W1540242629"],"abstract_inverted_index":{"To":[0],"utilize":[1],"DBMSs,":[2],"a":[3,9,75,115,120],"database":[116],"designer":[5],"must":[6,46],"usually":[7],"construct":[8],"schema,":[10,58],"which":[11,87,123],"is":[12,29,37,99,149],"used":[13,153],"to":[14,93,129],"validate":[15],"the":[16,34,53,57,60,67,88,102,106,130,137,144],"data":[17,103],"stored":[18],"and":[19,32,40,77,127,133,148],"help":[20],"set":[21],"up":[22],"efficient":[23],"access":[24],"structures.":[25],"Because":[26],"design":[28],"an":[30],"art,":[31],"because":[33],"real":[35],"world":[36],"irregular,":[38],"unpredictable,":[39],"evolves,":[41],"truly":[42],"useful":[43],"systems":[45],"be":[47,91],"tolerant":[48],"of":[49,114],"occasional":[50],"deviations":[51],"from":[52,143],"constraints":[54,135],"imposed":[55],"by":[56],"including":[59,105],"semantic":[61],"integrity":[62,134],"constraints.":[63],"We":[64],"therefore":[65],"examine":[66],"problems":[68],"involved":[69],"in":[70,74,86,101,136,154],"accommodating":[71],"ezceptional":[72],"information":[73],"database,":[76],"outline":[78],"techniques":[79,152],"for":[80],"resolving":[81],"them.\r\n\r\nFurthermore,":[82],"we":[83,111],"consider":[84],"ways":[85],"schema":[89],"can":[90,124],"refined":[92],"better":[94],"characterize":[95],"reality":[96],"as":[97],"it":[98],"reflected":[100],"encountered,":[104],"exceptions.":[107],"For":[108],"this":[109],"purpose,":[110],"describe":[112],"part":[113],"administrator's":[117],"assistant":[118],"-":[119],"computer":[121],"system":[122,140],"suggest":[125],"modifications":[126],"additions":[128],"current":[131],"definitions":[132],"schema.":[138],"This":[139],"makes":[141],"generalizations":[142],"currently":[145],"encountered":[146],"exceptions,":[147],"based":[150],"on":[151],"Machine":[155],"Learning.":[156]},"counts_by_year":[{"year":2012,"cited_by_count":1}],"updated_date":"2026-10-30T12:39:25.321706","created_date":"2016-06-24T00:00:00"}