Techniques for processing operations on column partitions in a database

作者: Donald R. Pederson , Paul Sinclair

DOI:

关键词: Bit arrayPartition (database)DatabaseRowOn columnComputer scienceFull table scan

摘要: Techniques for processing operations on column partitions of a table in database are provided. A includes control partition. Each delete container the partition representing multiple rows (or row partition, if any), and each represented by bit flag within string. Rows set deletion have their corresponding bits particular to indicate those deleted.

参考文章(17)
Sreenath Bodagala, Rajat Venkatesh, Benjamin Vandiver, Shilpa Lawande, Chuck Bear, Database storage architecture ,(2010)
Donald Pederson, Steven Bart Cohen, Paul L. Sinclair, Partitioned database system ,(2001)
Roger MacNicol, Vikram Kapoor, Jesse Kamp, Kam Shergill, Vineet Marwah, Sachin Kulkarni, Amit Ganesh, Structure of hierarchical compressed data structure for tabular data ,(2009)
Mohamed Zait, Benoit Dageville, Abhinav Gupta, Automatic discovery and use of column correlations in tables ,(2002)
Hansjorg Zeller, Anoop Sharma, Hash-based database grouping system and method ,(1995)
Gerald Johann Wilmot, Jing-Song Jang, James Louis Keesey, Erik Allan Kane, Jean Chen Ho, Angela Go Reyda, Roger Georges Bitar, Complex data query support in a partitioned database system ,(1998)
Ananth Raghavan, George Eadon, Eugene Inseok Chong, Shrikanth Shankar, Souriprlya Das, Jagannathan Srinivasan, Reference partitioned tables ,(2007)
Paul Sinclair, Mark Sirek, Xiaorong Luo, Product join dynamic partition elimination for multilevel partitioning ,(2007)