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

Yujiao Liu, Rajeev Kumar, Ashutosh Tripathi, Anil Sharma, Muskaan Rana


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.

Full Text:



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).


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