Hybrid Database Solutions for Real-Time Educational Data Processing

References

[1] Cattell, R. (2011). Scalable SQL and NoSQL data stores. ACM SIGMOD Record, 39(4), 12–27. https://doi.org/10.1145/1978915.1978919

[2] Stonebraker, M., Abadi, D. J., DeWitt, D. J., Madden, S., Paulson, E., Pavlo, A., & Rasin, A. (2010). MapReduce and parallel DBMSs: Friends or foes? Communications of the ACM, 53(1), 64–71. https://doi.org/10.1145/1629175.1629197

[3] Sharma, A., & Kaur, R. (2022). Hybrid cloud-based database architecture for educational data analytics. International Journal of Cloud Applications and Computing, 12(4), 55–71.

[4] Tiwari, S., & Patel, N. (2021). Real-time educational data processing using hybrid database management systems. Journal of Educational Technology Systems, 49(4), 589–607. https://doi.org/10.1177/0047239520980282

[5] Sadalage, P. J., & Fowler, M. (2012). NoSQL distilled: A brief guide to the emerging world of polyglot persistence. Addison-Wesley.

[6] Grolinger, K., Higashino, W. A., Tiwari, A., & Capretz, M. A. M. (2013). Data management in cloud environments: NoSQL and NewSQL data stores. Journal of Cloud Computing: Advances, Systems and Applications, 2, Article 22. https://doi.org/10.1186/2192-113X-2-22

[7] Ahmad, M., & Bhatti, R. (2022). Polyglot persistence in education: Towards hybrid database adoption. International Journal of Computer Applications, 184(3), 17–23. https://doi.org/10.5120/ijca2022921812

[8] Zikopoulos, P., & Eaton, C. (2011). Understanding big data: Analytics for enterprise class Hadoop and streaming data. McGraw-Hill.

[9] Li, J., Chen, J., & Zhang, K. (2020). A hybrid storage architecture for large-scale educational data in cloud computing environments. IEEE Access, 8, 175349–175361. https://doi.org/10.1109/ACCESS.2020.3026510

[10] Oracle. (2023). Oracle autonomous database: Hybrid database management for educational data. Oracle White Paper. https://www.oracle.com/database/autonomous-database

[11] MongoDB Inc. (2022). Real-time analytics on hybrid data platforms: A guide for educational institutions. MongoDB White Paper. https://www.mongodb.com/white-papers/real-time-analytics

[12] Pulivarthy, P. (2025). Hybrid cloud databases for educational ERP: Design and challenges. FMDB Transactions on Sustainable Computing Systems, 3(1), 56–67.

[13] Gupta, S. K., & Sharma, V. (2023). Optimizing hybrid database systems for IoT-enabled educational campuses. Journal of Cloud Computing Research, 7(2), 105–118.

[14] Buyya, R., & Dastjerdi, A. V. (2016). Internet of Things: Principles and paradigms. Morgan Kaufmann.

[15] Khan, A., & Salah, K. (2018). IoT security: Review, blockchain solutions, and open challenges. Future Generation Computer Systems, 82, 395–411. https://doi.org/10.1016/j.future.2017.11.022

[16] Pathak, A., Anbu, A. D., Jamil, A. B. A., et al. (2025). Evaluation of energy consumption data for business consumers. Environment, Development and Sustainability. https://doi.org/10.1007/s10668-024-05960-0

[17] Pulivarthy, P. (2024). Harnessing serverless computing for agile cloud application development. FMDB Transactions on Sustainable Computing Systems, 2(4), 201–210.

[18] Pulivarthy, P. (2024). Research on Oracle database performance optimization in IT-based university educational management system. FMDB Transactions on Sustainable Computing Systems, 2(2), 84–95.

[19] Pulivarthy, P. (2024). Optimizing large scale distributed data systems using intelligent load balancing algorithms. AVE Trends in Intelligent Computing Systems, 1(4), 219–230.

[20] Pulivarthy, P. (2022). Performance tuning: AI analyse historical performance data, identify patterns, and predict future resource needs. International Journal of Innovative Applications of Science and Engineering, 8, 139–155.

[21] Pulivarthy, P., & Bhatia, A. B. (2025). Designing empathetic interfaces enhancing user experience through emotion. In S. Tikadar, H. Liu, P. Bhattacharya, & S. Bhattacharya (Eds.), Humanizing technology with emotional intelligence (pp. 47–64). IGI Global. https://doi.org/10.4018/979-8-3693-7011-7.ch004

[22] Nayak, M., Panigrahi, A., Dass, A. K., Mishra, B. K., & Gupta, S. K. (2025). Blockchain in Industry 4.0 and Industry 5.0: A paradigm shift towards decentralized efficiency and autonomous ecosystems. In Computational Intelligence in Industry 4.0 and 5.0 Applications (pp. 36). CRC Press. https://doi.org/10.1201/9781003581963-7

[23] Joshi, R., Pandey, K., Kumari, S., Gupta, S. K., Mohanty, M., & Salau, A. O. (2024). Augmenting EHR systems by utilizing blockchain technology with unique Aadhaar identity system. IC3TES 2024. https://doi.org/10.1109/IC3TES62412.2024.10877615

[24] Joshi, R., Pandey, K., Kumari, S., Gupta, S. K., Mohanty, M., & Salau, A. O. (2024). Exploring the development of machine learning innovation technology for data mining in smart healthcare. IC3TES 2024. https://doi.org/10.1109/IC3TES62412.2024.10877632

[25] Ayalew, A. M., et al. (2024). InvNets: A novel approach for Parkinson disease detection using involution neural networks. IC3TES 2024. https://doi.org/10.1109/IC3TES62412.2024.10877493

[26] Ayalew, A. A., et al. (2024). Grid search hyperparameters tuning with supervised machine learning for Awngi language named entity recognition. IC3TES 2024. https://doi.org/10.1109/IC3TES62412.2024.10877504

[27] Mammo, A. F., et al. (2024). Multimodal bio cryptography for securing cloud computing using convolutional neural network. IC3TES 2024. https://doi.org/10.1109/IC3TES62412.2024.10877575

[28] Salau, A. O., Miyenseigha Marvellous, T. J., Gupta, S. K., Żywiołek, J., Onibonoje, M. O., & Kanna, R. K. (2024). Development of a smart IoT-based dustbin level monitoring system. IC3TES 2024. https://doi.org/10.1109/IC3TES62412.2024.10877603

[29] Gupta, S. K., & Mehta, S. (2024). Optimization of processing sequence and computation mode in IoT for mobile edge computing: A comprehensive analysis. In Emerging materials, technologies, and solutions for energy harvesting (pp. 16–32). IGI Global. https://doi.org/10.4018/979-8-3693-2003-7.ch002

[30] Gupta, S. K., & Mehta, S. (2024). Antenna identification and power allocation in multicell massive MIMO downstream: Energy conservation under user sum-rate constraint. In Emerging materials, technologies, and solutions for energy harvesting (pp. 1–15). IGI Global. https://doi.org/10.4018/979-8-3693-2003-7.ch001

[31] Krishna, S., Natarajan, R., Flammini, F., Alfurhood, B. S., Janhavi, V., & Gupta, S. K. (2025). Web security in the digital age: Artificial intelligence solution for malicious website classification. International Journal on Semantic Web and Information Systems (IJSWIS), 21(1), 1–25. https://doi.org/10.4018/IJSWIS.369823

[32] Joshi, R., Pandey, K., Kumari, S., Gupta, S. K., Mohanty, M., & Salau, A. O. (2024). Analyzing the futuristic scope of artificial intelligence in the healthcare sector in India. IC3TES 2024. https://doi.org/10.1109/IC3TES62412.2024.10877568

[33] Joshi, R., Pandey, K., Kumari, S., Gupta, S. K., Mohanty, M., & Salau, A. O. (2024). Blockchain-powered monitoring of healthcare credentials through blockchain-based technology. In Blockchain-enabled Internet of Things applications in healthcare: Current practices and future directions (pp. 170). Bentham Science Publishers. https://doi.org/10.2174/9789815305210125010011

[34] Deepan, P., Vidy, R., Arul, N., Dhiravidaselvi, S., & Gupta, S. K. (2025). Revolutionizing hen care in smart poultry farming: The impact of AI-driven sensors on optimizing avian health. In Blockchain-enabled Internet of Things applications in healthcare: Current practices and future directions (pp. 200). Bentham Science Publishers. https://doi.org/10.2174/9789815305210125010012

[35] Puvvada, R. K. (2025). Enterprise revenue analytics and reporting in SAP S/4HANA Cloud. European Journal of Science, Innovation and Technology, 5(3), 25–40.

[36] Puvvada, R. K. (2025). Industry-specific applications of SAP S/4HANA Finance: A comprehensive review. International Journal of Information Technology and Management Information Systems, 16(2), 770–782.

[37] Puvvada, R. K. (2025). SAP S/4HANA Cloud: Driving digital transformation across industries. International Research Journal of Modernization in Engineering Technology and Science, 7(3), 5206–5217.

[38] Puvvada, R. K. (2025). The impact of SAP S/4HANA Finance on modern business processes: A comprehensive analysis. International Journal of Scientific Research in Computer Science, Engineering and Information Technology, 11(2), 817–825.

[39] Suresh Kumar, V., Khalaf, O. I., Raman Chandan, R., et al. (2024). Implementation of a novel secured authentication protocol for cyber security applications. Scientific Reports, 14, 25708. https://doi.org/10.1038/s41598-024-76306-z

[40] Kishore Kumar, A., Alemran, A., Karras, D. A., Gupta, S. K., Dixit, C. K., & Haralayya, B. (2023). An enhanced genetic algorithm for solving trajectory planning of autonomous robots. IEEE ICICACS 2023, 1–6. https://doi.org/10.1109/ICICACS57338.2023.10099994

[41] Gupta, S. K., Kumar, V. S., Khang, A., Hazela, B., N. T., & Haralayya, B. (2023). Detection of lung tumor using an efficient quadratic discriminant analysis model. IEEE ICRTEC 2023, 1–6. https://doi.org/10.1109/ICRTEC56977.2023.10111903

[42] Gupta, S. K., Alemran, A., Singh, P., Khang, A., Dixit, C. K., & Haralayya, B. (2023). Image segmentation on Gabor filtered images using projective transformation. IEEE ICRTEC 2023, 1–6. https://doi.org/10.1109/ICRTEC56977.2023.10111885

[43] Gupta, S. K., Saxena, S., Khang, A., Hazela, B., Dixit, C. K., & Haralayya, B. (2023). Detection of number plate in vehicles using deep learning based image labeler model. IEEE ICRTEC 2023, 1–6. https://doi.org/10.1109/ICRTEC56977.2023.10111862

[44] Gupta, S. K., Ahmad, W., Karras, D. A., Khang, A., Dixit, C. K., & Haralayya, B. (2023). Solving roulette wheel selection method using swarm intelligence for trajectory planning of intelligent systems. IEEE ICRTEC 2023, 1–5. https://doi.org/10.1109/ICRTEC56977.2023.10111861

[45] Salau, A. O., Miyenseigha Marvellous, T. J., Gupta, S. K., Żywiołek, J., Onibonoje, M. O., & Kanna, R. K. (2024). Development of a smart IoT-based dustbin level monitoring system. IEEE IC3TES 2024, 1–5. https://doi.org/10.1109/IC3TES62412.2024.10877603

[46] Ayalew, A. A., et al. (2024). Grid search hyperparameters tuning with supervised machine learning for Awngi language named entity recognition. IEEE IC3TES 2024, 1–6. https://doi.org/10.1109/IC3TES62412.2024.10877504

[47] Mammo, A. F., et al. (2024). Multimodal bio cryptography for securing cloud computing using convolutional neural network. IEEE IC3TES 2024, 1–6. https://doi.org/10.1109/IC3TES62412.2024.10877575

[48] Ayalew, A. M., et al. (2024). InvNets: A novel approach for Parkinson disease detection using involution neural networks. IEEE IC3TES 2024, 1–7. https://doi.org/10.1109/IC3TES62412.2024.10877493

[49] Joshi, R., Pandey, K., Kumari, S., Gupta, S. K., Mohanty, M., & Salau, A. O. (2024). Augmenting EHR systems by utilizing blockchain technology with unique Aadhaar identity system. IEEE IC3TES 2024, 1–6. https://doi.org/10.1109/IC3TES62412.2024.10877615

[50] Joshi, R., Pandey, K., Kumari, S., Gupta, S. K., Mohanty, M., & Salau, A. O. (2024). Exploring the development of machine learning innovation technology for data mining in smart healthcare. IEEE IC3TES 2024, 1–5. https://doi.org/10.1109/IC3TES62412.2024.10877632

@article{1709489,
      author = {Dr. Ashish Kumar Pandey},
      title = {Hybrid Database Solutions for Real-Time Educational Data Processing},
      journal = {Iconic Research And Engineering Journals},
      year = {2025},
      volume = {8},
      number = {12},
      pages = {1766-1774},
      issn = {2456-8880},
      url = {https://www.irejournals.com/formatedpaper/1709489.pdf},
      abstract = {The accelerated digital revolution in the education industry has resulted in an explosive growth in the volume, variety, and speed of data produced by institutions of learning. Real-time educational activities?like online admissions, grading of examinations, monitoring of attendance, e-learning analytics, and tracking of student performance?are required to be supported by flexible and elastic data processing infrastructure. Legacy relational databases, although adequate for structured transactional information, tend to fail when dealing with unstructured or semi-structured data and scaling under dynamic loads. NoSQL databases, however, provide high performance and flexibility but can fall short on strong consistency and transactional assurances critical for academic core functions. To overcome the above-mentioned limitations, hybrid database solutions, combining the capabilities of relational (SQL) and non-relational (NoSQL) systems, are proving to be a strategic solution in facilitating real-time processing of educational data. This paper discusses the design, deployment, and performance analysis of hybrid database architecture in educational institutions. The study examines how an integration of databases like MySQL or PostgreSQL with MongoDB, Cassandra, or Firebase can provide both data consistency and horizontal scalability. The suggested hybrid model is applied and evaluated in simulated academic environments, such as real-time publishing of results, real-time monitoring of attendance, and dynamic content dissemination in Learning Management Systems (LMS). Middleware software like Apache Kafka and API gateways are employed to facilitate synchronization, streaming, and smooth integration of the systems. The outcomes prove that hybrid solutions minimize data latency, enhance system response, and provide a versatile framework for managing heterogeneous types of educational data. It also includes some of the major challenges that accompany hybrid deployment, including data model complexity, synchronization overhead, and administrative skill deficiency. Nevertheless, the advantages such as real-time responsiveness, cost-effectiveness, and flexibility make hybrid databases a future-proof solution for academia infrastructures. The research concludes by providing strategic recommendations for institutions that need to implement hybrid architectures and proposing a roadmap for the implementation of emerging technologies like AI-based query optimization and blockchain for ensuring educational data integrity.},
      keywords = {Hybrid Database, Real-Time Data Processing, Educational Technology, SQL, NoSQL, MongoDB, MySQL, Academic Management Systems, Learning Analytics, Data Synchronization, Apache Kafka, Educational Infrastructure},
      month = {June},
  }