Oracle DBMS Scheduler Package for Data Integrity Test on Web-Based Application

Boby Siswanto


DBMS Scheduler Package is one of Oracle DBMS Packages that has the ability to perform automatic execution of data management at a predefined time. Oracle DBMS Scheduler is able to be integrated with Oracle Application Express on a web-based application. Web-based application can be accessed by a huge number of concurrent users that uses the same data on the database. On some conditions, users will not be allowed to change their data until the state of the current data is closed to maintain the data integrity, for example the scheduling data on university scheduling guidance between lecturers and students, where the student must not create another schedule until the existing schedule is closed. Data Integrity test is done by implementing web testing. This research found that the Oracle DBMS Scheduler Package is able to maintain data integrity on Web Based Application by closing the reservation schedule slot automatically.


Data Integrity Test; Oracle Application Express; Oracle DBMS Scheduler Package; Web Testing;

Full Text:



M. Alqahtani, "Online Lecturer Appointment System for Project Students", University of Hertfordshire, 2010.

A. M. Sinaga, "Case Study on Testing of Web-Based Application: Del’s Students Information System," Journal of Telecommunication, Electronic and Computer Engineering, vol. 9, no. 2-4, pp. 1-5, 2017.

D. Chen and H. Zhao, "Data Security and Privacy Protection Issues in Cloud Computing," in International Conference on Computer Science and Electronics Engineering, 2012.

S. Fuerstein and B. Pribyl, Oracle PL/SQL Programming, Fifth Edition, California: O’Reilly Media, Inc., 2009.

V. K. Myalapalli and B. L. R. Teja, "High Performance PL/SQL Programming," in International Conference on Pervasive Computing (ICPC), 2015.

Prabhjot and N. Sharma, "Overview of the Database Management System," International Journal of Advanced Research in Computer Science, pp. 262-269, 2017.

D. Saisanguansat and P. Jeatrakul, "Optimization Techniques for PL/SQL," in Fourteenth International Conference on ICT and Knowledge Engineering, 2016.

M. van der Plas and M. van Zoest, Oracle APEX 4.0 Cookbook, Birmingham: Packt Publishing, 2010.

V. Pathak, Oracle APEX 4.2 Reporting, Birmingham: Packt Publishing Ltd, 2013.

D. Parchment and S. Sankaranarayanan, "Intelligent Agent based Student-Staff Scheduling System", International Journal of Computer Information Systems and Industrial Management Applications, vol. 5, pp. 383-404, 2012.

R. Ramakrishnan and J. Gehrke, Database Management Systems Second Edition, New York: McGraw-Hill College, 2000.

A. Silberschatz and H. F. Korth, Database System Concepts Sixth Edition, NewYork: McGraw-Hill, 2011.

Y. Yan, X. Han, J. Yang and Q. Zhou, "On the Design of an Advanced Web-Based System for Supporting Thesis Research Process and Knowledge Sharing," Journal of Educational Technology Development and Exchange, vol. 5, no. 2, pp. 111-121, 2012.

R. S. Pressman, Software Engineering A Practitioner's Approach 5th Edition, New York: McGraw-Hill, 2001.

S. R. Jan, S. T. U. Shah, Z. U. Johar, Y. Shah and F. Khan, "An Innovative Approach to Investigate Various Software Testing Techniques and Strategies," International Journal of Scientific Research in Science, Engineering and Technology, pp. 682-689, 2016.


  • There are currently no refbacks.

Creative Commons License
This work is licensed under a Creative Commons Attribution 3.0 License.

ISSN: 2180-1843

eISSN: 2289-8131