This paper proposes a novel multivariate performance diagnostic approach for the oracle database systems to detect performance degradation and crashes during database operations and maintenance. It was based on three ...
详细信息
This paper proposes a novel multivariate performance diagnostic approach for the oracle database systems to detect performance degradation and crashes during database operations and maintenance. It was based on three technologies: image encoding, image concatenation, and deep convolutional network. Instantaneous variation and magnitude information of the time series were acquired by Heatmap and Recurrence Plot (RP) from databases. Moreover, the Heatmap and RP were concatenated in order to fully extract complementary information. Finally, the concatenated images of Heatmap and RP were used to train the VGG16 model for database performance diagnosis. The quantitative analysis demonstrated a good increment of accuracy in Heatmap and RP based on the same deep learning networks compared with other image encodings of Gramian Angular Difference Field (GADF), Gramian Angular Summation Fields (GASF), and Markov Transition Fields (MTF). Meanwhile, concatenated images of Heatmap and RP can improve the accuracy by 1% compared to single Heatmap input. The result of the trained model applied to multivariate database diagnosis shows an accuracy of 95.3%. Thus, our method can more effectively and accurately diagnose the performance of the oracle database systems.
The present research was conducted at the Budapest University of Technology in the field of indoor location using radio waves of Wi-Fi networks with a focus on practical application issues. Our goal was to enhance and...
详细信息
ISBN:
(纸本)9781424458646
The present research was conducted at the Budapest University of Technology in the field of indoor location using radio waves of Wi-Fi networks with a focus on practical application issues. Our goal was to enhance and combine existing algorithms and create an implementation that is efficient enough to enable real-time operation in 3D space in multi-level office environments while retaining the accuracy of more complex systems and allowing the addition of valuable context-sensitive features. The proposed solution is based on proven empirical propagation models, with the ability to augment and refine with surveyed radio fingerprint data. The results of the location algorithm are combined with heuristic probability distributions layered over the floor plan, thus incorporating available sensor data (accelerometers and magnetometers found in modern devices) and floor plans. The positioning system is used by an indoor navigation software developed for smartphones and complemented by a database of annotated entities (persons, devices, areas and points of interest) to allow the inference of location-dependent, context-sensitive information through an API provided for upper layer applications. This paper primarily focuses on the practical experience accumulated during the development of the positioning algorithm, as well as the possibilities opened by having a dynamic view of all the attributes assigned to persons either directly or indirectly via their locations or other external data sources. The implementation heavily relies on the Spatial extension of the oracle database system, which provides geometric data types and operations. The benefits of the employment of such a system are going to be presented in the current article.
The innovative performance and scalability features with each newer edition of the oracle database system can present challenges for users. This book teaches software developers and students how to effectively deal wi...
详细信息
ISBN:
(数字)9781118135495
ISBN:
(纸本)9781118056998
The innovative performance and scalability features with each newer edition of the oracle database system can present challenges for users. This book teaches software developers and students how to effectively deal with oracle performance and scalability issues throughout the entire life cycle of developing oracle-based applications. Using real-world case studies to deliver key theories and concepts, the book introduces highly dependable and ready-to-apply performance and scalability optimization techniques, augmented with Top 10 oracle Performance and Scalability Features as well as a supplementary support website.
暂无评论