{"id":"https://openalex.org/W3112026458","doi":"https://doi.org/10.1109/sccc51225.2020.9281209","title":"Delete operation in PostgreSQL for bitemporal tables","display_name":"Delete operation in PostgreSQL for bitemporal tables","publication_year":2020,"publication_date":"2020-11-16","ids":{"openalex":"https://openalex.org/W3112026458","doi":"https://doi.org/10.1109/sccc51225.2020.9281209","mag":"3112026458"},"language":"en","primary_location":{"id":"doi:10.1109/sccc51225.2020.9281209","is_oa":false,"landing_page_url":"https://doi.org/10.1109/sccc51225.2020.9281209","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2020 39th International Conference of the Chilean Computer Science Society (SCCC)","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/A5007770003","display_name":"Emilio Carlos L\u00f3pez Soler","orcid":"https://orcid.org/0000-0003-4003-6502"},"institutions":[{"id":"https://openalex.org/I255141171","display_name":"University of Matanzas","ror":"https://ror.org/04hk86037","country_code":"CU","type":"education","lineage":["https://openalex.org/I255141171"]},{"id":"https://openalex.org/I4399598445","display_name":"Universidad de Moa","ror":"https://ror.org/012ngjb50","country_code":null,"type":"education","lineage":["https://openalex.org/I4399598445"]}],"countries":["CU"],"is_corresponding":true,"raw_author_name":"Emilio Soler","raw_affiliation_strings":["Universidad de Matanzas, Cuba"],"affiliations":[{"raw_affiliation_string":"Universidad de Matanzas, Cuba","institution_ids":["https://openalex.org/I255141171","https://openalex.org/I4399598445"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5068205537","display_name":"Pedro Mirabal","orcid":"https://orcid.org/0000-0001-7345-6007"},"institutions":[{"id":"https://openalex.org/I2802558902","display_name":"Temuco Catholic University","ror":"https://ror.org/051nvp675","country_code":"CL","type":"education","lineage":["https://openalex.org/I2802558902"]}],"countries":["CL"],"is_corresponding":false,"raw_author_name":"Pedro Mirabal","raw_affiliation_strings":["Unversidad Cat\u00f3lica de Temuco, Chile"],"affiliations":[{"raw_affiliation_string":"Unversidad Cat\u00f3lica de Temuco, Chile","institution_ids":["https://openalex.org/I2802558902"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5044061857","display_name":"Cecilia Celestrin","orcid":null},"institutions":[{"id":"https://openalex.org/I4399598445","display_name":"Universidad de Moa","ror":"https://ror.org/012ngjb50","country_code":null,"type":"education","lineage":["https://openalex.org/I4399598445"]},{"id":"https://openalex.org/I255141171","display_name":"University of Matanzas","ror":"https://ror.org/04hk86037","country_code":"CU","type":"education","lineage":["https://openalex.org/I255141171"]}],"countries":["CU"],"is_corresponding":false,"raw_author_name":"Cecilia Celestrin","raw_affiliation_strings":["Universidad de Matanzas, Cuba"],"affiliations":[{"raw_affiliation_string":"Universidad de Matanzas, Cuba","institution_ids":["https://openalex.org/I255141171","https://openalex.org/I4399598445"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5007770003"],"corresponding_institution_ids":["https://openalex.org/I255141171","https://openalex.org/I4399598445"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.19917416,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"7"},"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.9998999834060669,"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.9998999834060669,"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.9991000294685364,"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/T11719","display_name":"Data Quality and Management","score":0.9957000017166138,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8257772326469421},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7989188432693481},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5696226358413696},{"id":"https://openalex.org/keywords/extension","display_name":"Extension (predicate logic)","score":0.5254273414611816},{"id":"https://openalex.org/keywords/base","display_name":"Base (topology)","score":0.4938376545906067},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.44511446356773376},{"id":"https://openalex.org/keywords/architecture","display_name":"Architecture","score":0.4361498951911926},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.43468135595321655},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.4185604453086853},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.35129064321517944},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.348967045545578},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.23684430122375488},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.2029390037059784},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.08238735795021057},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.060343265533447266}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8257772326469421},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7989188432693481},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5696226358413696},{"id":"https://openalex.org/C2778029271","wikidata":"https://www.wikidata.org/wiki/Q5421931","display_name":"Extension (predicate logic)","level":2,"score":0.5254273414611816},{"id":"https://openalex.org/C42058472","wikidata":"https://www.wikidata.org/wiki/Q810214","display_name":"Base (topology)","level":2,"score":0.4938376545906067},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.44511446356773376},{"id":"https://openalex.org/C123657996","wikidata":"https://www.wikidata.org/wiki/Q12271","display_name":"Architecture","level":2,"score":0.4361498951911926},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.43468135595321655},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.4185604453086853},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.35129064321517944},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.348967045545578},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.23684430122375488},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2029390037059784},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.08238735795021057},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.060343265533447266},{"id":"https://openalex.org/C142362112","wikidata":"https://www.wikidata.org/wiki/Q735","display_name":"Art","level":0,"score":0.0},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0},{"id":"https://openalex.org/C153349607","wikidata":"https://www.wikidata.org/wiki/Q36649","display_name":"Visual arts","level":1,"score":0.0},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/sccc51225.2020.9281209","is_oa":false,"landing_page_url":"https://doi.org/10.1109/sccc51225.2020.9281209","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2020 39th International Conference of the Chilean Computer Science Society (SCCC)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":9,"referenced_works":["https://openalex.org/W2078970516","https://openalex.org/W2083150957","https://openalex.org/W2116470353","https://openalex.org/W2271952601","https://openalex.org/W2294081347","https://openalex.org/W2332233654","https://openalex.org/W2399183044","https://openalex.org/W2906277631","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W1575529579","https://openalex.org/W1982455124","https://openalex.org/W2914183533","https://openalex.org/W1488984669","https://openalex.org/W151494989","https://openalex.org/W3022423983","https://openalex.org/W2614112517","https://openalex.org/W2108932068","https://openalex.org/W1980548249","https://openalex.org/W2340883001"],"abstract_inverted_index":{"The":[0,28,91,126],"development":[1],"of":[2,10,43,67,86,103,135,143],"applications":[3],"and":[4,13,37,98],"computer":[5],"systems":[6],"demands":[7],"the":[8,19,41,68,83,87,100,118,122,141],"management":[9,42,142],"historical,":[11],"current,":[12],"future":[14],"data,":[15,45],"which":[16],"contrasts":[17],"with":[18,82],"classic":[20],"databases":[21],"where":[22],"only":[23],"current":[24],"data":[25],"is":[26,111,131],"managed.":[27],"SQL:":[29,88],"2011":[30,89],"standard":[31],"proposes":[32],"application":[33],"time,":[34,36],"system":[35,144],"bitemporal":[38,74,129],"tables":[39,75,130],"for":[40,57,73,121,128,140],"temporal":[44],"however,":[46],"to":[47,79],"date":[48],"very":[49],"few":[50],"Database":[51],"Management":[52],"Systems":[53],"(DBMS)":[54],"offer":[55],"support":[56],"temporary":[58],"data.":[59],"In":[60],"this":[61,108],"paper,":[62],"we":[63],"propose":[64],"a":[65,136],"modification":[66],"native":[69],"PostgreSQL":[70,95,138],"DELETE":[71],"operation":[72,85],"that":[76,115],"allows":[77,116],"it":[78,110],"be":[80],"aligned":[81],"corresponding":[84,119],"standard.":[90],"hooks":[92],"offered":[93],"by":[94,133],"allow":[96],"interrupting":[97],"modifying":[99],"execution":[101],"phases":[102],"an":[104,113],"SQL":[105],"query,":[106],"on":[107],"base,":[109],"established":[112],"architecture":[114,127],"defining":[117],"algorithm":[120],"new":[123],"delete":[124],"operation.":[125],"supported":[132],"modifications":[134],"previous":[137],"extension":[139],"time":[145],"tables.":[146]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}