Database Storage Research Articles

Migrating data from document-oriented database to graph-oriented database

In data migration between different types of NoSQL databases, data may not be directly transferred to the targeted database compared to migration of data between the same types of database. This is due to the heterogeneity of the storage paradigm of the NoSQL databases. For example, when migrating data from a document-oriented database such as MongoDB, which stores data in JSON (Java Object Notation) format to Neo4j, a graph-oriented database stores data in nodes, the differences among these databases’ storage paradigms require different representations of the data model in the targeted graph-oriented database. This paper proposed a sequential approach to migrate data from MongoDB to Neo4j. The approach migrates MongoDB data to Neo4j and verifies the migrated data using a comparative method. The paper discusses the migration algorithm and how complex fields in MongoDB, such as nested documents, are presented in Neo4j.

Integrated Information System for 3D Interactive Reconstruction of an Archaeological Site

Archaeological recording is intended to preserve as much information as possible about the finds. However, once the pieces are removed from the site, there is information regarding the original positioning of these pieces that may be lost or not accurately recorded and can be relevant for further studies. This spatial arrangement can also be crucial for subsequent piece restoration or to understand certain aspects of ancient cultures. In this article, we describe a software prototype and a methodology to virtually reconstruct an archaeological site for posterity, once it has been excavated. The system is implemented with a client-server architecture. In the server, a spatial database stores and manages the three-dimensional (3D) models of the finds, as well as several 3D site ground surface models acquired at different times during the excavation process. On the client side, a graphical interface allows the user to manipulate the find models to re-create and virtually reconstruct the original spatial arrangement of the archaeological site. Topological relationships among the finds are stored in the database to provide further spatial analysis. The result is an integrated information system that goes beyond 3D visualization, making the site last for posterity after its excavation and allowing further spatial analysis.

RESEARCH OF METHODS OF SOFTWARE IMPLEMENTATION OF THE COSMOS DB API ON THE .NET PLATFORM

Large number of developers use the .NET platform to create applications that work with databases today. In turn, Cosmos DB is becoming an increasingly popular choice as a NoSQL storage for such databases. Cosmos DB is a flexible and scalable system, and the correct selection of the appropriate API during software implementation can significantly affect the performance of the programs themselves. Cosmos DB provides different APIs for working with different types of databases, such as SQL databases, running MongoDB or Cassandra. In turn, each of these APIs can be used using various methods of software implementation. The subject of research is software implementations on the .NET platform for various Cosmos DB APIs. When choosing the most suitable Cosmos DB API on the .NET platform, developers can be helped not only by the documentation, but also by the results of experimental studies of these APIs, which in turn will improve the quality of the code and the performance of the systems themselves. The goal of the work is to increase the efficiency of software development on the .NET platform. That use the Cosmos DB API, by developing a recommendation for the selection of software implementation methods for these APIs based on the results of their experimental research. The task: to investigate and compare the methods of software implementation of the Cosmos DB API through an experimental study of the performance of different types of queries on these software solutions; analyze the obtained results and develop recommendations for the use of methods. Methods: multi-criteria analysis of Cosmos DB API, logical data modeling, experimental research. Results: developed software solutions based on the use of CosmosClient, Entity Framework Core for Cosmos DB API for NoSQL and based on MongoClient for Cosmos DB API for MongoDB. A series of experiments and measurements of performance metrics for each of the software solutions were conducted, the obtained results were analyzed, and recommendations were offered for using the considered methods of software implementations of the Cosmos DB API on the .NET platform. Conclusion: In general, the choice of software approach depends on the specific task, but experiments have shown that CosmosDB API for NoSQL using CosmosClient is the best choice for small projects, and using the Entity Framework Core Cosmos is suitable for more complex projects with larger volumes of data and complex queries. If MongoDB is used in the project, then the corresponding solution using MongoClient is a better option than Cosmos DB API for NoSQL.

CDSBen: Benchmarking the Performance of Storage Services in Cloud-Native Database System at ByteDance

In this work, we focus on the performance benchmarking problem of storage services in cloud-native database systems, which are widely used in various cloud applications. The core idea of these systems is to separate computation and storage in traditional monolithic OLTP databases. Specifically, we first present the characteristics of two representative real I/O workloads at the storage tier of ByteDance's cloud-native database veDB. We then elaborate the limitations of using standard benchmarks such as TPC-C and YCSB to resemble these workloads. To overcome these limitations, we devise a learning-based I/O workload benchmark called CDS-Ben. We demonstrate the superiority of CDSBen by deploying it at ByteDance and showing that its generated I/O traces accurately resemble the real I/O traces in production. Additionally, we verify the accuracy and flexibility of CDSBen by generating a wide range of I/O workloads with different I/O characteristics.

Guarantee of Protection of Electronic Land Certificates as Proof of Ownership of Land Rights

Changes in information technology have an impact on the public service system, especially in the land sector which is experiencing a transition from Analog Certificates to Electronic Certificates which raises several challenges, one of which is in the field of law, in practice the power of law because electronic information and transactions cannot be used as evidence, but must meet certain requirements. The purpose of this research is to find out and analyze the legal force of Electronic Land Certificates and to find out the efforts made by the government to protect the Electronic Land Certificate system. The research method used is the Normative Juridical Approach. The results of this study are the legal protection of electronic certificates in proving that they have a position as legal electronic evidence have been recognized in the procedural law system in Indonesia, and have strong legal force. Electronic Land Certificates require a legal umbrella governing the use of Blockchain technology contained in the ITE Law to be delegated to an implementing regulation. This study concludes that Electronic Certificates have the same legal force as Analog Certificates. As an effort to support the use of Electronic Certificates, the government's role is needed in formulating laws that regulate the substance of the use of technology in electronic certificate database storage systems.

Web-based Product Marketing Information System for MSMEs Tanggulangin Wallet and Bag Manufacturers

The existence of MSMEs has an influence on improving people's welfare which can provide many business opportunities for the community. However, MSMEs currently have weaknesses in marketing their products, moreover they are still carrying out a manual marketing strategy using the method of making brochures, pamphlets and promoting their products in several stores. At the present time it is not easy to do marketing, the lack of the role of internet technology which can hinder MSMEs in terms of marketing their products. So that the business can develop and get maximum results, of course the role of internet technology is also very important for MSMEs in developing their business products. One way is to build an information system with PHP and MySQL programming as database storage. The end result of this research is the advantage of an information system that is useful for the long term with the aim of facilitating online marketing and sales to be able to expand market reach.

BSafe-360: An All-in-One Naturalistic Cycling Data Collection Tool.

The popularity of bicycles as a mode of transportation has been steadily increasing. However, concerns about cyclist safety persist due to a need for comprehensive data. This data scarcity hinders accurate assessment of bicycle safety and identification of factors that contribute to the occurrence and severity of bicycle collisions in urban environments. This paper presents the development of the BSafe-360, a novel multi-sensor device designed as a data acquisition system (DAS) for collecting naturalistic cycling data, which provides a high granularity of cyclist behavior and interactions with other road users. For the hardware component, the BSafe-360 utilizes a Raspberry Pi microcomputer, a Global Positioning System (GPS) antenna and receiver, two ultrasonic sensors, an inertial measurement unit (IMU), and a real-time clock (RTC), which are all housed within a customized bicycle phone case. To handle the software aspect, BSafe-360 has two Python scripts that manage data processing and storage in both local and online databases. To demonstrate the capabilities of the device, we conducted a proof of concept experiment, collecting data for seven hours. In addition to utilizing the BSafe-360, we included data from CCTV and weather information in the data analysis step for verifying the occurrence of critical events, ensuring comprehensive coverage of all relevant information. The combination of sensors within a single device enables the collection of crucial data for bicycle safety studies, including bicycle trajectory, lateral passing distance (LPD), and cyclist behavior. Our findings show that the BSafe-360 is a promising tool for collecting naturalistic cycling data, facilitating a deeper understanding of bicycle safety and improving it. By effectively improving bicycle safety, numerous benefits can be realized, including the potential to reduce bicycle injuries and fatalities to zero in the near future.

Web-Based Inventory and Sales Information System: Indonesian Micro Small Medium Enterprise Case Study

Information systems have a very important role in increasing productivity values that provide effectiveness and efficiency in the business sector. Cik Cik MSME Meatshop and Frozenfood is still using a manual system for recording their inventory and sales data, which causes several problems such as human error, human fraud, and inaccurate data. To overcome the problems, a solution is provided, that is a web-based information system, focused on the inventory and sales business processes. The information system is designed using Rapid Application Development method. The tools used are XAMPP as a web server and Visual Studio Code as a code editor. The programming language to be used is PHP, CodeIgniter as a framework, and MySQL as a database storage. The results obtained from the development of this information system are this system can help Cik Cik MSME Meatshop and Frozenfood in overcoming problems related to sales and inventory become easier to manage the data so that it is more automated compared to the previous manual system.

Digitalisasi Pengelolaan Pustaka Sekolah

Along with the development of science and the globalization of information that demands the creation of an all-computerized state. At SMA Negeri 4 Tualang, Siak Regency, the process of processing library data to making reports still uses manual bookkeeping. This can cause the process of searching for book data, member data and book borrowing data to take a long time and not to mention if the data is lost so it cannot be used again. Library applications are made according to user needs using the PHP programming language with MySQL database storage and Waterfall modeling. This library application has been tested with the black box method with 100% results then implemented and measured with values and measuring indicators as follows: User Satisfaction = 94%, Data Accuracy = 93%, Speed and convenience = 96%, Application and information security = 93 % and Support = 96%. Thus the digitization of library management is very beneficial for library managers and students as users at SMAN 4 Tualang

Car-Economics: Forecasting Prices in the Pre-Owned Market Using Machine Learning

The purchase price of a new car and a few additional costs are determined by the company that makes the vehicle. Used vehicle sales are increasing globally as a result of rising new car prices and people’s unwillingness to afford them. This strategy is successful since the vendor often sets the price impulsively and the buyer normally isn’t aware of all the features and the car’s market value. According to research, figuring out a used car’s fair market value is both difficult and important. Consequently, it is necessary to create a precise method for estimating used automobile cost. In this case, machine learning prediction approaches could be helpful. The model has to be trained on the massive dataset using techniques like random forest and decision tree before it can be used. Our primary objective is to develop a model that, given the information provided by the client, can accurately and dependably anticipate the selling price of a used car. In this project, our team designed a stunning User Interface (UI) that asks customers for comments and provides pricing estimates. The database stores both the user inputs and the predicted cost of the automobile.

Cloud computing and machine learning for analysis of health care data based on neuro fuzzy logistic regression

Healthcare data is the most sensitive information for processing through machine learning and cloud computing in the various healthcare organizations. Electronic Health Record (EHR) manipulation are now on the rise, and we need to focus on using the data generated by the healthcare applications. Many sensitive data are associated with various health care domains, particularly neurology and cardiology. Previous approaches, such as manual data records, had significant disadvantages, and hence disease prediction based on the above records was found ineffective resulting with improper diagnosis on the patients. These data records require special attention, and current frameworks focused on these areas must implement sophisticated technologies to predict specific patterns. To address the above concerns, the proposed work incorporates the integration of Neuro Fuzzy Logistic Regression (NFLR) machine learning algorithm and cloud computing storage management to solve these problems. The usage of cloud storage reduces data duplication while handling the storage of EHRs where the proposed ML algorithm accurately predict the disease. In the proposed research, the features are extracted using a specific algorithm –Self-organizing Clustering (SOC) which forms a clustered data with highest weight. To select the maximum number of features, and to predict the disease risk factors, the S2NO algorithm and NFLR algorithms are used in this work. Further, the database storage estimation with fuzzy rules, logistic analysis, and other benefits such as experimental learning of different ML tools, data privacy constraints related to healthcare are considered in this paper.

The Design of Web Based Information System for 'Bintang Multi Sparepart Store'

The advancements in information technology have provided many conveniences in the process of recording and reporting. Bintang Multi Sparepart Store is a business that sells automotive supplies. Its business process is divided into product sales, product stock fulfilment, and sales report creation. Based on the ongoing business process, sales recordings are done manually with a book, which increases the risk of errors due to spills and dirt on the book, tears, and human error. This results in inaccurate sales report calculations. Information about product availability also often has errors due to inaccurate information. In view of the problems that are occurring, this study designed an integrated information system that can collect, store, and process data to produce accurate information by applying the System Development Life Cycle (SDLC) principles, programming language PHP and MySQL for database storage, and through unit testing, integration testing, system testing, and acceptance testing. The designed information system is operating well, and the entire process in the information system meets the user's needs in terms of functionality and usability. The implementation of the proposed information system allows the owner to monitor all business processes, including transaction data and product data. The proposed information system is also capable of storing, summarizing, and presenting the entire sales transaction data in real time. In addition, the designed information system can process calculation on transaction data to be presented in the form of an accurate sales report, and there is a manual to make the information system operation process easier.

Lectura y almacenamiento de recursos bibliográficos empleando tecnología RFID de ultra alta frecuencia con internet de las cosas

Libraries supervisors have the administrative duty of control and keep safe their inventories, such as books, documents, manuals, and theses, facilitating access to their users to this information and helping them loan and return, internal or external, in case it’s permitted. We wanted to design and build a prototype for a device capable of complementing these tasks in a low cost. We go through the processes in the design of a prototype for a simultaneous Radio Frequency Identification Reader using Ultra High Frequencies with Internet of Things technologies for data storage and communication between multiple stations, to do so we use a decision matrix method to select hardware tools, and software programming languages and libraries, needed to build such device, comparing, and weighting the characteristics that fit our needs. The resulting hardware selection was the Raspberry Pi and the RedBoard with a 59,7% and 12,4% respectively, and NodeJS with WebSockets for the software selection with a 53,8%. Finally, we present the designed architecture and a working prototype of the device that was built. Obtained response times from the reader and the database storage were as low as 10 milliseconds and as high as 20 milliseconds.

Cloud-Based Monitoring System for Foam Content at the Wellhead of Foam Drainage Gas Production

To achieve automatic online monitoring of foam content in wellhead pipelines during the foam drainage gas production of shale gas, a cloud-based monitoring system for the foam content at the wellhead of foam drainage gas production is proposed. The system mainly comprises a terminal foam content detection sensor and a cloud platform, which relies on a wireless network for data communication. In this system, the foam content detection sensor uses the absorption of infrared light by the foam in the pipeline as a basic detection principle. Furthermore, the sensor uses signal-processing circuits to convert infrared light of different intensities into model voltage signals of different sizes and uses LoRa wireless networks to transfer the measurement data to a server for storage in a time-series database while displaying real-time foam content data on a web page. The monitoring system was tested in a field, and the relationship model between the foam content and the detection voltage signal was fitted based on the test data. Based on this model, and then tested and compared with the manual sampling results, the results of the 40 data samples tested showed that the monitoring system was effective and met the field working conditions. The foam content calculated by the fitted model compared with the manually measured foam content showed an error range of 0.11%–15.37%. The test results show that the system has functional requirements to monitor foam content in the field, contributing to the automation, networking, and cloud-based monitoring of the foam content at the wellhead.

DISTRIBUTION SERVICE PERFORMANCE OPTIMIZATION OF PDAM TIRTA TAMAN BONTANG CITY EAST KALIMANTAN PROVINCE

To achieve the level of service performance from PDAM Tirta Taman Kota Bontang , obtained based on user perceptions of PDAM Taman Tirta obtained from the results of a questionnaire with a Likert scale using the Importance Performance Analysis (IPA) method. From the results of the IPA analysis, interviews were then conducted using the Strength Weakness Opportunities Threats (SWOT) method . The results of the IPA analysis were used in quadrant I, namely service to the registration process (x11), survey of prospective customer locations (x12), time of survey implementation (x13) , Payment orders before installation (x15), Notice the length of the installation process (X15). Registration up to installation (X16), the supplied water meets health standards, attributes (X21 ), the quality of the supplied water (color, smell, taste) (X22) , report to PDAM Tirta Taman if there is a disturbance or it doesn't work smoothly (x 33 ), the duration of handling the damage house connection (x 43 ), customer or prospective customer database of PDAM Tirta Taman (x 71 ). Then the SWOT quadrant matrix with the SO ( Strengths-Opportunities ) strategy, namely development with IT and with social media Periodic pipe rejuvenation to avoid pipe leaks that can affect quality, Providing Customer Service via WhatsApp for service notifications, disruptions and payment orders, Issuing SOPs new and regular schedule for maintenance., Continue to perform security updates on the database storage system , Use of official forms for prospective customers with the interest of installing a new connection

CRS (Computer Reservation Systems) like Ticketmaster shifting to nuanced Data Models and NoSQL Architectures

Abstract - This paper examines the paradigm shift from RDBMS (Relational Database Management Systems) to NoSQL (Not Only SQL) databases in the context of Computer Reservation Systems (CRS) such as Ticketmaster. CRS are systems that handle travel-related service bookings such as airline tickets, car rentals, and hotel reservations. Ticketmaster, a leading company in the online ticket booking industry, has adopted NoSQL databases and other distributed database solutions to improve its platform’s scalability, flexibility, and performance. This paper discusses the advantages of NoSQL databases over RDBMS, specifically in the areas of scalability, flexibility, performance, and cost-effectiveness. Furthermore, this paper proposes a wide-column store database as the most suitable type of NoSQL database for a CRS such as Ticketmaster. The advantages of a wide-column store database include horizontal scaling, schema-free data modelling, high-performance read-and-write operations, and cost-effectiveness.

Crime Record Management System

The Crime Record Management System is a web-based application designed to improve the management of crime records across all police stations in the country. Effective crime prevention, detection, and conviction rely heavily on a responsive information management system. Therefore, centralizing information management in crime is proposed for the efficient sharing of crucial information among police stations. Initially, the system will be implemented in cities and towns and later interconnected to enable police staff to access information from all records in the state, ultimately helping to close cases faster. The system will also generate information for proactive and preventive measures to fight crime. The project will adopt a distributed architecture with a centralized database storage system, with high priority given to security and data protection mechanisms. The application is designed to handle various modules and their associated reports, produced in line with the administrative staff's applicable strategies and standards. In summary, the Crime Record Management System is a web-based application that aims to improve the management of crime records across police stations in the country. The system is designed to centralize information management, generate crucial information for crime prevention, and provide efficient and fast access to records. The project adopts a distributed architecture with centralized database storage, prioritizing data protection and security mechanisms while producing reports that align with applicable administrative strategies and standards

Compact Back-End Electronics with Temperature Compensation and Efficient Data Management for In Situ SiPM-Based Radiation Detection.

A compact back-end interface for silicon photomultipliers (SiPMs) implementing Zener diode-based temperature compensation has been developed for the remote detection of beta and gamma radiation. Remote detection is facilitated by the development of an efficient data management system utilising MySQL database storage for recording periodic spectra data for wireless access over a private Wi-Fi network. A trapezoidal peak shaping algorithm has been implemented on an FPGA for the continuous conversation of pulses from the SiPM, signifying the detection of a radiological particle, into spectra. This system has been designed to fit within a 46 mm cylindrical diameter for in situ characterization, and can be attached to one or more SiPMs used in conjunction with a range of scintillators. LED blink tests have been used to optimise the trapezoidal shaper coefficients to maximise the resolution of the recorded spectra. Experiments with an array of SiPMs integrated with a NaI(Tl) scintillator exposed to sealed sources of Co-60, Cs-137, Na-22 and Am-241 have shown that the detector achieves a peak efficiency of 27.09 ± 0.13% for a gamma peak at 59.54 keV produced by Am-241, and a minimum energy resolution (Delta E/E) of 4.27 ± 1.16% for the 1332.5 keV gamma peak from Co-60.

SISTEM INFORMASI AKUNTANSI PERSEDIAAN BAHAN BAKU BANGUNAN BERBASIS WEB

PT. Bintang Mataram Sejahtera Semarang is a company engaged in the field of housing construction contractors. In carrying out its business, the company has a project warehouse near the project that is being worked on for storage of materials while working on the project, the project warehouse is located to move according to the project being worked on. The problem faced is that the recording of material inventory is still done manually using the goods control stock card then after it is recorded it is entered into Microsoft Excel, this causes a long time for recording material data stocks because you have to open the parts one by one or sheet per sheet beforehand to make reports. and can hinder reporting to company leaders.This study aims to produce a system that can speed up the process of recording inventory of building material stock in the construction project warehouse, and can generate various material inventory reports that can control the availability of material inventory in the project warehouse. The method used is the Perpetual Inventory System, namely material management is carried out by controlling the stock of material inventory directly per period continuously updating the stock every time material comes in and material goes out. A web-based building material inventory information system with the PHP programming language and supported by MySQL database storage is urgently needed to assist administration, foremen and project leaders to speed up various material inventory control reports that are fast, accurate and thorough and can improve officer performance in presenting report.

Kombinasi Algoritma Kriptografi Vigenere Cipher dan SHA256 untuk Keamanan Basis Data

An organization must consider and manage the security of data storage in databases or databases, and special procedures are needed to protect data from various security risks. The problem in this study is that the population data contained in the Girisuko village administrative service information system has not been encrypted or secured. This can pose a risk that the data stored in the database can be intercepted and misused. In this study, the cryptographic technique used was a combination of the Vigenere Cipher and SHA 256 algorithms to secure or encrypt databases, especially population data in the Girisuko village administrative service information system. The text in the database is encrypted using the Vigenere Cipher, and SHA-256 is used to generate a hash value or a random value that is different from the text in the database. Messages will be encrypted using the Vigenere Cipher and then hashed with SHA-256 simultaneously. As a result, it will be difficult for an attacker to decrypt the text stored in the database because they have to break the Vigenere Cipher encryption, and also have to solve the hash value generated using SHA-256. This combination aims to increase security and maintain the confidentiality of messages from attackers. The application of the Vigenere Cipher and SHA to the village administration service information system application with a real-time database works well, as evidenced by the fast running-time of 0.39 seconds the data encryption process uses the Vigenere Cipher with 894,968 keys/second and an analyzed key length of 7 characters then text on population database successfully secured. By conducting this research, it is hoped that it can contribute to improving database system security.