Luz María Hernández-Cruz, M. Castillo-Téllez, Martina Díaz-Rosado, Johan Oliver Chan-Chi
{"title":"Design of an academic data repository applying data warehouse technology","authors":"Luz María Hernández-Cruz, M. Castillo-Téllez, Martina Díaz-Rosado, Johan Oliver Chan-Chi","doi":"10.35429/joti.2021.15.5.8.15","DOIUrl":"https://doi.org/10.35429/joti.2021.15.5.8.15","url":null,"abstract":"This article presents the proposal for the design and construction of an academic data repository under data warehouse technology. The initiative of the study arises from the identification of large volumes of data and the importance of combining them to analyze relevant indicators in decision-making by managers in higher-level educational institutions. The applied research proposes the use and implementation of the Hefesto v2.0 methodology capable of guiding step by step in the development of the data warehouse ensuring its start-up. As an added value, emerging technologies are integrated, particularly Microsoft SQL Server 2019 and Visual Studio 2019. The exposed results will serve as an applied study case for information systems administrators, administrative personnel and directors of educational institutions who wish to implement strategies with the aim of optimizing and make more efficient the analysis of data oriented to the benefit of educational processes that allow discerning relevant findings for decision-making.","PeriodicalId":197208,"journal":{"name":"Revista de la Invención Técnica","volume":"1171 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2021-06-30","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"113994977","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}
L. Y. Villagrán-Villegas, Xóchitl Siordia-Vásquez, M. Patiño-Ortiz, V. Velázquez-Martínez
{"title":"Methodology to carry out an analysis of damage caused by wear of blades of axial compressor on a marine gas turbine","authors":"L. Y. Villagrán-Villegas, Xóchitl Siordia-Vásquez, M. Patiño-Ortiz, V. Velázquez-Martínez","doi":"10.35429/joti.2021.15.5.1.7","DOIUrl":"https://doi.org/10.35429/joti.2021.15.5.1.7","url":null,"abstract":"The objective of this research was to reduce cost of maintenance in this equipment. Analysis on a blade of gas turbine was performed, which was in operation on an offshore platform. Compressor blade was exposed to a severe damage by the impact of particles and environmental pollutants such as salts, sands and sulphurs. In first stage of this analysis, a visual inspection with a borescope was effected. Images analysis was used to determine the typical failure modes. A tribological characterization was carried out. Chemical composition of the material of blades was obtained. Scanning electron microscopy (SEM) was used to measure chemical properties and evaluate degradation of surfaces of blades after 30,000 service hours. The points, where there are the points in which failures take place. Results showed wear modes were originated by a severe stinging action. Also, large craters, similar to those observed in solid particle erosion, were developed by at normal impact. In the same way it could be found some localized areas with corrosion and irregular scratches like plowing action, was observed; these are the points in which failures take place.","PeriodicalId":197208,"journal":{"name":"Revista de la Invención Técnica","volume":"2 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2021-06-30","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"133845747","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}