{"id":"https://openalex.org/W2804654209","doi":"https://doi.org/10.1145/3164541.3164584","title":"Extending the View Updatability of Relational Databases from Set Semantics to Bag Semantics and Its Implementation on PostgreSQL","display_name":"Extending the View Updatability of Relational Databases from Set Semantics to Bag Semantics and Its Implementation on PostgreSQL","publication_year":2018,"publication_date":"2018-01-05","ids":{"openalex":"https://openalex.org/W2804654209","doi":"https://doi.org/10.1145/3164541.3164584","mag":"2804654209"},"language":"en","primary_location":{"id":"doi:10.1145/3164541.3164584","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3164541.3164584","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 12th International Conference on Ubiquitous Information Management and Communication","raw_type":"proceedings-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/A5111378121","display_name":"Yoshifumi Masunaga","orcid":null},"institutions":[{"id":"https://openalex.org/I26120043","display_name":"Ochanomizu University","ror":"https://ror.org/03599d813","country_code":"JP","type":"education","lineage":["https://openalex.org/I26120043"]}],"countries":["JP"],"is_corresponding":true,"raw_author_name":"Yoshifumi Masunaga","raw_affiliation_strings":["Ochanomizu University (Emeritus), Bunkyo-ku, Tokyo, Japan"],"affiliations":[{"raw_affiliation_string":"Ochanomizu University (Emeritus), Bunkyo-ku, Tokyo, Japan","institution_ids":["https://openalex.org/I26120043"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5080150095","display_name":"Yugo Nagata","orcid":null},"institutions":[{"id":"https://openalex.org/I4210130202","display_name":"Software Research Associates (Japan)","ror":"https://ror.org/02frcze54","country_code":"JP","type":"company","lineage":["https://openalex.org/I4210130202"]}],"countries":["JP"],"is_corresponding":false,"raw_author_name":"Yugo Nagata","raw_affiliation_strings":["SRA OSS, Inc. Japan, Toshima-ku, Tokyo, Japan"],"affiliations":[{"raw_affiliation_string":"SRA OSS, Inc. Japan, Toshima-ku, Tokyo, Japan","institution_ids":["https://openalex.org/I4210130202"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5108554935","display_name":"Tatsuo Ishii","orcid":null},"institutions":[{"id":"https://openalex.org/I4210130202","display_name":"Software Research Associates (Japan)","ror":"https://ror.org/02frcze54","country_code":"JP","type":"company","lineage":["https://openalex.org/I4210130202"]}],"countries":["JP"],"is_corresponding":false,"raw_author_name":"Tatsuo Ishii","raw_affiliation_strings":["SRA OSS, Inc. Japan, Toshima-ku, Tokyo, Japan"],"affiliations":[{"raw_affiliation_string":"SRA OSS, Inc. Japan, Toshima-ku, Tokyo, Japan","institution_ids":["https://openalex.org/I4210130202"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5111378121"],"corresponding_institution_ids":["https://openalex.org/I26120043"],"apc_list":null,"apc_paid":null,"fwci":0.7381,"has_fulltext":false,"cited_by_count":6,"citation_normalized_percentile":{"value":0.73926505,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"8"},"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.9995999932289124,"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.9995999932289124,"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/T11106","display_name":"Data Management and Algorithms","score":0.9994000196456909,"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"}},{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9984999895095825,"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/computer-science","display_name":"Computer science","score":0.7980533838272095},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7884942889213562},{"id":"https://openalex.org/keywords/semantics","display_name":"Semantics (computer science)","score":0.6713186502456665},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.6615275144577026},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5784486532211304},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5287831425666809},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.44951486587524414},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.4470852017402649},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.42108309268951416},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4008549451828003},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.32060855627059937},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.20714205503463745}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7980533838272095},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7884942889213562},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.6713186502456665},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6615275144577026},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5784486532211304},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5287831425666809},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.44951486587524414},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.4470852017402649},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.42108309268951416},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4008549451828003},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.32060855627059937},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.20714205503463745}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3164541.3164584","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3164541.3164584","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 12th International Conference on Ubiquitous Information Management and Communication","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":12,"referenced_works":["https://openalex.org/W1544708267","https://openalex.org/W1554291310","https://openalex.org/W1964282769","https://openalex.org/W1973382888","https://openalex.org/W1996545223","https://openalex.org/W2029138494","https://openalex.org/W2093882190","https://openalex.org/W2103920867","https://openalex.org/W2113582770","https://openalex.org/W2586049562","https://openalex.org/W4206007682","https://openalex.org/W6633290818"],"related_works":["https://openalex.org/W1575529579","https://openalex.org/W2476511644","https://openalex.org/W1981673052","https://openalex.org/W3022423983","https://openalex.org/W4385834214","https://openalex.org/W1988380406","https://openalex.org/W2134231752","https://openalex.org/W12347151","https://openalex.org/W2163168510","https://openalex.org/W41949812"],"abstract_inverted_index":{"View":[0],"support":[1],"is":[2,94,189],"one":[3],"of":[4,9,18,34,42],"the":[5,40,50,56,62,72,76,121,144,166,181,190,199],"most":[6,77],"attractive":[7],"features":[8],"relational":[10,114,126,194],"databases":[11],"from":[12],"both":[13],"theoretical":[14,59,152],"and":[15,66,85,159],"practical":[16],"points":[17],"view.":[19],"However,":[20,130],"as":[21,49,151],"views":[22,43,101],"are":[23,154],"not":[24,176],"base":[25],"relations":[26],"stored":[27],"in":[28,104,135,139,198],"a":[29,38,45,83,125],"database":[30,115,127,195],"but":[31,91],"merely":[32],"definitions":[33],"queries":[35],"issued":[36],"to":[37,109,119,147,172],"database,":[39],"updatability":[41,93],"poses":[44],"difficult":[46],"dilemma":[47],"known":[48],"view":[51],"update":[52],"problem.":[53],"To":[54,112],"resolve":[55],"problem,":[57],"many":[58],"investigations,":[60],"namely,":[61],"syntactic,":[63],"semantic,":[64],"interactive,":[65],"intention-based":[67,73,122,167],"approaches":[68],"were":[69,102],"conducted,":[70],"with":[71],"approach":[74,123,168,182],"being":[75],"promising.":[78],"In":[79],"practice,":[80],"SQL-92":[81],"standardized":[82,103],"necessary":[84],"sufficient":[86],"condition":[87],"for":[88,99,124],"updatable":[89,100],"views,":[90],"its":[92,106],"limited.":[95],"Although":[96],"new":[97],"criteria":[98],"SQL:1999,":[105],"implementation":[107],"seemed":[108],"be":[110,170,178,184],"hard.":[111],"benefit":[113],"users,":[116],"we":[117,131,142],"aimed":[118],"implement":[120],"management":[128,196],"system.":[129],"faced":[132],"two":[133],"issues":[134],"doing":[136],"so.":[137],"Therefore,":[138],"this":[140],"study,":[141],"present":[143],"positive":[145],"solutions":[146],"these":[148],"problems.":[149],"First,":[150],"works":[153],"based":[155],"on":[156,162,186],"set":[157],"semantics":[158,174],"SQL":[160],"standards":[161],"bag":[163,173],"semantics,":[164],"whether":[165],"can":[169],"extended":[171],"or":[175],"should":[177,183],"investigated.":[179],"Second,":[180],"implemented":[185],"PostgreSQL,":[187],"which":[188],"prevalent":[191],"open":[192],"source":[193],"system":[197],"world.":[200]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}