The application of Internet of things and Oracle database in the research of intelligent data management system

Authors

  • Yujiao Liu Chongqing Open University
  • Rajeev Kumar Chitkara University Institute of Engineering and Technology, Chitkara University, Punjab, India
  • Ashutosh Tripathi Department of ECE, University Institute of Engineering, Chandigarh University, Chandigarh, India
  • Anil Sharma Department of Computer Science, Faculty of Technology, Debre Tabor University, Ethiopia
  • Muskaan Rana Department of Computer Science and Engineering Chandigarh University, Mohali, India

DOI:

https://doi.org/10.31449/inf.v46i3.4019

Abstract

Aiming at the needs of general large-scale monitoring systems, this paper designs an intelligent data management system that can provide fast data query and relieve sudden data congestion through in-depth research on Oracle database and data division. To the data access request from the front desk, the system can respond quickly through the real-time data monitoring module and the online analysis software OLAP mode database, which has far-reaching significance for the development of the Internet of Things and related systems. The experimental results show that, compared with the traditional system, the same bitmap index only occupies about 1/30 of the original table, and the data size is reduced by more than 10 times. The experimental data verifies the characteristics of the system in this paper to strengthen the background data receiving and processing capabilities, and alleviate the problems such as the reduction of the system running rate and even the system paralysis caused by the sudden mass data.

References

Zheng, F. , & Zheng, B. . (2021). Research on the optimization and application of intelligent data acquisition and alarm system based on internet of things. Journal of Physics: Conference Series, 1992(2), 022083 (4pp).

Hemanth, J. , Bestak, R. , & Chen, I. Z. . (2021). Intelligent data communication technologies and internet of things proceedings of icici 2020: proceedings of icici 2020.

Dan, J. , Y Zheng, & Hu, J. . (2021). Research on sports training model based on intelligent data aggregation processing in internet of things. Cluster Computing, 1-8.

Xue, B. . (2021). Information Fusion and Intelligent Management of Industrial Internet of Things under the Background of Big Data. 2021 13th International Conference on Measuring Technology and Mechatronics Automation (ICMTMA).

Gao, L. , Yang, Q. , Zou, B. , Liu, Q. , & Wang, C. . (2021). Research on data asset management system of graph database based on internet of things. Journal of Physics: Conference Series, 1802(3), 032134 (7pp).

Crosthwaite, C. . (2021). Minimising risk—the application of kotter's change management model on customer relationship management systems: a case study. Journal of Risk and Financial Management, 14.

Jia, J. , & Wang, B. . (2021). The development of intelligent operation method of urban public infrastructure driven by accurate spatio-temporal information. Journal of Surveying and Mapping, 4(2), 9.

WangZhenzhuozhenzhuowang@gmail.comSharmaAmitamit.amitsharma@gmail.comCollege of Mechanical Engineering and Automation, Henan Polytechnic Institute,Nanyang ,ChinaDepartment of Computer Science and Engineering, Jaypee University of Information Technology,Solan,,India. (2021). Research on transformer vibration monitoring and diagnosis based on internet of things. Journal of Intelligent Systems, 30(1), 677-688.

Zhen, H. , Kumar, P. M. , & Samuel, R. D. J. . (2021). Internet of things framework in athletics physical teaching system and health monitoring. International Journal on Artificial Intelligence Tools, 30(06n08).

Chen, G. , Xiao, X. , Zhao, X. , Tat, T. , Bick, M. , & Chen, J. . (2021). Electronic textiles for wearable point-of-care systems.

Jiang, Z. G. , & Shi, X. T. . (2021). Application research of key frames extraction technology combined with optimized faster r-cnn algorithm in traffic video analysis. Complexity, 2021.

Wen, C. , Yang, J. , Gan, L. , & Pan, Y. . (2021). Big data driven internet of things for credit evaluation and early warning in finance. Future Generation Computer Systems, 124(4).

Aneja, S. , En, M. A. X. , & Aneja, N. . (2021). Collaborative adversary nodes learning on the logs of iot devices in an iot network. arXiv e-prints.

Mitzutani, I. , Ramanathan, G. , & Mayer, S. . (2021). Semantic data integration with DevOps to support engineering process of intelligent building automation systems.

Sidlauskiene, J. . (2021). What drives consumers' decisions to use intelligent agent technologies? a systematic review. Journal of Internet Commerce(4), 1-38.

Sun, H. , Tan, Y. A. , Zhu, L. , Zhang, Q. , Li, Y. , & Wu, S. . (2021). A fine-grained and traceable multidomain secure data-sharing model for intelligent terminals in edge-cloud collaboration scenarios. International Journal of Intelligent Systems.

Khalil, R. A. , Saeed, N. , Masood, M. , Fard, Y. M. , & Al-Naffouri, T. Y. . (2021). Deep learning in the industrial internet of things: potentials, challenges, and emerging applications. IEEE Internet of Things Journal, PP(99), 1-1.

Khan, I. K. , Qing, W. , Samuel, C. , Kc, D. B. , & Daisuke, K. . (2021). The PFP and ESG protein function prediction methods in 2014: effect of database updates and ensemble approaches.

Chen, C. , Huang, T. S. , Huang, J. C. , Shih, C. H. , & Du, Y. . (2021). Music intelligent push play and data analysis system based on 5g internet of things. Mathematical Problems in Engineering, 2021.

Wang, X. . (2021). Application of 3d-hevc fast coding by internet of things data in intelligent decision.

Gao, X. , Li, Q. , & Liu, F. . (2021). Research on the new normal technology and application of artificial intelligence in the internet of things. Journal of Physics: Conference Series, 1865(4), 042062 (5pp).

Qi, Y. , & Wu, H. . (2021). Fusion application of big data and cloud computing in the internet of things. Journal of Physics: Conference Series, 1881(3), 032013 (6pp).

Zhou, G. . (2021). The Application of Computer in Enterprise Economic Management Under the Background of Internet of Things.

Caiqian, Z. , & Xincheng, Z. . (2021). Multimedia system and database simulation based on internet of things and cloud service platform. Journal of Intelligent and Fuzzy Systems, 40(2), 2613-2624.

Yue, S. , Du, Y. , & Zhang, X. . (2021). Research and application of agricultural internet of things technology in intelligent agriculture. Journal of Physics Conference Series, 1769(1), 012020.

Zhou, B. , Liu, Y. , Xie, Y. , Wang, J. , Hao, Z. , & Meng, J. . (2021). Research and application of intelligent street lamp platform based on ubiquitous internet of things. Journal of Physics: Conference Series, 1920(1), 012068 (5pp).

Downloads

Published

2022-09-15

How to Cite

Liu, Y., Kumar, R., Tripathi, A., Sharma, A., & Rana, M. (2022). The application of Internet of things and Oracle database in the research of intelligent data management system. Informatica, 46(3). https://doi.org/10.31449/inf.v46i3.4019

Issue

Vol. 46 No. 3 (2022)

Section

SPECIAL ISSUE ON Recent Trends and Advances of Informatica in E-Commerce: Opportunities, Challenges and Solutions

License

I assign to Informatica, An International Journal of Computing and Informatics ("Journal") the copyright in the manuscript identified above and any additional material (figures, tables, illustrations, software or other information intended for publication) submitted as part of or as a supplement to the manuscript ("Paper") in all forms and media throughout the world, in all languages, for the full term of copyright, effective when and if the article is accepted for publication. This transfer includes the right to reproduce and/or to distribute the Paper to other journals or digital libraries in electronic and online forms and systems.

I understand that I retain the rights to use the pre-prints, off-prints, accepted manuscript and published journal Paper for personal use, scholarly purposes and internal institutional use.

In certain cases, I can ask for retaining the publishing rights of the Paper. The Journal can permit or deny the request for publishing rights, to which I fully agree.

I declare that the submitted Paper is original, has been written by the stated authors and has not been published elsewhere nor is currently being considered for publication by any other journal and will not be submitted for such review while under review by this Journal.  The Paper contains no material that violates proprietary rights of any other person or entity. I have obtained written permission from copyright owners for any excerpts from copyrighted works that are included and have credited the sources in my article. I have informed the co-author(s) of the terms of this publishing agreement.


Copyright ©  Slovenian Society Informatika