Open AccessConstruction Method of Enterprise-level Database Operational Measurement Platform Based on Bidirectional Coupling Algorithm
Author(s) -
Hongwen Xia
Publication year - 2022
Publication title -
international journal of circuits, systems and signal processing
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.156
H-Index - 13
ISSN - 1998-4464
DOI - 10.46300/9106.2022.16.5
Subject(s) - database , computer science , database tuning , database testing , database design , enterprise information system , physical data model , database model , database schema , data mining , view
When identifying the enterprise database data information, the enterprise database operational dimension measurement platform based on the bilinear method will produce ringing or overshoot effect, the database data monitoring effect is poor as well as the accuracy of operation measurement. To solve this problem, this paper proposes a method to build an enterprise level database operation and maintenance measurement platform based on bidirectional coupling algorithm. Build enterprise database operation measurement platform. The enterprise database monitoring platform is connected with the monitoring database by remote database chain. The Oracle database job scheduling method is used to obtain the monitoring index information in the monitored database, and the database memory performance is comprehensively evaluated by MPI (Memory Perform Index). The platform uses semantic capture layer and related analysis layer to distinguish user behavior, analyze user experience satisfaction, and realize the operation measurement of enterprise level database. The experimental results show that the operational measurement platform built by this method has high throughput, low memory occupancy rate, high measurement accuracy and good user experience.