Methods of Using Business Intelligence Technologies for Dynamic Database Performance Administration
Author: Veska Mihova
Abstract
Today productivity and performance are the main problems of business applications. Business applications become increasingly slow while their stored and managed data are growing. The problem of monitoring and productivity optimization of a business application’s database is a traditional and well-known problem. Therefore, there are many various concepts and software products developed for its solution. But all solutions perform monitoring on the current state of the information system, which makes the process of optimization slow and ineffective. The current paper proposes a concept for monitoring the future state of a database. This solution gives the business enough time for reaction to an occurring problem with the application’s performance and respectively the database’s performance. The concept presents a metadata model for generating a specific data warehouse that is generated in dependence of specific RDBMS. The proposed architecture offers an additional layer of web services which provides the necessary data for monitoring the future state of the database so that any business organization can integrate, visualize and implement the data in a different and appropriate way. Also the current paper proposes methods for dynamic database performance administration through which the overall concept is created.