[KSCI] Korea Science Citation Index Service

http://dx.doi.org/10.3837/tiis.2019.07.011

An Enhanced University Registration Model Using Distributed Database Schema

Maabreh, Khaled Saleh (Faculty of Information Technology Zarqa University)

Publication Information

KSII Transactions on Internet and Information Systems (TIIS) / v.13, no.7, 2019 , pp. 3533-3549 More about this Journal

Abstract

A big database utilizes the establishing network technology, and it became an emerging trend in the computing field. Therefore, there is a necessity for an optimal and effective data distribution approach to deal with this trend. This research presents the practical perspective of designing and implementing distributed database features. The proposed system has been establishing the satisfying, reliable, scalable, and standardized use of information. Furthermore, the proposed scheme reduces the vast and recurring efforts for designing an individual system for each university, as well as it is effectively participating in solving the course equivalence problem. The empirical finding in this study shows the superiority of the distributed system performance based on the average response time and the average waiting time than the centralized system. The system throughput also overcomes the centralized system because of data distribution and replication. Therefore, the analyzed data shows that the centralized system thrashes when the workload exceeds 60%, while the distributed system becomes thrashes after 81% workload.

Keywords

Availability; Cloud Computing; Distributed Database; Fragmentation; Registration; Reliability;

Citations & Related Records

Reference

1	M. T. Ozsu, "Principles of Distributed Database Systems, 3rd ed," Prentice Hall Press, 2011.
2	R. Elmasri and S. Navathe, "Fundamentals of database systems," Pearson London, 2016.
3	S. B. Shende and P. P. Chapke, "Cloud Database Management System (CDBMS)," Compusoft, vol. 4, no. 1, p. 1462, 2015.
4	A. Mathur, M. Mathur, and P. Upadhyay, "Cloud Based Distributed Databases: The Future Ahead," International Journal on Computer Science and Engineering, vol. 3, no. 6, pp. 2477-2481, 2011..
5	S. Alyaseri, "Distributed University Registration Database System Using Oracle 9i," Computer and Information Science, vol. 3, no. 1, pp. 59-67, 2010.
6	S. M. Motta, "Design of a Comprehensive Student Information System (SIS) and User Interface for the Honors College at USF," USF College of Engineering USF Honors College, 2010.
7	Y. D. Xaveria, "Design and Implementation of a Client Server Distributed Database for Student Results Processing," The Pacific Journal of Science and Technology, vol. 11, no. 2, pp. 288-295, 2010.
8	M. Little, S. Wheater, D. B. Ingham, C. Richard Snow, H. Whitfield, and S. K. Shrivastava, "The University Student Registration System: A Case Study in Building a High-Availability Distributed Application Using General Purpose Components," in Proc. of Advances in Distributed Systems, Advanced Distributed Com-puting: From Algorithms to Systems, LNCS, vol. 1752, pp. 453-471, 1999.
9	A. a. Al-Shaikh, "Online Registration System," International Journal of Computer Science and Security (IJCSS), vol. 4, no. 3, pp. 331-345, 2010.
10	A. E. B. Mohamed, "An Integrated Remote Registration Systems in a Distributed Data Base Environment," in Proc. of 4th International Conference: Circuits, Systems & Computers, CSCC2000, World Scientific and Engineering Society press (WSES), IEEE, Vouliagmeni, Greece Conference 2000, 2000.
11	A. Noraziah, A. A. C. Fauzi, M. M. Deris, M. Y. M. Saman, N. M. Zain, and N. Khan, "Managing Educational Resource - Student Information Systems Using BVAGQ Fragmented Database Replication Model," Procedia - Social and Behavioral Sciences, vol. 28, no. Supplement C, pp. 127-132, 2011. DOI
12	T. Zhu, J. W. Guo, H. Zhou, X. Zhou, and A. Y. Zhou, "Consistency and Availability in Distributed Database Systems," Journal of Software, vol. 29, no. 1, pp. 131-149, 2018.
13	I. A. ALAMERI and G. RADCHENKO, "Development of Student Information Management System based on Cloud Computing Platform," Journal of Applied Computer Science & Mathematics, vol. 11, no. 2, pp. 9-14, 2017.
14	"Oracle-Corporation," Two-Phase Commit Mechanism, 2018.
15	Jordan, "The Annual Statistical Report," Ministry of Higher Education and Scientific Research 2016, 2017.
16	K. E. Kendall and J. E. Kendall, "Systems analysis and design, 9th ed," Upper Saddle River, NJ: Pearson, p. 552, 2013.
17	A. Boicea, F. Radulescu, C. O. Truica, and L. Urse, "Improving Query Performance in Distributed Database," Journal of Control Engineering and Applied Informatics, vol. 18, no. 2, pp. 57-64, 2016.
18	K. Gopalakrishnan, "Oracle Database 11g Oracle Real Application Clusters Handbook," McGraw-Hill Education Group, 2011.
19	J. Kuhlenkamp, M. Klems, and O. Ross, "Benchmarking scalability and elasticity of distributed database systems," VLDB Endowment, vol. 7, no. 12, pp. 1219-1230, 2014. DOI
20	Oracle-Corporation, "Oracle's Understanding SQL*Net," Oracle White Paper, California, USA, 2002.
21	S. Fogel and P. Lane, "Oracle Database Administrator's Guide. 11g Release 2 (11.2)," Oracle Corp, 2013.
22	R. Gallersd and M. Nicola, "Improving Performance in Replicated Databases through Relaxed Coherency," in Proc. of the 21th International Conference on Very Large Data Bases, pp. 445-456, 1995.