Automatically revising synopsis table structure
作者： Adam J. Storm , Christian M. Garcia-Arellano , Calisto P. Zuzarte , Ian R. Finlay
DOI:
关键词: Table (database) 、 Information retrieval 、 Row 、 Space (punctuation) 、 Database 、 Process (computing) 、 Database index 、 Computer science 、 Structure (mathematical logic)
摘要: Merging adjacent rows of a synopsis table so as to increase the effectiveness regarding data skipping. Adjacent for merging are identified based on statistics regarding: (i) queries database; (ii) skipping; and (iii) usage predicates in database. Once merged, is smaller, more effective with respect skipping, while fewer computing resources (administrative, maintenance, memory, clock cycles, storage space, etc.) needed process database queries.
lens.org 参考文章(22)
Ramakumar Kosuru, Choudur Lakshminarayan, Hansjorg Zeller, QiFan Chen, Estimating Unique Entry Counts Using a Counting Bloom Filter ,(2012)
Torsten Ziegler, Frank-Martin Haas, Arndt Effern, Method for reorganizing or moving a database table ,(2010)
Eric B. Vigesaa, Robert C. Collie, Bruce Cordell Jones, Allan Folting, Associating conditions to summary table data ,(2016)
Thomas Pugh, Eyal M. Aronoff, Ross Doering, System and method for developing a cost-effective reorganization plan for data reorganization ,(2000)
Yefim Shuf, Hong Min, Hubertus Franke, Terence P. Purcell, You-Chin Fuh, Database table look-up ,(2010)
Ronald P. Millett, Indexing and filtering using composite data stores ,(2011)
Jeffrey Alan D'agostino, Arthur Watterson, Implantable polymer for bone and vascular lesions ,(2011)
Guy Randazzo, Suzie Cho Yee, Neil Yoshida, Marc Meyer, Mark Sturdevant, Mark Gratiot, Brian Fischer, Guy Travis Hall, Yukon Fong, Data warehouse which is accessed by a user using a schema of virtual tables ,(1994)
Andrew P. Osborn, Stephen D. Cave, Robert L. Lavender, Summary table management in a computer system ,(1999)
Vijayshankar Raman, Gopi Attaluri, Ronald Barber, Naresh Chainani, David Kalmuk, Vincent KulandaiSamy, Jens Leenstra, Sam Lightstone, Shaorong Liu, Guy M. Lohman, Tim Malkemus, Rene Mueller, Ippokratis Pandis, Berni Schiefer, David Sharpe, Richard Sidle, Adam Storm, Liping Zhang, DB2 with BLU acceleration Proceedings of the VLDB Endowment. ,vol. 6, pp. 1080- 1091 ,(2013) , 10.14778/2536222.2536233