1,000 Tables Under the From
Summary: Operational BI over heterogeneous, distributed sources induces virtual schemas and “mega queries” spanning up to 1,000 tables through complex source-to-target mappings. Describes optimization techniques implemented in SAP BusinessObjects Data Federator to execute them. (summarized by gpt-5.6-luna on Jul 24 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Nicolas Dieu (Systems, Applications, and Products in Data Processing Business Objects)
- 2. Adrian Dragusanu (Systems, Applications, and Products in Data Processing Business Objects)
- 3. Françoise Fabret (Systems, Applications, and Products in Data Processing Business Objects)
- 4. François Llirbat (Systems, Applications, and Products in Data Processing Business Objects)
- 5. Eric Simon (Systems, Applications, and Products in Data Processing Business Objects)
BibTeX Citation
@article{dieu_vldb09,
title = {{1,000 Tables Under the From}},
author = {Dieu, Nicolas and Dragusanu, Adrian and Fabret, Françoise and Llirbat, François and Simon, Eric},
journal = {PVLDB},
series = {{VLDB} '09},
doi = {10.14778/1687553.1687572},
url = {https://doi.org/10.14778/1687553.1687572},
year = {2009}
}Incoming Citations (Sorted by Pagerank)
Showing 3 of 3 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 7,912 | Quantum-Inspired Digital Annealing for Join Ordering | 2024 | VLDB | 5.5180253e-05 |
| 9,969 | Hybrid Mixed Integer Linear Programming for Large-Scale Join Order Optimisation | 2026 | VLDB | 5.1845183e-05 |
| 11,453 | Asymptotically Better Query Optimization Using Indexed Algebra | 2023 | VLDB | 5.0935618e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 4 of 4 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 298 | Answering Queries Using Templates With Binding Patterns (Extended Abstract) | 1995 | PODS | 0.00022137688 |
| 851 | Query Optimization in the Presence of Limited Access Patterns | 1999 | SIGMOD | 0.00013610976 |
| 3,625 | Canonical Abstraction for Outerjoin Optimization | 2004 | SIGMOD | 7.2457196e-05 |
| 3,664 | Enterprise Information Integration: Successes, Challenges and Controversies | 2005 | SIGMOD | 7.2147124e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 559 | Optimizing Queries Using Materialized Views: A Practical, Scalable Solution | 2001 | SIGMOD |
| 2 | 4,481 | Dynamically Optimizing Queries over Large Scale Data Platforms | 2014 | SIGMOD |
| 3 | 5,992 | Iterative Query Processing based on Unified Optimization Techniques | 2019 | SIGMOD |
| 4 | 5,471 | Efficient Computation of Multiple Group By Queries | 2005 | SIGMOD |
| 5 | 151 | Efficient Mid-Query Re-Optimization of Sub-Optimal Query Execution Plans | 1998 | SIGMOD |
| 6 | 3,275 | Optimizing Analytic Data Flows for Multiple Execution Engines | 2012 | SIGMOD |
| 7 | 4,327 | Dynamic Workload Management for Very Large Data Warehouses - Juggling Feathers and Bowling Balls | 2007 | VLDB |
| 8 | 9,350 | Enterprise Application-Database Co-Innovation for Hybrid Transactional/Analytical Processing: A Virtual Data Model and Its Query Optimization Needs | 2025 | SIGMOD |
| 9 | 1,286 | Adaptive Optimization of Very Large Join Queries | 2018 | SIGMOD |
| 10 | 6,234 | Integrating Heterogeneous Overlapping Databases Through Object-Oriented Transformations | 1999 | VLDB |