Improved performance of data warehouse

Tiwari, Prayag; Kumar, Sachin; Mishra, Avinash Chandra; Kumar, Vivek; Terfa, Bodena

doi:10.1109/icicct.2017.7975167

Cited by 9 publications

(5 citation statements)

References 7 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…If we have a large amount of data that has been fetched and cached into query cache memory, in this case, these methods cannot perform effectively, and the purpose of the query cache is evaded to VOLUME XX, 2017 use it for fast access. This slows down the performance of cache methods [18]. Cache techniques vary from task to task.…”

Section: Related Workmentioning

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

Section: Related Workmentioning

confidence: 99%

Optimizing the Performance of Data Warehouse by Query Cache Mechanism

et al. 2022

View full text Add to dashboard Cite

show abstract

“…The query cache method was first used in Tiwari et al [40] study to increase the speed and efficiency of ETL within the data warehouse by reducing response time. This method's primary goal is to save queries and their associated output.…”

Section: Literature Reviewmentioning

confidence: 99%

Analyses the Performance of Data Warehouse Architecture Types

Merceedi,

Yazdeen,

Ibrahim

et al. 2022

JSCDM

View full text Add to dashboard Cite

The concept of storing historical data for retrieving them when needed has been conceived, and the idea was primitive to build repositories for historical data to store these data, despite the use of a specific technique for recovering these data from various storage modes. The data warehouse is the most reliable and widely used technology for scheduling, forecasting, and managing corporations. Also, it is concerned with the data storage facility that extensive collection of data. Data warehouses are called ancient modern techniques; since the early days of relational databases, the critical component of decision support, increasing focus for the database industry. Many commercial products and services are now available, and almost all of the primary database management system vendors provide them. When opposed to conventional online transaction processing applications, decision support puts slightly different demands on database technology. This paper analyzes the performance of the data warehouse architectures by studying and comparing many research works in this field. The study involves extracting, transforming, and loading the data from different recourses and the important characteristic of the architecture types. Furthermore, the tools and application service techniques used to build data warehouse architecture.

show abstract

“…A qualidade de dados também representa grande importância na construção de um DM. Numerosos projetos não atingem seus objetivos devido a não observância desse critério, afetando o resultado (TIWARI et al, 2017 O ETL precisa ter a capacidade de lidar com mudanças de objetivos dos DM e suportar novas demandas de dados, com volumes cada vez maiores, variedade de tipos e fontes para extração das informações. Novos requisitos dos usuários para análises em tempo real, integração com ambientes externos, de novas tecnologias e ferramentas mais poderosas são qualidades que devem ser implementadas nesse processo à medida que se apresentam (SABTU, 2017).…”

Section: Data Martunclassified

Avaliação Dos Principais Critérios De Desempenho De Terceirização De Ti Para a Gestão Contratual Em Empresas Públicas: Uma Revisão Bibliométrica

Felisoni¹,

Martins²,

Gaspar³

2021

Tecnologia Da Informação: Sistemas E Aplicações

View full text Add to dashboard Cite

Tecnologia da informação. 2. Sistemas de informação. 3. Gestão da informação. I. Tecnologia da Informação: Sistemas e Aplicações 2021 Tecnologia da Informação: Sistemas e Aplicações Apresentação Diego Brito Cangussu O mundo em que vivemos vem se tornando cada vez mais tecnológico e autônomo, com intuito de melhorar os produtos finais e, consequentemente, a qualidade de vida. Com sistemas inteligentes, o controle e monitoramento de processos se tornam mais confiáveis e seguros, facilitando atividades humanas, industriais,escolares, rurais e etc. Com a automação e internet houve um facilitador para a interrelação humana e o desenvolvimento. Nos anos 80, diversas empresas optaram com a implantação da tecnologia em seus processos. A automação veio substituindo trabalhos manuais por máquinas, melhorando a produção em tempo e qualidade. Cada capítulo desse livro apresenta artigos nos quais a tecnologia pode ser implementada para adquirir um melhor desempenho. É possível visualizar sistemas em diversos setores tais como mineração, plantio, escolas, dentre outros.

show abstract

Improved performance of data warehouse

Cited by 9 publications

References 7 publications

Optimizing the Performance of Data Warehouse by Query Cache Mechanism

Optimizing the Performance of Data Warehouse by Query Cache Mechanism

Analyses the Performance of Data Warehouse Architecture Types

Avaliação Dos Principais Critérios De Desempenho De Terceirização De Ti Para a Gestão Contratual Em Empresas Públicas: Uma Revisão Bibliométrica

Contact Info

Product

Resources

About