Pub Date : 2022-12-31DOI: 10.35429/joti.2022.18.6.1.10
Juan Fernando Hernández-Sánchez, Gregorio Castillo-Quiroz, Claudia Yadira Luna-Carrasco, Jacinto Torres-Jiméne
Currently, electrical installations of any kind must comply with minimum safety standards taken into account at the time of their construction and use. This article aims to present the design and construction of a series of practices as well as the design of a mobile application for the improvement of learning in the training of residential electrical installations of the "Mahatma Gandhi" High School of Xilocuautla, Huauchinango, Puebla, through a practice module "ElectriBasic App". The App will serve as a didactic support, since it is a graphic and technical instruction for students who wish to carry out practices related to residential electrical installations. With this module, students will be able to identify, through various previously organized practices, the types of connections and different types of accessory arrangements of a residential electrical installation, as well as identify concepts from basic to intermediate that they do not know within the topics of electricity.
{"title":"Design of an app for a module of practices of basic electrical installations","authors":"Juan Fernando Hernández-Sánchez, Gregorio Castillo-Quiroz, Claudia Yadira Luna-Carrasco, Jacinto Torres-Jiméne","doi":"10.35429/joti.2022.18.6.1.10","DOIUrl":"https://doi.org/10.35429/joti.2022.18.6.1.10","url":null,"abstract":"Currently, electrical installations of any kind must comply with minimum safety standards taken into account at the time of their construction and use. This article aims to present the design and construction of a series of practices as well as the design of a mobile application for the improvement of learning in the training of residential electrical installations of the \"Mahatma Gandhi\" High School of Xilocuautla, Huauchinango, Puebla, through a practice module \"ElectriBasic App\". The App will serve as a didactic support, since it is a graphic and technical instruction for students who wish to carry out practices related to residential electrical installations. With this module, students will be able to identify, through various previously organized practices, the types of connections and different types of accessory arrangements of a residential electrical installation, as well as identify concepts from basic to intermediate that they do not know within the topics of electricity.","PeriodicalId":197208,"journal":{"name":"Revista de la Invención Técnica","volume":"33 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2022-12-31","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"133018956","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}
Pub Date : 2022-12-31DOI: 10.35429/joti.2022.18.6.11.17
Rene Herrera-Velázquez, Jeovany Rafael Rodriguez-Mejia, Alfonso López-Mártine, M. Araiza-Esquivel
This paper presents the design and implementation of a speed control for BLDC motors; This is considered a high-capacity actuator mainly because of its operation, power, and control characteristics. BLDC motors require digital tools for good practices in position and speed control; as well as the power electronics for optimal performance. In order to take better advantage of the characteristics in this type of motor, a control strategy is presented that allows integrating the internet of things, to monitor and satisfy the needs when applied to a BLDC motor, which will also allow driving a submersible pump. Based on these characteristics, it will be possible to have a greater range of operation of the same, consequently, a better regulation of the speed, so that the desired water flow can be provided in the application of solar pumping systems. The results obtained validate the control designed for speed regulation in the system.
{"title":"Design and validation of a control for a BLDC motor to be applied on a solar water pump","authors":"Rene Herrera-Velázquez, Jeovany Rafael Rodriguez-Mejia, Alfonso López-Mártine, M. Araiza-Esquivel","doi":"10.35429/joti.2022.18.6.11.17","DOIUrl":"https://doi.org/10.35429/joti.2022.18.6.11.17","url":null,"abstract":"This paper presents the design and implementation of a speed control for BLDC motors; This is considered a high-capacity actuator mainly because of its operation, power, and control characteristics. BLDC motors require digital tools for good practices in position and speed control; as well as the power electronics for optimal performance. In order to take better advantage of the characteristics in this type of motor, a control strategy is presented that allows integrating the internet of things, to monitor and satisfy the needs when applied to a BLDC motor, which will also allow driving a submersible pump. Based on these characteristics, it will be possible to have a greater range of operation of the same, consequently, a better regulation of the speed, so that the desired water flow can be provided in the application of solar pumping systems. The results obtained validate the control designed for speed regulation in the system.","PeriodicalId":197208,"journal":{"name":"Revista de la Invención Técnica","volume":"52 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2022-12-31","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"128699862","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}
Pub Date : 2022-12-31DOI: 10.35429/joti.2022.18.6.18.26
This article will give the progress of the project of design of a device of alternative energy generation using piezoelectric, applied in the improvement of the lighting of an urban dwelling. Giving the background of the piezoelectric effect, a diagnosis of the conditions of the housing unit in terms of the energy demand for lighting, its vehicular capacity and road conditions, as well as the proposed solution to the demand for electrical energy, indicating the necessary electronic components in the first proposal and ending with the initial design and technical analysis, to conclude with the results of the research project. It is also important to consider that within the 13 modules that are required to form the speed reducer when a vehicle passes it will not pass through the 13 modules, but only a few, so the energy generated will also have variations in the results; unless a way is sought that when the vehicle passes over the reducer, all modules are pressed at the same time.
{"title":"Advances in the design of an alternative power generation device using piezoelectric","authors":"","doi":"10.35429/joti.2022.18.6.18.26","DOIUrl":"https://doi.org/10.35429/joti.2022.18.6.18.26","url":null,"abstract":"This article will give the progress of the project of design of a device of alternative energy generation using piezoelectric, applied in the improvement of the lighting of an urban dwelling. Giving the background of the piezoelectric effect, a diagnosis of the conditions of the housing unit in terms of the energy demand for lighting, its vehicular capacity and road conditions, as well as the proposed solution to the demand for electrical energy, indicating the necessary electronic components in the first proposal and ending with the initial design and technical analysis, to conclude with the results of the research project. It is also important to consider that within the 13 modules that are required to form the speed reducer when a vehicle passes it will not pass through the 13 modules, but only a few, so the energy generated will also have variations in the results; unless a way is sought that when the vehicle passes over the reducer, all modules are pressed at the same time.","PeriodicalId":197208,"journal":{"name":"Revista de la Invención Técnica","volume":"1 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2022-12-31","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"129769846","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}
Pub Date : 2022-12-31DOI: 10.35429/joti.2022.18.6.27.33
H. P. Martínez-Hernández, R. Cortés-Maldonado, R. Morales-Caporal, Alejandro Islas-Cerón
This work describes the design and implementation of the CO2 meter, operated with the PIC18F45K50 microcontroller; which detects the concentration of the gas in parts per thousand (ppm); also, this instrument has an-App downloaded on a mobile device with Android operating system, communicating with the microcontroller via Bluetooth. This to measure the concentration of CO2 which is a colorless gas compound of carbon and oxygen. The measurement of CO2 concentration is a strategy that can warn of the risk of COVID-19 contagion in an enclosed place where a group of people are gathered. In the return to classroom, because the risk of contagion by COVID-19, which is spread through CO2, persists. Also, there are very crowded places due to the daily activities developed by the human being, so now it is not a luxury to take care of the air we breathe to have a healthy life.
{"title":"Indoor CO2 monitoring system using a microcontroller via Bluetooth for coronavirus prevention","authors":"H. P. Martínez-Hernández, R. Cortés-Maldonado, R. Morales-Caporal, Alejandro Islas-Cerón","doi":"10.35429/joti.2022.18.6.27.33","DOIUrl":"https://doi.org/10.35429/joti.2022.18.6.27.33","url":null,"abstract":"This work describes the design and implementation of the CO2 meter, operated with the PIC18F45K50 microcontroller; which detects the concentration of the gas in parts per thousand (ppm); also, this instrument has an-App downloaded on a mobile device with Android operating system, communicating with the microcontroller via Bluetooth. This to measure the concentration of CO2 which is a colorless gas compound of carbon and oxygen. The measurement of CO2 concentration is a strategy that can warn of the risk of COVID-19 contagion in an enclosed place where a group of people are gathered. In the return to classroom, because the risk of contagion by COVID-19, which is spread through CO2, persists. Also, there are very crowded places due to the daily activities developed by the human being, so now it is not a luxury to take care of the air we breathe to have a healthy life.","PeriodicalId":197208,"journal":{"name":"Revista de la Invención Técnica","volume":"47 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2022-12-31","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"122660629","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}
Pub Date : 2022-06-30DOI: 10.35429/joti.2022.17.6.17.21
D. Talavera-Velázquez, J. M. Gutiérrez-Villalobos, E. Rivas-Araiza, E. Mejia-Beltran
The necessity to have semiconductor components inside mobile, thinner and lighter devices, has created a new form to solder these electronics components to their main boards. This work for soldering superficial mounting semiconductors has become a precision task. For that reason, nowadays, the construction of equipements to pick and place semiconductors, has got an important attention. A high accuracy aligning systems are required in those equipements. In this work, an aligning prototype for superficial soldering systems is presented, using a laser devise with a set of mirrors, and an aligning mechanic system, which is low-cost, modular and upgradeable.
{"title":"Aligning system for a pick-and-place BGA soldering equipment","authors":"D. Talavera-Velázquez, J. M. Gutiérrez-Villalobos, E. Rivas-Araiza, E. Mejia-Beltran","doi":"10.35429/joti.2022.17.6.17.21","DOIUrl":"https://doi.org/10.35429/joti.2022.17.6.17.21","url":null,"abstract":"The necessity to have semiconductor components inside mobile, thinner and lighter devices, has created a new form to solder these electronics components to their main boards. This work for soldering superficial mounting semiconductors has become a precision task. For that reason, nowadays, the construction of equipements to pick and place semiconductors, has got an important attention. A high accuracy aligning systems are required in those equipements. In this work, an aligning prototype for superficial soldering systems is presented, using a laser devise with a set of mirrors, and an aligning mechanic system, which is low-cost, modular and upgradeable.","PeriodicalId":197208,"journal":{"name":"Revista de la Invención Técnica","volume":"78 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2022-06-30","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"127486276","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}
Pub Date : 2022-06-30DOI: 10.35429/joti.2022.17.6.10.16
This work deals with the design and evaluation of a concentrator-luminoduct system for daylighting. A concentrator with a truncated cone profile was designed to capture, transfer and diffuse sunlight, which was concentrated and transported by reflection along the walls of the system and finally projected to the interior of an agricultural building. The illuminance achieved by the system with and without concentration was compared and a significant difference in illumination levels was found. The concentrator obtained concentration factors between 1.7 and 3.6. The critical aspects that determined the concentration of natural light were the angle of acceptance (45.68º), the orientation (45º and 90º) and the reflectance of the material used (95%), in addition, it was possible to reduce the dimensions of these systems, conserving the illuminance. It was proven that this system increased the illumination of the interior space where the light did not reach naturally, improving the illuminance levels (300-500 lx), according to CIE (Commission Internationale l'Eclarige). It was demonstrated that the system represents a viable and adaptable solution for naturally illuminating buildings.
{"title":"Solar concentrating and redirecting systems for application in an agricultural construction","authors":"","doi":"10.35429/joti.2022.17.6.10.16","DOIUrl":"https://doi.org/10.35429/joti.2022.17.6.10.16","url":null,"abstract":"This work deals with the design and evaluation of a concentrator-luminoduct system for daylighting. A concentrator with a truncated cone profile was designed to capture, transfer and diffuse sunlight, which was concentrated and transported by reflection along the walls of the system and finally projected to the interior of an agricultural building. The illuminance achieved by the system with and without concentration was compared and a significant difference in illumination levels was found. The concentrator obtained concentration factors between 1.7 and 3.6. The critical aspects that determined the concentration of natural light were the angle of acceptance (45.68º), the orientation (45º and 90º) and the reflectance of the material used (95%), in addition, it was possible to reduce the dimensions of these systems, conserving the illuminance. It was proven that this system increased the illumination of the interior space where the light did not reach naturally, improving the illuminance levels (300-500 lx), according to CIE (Commission Internationale l'Eclarige). It was demonstrated that the system represents a viable and adaptable solution for naturally illuminating buildings.","PeriodicalId":197208,"journal":{"name":"Revista de la Invención Técnica","volume":"142 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2022-06-30","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"116330702","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}
Pub Date : 2022-06-30DOI: 10.35429/joti.2022.17.6.22.28
Solar trackers have emerged as an alternative for increased solar energy collection for photovoltaic panels (PV). However, PV trackers could eventually fail or have unexpected changes during tracking, requiring continuous knowledge of the solar tracker parameters at any time. It is possible to accomplish with IoT communication, which consists of implementing microcontrollers, embedded computers and network communication to transmit the information to a server. This paper presents a monitoring scheme for two-axis single pole solar trackers. In contrast to the published papers in the state of the art, it has more functionality and greater flexibility, employing a Wi-Fi connection with the Raspberry PI 4B. This monitoring scheme has been experimentally tested using the motors for a two-axis single pole solar tracker, resulting in an excellent performance along their trajectories.
{"title":"Two Axis Solar Tracker Monitoring","authors":"","doi":"10.35429/joti.2022.17.6.22.28","DOIUrl":"https://doi.org/10.35429/joti.2022.17.6.22.28","url":null,"abstract":"Solar trackers have emerged as an alternative for increased solar energy collection for photovoltaic panels (PV). However, PV trackers could eventually fail or have unexpected changes during tracking, requiring continuous knowledge of the solar tracker parameters at any time. It is possible to accomplish with IoT communication, which consists of implementing microcontrollers, embedded computers and network communication to transmit the information to a server. This paper presents a monitoring scheme for two-axis single pole solar trackers. In contrast to the published papers in the state of the art, it has more functionality and greater flexibility, employing a Wi-Fi connection with the Raspberry PI 4B. This monitoring scheme has been experimentally tested using the motors for a two-axis single pole solar tracker, resulting in an excellent performance along their trajectories.","PeriodicalId":197208,"journal":{"name":"Revista de la Invención Técnica","volume":"12 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2022-06-30","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"116796481","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}
Pub Date : 2022-06-30DOI: 10.35429/joti.2022.17.6.1.9
Carmen Jeannette Sampayo-Rodríguez, Gregorio Castillo-Quiroz, Aldo Hernández-Luna, Iberio Cabrera-Hernández
This paper presents the design and construction of a machine that automates the process of selling access credentials to a wireless network. For its construction, the V methodology for project management was followed. The machine consists of a closed box with two buttons on the outside to indicate the start and end of the transaction, a 16x2 LCD screen with an I2c conversion interface to show transaction, user and password indications, a multi-currency purse and four LED lights that serve as indicators of the amount entered. Internally the machine consists of an ESP-8266-E development board, an Mb102 breadboard source module, a 12V 2.5A eliminator, a 5.0 V universal charger cube and a breadboard. Logically, the web-based spreadsheet (Google sheets), Google apps script and the Arduino integrated development environment were used. The result is a low-cost prototype, which provides controlled internet access credentials for multiple users.
{"title":"Design and construction of a token vending machine for wireless internet connection","authors":"Carmen Jeannette Sampayo-Rodríguez, Gregorio Castillo-Quiroz, Aldo Hernández-Luna, Iberio Cabrera-Hernández","doi":"10.35429/joti.2022.17.6.1.9","DOIUrl":"https://doi.org/10.35429/joti.2022.17.6.1.9","url":null,"abstract":"This paper presents the design and construction of a machine that automates the process of selling access credentials to a wireless network. For its construction, the V methodology for project management was followed. The machine consists of a closed box with two buttons on the outside to indicate the start and end of the transaction, a 16x2 LCD screen with an I2c conversion interface to show transaction, user and password indications, a multi-currency purse and four LED lights that serve as indicators of the amount entered. Internally the machine consists of an ESP-8266-E development board, an Mb102 breadboard source module, a 12V 2.5A eliminator, a 5.0 V universal charger cube and a breadboard. Logically, the web-based spreadsheet (Google sheets), Google apps script and the Arduino integrated development environment were used. The result is a low-cost prototype, which provides controlled internet access credentials for multiple users.","PeriodicalId":197208,"journal":{"name":"Revista de la Invención Técnica","volume":"49 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2022-06-30","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"128783888","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}
Pub Date : 2021-06-30DOI: 10.35429/joti.2021.15.5.22.25
F. Sandoval-Salas, Carlos Méndez-Carreto, Christell Barrales-Fernández, Graciela Ortega-Avila
The cheese industry produces a large amount of waste, the equivalent of 9L of cheese whey for every 10L of milk (Murari et al., 2018; Pendon et al., 2021; Sar et al., 2021). Whey is composed by lactose and proteins, mainly (Murari et al., 2018; Murari et al., 2019; Tesfaw et al., 2021). In most cases, cheese whey had not added value or specific use, being discarded and causing very important environmental implications (Maruri et al., 2018; Tesfaw et al., 2021; Sar et al., 2021). In the present study, the production of bioethanol from cheese whey were analyzed, using Kluyveromyces marxianus as inoculum, under continuous culture conditions (28°C, agitation at 100 rpm, aeration at 1 vvm, feed at 8.63 mL/min), where it was established that is possible to obtain yields of 0.62 g of ethanol per g of lactose in the first 18 h, this makes it feasible for the continuous production of ethanol with cheese whey with minimal pretreatment.
奶酪行业产生大量废物，相当于每10L牛奶产生9L奶酪乳清(Murari等人，2018;Pendon et al.， 2021;Sar et al.， 2021)。乳清主要由乳糖和蛋白质组成(Murari et al.， 2018;Murari等人，2019;Tesfaw et al.， 2021)。在大多数情况下，奶酪乳清没有附加价值或特定用途，被丢弃并造成非常重要的环境影响(Maruri等人，2018;Tesfaw等人，2021;Sar et al.， 2021)。在本研究中，以马氏克鲁维菌为接种物，在连续培养条件下(28°C, 100 rpm搅拌，1 vvm曝气，8.63 mL/min进料)，分析了奶酪乳清生产生物乙醇的情况，确定了在前18小时内每g乳糖可以获得0.62 g乙醇的产量，这使得用奶酪乳清连续生产乙醇成为可能。
{"title":"Bioethanol production of cheese whey in continuous culture","authors":"F. Sandoval-Salas, Carlos Méndez-Carreto, Christell Barrales-Fernández, Graciela Ortega-Avila","doi":"10.35429/joti.2021.15.5.22.25","DOIUrl":"https://doi.org/10.35429/joti.2021.15.5.22.25","url":null,"abstract":"The cheese industry produces a large amount of waste, the equivalent of 9L of cheese whey for every 10L of milk (Murari et al., 2018; Pendon et al., 2021; Sar et al., 2021). Whey is composed by lactose and proteins, mainly (Murari et al., 2018; Murari et al., 2019; Tesfaw et al., 2021). In most cases, cheese whey had not added value or specific use, being discarded and causing very important environmental implications (Maruri et al., 2018; Tesfaw et al., 2021; Sar et al., 2021). In the present study, the production of bioethanol from cheese whey were analyzed, using Kluyveromyces marxianus as inoculum, under continuous culture conditions (28°C, agitation at 100 rpm, aeration at 1 vvm, feed at 8.63 mL/min), where it was established that is possible to obtain yields of 0.62 g of ethanol per g of lactose in the first 18 h, this makes it feasible for the continuous production of ethanol with cheese whey with minimal pretreatment.","PeriodicalId":197208,"journal":{"name":"Revista de la Invención Técnica","volume":"1 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":"130060977","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}
Pub Date : 2021-06-30DOI: 10.35429/joti.2021.15.5.8.15
Luz María Hernández-Cruz, M. Castillo-Téllez, Martina Díaz-Rosado, Johan Oliver Chan-Chi
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.
本文提出了基于数据仓库技术的学术数据存储库的设计与构建方案。这项研究的倡议源于对大量数据的识别，以及将这些数据结合起来分析高等教育机构管理人员决策中的有关指标的重要性。应用研究提出了Hefesto v2.0方法的使用和实现，该方法能够逐步指导数据仓库的开发，确保其启动。作为附加价值，集成了新兴技术，特别是Microsoft SQL Server 2019和Visual Studio 2019。所公布的结果将作为一个应用研究案例，供信息系统管理员、行政人员和教育机构主任使用，他们希望执行战略，以优化和提高面向教育过程的数据分析的效率，以便为决策提供辨别相关结果。
{"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}
京公网安备 11010802042870号
京ICP备2023020795号-1
扫码关注我们
求助内容：
应助结果提醒方式：