Cited By
View all- Kato CHayamizu YGoda KKitsuregawa M(2016)Aging Locality Awareness in Cost Estimation for Database Query OptimizationDatabase and Expert Systems Applications10.1007/978-3-319-44406-2_32(389-396)Online publication date: 6-Aug-2016
Storage fusion
Pages 270 - 277
Abstract
So far, the core component of the IT system was absolutely a server, and the storage was recognized as its peripheral. The recent evolution of device and network technologies has enabled storage consolidation, by which all the data and its related simple software codes can be placed in one place. Storage centric designs are being deployed into many enterprise systems. The role of the storage should be reconsidered. This paper presents activities of the Storage Fusion Project, a five-year research and development project. Storage Fusion is an idea of elegant deep collaboration between storage and database servers. Two substantial works are presented in this paper. First, the exploitation of query execution plans enables dynamically informed prefetching, accordingly boosting ad-hoc queries significantly. Second, the idea of putting autonomic database reorganization into the storage has the potential benefit of relieving the management burdens of database structural deterioration.
References
[1]
A. Acharya, M. Uysal, and J. Saltz. Active Disks: Programming Model, Algorithm and Evaluation. In Proc. Int'l. Conf. on Arch. Suport for Prog. Lang. and Operating Syst., pages 81--91, 1998.
[2]
A. Azagury, M. E. Factor, J. Satran, and W. Micka. Point-in-Time Copy: Yesterday, Today and Tomorrow. In Proc. NASA/IEEE Conf. on Mass Storage Syst. Tech., pages 259--270, 2002.
[3]
C. Babcock. Data, Data, Everywhere. InfomationWeek, 2006.
[4]
D. Barrick et al. Logical partitions on the IBM PowerPC, A Guide to Working with LPAR on Power5 i5 Severs. IBM Redbooks, 2005.
[5]
BMC Software, Inc. Easing the Pain of an IMS Reorganization. White Paper, 2002.
[6]
F. Bunn and R. Peglar. Storage Virtualization I. What, Why, Where and How? SNIA Education, 2004.
[7]
J. Carleton. Electronic Data Archiving and Retrieval in the Public Sector. Analyst Report, Frost & Sullivan, 2004.
[8]
M. A. Carlson and J. Crandall. Storage Management from SMI-S to Management Frameworks. SNIA Education, 2007.
[9]
D. J. DeWitt and P. B. Hawthorn. A Performance Evaluation of Database Machine Architectures. In Proc. Int'l. Conf. on Very Large Data Base, pages 199--214, 1981.
[10]
EMC Corp. EMC Mainframe Solutions Guide. Engineering White Paper, 2002.
[11]
EMC Corp. EMC Symmetrix DMX Series. White Paper, 2004.
[12]
Fibre Channel Industry Association. FCIA Roadmap. http://www.fibrechannel.org/.
[13]
Hitachi Global Storage Technologies, San Jose Research Center. HDD Technology Overview Charts, 2003.
[14]
Hitachi Ltd. Hitachi HiRDB Version 7. http://www.hitachi.co.jp/Prod/comp/soft1/hirdb/.
[15]
Hitachi Ltd. Hitachi Relational Database Management System Solutions for Disaster Recovery to Support Business Continuity. Review Special Issue, Hitachi Technology, 2004.
[16]
T. Hoshino, K. Goda, and M. Kitsuregawa. Online Monitoring of Database Structural Deterioration. In Proc. Int'l Conf. on Autonomic Comput., pages 22--23, 2007.
[17]
IDC. The Expanding Digital Universe: A Forecast of Worldwide Information Growth Through 2010. An IDC White Paper sponsored by EMC, 2007.
[18]
M. Ji, A. Veitch, and J. Wikes. Seneca: remote mirroring done write. In Proc. USENIX Conf. on File and Storage Tech., pages 253--268, 2003.
[19]
K. Keeton, D. A. Patteson, and J. M. Hellerstein. A case for intelligent disks (IDISKs). SIGMOD Record, 27(3):42--52, 1998.
[20]
G. M. Lohman and J. A. Muckstadt. Optimal Policy for Batch Operations: Backup, Checkpointing, Reorganization, and Updating. ACM Trans. Database Syst., 2(3):209--222, 1977.
[21]
D. Lomet, editor. IEEE Data Eng. Bull.: Special Issue on Online Reorganization., volume 19. IEEE Computer Society, 1996.
[22]
C. R. Lumb, J. Schindler, G. R. Ganger, D. F. Nagle, and E. Riedel. Towards higher disk head utilization: extracting free bandwidth from busy drives. In Proc. USENIX Symp. on Operating Syst. Design and Imple., pages 87--102, 2000.
[23]
K. Maruyama and S. E. Smith. Optimal Reorganization of Distributed Space Disk Files. Comm. ACM, 19(11):634--642, 1976.
[24]
M. Mesnier, G. R. Ganger, and E. Riedel. Object-based Storage. IEEE Comm., 41(8):84--90, 2003.
[25]
A. Mohamed, G. Candia, and D. Sherwin. Comparing Architectures of Online Reorganization. White Paper, Quest Software, 2002.
[26]
MySQL AB. MySQL: The World's Most Popular Open Source Database. http://www.mysql.com/.
[27]
Oracle Corp. Oracle Database 10g Online Data Reorganization & Redefinition. White Paper, 2004.
[28]
E. A. Ozkarahan, S. A. Schuster, and K. C. Smith. RAP - Associative Processor for Database Management. In Proc. AFIPS Conf., pages 379--387, 1975.
[29]
E. Riedel, G. A. Gibson, and C. Faloutsos. Active Storage For Large-Scale Data Mining and Multimedia. In Proc. Int'l. Conf. on Very Large Data Base, pages 62--73, 1998.
[30]
B. Shneiderman. Optimum Data Base Reorganization Points. Comm. ACM, 16(6):362--365, 1973.
[31]
D. L. Slotnick. Logic per Track Devices. Advances in Computers, 10:291--296, 1970.
[32]
G. H. Sockut, T. A. Beavin, and C.-C. Chang. A Method for On-Line Reorganization of a Database. IBM Syst. J., 36(3):411--436, 1997.
[33]
L. D. Stevens. The Evolution of Magnetic Storage. IBM Res. Develop., 25(5):663--676, 1981.
[34]
S. Y. W. Su and G. J. Lipovski. CASSM: a cellular system for very large database. In Proc. Int'l. Conf. on Very Large Data Base, pages 456--472, 1975.
[35]
N. Takahashi and H. Yoshida. Hitachi TagmaStore Universal Storage Platform: Virtualization without Limits. White Paper, Hitachi Ltd., 2004.
[36]
E. Thereska, J. Schindler, J. S. Bucky, B. Salmon, C. R. Lumb, and G. R. Ganger. A framework for building unobtrusive disk maintenance applications. In Proc. USENIX Conf. on File and Storage Tech., pages 213--226, 2004.
[37]
University of California. How Much Information?, 2000.
[38]
S. Watanabe and T. Miura. Reordering B-tree Files. In Proc. ACM Symp. on Applied Comput., pages 681--686, 2002.
[39]
R. Whiting. Data Avalance. InfomationWeek, 2004.
[40]
S. B. Yao, K. S. Das, and T. J. Teorey. A Dynamic Database Reorganization Algorithm. ACM Trans. Database Syst., 1(2):159--174, 1976.
Index Terms
- Storage fusion
Comments
Please enable JavaScript to view thecomments powered by Disqus.Information & Contributors
Information
Published In
Copyright © 2008 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]
Sponsors
In-Cooperation
Publisher
Association for Computing Machinery
New York, NY, United States
Publication History
Published: 31 January 2008
Check for updates
Qualifiers
- Research-article
Conference
ICUIMC08
Sponsor:
ICUIMC08: The Second International Conference on Ubiquitous Information Management and Communication
January 31 - February 1, 2008
Suwon, Korea
Acceptance Rates
Overall Acceptance Rate 251 of 941 submissions, 27%
Contributors
Other Metrics
Bibliometrics & Citations
Bibliometrics
Article Metrics
- View Citations1Total Citations
- 309Total Downloads
- Downloads (Last 12 months)1
- Downloads (Last 6 weeks)1
Reflects downloads up to 23 Nov 2024
Other Metrics
Citations
Cited By
View all- Kato CHayamizu YGoda KKitsuregawa M(2016)Aging Locality Awareness in Cost Estimation for Database Query OptimizationDatabase and Expert Systems Applications10.1007/978-3-319-44406-2_32(389-396)Online publication date: 6-Aug-2016
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