NDLI: What can Emerging Hardware do for your DBMS Buffer?

Please wait, while we are loading the content...

Querying Big, Dynamic, Distributed Data

GOLAM: A Framework for Analyzing Genomic Data

A Holistic Approach to OLAP Sessions Composition: The Falseto Experience

Recursive Query Evaluation in a Column DBMS to Analyze Large Graphs

An Advanced Data Warehouse for Integrating Large Sets of GPS Data

A Semantic Model for Movement Data Warehouses

fVSS: A New Secure and Cost-Efficient Scheme for Cloud Data Warehouses

Bijoux: Data Generator for Evaluating ETL Process Quality

SM4AM: A Semantic Metamodel for Analytical Metadata

What can Emerging Hardware do for your DBMS Buffer?

From Business Intelligence to Location Intelligence with the Lily Library

A Framework for User-Centered Declarative ETL

Optimization of Data-intensive Flows: Is it Needed? Is it Solved?

Big Graph Analytics: The State of the Art and Future Research Agenda

What can Emerging Hardware do for your DBMS Buffer?

Content Provider	ACM Digital Library
Author	Nacef, Abdelhakim Salmi, Cheikh Bellatreche, Ladjel Boukhobza, Jalil
Abstract	The spectacular development of business intelligence applications (BIA), built around the data warehousing technology, increases the demand on query performance of DBMS hosting with its extremely high amount of data. In such a context a high interaction among queries exists since they share a large number of intermediate results. This is due to the fact that BIA use relational schemes such as a star schema in which each join passes through the fact table. The decision to cache these intermediate results in the traditional buffer becomes a critical issue since it depends on the size of the buffer and the number of intermediate results candidate for caching. As flash memory is more and more adopted in mass storage systems, we rely on it to buffer some intermediate results. In this paper, we first propose to couple the RAM and Solid State Drive, to respond to the problem combining buffer management and query scheduling sub problems. Secondly, a cost model for evaluating the quality of buffering data and scheduling queries is given. Based on this cost model, an algorithm is given to solve our joint problem. Simulations show that our proposal enhances the performance of SQL queries up to 86%.
Starting Page	91
Ending Page	94
Page Count	4
File Format	PDF
ISBN	9781450309998
DOI	10.1145/2666158.2666181
Language	English
Publisher	Association for Computing Machinery (ACM)
Publisher Date	2014-11-07
Publisher Place	New York
Access Restriction	Subscribed
Subject Keyword	Ssd Flash memory Multi-query optimisation Database Buffer management Dataware house Query scheduling
Content Type	Text
Resource Type	Article

Central Library (ISO-9001:2015 Certified)
Indian Institute of Technology Kharagpur
Kharagpur, West Bengal, India | PIN - 721302

See location in the Map
03222 282435
Mail: support@ndl.gov.in

Sl.	Authority	Responsibilities	Communication Details
1	Ministry of Education (GoI), Department of Higher Education	Sanctioning Authority	https://www.education.gov.in/ict-initiatives
2	Indian Institute of Technology Kharagpur	Host Institute of the Project: The host institute of the project is responsible for providing infrastructure support and hosting the project	https://www.iitkgp.ac.in
3	National Digital Library of India Office, Indian Institute of Technology Kharagpur	The administrative and infrastructural headquarters of the project	Dr. B. Sutradhar bsutra@ndl.gov.in
4	Project PI / Joint PI	Principal Investigator and Joint Principal Investigators of the project	Dr. B. Sutradhar bsutra@ndl.gov.in Prof. Saswat Chakrabarti will be added soon
5	Website/Portal (Helpdesk)	Queries regarding NDLI and its services	support@ndl.gov.in
6	Contents and Copyright Issues	Queries related to content curation and copyright issues	content@ndl.gov.in
7	National Digital Library of India Club (NDLI Club)	Queries related to NDLI Club formation, support, user awareness program, seminar/symposium, collaboration, social media, promotion, and outreach	clubsupport@ndl.gov.in
8	Digital Preservation Centre (DPC)	Assistance with digitizing and archiving copyright-free printed books	dpc@ndl.gov.in
9	IDR Setup or Support	Queries related to establishment and support of Institutional Digital Repository (IDR) and IDR workshops	idr@ndl.gov.in