{"title":"Delete operation in PostgreSQL for bitemporal tables","authors":"E. Soler, P. Mirabal, Cecilia Celestrín","doi":"10.1109/SCCC51225.2020.9281209","DOIUrl":"https://doi.org/10.1109/SCCC51225.2020.9281209","url":null,"abstract":"The development of applications and computer systems demands the management of historical, current, and future data, which contrasts with the classic databases where only current data is managed. The SQL: 2011 standard proposes application time, system time, and bitemporal tables for the management of temporal data, however, to date very few Database Management Systems (DBMS) offer support for temporary data. In this paper, we propose a modification of the native PostgreSQL DELETE operation for bitemporal tables that allows it to be aligned with the corresponding operation of the SQL: 2011 standard. The hooks offered by PostgreSQL allow interrupting and modifying the execution phases of an SQL query, on this base, it is established an architecture that allows defining the corresponding algorithm for the new delete operation. The architecture for bitemporal tables is supported by modifications of a previous PostgreSQL extension for the management of system time tables.","PeriodicalId":117157,"journal":{"name":"2020 39th International Conference of the Chilean Computer Science Society (SCCC)","volume":"46 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2020-11-16","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"115988842","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
R. Luna, M. Araya, José Caris, José Cuevas-Valenzuela
{"title":"A Digital Platform for the Management of Grapes and Wine Quality in the Winery","authors":"R. Luna, M. Araya, José Caris, José Cuevas-Valenzuela","doi":"10.1109/SCCC51225.2020.9281240","DOIUrl":"https://doi.org/10.1109/SCCC51225.2020.9281240","url":null,"abstract":"The management of industrial winemaking is a complex challenge since there is a lot of uncertainty from the vineyard to the winery. In particular, climate change has had a negative effect on the management of harvest dates and the winery's capacity. Digital tools like the Industrial Internet of things (IIoT) allow integrating the productive processes data and used it for decision-making. In addition, model-based design such as the machine learning approach and first-principle models can generate a computational tool to optimize the fermentation process's management. In this work, we developed a digital platform to manage grapes and wine quality in the winery. We defined, adapted, and implemented an infrastructure of IIoT to use the digital platform in the winery successfully. Finally, we validated the digital platform and the infrastructure of IIoT in a test pilot of the industrial scale during the 2020 harvest season.","PeriodicalId":117157,"journal":{"name":"2020 39th International Conference of the Chilean Computer Science Society (SCCC)","volume":"48 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2020-11-16","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"127384214","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
I. M. Rodríguez, R. Hernández-García, A. Hernández-Solís
{"title":"ANICCA, a computational tool for simulating nuclear fuel cycles","authors":"I. M. Rodríguez, R. Hernández-García, A. Hernández-Solís","doi":"10.1109/SCCC51225.2020.9281233","DOIUrl":"https://doi.org/10.1109/SCCC51225.2020.9281233","url":null,"abstract":"Fuel cycle simulation codes are tools developed and used worldwide to answer the many questions that arise in relation to the development or deployment of nuclear technology for electricity generation. In this context, ANICCA was developed by the Belgian Nuclear Research Center (SCK • CEN) as the tool in charge of answering these questions related to the Belgian nuclear fleet. However, the development of this tool has also turned towards research and application, expanding the range of its functionalities and technologies that can be modeled, to cover from the most basic to the most complex and advanced scenario strategies. Thus, this work presents the main features of the Nuclear Fuel Cycle Simulation Code, ANICCA, its development, operation, and future goals.","PeriodicalId":117157,"journal":{"name":"2020 39th International Conference of the Chilean Computer Science Society (SCCC)","volume":"42 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2020-11-16","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"121708566","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}