Migrating From MySQL to Hyperledger Fabric: a Framework for Modernizing the Water Billing System of Ginatilan, Cebu Philippines

Glicerio Baguia, Chris Jordan Aliac, Larmie Feliscuzo and Cherry Lyn Sta. Romana, Cebu Institute of Technology-University, Cebu City, Philippines

ABSTRACT

This research presents a structured framework for migrating the water billing system of the Municipality of Ginatilan, Cebu, from a traditional MySQL-based client-server architecture to a private blockchain environment using Hyperledger Fabric. Motivations for this migration include the need for enhanced security, transparency, and data integrity in public utility management. The framework outlines a step-by-step process involving data modeling, smart contract development, architectural redesign, and system integration. A detailed case study of Ginatilan’s water billing system demonstrates the practical application of this framework, addressing challenges such as data consistency, performance optimization, and scalability. The research concludes with a comparative analysis evaluating the efficiency, security, and transparency of the blockchain-based system relative to the original MySQL setup. The findings provide actionable insights for other municipalities and public utility providers considering similar modernization efforts through blockchain technology.

Keywords

MySQL Migration, Hyperledger Fabric, Water Billing System, Private Blockchain, Public Utility Management, Smart Contracts, Data Security and Transparency.

Research on the Capacity of Applying Blockchain at High-end Hotels in Vung Tau City

MA. Duong Vu Manh Duy, Faculty of Tourism - Nguyen Tat Thanh University

ABSTRACT

This study aims to evaluate the awareness of hotel managers in Vung Tau city towards the possibility of applying blockchain technology using the TAM model. Three methods are used: description, analysis and explanation. Field data were collected using a survey form through a questionnaire targeting random samples of department managers and their assistants in two random samples selected from 5-star hotels and 4-star hotels. stars in Vung Tau city. Field data were analyzed using the SPSS program. Hotel managers and their assistants have a very strong positive perception towards adopting blockchain technology due to its many unique applications, along with some natural concerns. The results confirm the need to apply blockchain technology because it will create a significant revolution and fundamental change in the hotel sector in Vietnam in general, Vung Tau in particular as well as in the world. This study is one of the first studies to mention the adoption and application of this very urgent new technology "Blockchain" in the hotel sector of Vietnam in general and Vung Tau city in particular. Blockchain will certainly create a significant competitive advantage for hotels in Vung Tau city.

Keywords

Blockchain, distributed ledger, nodes, hotel management, Vung Tau city.

Evaluating the Opportunities and Obstacles of Blockchain Technologyin Saudi Arabia: a Case Study of STC Pay in Modern Applications

Ahmed Abdallah Abaker, Applied College, Department of Computer Science, Imam Muhammad ibn Saud University Riyadh, Saudi Arabia

ABSTRACT

This researchaims to evaluate the opportunities and challenges related to blockchain technology, focusing on its implementation within STC Pay. The study examines blockchain technology's principles, benefits, and obstacles in Saudi Arabia. User feedback was collected via a questionnaire distributed to 100 participants for a comprehensive analysis. The analysis covers various aspects, including participant information, opportunities of blockchain technology, obstacles and challenges, solutions and strategies, and general feedback. The research provides valuable insights into how blockchain technology is transforming modern applications and highlights the barriers that must be addressed for successful adoption. It underscores significant challenges associated with blockchain technology and proposes effective ways to enhance STC Pay. The results emphasize the importance of clear communication and strategies.

Keywords

Blockchain Technology, Digital Payments, STC Pay, Saudi Arabia, Scalability, Privacy Concerns, Regulatory Compliance, Interoperability Challenges, Security, Transparency, Operational Efficiency.