Database Storage Research Articles

5G-Oriented IoT Big Data Analysis Method System

The application degree and application scope of 5G Internet of Things technology and big data analysis technology are becoming wider and wider, bringing opportunities for the development of traditional enterprises and providing technological innovation support for the development of new enterprises. Based on 5G Internet of Things technology and big data technology, this paper designs and studies an intelligent agricultural monitoring platform. We collect crop growth data and monitor crop growth status through this platform to study the 5G-oriented IoT big data analysis method system. This paper studies the data collection and storage issues involved in the huge agricultural IoT data environment. This article analyzes the specific sources of agricultural big data, the specific methods of data collection, and the methods of various database storage technologies. Combining wireless sensor network technology, large-source data processing technology, and distributed data storage technology, a method is proposed to solve the problem of rural Internet data collection and storage in the big data environment. This paper proposes a spatiotemporal block processing TSBPS to store the first detection data. The method uses spatiotemporal preblocking, data compression, and caching to significantly improve the recording speed of near real-time storage and microdetection data. In the experimental part of this article, experiments are carried out on the key parts of the IOT-HSQM system model that may limit storage or query performance. Experimental results show that this article compares TSBPS and direct writing methods. The maximum write speed increased by 79%, and the average write speed increased by 42%. The IOT-HSQM system model can meet the requirements of compiling and query performance and statistical analysis.

PERANCANGAN APLIKASI SISTEM INFORMASI PENJUALAN RUMAH BERBASIS MOBILE WEB DENGAN METODE STRING MATCHING (STUDI KASUS: BUANA PROPERTI)

Buana Property is one of the developers in the housing sector or is engaged in the business of selling, buying, and renting property. Advances in technology make Buana properties that always want to grow and be better known in the community with the construction of a mobile commerce system. So far, the system at Buana Properti is still a physical store that is offline so it is not well known to the public, there is no housing sales information system that uses a mobile web system. Therefore, this system is needed to simplify the process of selling housing at Buana Properti Medan which makes it easier for buyers to make house purchases at Buana Property. The system built will also provide a home search feature where this search feature is built using the String Matching method with the Knuth-Morris Pratt (KMP) model. The system that has been built itself uses HTML and PHP programming languages ​​in building mobile web and MySQL as a place database storage. The results of this study are that this system can assist buyers in finding homes that match their wishes and make purchase and payment transactions more easily.

Improving the support for XML dynamic updates using a hybridization labeling scheme (ORD-GAP).

Background: As the standard for the exchange of data over the World Wide Web, it is important to ensure that the eXtensible Markup Language (XML) database is capable of supporting not only efficient query processing but also capable of enduring frequent data update operations over the dynamic changes of Web content. Most of the existing XML annotation is based on a labeling scheme to identify each hierarchical position of the XML nodes. This computation is costly as any updates will cause the whole XML tree to be re-labelled. This impact can be observed on large datasets. Therefore, a robust labeling scheme that avoids re-labeling is crucial. Method: Here, we present ORD-GAP (named after Order Gap), a robust and persistent XML labeling scheme that supports dynamic updates. ORD-GAP assigns unique identifiers with gaps in-between XML nodes, which could easily identify the level, Parent-Child (P-C), Ancestor-Descendant (A-D) and sibling relationship. ORD-GAP adopts the OrdPath labeling scheme for any future insertion. Results: We demonstrate that ORD-GAP is robust enough for dynamic updates, and have implemented it in three use cases: (i) left-most, (ii) in-between and (iii) right-most insertion. Experimental evaluations on DBLP dataset demonstrated that ORD-GAP outperformed existing approaches such as ORDPath and ME Labeling concerning database storage size, data loading time and query retrieval. On average, ORD-GAP has the best storing and query retrieval time. Conclusion: The main contributions of this paper are: (i) A robust labeling scheme named ORD-GAP that assigns certain gap between each node to support future insertion, and (ii) An efficient mapping scheme, which built upon ORD-GAP labeling scheme to transform XML into RDB effectively.

The Development of Web-Based Health Center Management Information System at Puskesmas Pinarik Using Codeigniter Framework

Information systems are one of the fields of science within the computer science family where technically it refers more to business processes and management of an application to the sustainability of business processes of institutions, industries or organizations. The need for information systems in the industrial world is increasing along with the development of technology which has very significantly grown, many models and technologies are offered to simplify the processes that take place in companies or in agencies to reduce and minimize errors and human-errors. This is also felt by a government agency in Batang Lubu Sutam District, where there is a Puskesmas that is still very overwhelmed in the administrative process because it has not utilized technology in managing the processes in the Puskesmas, both in terms of patient registration and other related processes. . The need for a Management Information System is the right solution for the Pinarik Health Center to improve the quality of service and administrative systems at the Puskesmas. In addition to speeding up the administrative process, the existence of a Management Information System will make it easier for patients visiting because the entire process has been systemised. The Management Information System that will be built at the Pinarik Health Center will use a web-based platform using the MVC (Model View Controller) model with the Code Igniter framework and MySQL as the database storage medium. It is hoped that with the Information Management System the administrative process of the Pinarik Health Center will be effective and efficient and provide convenience both for patients and for the Puskesmas itself in particular.

Design and implementation of a practical quality control program for dual-energy CT.

A novel routine dual‐energy computed tomography (DECT) quality control (QC) program was developed to address the current deficiency of routine QC for this technology. The dual‐energy quality control (DEQC) program features (1) a practical phantom with clinically relevant materials and concentrations, (2) a clinically relevant acquisition, reconstruction, and postprocessing protocol, and (3) a fully automated analysis software to extract quantitative data for database storage and trend analysis. The phantom, designed for easy set up for standalone or adjacent imaging next to the ACR phantom, was made in collaboration with an industry partner and informed by clinical needs to have four iodine inserts (0.5, 1, 2, and 5 mg/ml) and one calcium insert (100 mg/ml) equally spaced in a cylindrical water‐equivalent background. The imaging protocol was based on a clinical DECT abdominal protocol capable of producing material specific concentration maps, virtual unenhanced images, and virtual monochromatic images. The QC automated analysis software uses open‐source technologies which integrates well with our current automated CT QC database. The QC program was tested on a GE 750 HD scanner and two Siemens SOMATOM FLASH scanners over a 3‐month period. The automated algorithm correctly identified the appropriate region of interest (ROI) locations and stores measured values in a database for monitoring and trend analysis. Slight variations in protocol settings were noted based on manufacturer. Overall, the project proved to provide a convenient and dependable clinical tool for routine oversight of DE CT imaging within the clinic.

Implementation of Geographic Information System for District and City Poverty Data Distribution Using the Rational Unified Process in West Java

Poverty is a fundamental problem that several districts and cities have, especially in West Java province. One important aspect to support the Poverty Reduction Strategy is the availability of poverty data that is accurate and on target with good visualization so that it can facilitate the data analysis process. A website-based Geographic Information System is the right solution for mapping the distribution of poverty data. Making this website using software development methods and the Rational Unified Process (RUP) with the Unified Modeling Language (UML) modeling language tool. For the maps, making process using Quantum GIS software and database storage using PostgreSQL. This website is expected to make it easier for the public to find the latest information and analyze poverty data, especially in districts and cities in West Java.

Earthquake observation data grading and storage research

With the constant development of contemporary science and technology and increasing popularization of the big data technology, the concept of “database” has been integrated into people’s daily work and life. The database system also plays an indispensable role in earthquake early reports. This paper briefly analyzes introducing the mature big data technology to earthquake observation and seeks graded storage of databases to ensure a faster and more accurate retrieval of data as well as timely reports of earthquakes.

Event Logic Graph Construction for Event Mining

Event Logic Graph is a directed and cyclic graph, the nodes in the graph represent events, and the edges represent the logical relationship between events. In essence, Event Logic Graph is a knowledge base of event logic, in order to reveal the evolution law and development mode of the event, we research a method of constructing Event Logic Graph, which describes the logical structural relationship between events by adopting knowledge graph structure. At the same time, in order to describe the event more clearly, we also describe the multi-dimensional attributes of the event. We propose an architecture for constructing Event Logic Graph, which includes text corpus collection, event relationship template construction, event extraction and structured representation, event similarity calculation and fusion, event trigger word extraction and argument extraction model construction, event relationship pair construction, graph database storage, and the architecture is used to construct Serial Event Logic Graph, Causal Event Logic Graph, Conditional Event Logic Graph, Transitional Event Logic Graph, and Concurrent Event Logic Graph.

Contour Extraction Based on Adaptive Thresholding in Sonar Images

A common problem in underwater side-scan sonar images is the acoustic shadow generated by the beam. Apart from that, there are a number of reasons impairing image quality. In this paper, an innovative algorithm with two alternative histogram approximation methods is presented. Histogram approximation is based on automatically estimating the optimal threshold for converting the original gray scale images into binary images. The proposed algorithm clears the shadows and masks most of the impairments in side-scan sonar images. The idea is to select a proper threshold towards the rightmost local minimum of the histogram, i.e., closest to the white values. For this purpose, the histogram envelope is approximated by two alternative contour extraction methods: polynomial curve fitting and data smoothing. Experimental results indicate that the proposed algorithm produces superior results than popular thresholding methods and common edge detection filters, even after corrosion expansion. The algorithm is simple, robust and adaptive and can be used in automatic target recognition, classification and storage in large-scale multimedia databases.

A STUDY OF THE BENEFITS AND DRAWBACKS OF NOSQL DATABASES

NoSQL database management solutions are a departure from standard relational database management systems (RDBMS). Non-tabular NoSQL databases store data in a distinct way when compared to relational database tables. The data model of NoSQL databases is used to classify them. The most popular types are document, key-value, wide-column, and graph. They feature customizable schemas and can easily handle large amounts of data as well as significant user loads. They have adaptable schemas and can handle big amounts of data and high user loads with ease. Furthermore, their data models' flexibility and ease of use, in comparison to the relational model, can faster the development, especially in the field of cloud computing. This paper discusses the benefits of NoSQL databases, such as the ability to handle large volumes of data at high speeds with a scale-out architecture, the ability to store unstructured, semi-structured, or structured data, and the ability to easily update schemas and fields, making them developer friendly. Furthermore, this paper discusses the downsides, such as the lack of reliability features found in Relational Databases.

Towards an architecture for cloud robotic services

Cloud computing revealed recently to be of great interest in robotics. Indeed, it provides on-demand and elastic computing resources, database storage, and applications over the internet. These are major assets to improve robots' computational and cognitive capabilities, and share knowledge among the international robotic community. In this context, web services technologies are considered as a key factor for providing encapsulated and interoperable robotic services. However, finding the relevant robotic web service that can match the user request among the published services for different robots is still an issue. This paper presents a solution towards robotic web services discovery and selection in a cloud computing environment, based on Robot Operating System (ROS). We propose an approach, which aims to automate the robotic services search, and enables their use when needed ‘as a service’. This solution allows users to obtain the suitable service for their robots, according to a service-query matching score. To that end, we exploit the sentence-BERT model and reinforce the training dataset through ROS and robot tasks, which enhances significantly the performance of the discovery process. We conducted experiments over several ROS Web services using NAO robot. The obtained results are presented and discussed in this paper.

Information Management and IoT Technology for Safety and Security of Smart Home and Farm Systems

Information management collects data from several online systems. They analyze the information. They issue reports about information for supporting decision-making management. Utilizing current modern innovations try to controlling many obstacles such as, high cost, high battery power, and speed system, safety System without building a full system to solve all these problems together, we created a new internet of things ( IoT) system that provides attention to safety, and Security with low cost, low battery power, and high-speed System. As for the information management system. This paper aims at developing an active system for managing most of the smart farm and home obstacles, such issues to deal with the security system for the farm's and house and animal hanger, raining, irrigation and watering system, food supplement system, Also, a network was established to connect all those systems. Connected database storage was used, infra-red, The system is used for monitoring. They send all the collected information back to be maintained. Arduino will be used for programming this system

Decision Support System for Selection of Quality Doves with Web-Based Analytical Hierarchy Process (AHP) Methods

The purpose of making this system is to make it easier for breeders and pigeon lovers to determine high quality pigeons. The method used is the analytical hierarchy process (AHP), this method is used to support completing the program, using the analytical hierarchy process method, using the analytical hierarchy process method. this is because it can make it easier to make decisions. The result of this system is a web-based system that supports windows and linux operating systems, the purpose of making this system is to facilitate the decision making of high pigeons in determining quality pigeons that are integrated with database storage. The benefit of using this system is to facilitate the decision-making process for quality pigeons.

Blockchain Processing Technique Based on Multiple Hash Chains for Minimizing Integrity Errors of IoT Data in Cloud Environments.

As IoT (Internet of Things) devices are diversified in the fields of use (manufacturing, health, medical, energy, home, automobile, transportation, etc.), it is becoming important to analyze and process data sent and received from IoT devices connected to the Internet. Data collected from IoT devices is highly dependent on secure storage in databases located in cloud environments. However, storing directly in a database located in a cloud environment makes it not only difficult to directly control IoT data, but also does not guarantee the integrity of IoT data due to a number of hazards (error and error handling, security attacks, etc.) that can arise from natural disasters and management neglect. In this paper, we propose an optimized hash processing technique that enables hierarchical distributed processing with an n-bit-size blockchain to minimize the loss of data generated from IoT devices deployed in distributed cloud environments. The proposed technique minimizes IoT data integrity errors as well as strengthening the role of intermediate media acting as gateways by interactively authenticating blockchains of n bits into n + 1 and n − 1 layers to normally validate IoT data sent and received from IoT data integrity errors. In particular, the proposed technique ensures the reliability of IoT information by validating hash values of IoT data in the process of storing index information of IoT data distributed in different locations in a blockchain in order to maintain the integrity of the data. Furthermore, the proposed technique ensures the linkage of IoT data by allowing minimal errors in the collected IoT data while simultaneously grouping their linkage information, thus optimizing the load balance after hash processing. In performance evaluation, the proposed technique reduced IoT data processing time by an average of 2.54 times. Blockchain generation time improved on average by 17.3% when linking IoT data. The asymmetric storage efficiency of IoT data according to hash code length is improved by 6.9% on average over existing techniques. Asymmetric storage speed according to the hash code length of the IoT data block was shown to be 10.3% faster on average than existing techniques. Integrity accuracy of IoT data is improved by 18.3% on average over existing techniques.

Rancang Bangun Aplikasi Pengelolahan Data Penempatan TKI Asal Timor Ke Luar Negeri Berbasis Web Studi Kasus (BP3TKI) Kupang

The Indonesian Worker Placement and Protection Service Agency (BP3TKI) has the authority to provide services for people who wish to run for Indonesian Workers (TKI). In this case, of course the BP3TKI Office has a lot of important data that will be well managed so that its integrity is maintained. All important data will be processed in the Placement section of the BP3TKI Office. In managing TKI data, the placement section uses Microsoft Excel which is managed by one person and only uses one Personal Computer (PC) unit in the placement section. Because the data is managed by one person with one PC and is not stored in the database, it is very possible that the data that has been managed will be lost if one day the PC in the placement section is damaged, this will make it difficult for the placement employee to find data when required return. For this reason, a "WEB-BASED DESIGN OF DATA PROCESSING APPLICATION FOR PLACEMENT OF TKI ORDER OF TIMOR ABROAD BASED ON WEB-BASED" was made. The method used in this system is the Waterfall Model. This system is designed based on Web, using PHP programming language and database storage media using MySql. It is hoped that this system can manage and store TKI data properly and safely and facilitate the data search process.

Malware detection using machine learning with cloud support

This paper “malware detection using machine learning with cloud support” aims to present the functionality and accuracy of five different machine learning algorithms to detect whether an executable is infested or clean. It starts by prompting the user to login into the system by entering valid credentials. Upon successful validation of the details, the user is asked to upload the binary that he/she wants to store in the cloud database. After this, when the user uploads a file from his system, the underlying machine learning algorithms would analyse that the file is benign or infested by means of various classification algorithms. The output provided by the algorithm with highest accuracy is considered and the corresponding result is displayed to the user. The user thus becomes aware if the file uploaded by him/her contains malware or not. In case the file is found to be containing malware, it is discarded, and on the contrary if it is found to be legitimate it is stored on the Cloud by making use of Amazon S3(Simple Storage Service) and thus can be accessed by the user anytime in future. This is how malware is detected successfully by making use of Web, Machine Learning and Cloud Services.

QUALITY ASPECTS OF HIGH-DEFINITION MAPS

Abstract. A self-driving vehicle is one of the most expected inventions in the near future. These vehicles are enabled by several technological developments, like artificial intelligence, robust control, vehicular sensors, and high-speed communication. But beyond all these elements, the essential component is the knowledge about reality. Our profession has answered that question with the development of high-definition (abbreviated as HD) maps. Fully automated driving (also called driverless transportation) must be reliable enough to entrust our lives to the car. This fact indicates that the applied technology and the used map must be of high quality. But how can the quality of such a map be expressed? We are looking for the answer in the current paper.Following Carlo Batini’s idea, the general approach is based on the triumvirate of data sources – quality dimensions – life cycle phases. Data sources cover aerial, terrestrial and mobile mapping products with the available highest technological care; furthermore, onboard vehicular sensing extends the corresponding data sets. Lifecycle phases focus on the production (data collection and processing technologies) expanded by conceptualization (pre-production) and data delivery and use (post-production). Quality dimensions are strongly related to the dimensionality of the data; they can be measured by dimension metrics.The first part of the paper summarizes the applied data collection methodologies, emphasizing the output data. This description contains a summary of the processing mechanism – inevitably characterized by quality indicators. The paper aims to give a complete outline for the quality dimensions; we do not limit the resolution and accuracy dimensions, but other significant clusters like completeness or consistency are also discussed. Because the reality changes are enormous in transportation (vehicles, pedestrians, etc., are moving – even at higher speed) and the newly developing HD maps are expected to be live, actuality is a cardinal quality dimension as well. Vehicular technologies like SENSORIS give an excellent option to the equipped vehicles to download and use maps from the cloud and upload their field observations, opening a new way to maintain the map database. The so established crowd-sourced data collection intensely influences the map quality; therefore, this method generates quality-related issues that are also to be analyzed.The second part of the paper is a case study, where a pilot site close to the university campus was selected. In this area, thousands of images were captured and uploaded into the Mapillary database. Artificial intelligence processes were applied for segmenting, classifying, and evaluating the content of the georeferenced imagery. The map database stores various object categories in the area, for example, pedestrian crossings, traffic signs, or trash cans. All extracted objects are available in georeferenced format, enabling spatial analyses to derive numeric quality indicators. The paper presents the complete results of this study.

Sistem Informasi Pencatatan Kas Masuk Pada Lemon Fresh Laundry Jambi

Laundry business is a business related to laundry services with washing machines and automatic dryers and special cleaning and fragrance fluids. This business is mushrooming in big cities where there are many boarding houses and rented houses, where renters of boarding or rented houses do not have time or cannot do their own washing and ironing of clothes due to busyness as students and workers. Lemon Fresh Laundry, one of the kilogram laundry in Kisaran. Its strategic location, precisely on Jl. Lkr. Barat 3, Bagan Pete, Kec. Kota Baru, Jambi City, makes many customers visit every day to use Lemon Fresh Laundry services. Until now Lemon Fresh Laundry does not have its own information system and still uses a manual system, this laundry also does not have an accurate database storage system so that all data is still stored in a book. With the use of this manual system, various problems arise such as the difficulty of finding customer data in a book. The purpose of this Web-based cash-in recording system application is to provide professional services to customers and minimize errors that may occur. This Web-based cash recording information system uses ERD and MYSQL flow diagrams for data processing.

Glycowork: A Python package for glycan data science and machine learning.

While glycans are crucial for biological processes, existing analysis modalities make it difficult for researchers with limited computational background to include these diverse carbohydrates into workflows. Here, we present glycowork, an open-source Python package designed for glycan-related data science and machine learning by end users. Glycowork includes functions to, for instance, automatically annotate glycan motifs and analyze their distributions via heatmaps and statistical enrichment. We also provide visualization methods, routines to interact with stored databases, trained machine learning models and learned glycan representations. We envision that glycowork can extract further insights from glycan datasets and demonstrate this with workflows that analyze glycan motifs in various biological contexts. Glycowork can be freely accessed at https://github.com/BojarLab/glycowork/.

SISTEM INFORMASI PENCATATAN KAS MASUK PADA LEMON FRESH LAUNDRY JAMBI

Laundry business is a business related to laundry services with washing machines and automatic dryers and special cleaning and fragrance fluids. This business is mushrooming in big cities where there are many boarding houses and rented houses, where renters of boarding or rented houses do not have time or cannot do their own washing and ironing of clothes due to busyness as students and workers. Lemon Fresh Laundry, one of the kilogram laundry in Kisaran. Its strategic location, precisely on Jl. Lkr. Barat 3, Bagan Pete, Kec. Kota Baru, Jambi City, makes many customers visit every day to use Lemon Fresh Laundry services. Until now Lemon Fresh Laundry does not have its own information system and still uses a manual system, this laundry also does not have an accurate database storage system so that all data is still stored in a book. With the use of this manual system, various problems arise such as the difficulty of finding customer data in a book. The purpose of this Web-based cash-in recording system application is to provide professional services to customers and minimize errors that may occur. This Web-based cash recording information system uses ERD and MYSQL flow diagrams for data processing.