Database Paper Browser

Back to papers

Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design

Summary: Integrated automation of vertical and horizontal partitioning with indexes and materialized views. Scalable techniques under manageability constraints, evaluated on Microsoft SQL Server, highlight the value of an integrated physical design. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
3533
Venue
SIGMOD
Year
2004
Pagerank
0.00029024583
Overall Rank
283 | 98.04%
DOI
-

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 50 of 62 citing papers.

Rank Citing Paper Year Venue Pagerank
183 Automatic Database Management System Tuning Through Large-scale Machine Learning 2017 SIGMOD 0.00036859633
208 Schism: a Workload-Driven Approach to Database Replication and Partitioning 2010 VLDB 0.00034478612
258 DB2 Design Advisor: Integrated Automatic Physical Database Design 2004 VLDB 0.00030196528
371 Self-Driving Database Management Systems 2017 CIDR 0.00025382677
510 An End-to-End Automatic Cloud Database Tuning System Using Deep Reinforcement Learning 2019 SIGMOD 0.00021420477
594 HYRISE—A Main Memory Hybrid Storage Engine 2011 VLDB 0.00019515008
662 Database Tuning Advisor for Microsoft SQL Server 2005 2004 VLDB 0.00018478597
679 Skew-Aware Automatic Database Partitioning in Shared-Nothing, Parallel OLTP Systems 2012 SIGMOD 0.00018211621
708 Performance Tradeoffs in Read-Optimized Databases 2006 VLDB 0.00017753572
796 SageDB: A Learned Database System 2019 CIDR 0.00016541749
1,086 Low Overhead Concurrency Control for Partitioned Main Memory Databases 2010 SIGMOD 0.00014159702
1,255 Aggregation and Ordering in Factorised Databases 2013 VLDB 0.00013011216
1,346 NoDB: Efficient Query Execution on Raw Data Files 2012 SIGMOD 0.00012472598
1,473 Fine-grained Partitioning for Aggressive Data Skipping 2014 SIGMOD 0.00011786148
1,608 Qd-tree: Learning Data Layouts for Big Data Analytics 2020 SIGMOD 0.00011169837
1,697 Bridging the Archipelago between Row-Stores and Column-Stores for Hybrid Workloads 2016 SIGMOD 0.00010859294
1,726 Fast Updates on Read-Optimized Databases Using Multi-Core CPUs 2012 VLDB 0.00010734339
1,801 H2O: A Hands-free Adaptive Store 2014 SIGMOD 0.00010485628
1,816 An Inquiry into Machine Learning-based Automatic Configuration Tuning Services on Real-World Database Management Systems 2021 VLDB 0.00010438512
1,856 AI Meets AI: Leveraging Query Executions to Improve Index Recommendations 2019 SIGMOD 0.00010319105
1,946 Heterogeneity-aware Distributed Parameter Servers 2017 SIGMOD 9.9983926e-05
2,050 Automatically Indexing Millions of Databases in Microsoft Azure SQL Database 2019 SIGMOD 9.6883066e-05
2,410 Automated Partitioning Design in Parallel Database Systems 2011 SIGMOD 8.8643562e-05
2,479 Efficient Use of the Query Optimizer for Automated Physical Design 2007 VLDB 8.6836615e-05
2,834 Automatic Physical Design Tuning: Workload as a Sequence 2006 SIGMOD 8.0468556e-05
2,985 Supporting Table Partitioning By Reference in Oracle 2008 SIGMOD 7.7758625e-05
3,088 FDB: A Query Engine for Factorised Relational Databases 2012 VLDB 7.5940302e-05
3,219 Query Optimization Techniques for Partitioned Tables 2011 SIGMOD 7.3592303e-05
3,279 The Case for RodentStore, an Adaptive, Declarative Storage System 2009 CIDR 7.2816693e-05
3,312 Automatic Partitioning of Database Applications 2012 VLDB 7.2356116e-05
3,482 Optimal Column Layout for Hybrid Workloads 2019 VLDB 7.0514808e-05
3,661 Database Tuning Advisor for Microsoft SQL Server 2005: Demo 2005 SIGMOD 6.8680306e-05
3,731 Skipping-oriented Partitioning for Columnar Layouts 2017 VLDB 6.8074069e-05
3,893 Slalom: Coasting Through Raw Data via Adaptive Partitioning and Indexing 2017 VLDB 6.653922e-05
4,216 Make Your Database System Dream of Electric Sheep: Towards Self-Driving Operation 2021 VLDB 6.3448176e-05
4,924 An Experimental Evaluation of Large Scale GBDT Systems 2019 VLDB 5.8211961e-05
5,116 AdaptDB: Adaptive Partitioning for Distributed Joins 2017 VLDB 5.6805476e-05
6,241 Helios: Hyperscale Indexing for the Cloud & Edge 2020 VLDB 5.1357476e-05
6,298 Towards instance-optimized data systems 2021 VLDB 5.1182917e-05
6,461 Pando: Enhanced Data Skipping with Logical Data Partitioning 2023 VLDB 5.0479786e-05
6,655 Fast and Effective Distribution-Key Recommendation for Amazon Redshift 2020 VLDB 4.9693109e-05
6,962 Replicated Layout for In-Memory Database Systems 2022 VLDB 4.8771234e-05
7,049 Statisticum: Data Statistics Management in SAP HANA 2017 VLDB 4.8454978e-05
7,096 Optimizing Queries over Partitioned Tables in MPP Systems 2014 SIGMOD 4.8283743e-05
7,111 A Comparison of Knives for Bread Slicing 2013 VLDB 4.8228024e-05
7,127 Jigsaw: A Data Storage and Query Processing Engine for Irregular Table Partitioning 2021 SIGMOD 4.8184276e-05
7,459 Lachesis: Automatic Partitioning for UDF-Centric Analytics 2021 VLDB 4.7199075e-05
7,914 Resource Bricolage for Parallel Database Systems 2015 VLDB 4.6136905e-05
8,005 Pangea: Monolithic Distributed Storage for Data Analytics 2019 VLDB 4.6044087e-05
8,387 A Storage Advisor for Hybrid-Store Databases 2012 VLDB 4.5255213e-05
Previous Page 1 / 2 Next

Outgoing Citations (Sorted by Pagerank)

Showing 10 of 10 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Previous Page 1 / 1 Next

Semantically Similar Papers