Revisiting Web Application Development with Integrated Records Management Important Aspect using Re-CRUD
DOI:
https://doi.org/10.24191/jikm.v12i1.5898Keywords:
web, web application framework, CRUD, web application developmentAbstract
A modern web application is plagued by a jungle of heterogeneous aspects and web technologies. Web frameworks or web application frameworks are examples of these technologies. These technologies have made it conceivable to confront verifiable issues of this WA development, for example, code automation and rapid prototyping. As the main factor for their features, both methods suggest the automation for redundant development tasks. A great analogy of a competitive and repetitive task that can be automated is the implementation of Create Read Update Delete (CRUD) operations. However, although the web application frameworks have provided a mechanism for CRUD operations, there are still many challenges that exist in integrating the other important aspects for modern data-driven WA such as searching, archiving, sharing, reporting and audit trail. So automation has not been properly faced yet. Further enhancement and manual code modification are required to improvise the halfbaked generated CRUD especially in the functional integration which is timeconsuming and comprise repetitive coding for each of the CRUD output. This paper presents Re-CRUD that integrates electronic records aspects into CRUD operation. Our approach is illustrated by combining a complete and robust methodology for dynamic code automation, electronic record management important aspects and Model View Controller (MVC) metaphor. A proof of concept study is carried out to demonstrate and validate the electronic record important aspect integration into CRUD operation for web application development. With the integrated important aspects in Re-CRUD, the development process is faster and able to automatically generate more features to support modern web applications.
References
Bandirmali, N. (2018). mtCMF: A novel memory table based content management framework for automatic website generation. Computer Standards and Interfaces, 58, 43–52. https://doi.org/10.1016/j.csi.2017.12.002
Bartosz Porebski, Karol Przystalski, L. N. (2011). Building PHP applications with Symfony, CakePHP, and Zend framework (1st ed.). Indianapolis: Wiley Publishing.
Broussard, M., & Boss, K. (2018). Saving Data Journalism: New strategies for archiving interactive, born-digital news. Digital Journalism, 6(9), 1206–1221. https://doi.org/10.1080/21670811.2018.1505437
CakePHP. (2020). CakePHP Cookbook Documentation. In CakePHP 4 (4th ed.). Retrieved from https://book.cakephp.org/4/_downloads/en/CakePHPCookbook.pdf
Chen, J., Jia, J., & Duan, L. (2011). DOM semantic expansion-based extraction of topical information from web pages. Lecture Notes in Computer Science (Including Subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), 6988 LNCS(PART 2), 343–350. https://doi.org/10.1007/978-3-642-23982-3_42
Chen, L., Lee, W. K., Chang, C. C., Choo, K. K. R., & Zhang, N. (2019). Blockchain based searchable encryption for electronic health record sharing. Future Generation Computer Systems, 95, 420–429. https://doi.org/10.1016/j.future.2019.01.018
Chu, W. C.-C., Chao, H.-C., & Yang, S. J. H. (2015). Intelligent Systems and Applications. Proceedings of the International Computer Symposium, 18(2), 9–11. IOS Press.
Crockett, M. (2011). User Guide to Retention and Disposal Schedules Council of Europe Records Management Project.
Da Rocha, H. (2019). Learn Chart. js: Create interactive visualizations for the Web with Chart.js 2. Packt Publishing Ltd.
Daly, L. (2007). Next-generation web frameworks in Python. O’Reilly Media, Inc.
Daoudi, A., ElBoussaidi, G., Moha, N., & Kpodjedo, S. (2019). An exploratory study of MVCbased architectural patterns in Android apps. Proceedings of the 34th ACM/SIGAPP Symposium on Applied Computing - SAC ’19, 1711–1720. https://doi.org/10.1145/3297280.3297447
Das, R., & Saikia, L. P. (2016). Comparison of Procedural PHP with Codeigniter and Laravel Framework. International Journal of Current Trends in Engineering & Research (IJCTER), 2(6), 42–48. Retrieved from http://www.ijcter.com
Dāsa, R. (2016). Learn CakePHP. In Learn CakePHP. https://doi.org/10.1007/978-1-4842-1212-7
David, S. (2016). Debugging. In Learning PHP. Retrieved from https://www.oreilly.com/library/view/learning-php/9781491933565/ch12.html
Dennis, A., Wixom, B. H., Roth, R. M. (Roberta M., Wixom, B. H., & Roth, R. M. (2014). Systems analysis and design (5th ed.). United States of America: John Wiley & Sons Ltd.
Dey, T. (2011). A Comparative Analysis on Modeling and Implementing with MVC Architecture. International Journal of Computer Applications®, (Mvc), 44–49. https://doi.org/10.1.1.472.1591
Diamond, M. (2017). How to Implement a Record Retention Schedule for Electronic and Other Records. Retrieved February 20, 2021, from Association of Corporate Counsel (ACC) website: https://www.acc.com/resource-library/how-implement-record-retentionschedule-electronic-and-other-records#
Dixit, B. (2016). Different Methods of Search and Bulk Operations. In Elasticsearch Essentials (pp. 143–160). Packt Publishing.
Eastwood, T. (2004). Appraising digital records for long-term preservation. Data Science Journal, 3, 202–208. https://doi.org/10.2481/dsj.3.202
Eastwood, T., Katuu, S., & Killawee, J. (2000). Appraisal of Electronic Records: A Review of the Literature in English.
ÉricQuinton. (2017). Using the MVC Model to Structure the Application. https://doi.org/10.1016/B978-1-78548-228-1.50006-0
Felin, T., & Kauffman, S. (2019). The Search Function and Evolutionary Novelty. SSRN Electronic Journal. https://doi.org/10.2139/ssrn.3468246
Frank, B., Kevin, H., & Douglas, C. S. (2007). Pattern-Oriented Software Architecture (4th ed.). Chichester: John Wiley & Sons Ltd.
Freeman, A. (2015). The Model/View/Controller Pattern. In Pro Design Patterns in Swift (pp. 527–552). https://doi.org/10.1007/978-1-4842-0394-1_27
Giatsoglou, M., Koutsonikola, V., Stamos, K., Vakali, A., & Zigkolis, C. (2010). Dynamic code generation for cultural content management. Proceedings - 14th Panhellenic Conference on Informatics, PCI 2010, 21–24. https://doi.org/10.1109/PCI.2010.35
Gipp, T., & Ebert, J. (2007). Functional web applications. Lecture Notes in Computer Science (Including Subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), 4607 LNCS, 194–209. https://doi.org/10.1007/978-3-540-73597-7_16
Golding, D. (2008). Beginning CakePHP: From novice to professional. In Beginning CakePHP: From Novice to Professional. https://doi.org/10.1007/978-1-4302-0978-2
Guo, H., Li, W., Nejad, M., & Shen, C. C. (2019). Access control for electronic health records with hybrid blockchain-edge architecture. Proceedings - 2019 2nd IEEE International Conference on Blockchain, Blockchain 2019, 44–51. https://doi.org/10.1109/Blockchain.2019.00015
Gutlić, A., & Mujčić, E. (2020). Intelligent Web Application for Search of Restaurants and Their Services. In Networks and Systems (Vol. 83, pp. 452–469). https://doi.org/10.1007/978-3-030-24986-1_36
Haggerty, K. C., & Scott, R. E. (2019). Do, or Do Not, Make Them Think?: A Usability Study of an Academic Library Search Box. Journal of Web Librarianship, 13(4), 296–310. https://doi.org/10.1080/19322909.2019.1684223
Hall, R. H., Digennaro, A., Ward, J., & Havens, N. (2003). Usability Assessment Of A WebBased Learning System For Teaching Web Development: A Progressive Scaffolding Approach.
Hao, L., Zhang, J., & Ma, X. (2019). Design and Implementation of Simulation Training System Based on MVC Architecture. IOP Conference Series: Materials Science and Engineering, 563, 52043. https://doi.org/10.1088/1757-899X/563/5/052043
Harvey, R., & Thompson, D. (2010). Automating the appraisal of digital materials. Library Hi Tech, 28(2), 313–322. https://doi.org/10.1108/07378831011047703
Herrero Agustin, J. L., & Del Barco, P. C. (2013). A model-driven approach to develop high performance web applications. Journal of Systems and Software, 86(12), 3013–3023. https://doi.org/10.1016/j.jss.2013.07.028
International Council on Archives. (2013). Principles and functional requirements for records in electronic office environments. Retrieved from
https://www.ica.org/sites/default/files/9. Recordkeeping Requirements for Database Based Business Systems.pdf
Ira A. Penn, & Gail B. Pennix. (2017). Records inventory. In Records Management Handbook (2nd ed.). New York: Routledge.
IRMT. (2009). Managing the Creation, Use and Disposal of Electronic Records. International Record Management Trust.
Ivanovich, B. V., Vladimirovich, B. V., Victorovich, N. F., Viktorovich, B. V., & Vitalievna, A. L. (2019). Using MVC pattern in the software development to simulate production of high cylindrical steel ingots. Journal of Crystal Growth, 526, 125240. https://doi.org/10.1016/j.jcrysgro.2019.125240
Jazayeri, M. (2007). Some trends in Web application development. FoSE 2007: Future of Software Engineering, 199–213. https://doi.org/10.1109/FOSE.2007.26
Judith Read, & Mary Lea Ginn. (2016). Electronic Records Management. In Records Management (10th ed.). Boston: Cengage Learning.
Kai, C., Omokore, J., & Miller, R. K. (2009). Practical CakePHP Projects. In Practical CakePHP Projects. https://doi.org/10.1007/978-1-4302-1579-0
Kalinin, A., Cetintemel, U., & Zdonik, S. (2015). Searchlight: Enabling integrated search and exploration over large multidimensional data. In Proceedings of the VLDB Endowment (Vol. 8, pp. 1094–1105). https://doi.org/10.14778/2794367.2794378
Karnouskos, S., Da Silva, P. G., & Ilić, D. (2013). Developing a web application for monitoring and management of Smart Grid neighborhoods. IEEE International Conference on Industrial Informatics (INDIN), 408–413. https://doi.org/10.1109/INDIN.2013.6622919
Katuu, S. (2012). Enterprise content management (ECM) implementation in South Africa. Records Management Journal, 22(1), 37–56. https://doi.org/10.1108/09565691211222081
Katuu, S. (2016). Managing digital records in a global environment: A review of the landscape of international standards and good practice guidelines. Electronic Library, Vol. 34, pp. 869–894. https://doi.org/10.1108/EL-04-2015-0064
Kautz, K., Madsen, S., & Nørbjerg, J. (2007). Persistent problems and practices in information systems development. Information Systems Journal, 17(3), 217–239. https://doi.org/10.1111/j.1365-2575.2007.00222.x
Kelly, S. (2019). Model View Controller. In Python, PyGame, and Raspberry Pi Game Development (pp. 213–231). https://doi.org/10.1007/978-1-4842-4533-0_17
Kessentini, M., Wang, H., Dea, J. T., & Ouni, A. (2017). Improving Web Services Design Quality Using Heuristic Search and Machine Learning. Proceedings - 2017 IEEE 24th International Conference on Web Services, ICWS 2017, 540–547. https://doi.org/10.1109/ICWS.2017.63
Kirschenbaum, M. (2013). The .txtual Condition: Digital Humanities, Born-Digital Archives, and the Future Literary. Digital Humanities Quarterly, 007(1).
Krasner, G. E., & Pope, S. T. (1988). A Cookbook for Using the Model-view Controller User Interface Paradigm in Smalltalk-80. J. Object Oriented Program., 1(3), 26–49. Retrieved from http://dl.acm.org/citation.cfm?id=50757.50759
Kumar, S., & Gupta, S. (2019). Development of Decision Support System for Promotion Assessment. 2019 6th International Conference on Computing for Sustainable Global Development (INDIACom), 1169–1173.
Laaziri, M., Benmoussa, K., Khoulji, S., & Kerkeb, M. L. (2019). A Comparative study of PHP frameworks performance. Procedia Manufacturing, 32, 864–871. https://doi.org/10.1016/j.promfg.2019.02.295
Laaziri, M., Benmoussa, K., Khoulji, S., Larbi, K. M., & Yamami, A. El. (2019). A comparative study of laravel and symfony PHP frameworks. International Journal of Electrical and Computer Engineering, 9(1), 704–712. https://doi.org/10.11591/ijece.v9i1.pp.704-712
Laaziri, M., Benmoussa, K., Khoulji, S., Mohamed Larbi, K., & Yamami, A. El. (2019). Analyzing bootsrap and foundation font-end frameworks : a comparative study. International Journal of Electrical and Computer Engineering (IJECE), 9(1), 713. https://doi.org/10.11591/ijece.v9i1.pp713-722
Laravel. (2019). Laravel - The PHP Framework For Web Artisans. Retrieved July 14, 2020, from LARAVEL website: https://laravel.com/docs/8.x/controllers
Larman, C., & Basili, V. R. (2003). Iterative and incremental development: A brief history. Computer, Vol. 36, pp. 47–56. https://doi.org/10.1109/MC.2003.1204375
Lazetic, S., Savic, D., Vlajić, S., & Lazarević, S. (2012). A Generator of MVC-based Web Applications. World of Computer Science and Information Technology Journal, 2, 2221–2741.
Lee, C. A. (2019). Computer-Assisted Appraisal and Selection of Archival Materials. Proceedings - 2018 IEEE International Conference on Big Data, Big Data 2018, 2721–2724. https://doi.org/10.1109/BigData.2018.8622267
Lemieux, V. L. (2016). Trusting records: is Blockchain technology the answer? Records Management Journal, 26(2), 110–139. https://doi.org/10.1108/RMJ-12-2015-0042
Lengstorf, J., & Wald, K. (2016). Pro PHP and jQuery. https://doi.org/10.1007/978-1-4842-1230-1
Li, X., Karnan, S., & Chishti, J. A. (2018). An empirical study of three PHP frameworks. 2017 4th International Conference on Systems and Informatics, ICSAI 2017, 2018-Janua, 1636–1640. https://doi.org/10.1109/ICSAI.2017.8248546
Lo, N. W., Wu, C. Y., & Chuang, Y. H. (2017). An authentication and authorization mechanism for long-term electronic health records management. Procedia Computer Science, 111, 145–153. https://doi.org/10.1016/j.procs.2017.06.021
Mark, R. H. (2013). Instant CakePHP Starter. Packt Publishing.
Maroye, L., van Hooland, S., Aranguren Celorrio, F., Soyez, S., Losdyck, B., Vanreck, O., & de Terwangne, C. (2017). Managing electronic records across organizational boundaries: The experience of the Belgian federal government in automating investigation processes. Records Management Journal, 27(1), 69–83. https://doi.org/10.1108/RMJ-11-2015-0037
Martin, J. (1983). Managing the data-base environment. USA: Prentice Hall.
Masenya, T. M. (2020). Application of modern technologies in the management of records in public libraries. Journal of the South African Society of Archivists, 53, 65–79. https://doi.org/10.4314/jsasa.v53i1.5
Maskrey, M. K. (2016). Web Services. In App Development Recipes for iOS and watchOS (pp. 259–299). https://doi.org/10.1007/978-1-4842-1820-4_11
Massimo Di Pierro. (2011). web2py for Scientific Applications. Computing in Science and Engineering, 13(2), 64–69. https://doi.org/10.1109/MCSE.2010.97
McArthur, K. (2008). Pro PHP Patterns, Frameworks, Testing and More (1st ed.). https://doi.org/10.1007/978-1-4302-0279-0
McFedries, P. (2018). Web Coding & Development All-in-One For Dummies. New Jersey: John Wiley & Sons, Inc.
Mike, A. (2017). RESTful Web Clients. Retrieved from http://shop.oreilly.com/product/0636920037958.do
Miles, M. (2016). Using web2py Python framework for creating data-driven web applications in the academic library. Library Hi Tech, 34(1), 164–171. https://doi.org/10.1108/LHT08-2015-0082
Muhanna, E. (2018, February 1). What does “Born digital” mean? International Journal of Middle East Studies, Vol. 50, pp. 110–112. https://doi.org/10.1017/S0020743817000976
Murugesan, S. (2007). Web Application Development: Challenges And The Role Of Web Engineering. In Web Engineering: Modelling and Implementing Web Applications (pp. 7–32). https://doi.org/10.1007/978-1-84628-923-1_2
Namukasa, J. (2017). Records management and procurement performance: A case of NAADS program in the central region of Uganda. Records Management Journal, 27(3), 256–274. https://doi.org/10.1108/RMJ-04-2016-0011
Nguyen, H. V., Kästner, C., & Nguyen, T. N. (2014). Exploring variability-aware execution for testing plugin-based web applications. Proceedings - International Conference on Software Engineering, (1), 907–918. https://doi.org/10.1145/2568225.2568300
Nguyen, L. T., Swatman, P. M., & Fraunholz, B. (2007). EDMS, ERMS, ECMS or EDRMS: Fighting through the acronyms towards a strategy for effective corporate records management. ACIS 2007 Proceedings - 18th Australasian Conference on Information Systems, 790–800. Retrieved from http://aisel.aisnet.org/acis2007/122
Niu, J. (2014). Appraisal and Selection for Digital Curation. International Journal of Digital Curation, 9(2), 65–82. https://doi.org/10.2218/ijdc.v9i2.272
Noppadon, P., & Panita, W. (2013). Development of a Ubiquitous Learning System with Scaffolding and Problem-Based Learning Model to Enhance Problem-Solving Skills and ICT Literacy. International Journal of E-Education, e-Business, e-Management and eLearning, 3(3). https://doi.org/10.7763/ijeeee.2013.v3.222
Oladejo, B., & Hadžidedić, S. (2021). Electronic records management – a state of the art review. Records Management Journal, ahead-of-p(ahead-of-print). https://doi.org/10.1108/RMJ-09-2019-0059
Olanrewaju, R., Islam, T., & Ali, N. (2015). An Empirical Study of the Evolution of PHP MVC Framework. https://doi.org/10.1007/978-3-319-07674-4_40
Onesinus, S. P. (2019). Laravel CRUD with bootstrap jQuery and Mysql. OSPT.
Paolone, G., Marinelli, M., Paesani, R., & Di Felice, P. (2020). Automatic code generation of mvc web applications. Computers, 9(3), 1–29.
https://doi.org/10.3390/computers9030056
Pappel, I., Butt, S., Pappel, I., & Draheim, D. (2021). On the specific role of electronic document and record management systems in enterprise integration. In Advances in Intelligent Systems and Computing (Vol. 1184, pp. 37–51). https://doi.org/10.1007/978-981-15-5859-7_3
Patricia C. Franks. (2013). Records Retention Strategies Inventory Appraisal Retention and Disposition. In Records and Information Management (pp. 84–114). American Library Association.
Pauline, J., Shelda, D., & Peter, G. (2013). Search behaviour in electronic document and records management systems: an exploratory investigation and model. Retrieved February 21, 2021, from Information Research website: http://informationr.net/ir/18 -1/paper572.html#.YDJWS2gzaUk
Pitt, C. (2012). Pro PHP MVC. In Pro PHP MVC. https://doi.org/10.1007/978-1-4302-4165-2
Pop, D.-P. P., & Altar, A. (2014). Designing an MVC model for rapid web application development. Procedia Engineering, 69, 1172–1179.
https://doi.org/10.1016/j.proeng.2014.03.106
Porebski, B., Przystalski, K., & Nowak, L. (2011). Building PHP Applications with Symfony, CakePHP, and Zend Framework (1st ed.). GBR: Wrox Press Ltd.
Prokofyeva, N., & Boltunova, V. (2016). Analysis and Practical Application of PHP Frameworks in Development of Web Information Systems. Procedia Computer Science, 104, 51–56. https://doi.org/10.1016/j.procs.2017.01.059
Prokofyeva, N., & Boltunova, V. (2017). Analysis and Practical Application of PHP Frameworks in Development of Web Information Systems. Procedia Computer Science, 104, 51–56. https://doi.org/10.1016/j.procs.2017.01.059
Rails Guides Team. (2015). Getting Started with Rails — Ruby on Rails Guides. Retrieved November 28, 2019, from https://guides.rubyonrails.org/getting_started.html#getting-upand-running-quickly-with-scaffolding
Ratnayake, R. N. (2015). WordPress Web Application Development (3rd ed.). Birmingham: Packt.
Raunak, M. S., Kuhn, D. R., & Kacker, R. (2017). Combinatorial Testing of Full Text Search in Web Applications. Proceedings - 2017 IEEE International Conference on Software Quality, Reliability and Security Companion, QRS-C 2017, 100–107. https://doi.org/10.1109/QRS-C.2017.24
Ries, T., & Palkó, G. (2019). Born-digital archives. International Journal of Digital Humanities, 1(1), 1–11. https://doi.org/10.1007/s42803-019-00011-x
Rodriguez-Echeverria, R., M. Conejero, J., Preciado, J. C., & Sanchez-Figueroa, F. (2016). AutoCRUD - Automating IFML Specification of CRUD Operations. Proceedings of the 12th International Conference on Web Information Systems and Technologies, 1, 307– 314. https://doi.org/10.5220/0005923003070314
Rodriguez-Echeverria, R., Preciado, J. C., Rubio-Largo, Á., Conejero, J. M., & Prieto, Á. E. (2019). A Pattern-Based Development Approach for Interaction Flow Modeling Language. Scientific Programming, 2019, 1–15. https://doi.org/10.1155/2019/7904353
Rodriguez-Echeverria, R., Preciado, J. C., Sierra, J., Conejero, J. M., & Sanchez-Figueroa, F. (2018). AutoCRUD: Automatic generation of CRUD specifications in interaction flow modelling language. Science of Computer Programming, 168, 165–168. https://doi.org/10.1016/j.scico.2018.09.004
Singh, S. (2016). Comparative Study of MVC ( Model View Controller ) Architecture with respect to Struts Framework and PHP. International Journal of Computer Science Engineering, 5(03), 142–150. Retrieved from www.ijcse.net/docs/IJCSE16-05-03-090.pdf
Sinha, S. (2019). Introduction to Laravel. In Beginning Laravel (pp. 1–10). https://doi.org/10.1007/978-1-4842-4991-8_1
Stauffer, M. (2019). Laravel: Up and Running: A Framework for Building Modern PHP Apps (2nd ed.). O’Reilly Media.
Symfony. (2019). Generating a CRUD Controller Based on a Doctrine Entity (SensioLabs Generator Bundle Docs). Retrieved July 14, 2020, from Symfony Official Documentation website: https://symfony.com/doc/current/bundles/SensioGeneratorBundle/commands/generate_d octrine_crud.html
The National Archives United Kingdom. (2017). Migrating information between records management systems. 1–35.
UK National Archive. (2012). Records Management retention scheduling. Retrieved from www.archive.official documents.co.uk/document/cm43/4310/4310.htm
Vellino, A., & Alberts, I. (2016). Assisting the appraisal of e-mail records with automatic classification. Records Management Journal, 26(3), 293–313. https://doi.org/10.1108/RMJ-02-2016-0006
Vohra, D. (2007). Ruby on rails for PHP and Java developers. In Ruby on Rails for PHP and Java Developers. https://doi.org/10.1007/978-3-540-73145-0
Wang, H., Kessentini, M., & Ouni, A. (2016). Bi-level identification of web service defects. Lecture Notes in Computer Science, 9936 LNCS, 352–368. https://doi.org/10.1007/978-3-319-46295-0_22
Watts, J., & Jorge, G. (2014). CakePHP 2 Application Cookbook. USA: Packt Publishing.
Yin, X., Zheng, W., Zhang, M., Zhang, J., Zhuang, G., & Ding, T. (2014). A modularized operator interface framework for Tokamak based on MVC design pattern. Fusion Engineering and Design, 89(5), 628–632. https://doi.org/10.1016/j.fusengdes.2014.03.028
Yu, X., & Jin, Z. (2018). Web content information extraction based on DOM tree and statistical information. International Conference on Communication Technology Proceedings, ICCT, 2017-October, 1308–1311. https://doi.org/10.1109/ICCT.2017.8359846
Zdenek, M. (2014). PHPUnit Essential. Birmingham, UK: Packt Publishing.
Downloads
Published
How to Cite
Issue
Section
License
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
Copyright of articles that appear in the journal belongs exclusively to Faculty of Information Science, Universiti Teknologi MARA (Publisher). This copyright covers the rights to reproduce the article, including reprints, electronic reproductions or any other reproductions of similar nature.
