An intelligent approach to improve the performance of a data warehouse cache based on association rules

Moudani, Walid; Hussein, Mohammad; Moukhtar, Mirna; Mora‐Camino, Félix

doi:10.1080/02522667.2012.10700162

Cited by 7 publications

(3 citation statements)

References 4 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Based on the new era of information management, on the one hand, it can improve the enterprise management process and improve the efficiency of enterprise management; On the other hand, it can also solve the problems of slow information acquisition speed, incomplete data retention and easy loss of information data [5]. In addition, the relevant managers can operate by computer, greatly reducing the human workload, which is also a potential cost saving means.…”

Section: Lack Of Understanding Of Business Information System Managementmentioning

confidence: 99%

Management and Analysis of Chinese Business Information System in the New Era

Cao¹

2023

Advances in Economics, Business and Management Research

View full text Add to dashboard Cite

In recent years, with the rapid development of information technology in China, business information system management has become the mainstream means of modern enterprise management. Nowadays, the transactions and development of Chinese enterprises are not limited to regions, borders, races and nationalities, etc., but also save a lot of costs for enterprises, which makes a great contribution to the development of China's social economy. However, with the continuous application of business information system management technology, the problems of business information system management are gradually shown. Therefore, this paper focuses on the management situation and existing problems of China's business information system in the new era, and puts forward optimization measures to solve these problems, aiming at providing reference and reference for the construction of a powerful and stable business information management system, and laying a foundation for enterprises to improve their management level and profits.

show abstract

Section: Lack Of Understanding Of Business Information System Managementmentioning

confidence: 99%

Management and Analysis of Chinese Business Information System in the New Era

Cao¹

2023

Advances in Economics, Business and Management Research

View full text Add to dashboard Cite

show abstract

“…Nowadays, businesses are growing rapidly, and the influence of Data Warehouses (DWs) has been increasing day by day, being used by several organizations. High customer demands are driving DWs to make fast business decisions based on the latest information [1]. Dealing with a large amount of data can slow down the performance, especially in data fetching, which will affect the user experience.…”

Section: Introductionmentioning

confidence: 99%

“…Several methods have been proposed to optimize data execution and data processing. In [1], the author used the query cache algorithms for optimizing the process of data execution.…”

Section: Introductionmentioning

confidence: 99%

Optimizing the Performance of Data Warehouse by Query Cache Mechanism

et al. 2022

View full text Add to dashboard Cite

Fast access of data from Data Warehouse (DW) is a need for today's Business Intelligence (BI). In the era of Big Data, cache is regarded as one of the most effective technique to improve the performance of accessing data. DW has been widely used by several organizations to manage data and use it for Decision Support System (DSS). Many methods have been used to optimize the performance of fetching data from DW. Query cache method is one of those methods that play an effective role in optimization. The proposed work is based on a cache-based mechanism that helps DW in two aspects: the first one is to reduce the execution time by directly accessing records from cache memory, and the second is to save cache memory space by eliminating non-frequent data. Our target is to fill the cache memory with the most used data. To achieve this goal aging-based Least Frequently Used (LFU) algorithm is used by considering the size and frequency of data simultaneously. The priority and expiry age of the data in the cache memory is managed by dealing with both the size and frequency of data. LFU sets priorities and counts the age of data placed in cache memory. The entry with the lowest age count and priority is eliminated first from the cache block. Ultimately, the proposed cache mechanism efficiently utilized cache memory and fills a large performance gap between the main Data warehouse and the business user query.

show abstract

Ind-AMSAD: A multidimensional design analysis using micro-strategy analytics desktop for Indian agriculture

Gupta¹,

Jain

2020

Journal of Statistics and Management Systems

View full text Add to dashboard Cite

An intelligent approach to improve the performance of a data warehouse cache based on association rules

Cited by 7 publications

References 4 publications

Management and Analysis of Chinese Business Information System in the New Era

Management and Analysis of Chinese Business Information System in the New Era

Optimizing the Performance of Data Warehouse by Query Cache Mechanism

Ind-AMSAD: A multidimensional design analysis using micro-strategy analytics desktop for Indian agriculture

Contact Info

Product

Resources

About