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

Abstract

The most critical issue in manufacturing is known as resource allocation. This article demonstrates an intelligent data management consisting resource allocation mechanism. The aim of the proposed system is to provide timely and effective decision for the resource allocation. 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 proposed model is compared with other state of art classifiers for evaluating percentage efficiency and F score. 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.Povzetek: Mehanizem dodeljevanja virov je implementiran s pomočjo inteligentnega sistema in baze Oracle.

Maintaining Query Performance through Table Rebuilding & Archiving

“…Besides setting up server hardware and the pre-configured Oracle version 11 database, the database is categorized into two types based on transaction nature: Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) [9]. The transaction schema is designed to house transaction tables, and the history schema is dedicated to data archiving.…”

Unmanned Aerial Vehicle-based Applications in Smart Farming: A Systematic Review

“…Air and disease monitoring each received 5% of attention, with water monitoring accounting for 7%. Fertilization monitoring was the least studied, with only 4% of the research papers devoted to it in [15].…”