scholarly journals Framework for Client-Server Distributed Database System for Federal Road Safety Commission Nigeria

2020 ◽  
Vol 7 (5) ◽  
pp. 440-451
Author(s):  
Sese Tuperekiye E.

In recent years it has been observed that the federal road safety commission FRSC has been having some challenges on how to handle traffic rule and traffic offences committed by road users both commercial and private. Based on the in ability of the FRSC to handle these problems this paper critically looked into the behavioural pattern of the drivers towards traffic rules and offences committed and found that there was a great need for the Organisation to have a good database, that will be able to keep records of traffic offences and offenders, which can be called upon at any time on reference basis. The aim of this study is to create a distributed Federal Road Safety commission traffic offence system that can access data from any state of the Federation. The system consists of a relational database of FRSC variables which could be shared by the various States and Local Government Areas in the country. Each of the local government area will form a website, and the database will be hosted by the server at the Federal Road Safety Commission Head Quarters at Abuja and at the various state capital. . All LGAs will access the database via a distributed network. The client/server distributed network architecture is used in the design and implementation of the system. The system is capable of monitoring all road offences and traffic offenders records at all levelsfrom  any part of the country and generation of reports concerning offenders and also access information from the local government at all times.

2019 ◽  
Vol 30 (1) ◽  
pp. 46-53
Author(s):  
David McTiernan

As the road authority for the unclassified (i.e. local) roads in their local government area, councils have the legislated responsibility to manage their road infrastructure; this fundamentally includes the safety of road users on their networks. Almost 70% of the 392 fatalities on NSW roads in 2017 occurred on country roads (Transport for NSW, 2018). The contribution of the local road network to road trauma across Australasia is significant with over half (52%) of all fatal and serious injuries recorded on roads that are the sole responsibility of local government (McTiernan et. al., 2016). Governments at all levels - Local, State and Federal – can no longer ignore the contribution of local roads to the national tragedy and trauma occurring each year. Without a concerted effort by all tiers of government to address road safety performance on the vast local road network, Australia will not achieve the 30% reduction target in fatal and serious injuries as set out in the National Road Safety Plan. Unfortunately, the current status for managing safety on local roads sees a myriad of systemic hurdles and failures that ultimately result in local government not making road safety a genuine priority. But what is required to change this situation? Two case studies are presented to assist a discussion about some of the systemic failures that contribute to local councils not taking, or not being able to take, action to make road safety a genuine priority.


Author(s):  
Surya Pratap Singh ◽  
Arvind Kumar Maurya ◽  
Manish Mishra ◽  
Upendra Nath Tripathi

The data is the most valuable asset of any organization, it resides data in the database system that is used to store data of every running application. So the security of database is very important. One of the most widely used types of a database is Distributed Database which has the capabilities of both a relational database and distributed network architecture. Hence the security of database is of the prime concern and at the same time, it is very tough to ensure, because different types of attackers and hackers are trying everything to compromise the distributed database security. Various researches are done to preserve the distributed database security but some security problems are still unresolved. In this paper, we propose the use of Multi-scope based authentication and Enhanced Distributed firewall by which the integrity and security of distributed database can be achieved.


Author(s):  
Anastasya Latubessy ◽  
Ahmad Ashari

AbstrakKemampuan socket yang bekerja pada komunikasi low level dalam melakukan transfer data antar aplikasi, diharapkan dapat diterapkan dalam sistem basis data terdistribusi. Beberapa alasan untuk membangun basis data terdistribusi adalah pemakaian bersama, kehandalan, ketersediaan, dan kecepatan pemrosesan query. Dengan pertimbangan tersebut, instansi-instansi baik pemerintah maupun swasta mulai tertarik untuk menggunakan sistem terdistribusi dalam pengelolaan pekerjaan pada instansinya. Hal ini dijadikan alasan untuk membangun sistem kenaikan gaji berkala otomatis di Dinas Informasi dan Komunikasi (Infokom) Provinsi Maluku. Selain itu, belum adanya sistem terkomputerisasi yang menangani sistem ini. Sistem kenaikan gaji berkala merupakan sistem yang bersifat kritis atau penting karena berhubungan dengan masalah uang, sehingga diperlukan juga sebuah sistem yang fault tolerant.Arsitektur sistem dibangun dengan metode client server yang memanfaatkan socket sebagai middleware dalam proses komunikasi pada jaringan. Menggunakan pendekatan full replica dengan pendekatan file replication using a group untuk menjamin konsistensi data. SQL Statement yang dikirimkan client akan diubah kedalam format XML yang kemudian akan dikirimkan ke kedua basisdata server menggunakan socket. Model redundansi data dan rendundansi proses diatur oleh middleware socket. Hasil yang diperoleh dalam penelitian ini adalah aplikasi socket sebagai middleware yang menangani distribusi data dari aplikasi web client ke basisdata server yang diimplementasikan pada sistem kenaikan gaji berkala otomatis di Dinas Infokom Provinsi Maluku.  Kata kunci— Socket, basisdata terdistribusi, client server AbstractSockets ability to transfer data between application  that work on the low level communication was expected to be implemented in a distributed database system. Some of the reasons for building a distributed database was data sharing, reliability, availability, and query processing speed. With these considerations, both government agencies and private sector became interested to use distributed systems to manage their job at the office. It is used as a reason to build an automated KGB system of Infokom Department in Province of Moluccas. Furthermore, there was no computerized system to handle this system before. Because of it was a critical or important system, then it was requires to build a system that has a fault tolerant capability.The system architecture was built by client server method using sockets as middleware in the process of network communicaton. The system method was used full replica, and used file replication using a group to ensure data consistency. The SQL Statement was sent by the client would be converted into an XML format which then would be sent to the server using a socket. Data redundancy model and process redundancy model managed by socket middleware.The results of this research was a middleware application using socket that handle the distribution of databases from client applications to database server that were implemented on a periodic system of automatic salary increases in the Office of Information and Communication in Province of Moluccas.  Keywords— Socket, distributed database, replication


2014 ◽  
Vol 13 (9) ◽  
pp. 4859-4867
Author(s):  
Khaled Saleh Maabreh

Distributed database management systems manage a huge amount of data as well as large and increasingly growing number of users through different types of queries. Therefore, efficient methods for accessing these data volumes will be required to provide a high and an acceptable level of system performance.  Data in these systems are varying in terms of types from texts to images, audios and videos that must be available through an optimized level of replication. Distributed database systems have many parameters like data distribution degree, operation mode and the number of sites and replication. These parameters have played a major role in any performance evaluation study. This paper investigates the main parameters that may affect the system performance, which may help with configuring the distributed database system for enhancing the overall system performance.


Author(s):  
Dagmara Jankowska-Karpa ◽  
Justyna Wacowska-Slezak ◽  
Aneta Wnuk
Keyword(s):  

Sign in / Sign up

Export Citation Format

Share Document