Query Processing Optimization using Two Types of Storage Devices
Pages 154 - 157
Abstract
Currently, OLAP systems capable of handling a huge amount of data tend to use two types of storage device based on NSM and DSM, respectively.
Conventional approaches for query optimization in OLAP systems usually classify issued queries according to their operation type, e.g., insert, delete, or update, and thereby select the data storage device to be used. Briefly, focusing on the type of query issued to the OLAP systems makes is possible to find another approach to improve query processing time.
In this paper, we propose a method for optimizing query processing in an OLAP system with two types of storage device that considers the type of each query.
References
[1]
Y.-M. Choi. Web-enabled OLAP Tutorial. http://www.cis.drexel.edu/faculty/song/courses/info%20607/tutorial OLAP/index.htm, April 2005. Retrieved May 1, 2015.
[2]
M. Colgan, J. Kamp, and S. Lee. Oracle Database In-Memory. Oracle Corporation, October 2014. An Oracle White Paper.
[3]
F. Färber, S.-K. Cha, J. Primsch, C. Bornhövd, S. Sigg, and W. Lehner. SAP HANA Database: Data Management for Modern Business Applications. ACM SIGMOD Record, 40(4):45--51, December 2011.
[4]
R. Ramamurthy, D. J. DeWitt, and Q. Su. A Case for Fractured Mirrors. In Proceedings of the 28th International Conference on Very Large Data Bases, pages 430--441. VLDB Endowment, August 2002.
[5]
R. Seiffert. Online Transactional and Analytics Processing using SPSS, DB2 z/OS, DB2 Analytics Accelerator. http://www-304.ibm.com/connections/blogs/systemz/entry/online transactional and analytics processing, March 2013. Retrieved April 20, 2015.
[6]
M. Stonebraker, D. J. Asadi, A. Batkin, X. Chen, M. Cherniack, M. Ferreira, E. Lau, A. Lin, S. Madden, E. O'Neil, P. O'Neil, A. Rasin, N. Tran, and S. Zdonik. C-Store: A Column-Oriented DBMS. In Proceedings of the 31st International Conference on Very Large Data Bases, pages 553--564. VLDB Endowment, August 2005.
Index Terms
- Query Processing Optimization using Two Types of Storage Devices
Recommendations
Query processing optimization using disk-based row-store and column-store
iiWAS '15: Proceedings of the 17th International Conference on Information Integration and Web-based Applications & ServicesRecent OLAP systems, which are usually called HOLAP systems, are often developed using both NSM and DSM storages in a single database system for big data analytics in real-time. In HOLAP systems, a method for two types of storages usually depends on the ...
View-based query processing: On the relationship between rewriting, answering and losslessness
As a result of the extensive research in view-based query processing, three notions have been identified as fundamental, namely rewriting, answering, and losslessness. Answering amounts to computing the tuples satisfying the query in all databases ...
Comments
Information & Contributors
Information
Published In
July 2015
251 pages
Copyright © 2015 ACM.
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]
In-Cooperation
- Keio University: Keio University
- BytePress
- Concordia University: Concordia University
Publisher
Association for Computing Machinery
New York, NY, United States
Publication History
Published: 13 July 2015
Check for updates
Author Tags
Qualifiers
- Short-paper
- Research
- Refereed limited
Funding Sources
- Grant-in-Aid for Scientific Research(B)
Conference
IDEAS '15
IDEAS '15: 19th International Database Engineering & Applications Symposium
July 13 - 15, 2015
Yokohama, Japan
Acceptance Rates
Overall Acceptance Rate 74 of 210 submissions, 35%
Contributors
Other Metrics
Bibliometrics & Citations
Bibliometrics
Article Metrics
- 0Total Citations
- 94Total Downloads
- Downloads (Last 12 months)1
- Downloads (Last 6 weeks)1
Reflects downloads up to 25 Dec 2024
Other Metrics
Citations
View Options
Login options
Check if you have access through your login credentials or your institution to get full access on this article.
Sign in