Centralized Database System Research Articles

Analysis of Road Traffic Accidents in Dense Cities: Geotech Transport and ArcGIS

Road Traffic Accidents (RTAs) provide a substantial risk to both public safety and infrastructure within severe earthquake zones. This research aims to provide a thorough analysis of the many elements that contribute to RTAs in the area. Although research on RTAs has been conducted in numerous settings, there is a lack of localized research specifically focused on developing countries. Therefore, this study is necessary to address this gap in literature. Our study focuses on examining the distinct issues and elements that are particular to this specific location. The objective is to provide customized solutions that effectively reduce the occurrence of accidents. The objective of this study is to examine the status of RTAs, ascertain the main factors contributing to RTAs, and provide viable approaches to improve road safety. A comprehensive study of data was undertaken, which included the examination of key highways, accident-prone areas, and causes contributing to accidents. Insights were derived by the use of statistical analysis, hotspot mapping, and the categorization of incidents. The results revealed a distressing roadway are afflicted by a significant frequency of accidents, even those occurring on prominent thoroughfares. Excessive speed has been revealed as the primary contributing factor, closely followed by negligence and recklessness. The common factor seen in these events was the insufficient enforcement of traffic regulations. The research highlights several practical consequences. Firstly, it is advised to implement urgent actions such as the upgrading of the traffic database, the adoption of contemporary traffic management software, and the enforcement of rigorous traffic laws. The establishment of a comprehensive centralized database system is crucial in order to enhance the documenting and management of accidents. Furthermore, the use of cost-benefit analysis provides justification for the adoption of traffic calming measures in locations with a high incidence of accidents. Furthermore, the implementation of continuous road safety awareness efforts and the establishment of clear legislative guidelines pertaining to fatal accidents are imperative measures in promoting enhanced road safety.

Thorough Data Pruning for Join Query in Database System

The improvement of robustness and efficiency for multi-way equijoin query is challenging, no-matter for centralized database systems or distributed database systems. Due to lots of unnecessary data existing during query processing, these two metrics will be seriously reduced. If we can thoroughly prune unnecessary data in advance, the robustness and efficiency will be highly improved. However, the pruning power of current strategies, such as predicate push-down and algebraic equivalence, is limited. We present deepDP, a powerful, generalized, and efficient strategy for data pruning. deepDP builds multiple independent pruning spaces by generating longest transitive closures and applies appropriate data pruning strategy for each pruning space. For thoroughly pruning unnecessary data, deepDP employs <inline-formula xmlns:mml="http://www.w3.org/1998/Math/MathML" xmlns:xlink="http://www.w3.org/1999/xlink"><tex-math notation="LaTeX">$\alpha \cdot \beta$</tex-math></inline-formula> pruning strategy to clean each pruning space based on a newly designed statistic information-Hollow Range and re-shuffles the elements in all pruned spaces for maximizing robustness and efficiency benefits meanwhile minimizing the invasion. We implement deepDP in PostgreSQL but are not limited to it, and evaluate deepDP on TPC-H, JOB, and our synthesis benchmark–DHR. The experiment results show that compared to traditional data pruning strategy, deepDP can improve multi-way equijoin query on efficiency by 3.5x.

ALOCALIZEDBASEDAPPLICATIONFORAUTOMOBILEMECHANICSLOCATION-AWARESYSTEM

ALOCALIZEDBASEDAPPLICATIONFORAUTOMOBILEMECHANICSLOCATION-AWARESYSTEM

Sistem Informasi Pelayanan Jasa Laundry Pada Rumah Laundry Kendal

Currently it is still done manually and causes difficulties in data retrieval and income capitulation, there are several steps that can be taken to increase efficiency and accuracy in administrative management. Here are some suggestions: Management Information System (MIS) or Laundry Application: Implement a management information system or laundry-specific application that can help automate administrative processes. This application can record laundry receipt transactions, record customer data, and store income information in a more structured manner. Barcode or Unique Identification System: Use a barcode or unique identification system on each laundry receipt. This will make it easier to track and search data. Each customer or order can have a unique code or barcode that can be scanned to identify the transaction. Electronic Logging: Switch from manual logging to electronic logging. Use spreadsheet or database software to store and manage data. Make sure all laundry receipt data, including customer information and type of service, is recorded carefully. Centralized Database System: By implementing these solutions, you can optimize the laundry service administration process, reduce data search time, and increase revenue management efficiency. The aim of creating a Laundry Service Information System is to make it easier for business owners to manage customer transaction data and in preparing financial reports. The methods used in collecting data are observation, interviews and literature study, while the system development method used is R&amp;D (Research and Development). This system was built using the PHP programming language, Boostrap, and for the database using MySQL. The results of this research are a web-based laundry service information system. This laundry service information system contains 2 access rights, namely Admin and customer. Customers can find out the status of their laundry and payments, while Admins can manage customer data, manage transactions, and view print reports

Patient Monitoring System using Blockchain and IoT Technology

Background: Recently, the construction of a smart city has accelerated due to developing technologies such as 5G and the Internet of things (IoT). The IoT is gaining access day by day in the area of the remote monitoring system. Along with smart city concepts, intelligent patient monitoring systems and intelligent health are being developed. Combining the two, here, patients have a nurse navigation system and a doctor emergency call system. IoT improves the effectiveness of medical equipment by providing real-time monitoring of patient health, in which sensors collect data from patients with less human errors. In IoT, the patient's parameters get transmitted through medical devices via a gateway to the centralized system, where it is stored and analyzed. Objective: In this paper, we have proposed an intelligent patient monitoring system for monitoring the patients' health condition automatically through sensors-based connected links. The system is more intelligent that it can be able to detect the critical condition of a patient by processing sensor data and instantly provides a notification to doctors/nurses as well as hospital in-charge personnel. The doctors and nurses get benefited from this system by observing their corresponding patients remotely without visiting to the particular seat of the patient. Methods: An idea has been proposed to use the centralized processing of IoT devices along with the rigid security and privacy of the classical blockchain to overcome the computation expense challenge with blockchain and the security and privacy threat of the IoT systems. We are developing a system in the field of medical care to enhance the functioning of Medicare systems and provide patients with more ease and hassle-free procedures of the Medicare system, i.e., hospitals, laboratories, dispensaries, chemists, druggists, etc. Results: This model helps in getting rid of this issue faced by all of us. There is a separate blockchain of different verified medical stores linked within the networks, which will be managed by the central hub based on their ratings, reviews, and stock availability. Conclusion: The exponential expansion of blockchain technology in healthcare is also astonishing and has a tremendous impact on the industry. By assessing prior activities, the idea is proposed to use a centralized database system with more privacy and security to gap between the healthcare industry and blockchain technologies has been addressed in this paper.

Adaptation of IoT with Blockchain in Food Supply Chain Management: An Analysis-Based Review in Development, Benefits and Potential Applications.

In today's scenario, blockchain technology is an emerging area and promising technology in the field of the food supply chain industry (FSCI). A literature survey comprising an analytical review of blockchain technology with the Internet of things (IoT) for food supply chain management (FSCM) is presented to better understand the associated research benefits, issues, and challenges. At present, with the concept of farm-to-fork gaining increasing popularity, food safety and quality certification are of critical concern. Blockchain technology provides the traceability of food supply from the source, i.e., the seeding factories, to the customer's table. The main idea of this paper is to identify blockchain technology with the Internet of things (IoT) devices to investigate the food conditions and various issues faced by transporters while supplying fresh food. Blockchain provides applications such as smart contracts to monitor, observe, and manage all transactions and communications among stakeholders. IoT technology provides approaches for verifying all transactions; these transactions are recorded and then stored in a centralized database system. Thus, IoT enables a safe and cost-effective FSCM system for stakeholders. In this paper, we contribute to the awareness of blockchain applications that are relevant to the food supply chain (FSC), and we present an analysis of the literature on relevant blockchain applications which has been conducted concerning various parameters. The observations in the present survey are also relevant to the application of blockchain technology with IoT in other areas.

Impact of a Centralized Database System on Radiation Therapy Quality Assurance Management at a Large Health Care Network: 5 Years’ Experience

PurposeThis study reports the impact of using a centralized database system for major equipment quality assurance (QA) at a large institution. Methods and MaterialsA centralized database system has been implemented for radiation therapy machine QA in our institution at 6 campuses with 11 computed tomographies and 22 linear accelerators (LINACs). The database system was customized to manage monthly and annual computed tomography and LINAC QA. This includes providing the same set of QA procedures across the enterprise, digitally storing all measurement records, and generating trend analyses. Compared with conventional methods (ie, paper forms), the effectiveness of the database system was quantified by changes in the compliance of QA tests and perceptions of staff to the efficiency of data retrieval and analyses. An anonymized questionnaire was provided to physicists enterprise-wide to assess workflow changes. ResultsWith the implementation of the database system, the compliance of QA test completion improved from 80% to >99% for the entire institution. This resonates with the 56% of physicists who found the database system helpful in guiding them through QA, and 25% of physicists found the contrary, and 19% reported no difference (n = 16). Meanwhile, 40% of physicists reported longer times needed to record data using the database system compared with conventional methods, and another 40% suggested otherwise. In addition, 87% and 80% found the database more efficient to analyze and retrieve previous data, respectively. This was also reflected by the shorter time taken to generate year-end QA statistics using the software (5 vs 30 min per LINAC). Overall, 94% of physicists preferred the centralized database system over conventional methods and endorsed continued use of the system. ConclusionsA centralized database system is useful and can improve the effectiveness and efficiency of QA management in a large institution. With consistent data collection and proper data storage using a database, high-quality data can be obtained for failure modes and effects analyses as per TG 100.

Open Source Based Enterprise Resource Planning

In the era of the 4.0 industrial revolution, companies are trying to implement information technology to increase competitive competitiveness. Information technology is implemented within the company to increase productivity and help achieve quality, time standards, and satisfaction for consumers and employees, wherein business this is manifested in a set of systems consisting of information systems and supporting infrastructure. One solution is to implement a system to manage all company resources or what is called an Enterprise Resource Planning (ERP) system. Implementing an ERP system requires high costs and is highly dependent on the vendor. The purpose of this research is to build an ERP system on an open-source basis so that it can be used by middle to lower enterprises as an alternative to ERP systems to support the company's operations.&#x0D; The ERP system was developed using the waterfall system development method. The result of this research is the development of an ERP system based on open source. The conclusion of this research is that the ERP system can be configured according to the needs of small and medium scale companies. Can record documentation of company operational activities. The centralized database system provides benefits for companies to view data on business operations. Suggestions given for further research are to develop warehouse management and material management modules.

Open Source Based Enterprise Resource Planning

In the era of the 4.0 industrial revolution, companies are trying to implement information technology to increase competitive competitiveness. Information technology is implemented within the company to increase productivity and help achieve quality, time standards, and satisfaction for consumers and employees, wherein business this is manifested in a set of systems consisting of information systems and supporting infrastructure. One solution is to implement a system to manage all company resources or what is called an Enterprise Resource Planning (ERP) system. Implementing an ERP system requires high costs and is highly dependent on the vendor. The purpose of this research is to build an ERP system on an open-source basis so that it can be used by middle to lower enterprises as an alternative to ERP systems to support the company's operations. The ERP system was developed using the waterfall system development method. The result of this research is the development of an ERP system based on open source. The conclusion of this research is that the ERP system can be configured according to the needs of small and medium scale companies. Can record documentation of company operational activities. The centralized database system provides benefits for companies to view data on business operations. Suggestions given for further research are to develop warehouse management and material management modules

Development of E-Healthcare Management System using PHP, Javascript and Cascading Style Sheets

It is a responsibility for higher authorities in a government/private institute to provide an essential health care service to all their own community. The current health management is quite tedious and unpractical by using manual methods in order to get an appointment from doctor. Furthermore, the current situation, Covid-19 is spreading throughout Malaysia and it is very risky for direct doctor visit. This paper is mainly focused on developing an E-healthcare management system for government/private institute to make doctor appointment online. The used programming developing tools are CSS, PHP, Javascript and Cascading Style Sheets (CSS). Patients may log in to make appointment with the doctor with its specialized. All the appointment details is processed and directly sent to the centralized database system. Then doctors confirm the appointment through their web page. Finally, patients receive an alert from doctor after the confirmation. E-Healthcare Management system is successfully developed to cater all the needs in appointments and organizing the records. In addition, current patients’ data and appointment can be retrieved just in a click of second.

Secure decentralized electronic health records sharing system based on blockchains

Blockchain technology has a great potential for improving efficiency, security and privacy of Electronic Health Records (EHR) sharing systems. However, existing solutions relying on a centralized database are susceptible to traditional security problems such as Denial of Service (DoS) attacks and a single point of failure similar to traditional database systems. In addition, past solutions exposed users to privacy linking attacks and did not tackle performance and scalability challenges. In this paper, we propose a permissioned Blockchain based healthcare data sharing system that integrates Blockchain technology, decentralized file system and threshold signature to address the aforementioned problems. The proposed system is based on Istanbul Byzantine Fault Tolerant (IBFT) consensus algorithm and Interplanetary File System (IPFS). We implemented the proposed system on an enterprise Ethereum Blockchain known as Hyperledger Besu. We evaluated and compared the performance of the proposed system based on various performance metrics such as transaction latency, throughput and failure rate. Experiments were conducted on a variable network size and number of transactions. The experimental results indicate that the proposed system performs better than existing Blockchain based systems. Moreover, the decentralized file system provides better security than existing traditional centralized database systems while providing the same level of performance.

Web-Based Interactive Health Record System (WIHRS)

A Web Based Interactive Health Record System (WIHRS) is a digital web-based record of patients presenting in a hospital. The information so generated on patients can then be accessed by medical personnel to provide treatment for them in any health care delivery setting at any location. Analogue ways of record keeping were the traditional way of documenting patients’ information by health information officers. The problems of unavailability of a centralized database system and inability to access patients records and provide prompt treatment to patients at any healthcare centre could be solved by WIHRS. The objective of the paper is to design a WIHRS. The methods included cloud computing model, service model, deployment model and cloud hosting. The web technologies languages such as Hypertext Pre-processor (PHP), Hypertext Mark-up Language (HTML), Cascading Style Sheet (CSS) and Ajax were deployed to implement the proposed system. The use of WIHRS improves the standard of healthcare to patients with optimal efficiency.

Web-Based Interactive Health Record System (WIHRS)

A Web Based Interactive Health Record System (WIHRS) is a digital web-based record of patients presenting in a hospital. The information so generated on patients can then be accessed by medical personnel to provide treatment for them in any health care delivery setting at any location. Analogue ways of record keeping were the traditional way of documenting patients’ information by health information officers. The problems of unavailability of a centralized database system and inability to access patients records and provide prompt treatment to patients at any healthcare centre could be solved by WIHRS. The objective of the paper is to design a WIHRS. The methods included cloud computing model, service model, deployment model and cloud hosting. The web technologies languages such as Hypertext Pre-processor (PHP), Hypertext Mark-up Language (HTML), Cascading Style Sheet (CSS) and Ajax were deployed to implement the proposed system. The use of WIHRS improves the standard of healthcare to patients with optimal efficiency.

Application of Blockchain in Agri-Food Supply Chain

Supply chain traceability is one of the most important problems faced by all organizations globally. Tracking any commodity is a tedious job and requires a lot of manual attention. The existing system uses a centralised database system to track a commodity. Blockchain is a decentralised, immutable ledger managed by a cluster of computers. The very nature of blockchain makes it suitable technology for traceability in a supply chain. Blockchain creates immutable records. Once a transaction is stored in the blockchain, it is impossible to tamper it illegally. This immutability of blockchain builds trust among the participants that conduct business in a lack of trust environment. Using consensus protocols, blockchain builds trust between the various participants. Blockchain provides traceability since immutable records are added in blockchain; it is easy to track the source of the product. This paper illustrates the Application of Blockchain in Agri-Food Supply Chain. It unfolds how blockchain technology can be integrated to an Agri Supply Chain and improves the traceability. This integration enables companies to quickly track unsafe products back to their source and see where else they have been distributed. This integration can result to prevent illness and save lives, as well as reduce the cost of product recalls.

Database Framework for Nigerian Prison Service, Adamawa State, Command

One of the major challenges facing prisons service especially in the developing countries like Nigeria is how to accurately and efficiently analyze the growing volume of prison inmate data. Nigerian Paramilitaries particularly the Nigerian Prison Service (NPS) Adamawa State command keep volumes of inmate data and information. Despite the enormously volume of data which is on the increase, the recordkeeping process remains manual; this does not assure proper safe keeping of inmate records. This study designed a database framework for the NPS Adamawa State command. The study analyzed the existing system of recordkeeping adopted by NPS which is the manual method of record keeping; developed a prototype database model; and designed a web application that would interact with the database. Before the main design, a comprehensive analysis of the existing system was carried out. 16 staff were interviewed for the exercise and the result showed the need for Nigerian Prison Service (NPS) Adamawa State command to have such robust database framework for accurate and efficient tracking of inmate data. The system was designed using Microsoft SQL server, MS Visual Studio. The researcher also used agile software development methodology and accomplished the development by the use of C-sharp, JavaScript, HTML 5 and Bootstrap CSS as tools. The system was tested using a workable prototype, and major recommendations were made. The researcher believes such a database framework should be deployed to Nigerian Prison Service (NPS) Adamawa State Command for full implementation. Findings of this work suggest that similar paramilitaries like the Nigerian Prison Services (NPS) should also incorporate a centralized database system into their process. Though further research needs to be conducted regarding the introduction of bio-metric fingerprinting as a means of tracking prison inmates in such organizations; this work is of the opinion that data warehousing of all prison data for the Nigerian Prison Service (NPS) as a whole is a necessary/vital way forward.

An Information Aggregation and Analytics System for ATLAS Frontier

ATLAS event processing requires access to centralized database systems where information about calibrations, detector status and data-taking conditions are stored. This processing is done on more than 150 computing sites on a world-wide computing grid which are able to access the database using the Squid-Frontier system. Some processing workflows have been found which overload the Frontier system due to the Conditions data model currently in use, specifically because some of the Conditions data requests have been found to have a low caching efficiency. The underlying cause is that non-identical requests as far as the caching are actually retrieving a much smaller number of unique payloads. While ATLAS is undertaking an adiabatic transition during the LHC Long Shutdown 2 and Run 3 from the current COOL Conditions data model to a new data model called CREST for Run 4, it is important to identify the problematic Conditions queries with low caching efficiency and work with the detector subsystems to improve the storage of such data within the current data model. For this purpose ATLAS put together an information aggregation and analytics system. The system is based on aggregated data from the Squid-Frontier logs using the Elasticsearch technology. This paper§ describes the components of this analytics system from the server based on Flask/Celery application to the user interface and how we use Spark SQL functionalities to filter data for making plots, storing the caching efficiency results into a Elasticsearch database and finally deploying the package via a Docker container.

ANALIS RESPONSE TIME REPLIKASI DATABASE SISTEM INFOMASI INVENTORI DARAH

This study aims to find out analsis response time replication of two-way database on blood inventory system in Madiun residency: Madiun City, Madiun Regency and Ponorogo Regency. Thepreviously used system has been integrated using a one-way database replication with centralizeddatabase system, but in the course of its journey found the instability of centralized databasesystem, such as the delay between 2-4 seconds during query activity and the data that does not gointo the data center when do activities. The method used in this research is to use the method ofcomparison between one-way replication system with two-way replication system. The data madefor comparative analysis are CPU response time, trougput, delay and packet loos network at eachUTD in Madiun residency. The tools used to get data using Mary DB and wireshark software. Theresults of the research indicate that the two-way database replication system in Madiun andMadiun City shows better CPU response time, troughput, delay and packet loss compared to theprevious system, only Ponorogo has decreased performance compared to the old system.Keywords: Blood inventory system, two-way data base replication, CPU response time, delay, packet loss, throughput.

A Wireless Internet of Things Architecture Based on Mobile Internet

In order to develop a valid wireless Internet of things system, a wireless Internet of things framework based on mobile Internet is designed. The architecture of the Internet of things determines the architecture of the Internet of things business platform. There is no uniform standard for the architecture of the Internet of things service platform. The Internet of things business platform is mostly in an isolated state. The platform uses the common information management platform of Internet websites to manage mobile internet. Combined with the technologies of perception, identification and network transmission in the Internet of things technology, it is a content management Web management information system with both B/S (Browser/Server) and C/S structure (Client/Server). The platform can operate anywhere, and can give full play to the processing capacity of the client PC, and greatly reduce the application server running data load. The experimental results show that compared with the centralized database system, in the same piece of redundant condition, when the test table data is greater than the 1 million and the concurrent number is 100, the distributed database system has shorter concurrent query time and faster system response rate. Based on the above finding, it is concluded that wireless Internet of things technology based on mobile Internet will promote the development of the whole logistics industry and other related industries.

Distributed Database for Bookstore Application

In recent past, the bookstores generate more data such as customer details, transaction details, book details, etc. for analyzing them to make data-driven decisions. These data are stored in a centralized database. In centralized database system, the data are stored in a single site or location and that are managed. The major drawback is that if the centralized system gets crashed the entire data are lost and also it makes access bottleneck when more users need to access the database. In order to overcome these limitations, the distributed database system is used to store the business data by locating them in different databases that are located in different sites in different location. The distributed database maintains the replication and duplication that ensure the availability and fault tolerance on the data. The distributed system also provides the high accessibility to the users. Thus, this paper presents a distributed database for a bookstore to improve availability, fault tolerance, and accessibility. This distribution also maintains the transparency and supports the database properties such as atomicity, consistency, inheritance and durability (ACID). Furthermore, this distributed database is designed with four sites and each site keeps the bookstore data for access and analyses. This distributed database is constructed and accessed using structured query language (SQL) with MySQL relational database management system (RDBMS). It also provides the security and work even in offline mode. Keywords: distributed databases; query processing; relational database management; structured query language; bookstore database;

Optimizing and Enhancing Performance of MVC Architecture based on Data Clustering Technique

The frequent use of web based application plays a vital role in our everyday life. MVC (Model View Controller) architecture is used as programmed architectural pattern in order to implement user interfaces. Application software developers utilize MVC (Model View Controller) Architecture for developing web based application. The sizes of databases are increasing day by day in relation with time. Therefore, if we take into account the concept of huge centralized database systems, it has become one of the most challenging criterions for accessing data in acceptable time. Basically, in centralized databases, the records can be classified into two categories considering the access frequency of data. Those records that are being accessed frequently are known as Level 1 data, on the contrary, those accessed in lesser frequency is considered as Level 2 Data. In this paper, we will try to enhance and optimize the performance of MVC architecture based on two parameters namely response time and throughput. The response time and throughput is improved based on the proposed database search algorithm using B+ tree. If the database search engine is idle, the database search engine will look forward to discover whether the intended data is in level 1, otherwise it will search for level 2 data. The level 2 data will be included as level 1 data inside the database or vice versa, for insertion and update operation. However, whether the data is level 1 or level 2 data will be depended upon user choice. Thus, the overall response time as well as throughput will be optimally increased.