Active Database System Approach and Rule Based in the Development of Academic Information System

  • Authors

    • M Miftakul Amin
    • Andino Maseleno
    • Shankar K
    • Eswaran Perumal
    • R M Vidhyavathi
    • Lakshmanaprabu SK
    2018-05-07
    https://doi.org/10.14419/ijet.v7i2.26.14361
  • active database system, ECA rules, trigger

  • Abstract

    Active database system is a database system which is  capable of generating a certain action automatically if it detects an event that meets certain conditions. The existence of Event Condition Action (ECA) rules and functional components such as triggers, stored procedures, and stored functions that are owned by active database system make the database system has the ability to automatically monitor input and output data. Separation of ECA rules components in the database with the application program will also facilitate the development of information systems. This research applies active database system in academic information system, so that academic business rules can be planted in database software and be able to produce the right solution automatically. The addition of active database system components to the database software makes procedures such as subject distribution, study plans, academic leave, values, thesis defense and other processes can be monitored by the system automatically. This can be done because between applications and databases use the model driven approach parameters to communicate with each other. The results of this research prove that a database is not only has  function as a container of data, but can control the information system actively, this is caused by the logic of programs that are generally planted in the application layer that can be moved and planted in the database software.

  • References

    1. [1] Vijayalakshmi, R., Duraipandian, N. 2014. Service Oriented Architecture and Privacy Preserving Mashup of Healthcare Data. International Journal of Engineering & Technology, vol.3, no.3, pp. 337-342.

      [2] Kurdi, N.,K. 2005. Rancang Bangun Sistem Administrasi Akademik (SIAKAD-2004) Berbasis Intranet Untuk Universitas Lampung. Tesis Magister Ilmu Komputer. Yogyakarta: Universitas Gadjah Mada

      [3] Efendi, R.M.M.H, 2007. Perancangan Sistem Informasi Akademik di Fakultas Adab UIN Sunan Kalijaga Yogyakarta dengan Konsep Human Computer Interaction. Tesis Magister Teknologi Informasi UGM. Yogyakarta

      [4] Fachrurrozi, M. 2008. Peningkatan Fungsionalitas Perangkat Lunak Melalui Restrukturisasi Data (Studi Kasus : Sistem Informasi Akademik Fakultas Ilmu Komputer Universitas Sriwijaya). Tesis Magister Informatika ITB. Bandung

      [5] PATON, N. W.; DÃAZ, O.; 1999. Active Database Systems. ACM Computing Surveys, vol.31, no.1, pp.63-103.

      [6] Lanova, W. 2009. Sistem Penjadwalan dengan Constraint Menggunakan Active Database. Skripsi Departemen Teknik Informatika IT. Telkom.

      [7] Meybodi, M.R.; Rasoolzadegan, A. 2010. Rule Scheduling in Active Database Using Learning Automata. International Journal of Computer, Mathematical Sciences and Applications, vol.4, no.1-2, pp.239-262.

      [8] Gupta, S.R.; Ali, M.S. 2010. Performance Evaluation in Active Real-Time Database System through Buffer Management. International Journal of Computer Science and Application, pp.151-156.

      [9] Guo, YZ. 2013. University Teaching Administration System based on Active Database. Proceedings of the 2nd International Conference on Computer Science and Electronics Engineering (ICCSEE 2013), published by Atlantis Press, Paris, France.

      [10] Ephzibah, E.P.; Sujatha, R. 2017. Big Data Management with Machine Learning Inscribed by Domain Knowledge for Health Care. International Journal of Engineering & Technology, vol.6, no.4, pp. 98-102.

      [11] ACT-NET Consortium. 1996. The Active Database Management System Manifesto: A Rulebase of ADBMS Features. ACM SIGMOD Record, vol.25, no.3, p.40-49.

      [12] Butleris, R; Kapocius, K. 2002. The Business Rules Repository For Information Systems Design. ADBIS. Department of Information Systems, Kaunas University of Technology, Lithuania.

      [13] Rabuzin K, Malekovi M, Lovreni A. 2007. The Theory of Active Databases vs. The SQL Standard. The Proceedings of 18 International Conference on Information and Intelligent Systems; Varaždin, Croatia, pp. 49-54.

      [14] Klaus R. Dittrich; Stella Gatziu; Andreas Geppert. 1995. The active database management system manifesto: A rulebase of ADBMS features. RIDS '95 Proceedings of the Second International Workshop on Rules in Database Systems, Pages 3-20

      [15] F. Casati, S. Castano, and M. Fugini. 2001. Managing Workflow Authorization Constraints through Active Database Technology. Information Systems Frontiers, vol. 3, no. 3, pp 319–338.

      [16] Rabuzin, K.; Maleković, M.; BaÄa, M. Active databases, business rules and reactive agents - what is the connection? Journal of Information and Organizational Sciences, vol.29, no.1, pp. 63-73.

      [17] Kozak, J. 2011. Rules in Database Systems. WDS'11 Proceedings of Contributed Papers, Part I, pp.131-136

      [18] Sharm, R.K.; Ghandi, P. 2017. Estimate Reliability of Component Based Software System Using Modified Neuro Fuzzy Model. International Journal of Engineering & Technology, v.6, n.2, pp. 45-49.

      [19] Singh, J.; Sharma, S. 2018. Fault Detection Technique for Test Cases in Software Engineering. International Journal of Engineering & Technology, vol.7, no.1, pp. 53-56.

      [20] Kermani, E.R.; Momeni, M. 2016. Simultaneous Management and Control on Cost and Time in The Project Development Through Fuzzy Logic to Risk Management. International Journal of Engineering & Technology, vol.5, no.4, pp. 135-138.

      [21] Yadav, M.; Kumari, S. 2016. A Paradigm for Active Database Management Systems. International Journal of Engineering and Computer Science, vol.5, no.1, pp.15572-15577.

  • Downloads

  • How to Cite

    Miftakul Amin, M., Maseleno, A., K, S., Perumal, E., M Vidhyavathi, R., & SK, L. (2018). Active Database System Approach and Rule Based in the Development of Academic Information System. International Journal of Engineering & Technology, 7(2.26), 95-101. https://doi.org/10.14419/ijet.v7i2.26.14361

    Received date: 2018-06-19

    Accepted date: 2018-06-19

    Published date: 2018-05-07