"One Size Fits All" Database Architectures Do Not Work For DSS

Summary: Argues against universal DB architectures for OLTP and DSS workloads. OLTP and DSS enforce opposing design laws; a single system optimized for one degrades the other, motivating workload-specific or hybrid architectures with distinct storage and processing paths. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 2893
Venue: SIGMOD
Year: 1995
Pagerank: 0.00015795625
Overall Rank: 608 | 95.84%
DOI: 10.1145/223784.223871

Incoming Non-self Citations Over Time

Authors

1. Clark D. French

BibTeX Citation

@inproceedings{french_sigmod95,
        title = {{"One Size Fits All" Database Architectures Do Not Work For DSS}},
        author = {French, Clark D.},
        series = {{SIGMOD} '95},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/223784.223871},
        url = {https://dl.acm.org/doi/10.1145/223784.223871},
        year = {1995}
}

Incoming Citations (Sorted by Pagerank)

Showing 9 of 9 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
12	C-Store: A Column-oriented DBMS	2005	VLDB	0.00069513174
104	Improved Query Performance with Variant Indexes	1997	SIGMOD	0.00033932213
204	Cache Conscious Indexing for Decision-Support in Main Memory	1999	VLDB	0.00025342994
794	Bitmap Index Design and Evaluation	1998	SIGMOD	0.00013969303
966	A Common Database Approach for OLTP and OLAP Using an In-Memory Column Database	2009	SIGMOD	0.00012920281
1,315	Fast Updates on Read-Optimized Databases Using Multi-Core CPUs	2012	VLDB	0.00011181796
1,854	Towards a One Size Fits All Database Architecture	2011	CIDR	9.6069414e-05
12,603	Dwarfs in the Rearview Mirror: How Big are they Really?	2008	VLDB	5.093636e-05
12,742	Bridging the Gap between OLAP and SQL	2005	VLDB	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 0 of 0 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	11,117	Scalable OLTP in the Cloud: What’s the BIG DEAL? The Database AND the Application Have a BIG DEAL: Their Isolation Semantics	2024	CIDR
2	3,202	How to Fit when No One Size Fits	2013	CIDR
3	2,451	One Size Fits All? – Part 2: Benchmarking Results	2007	CIDR
4	1,854	Towards a One Size Fits All Database Architecture	2011	CIDR
5	3,837	Database Buffer Size Investigation for OLTP Workloads	1997	SIGMOD
6	157	OLTP Through the Looking Glass, and What We Found There	2008	SIGMOD
7	966	A Common Database Approach for OLTP and OLAP Using an In-Memory Column Database	2009	SIGMOD
8	68	The End of an Architectural Era (It’s Time for a Complete Rewrite)	2007	VLDB
9	7,611	Real World Requirements for Decision Support - Implications for RDBMS	1995	SIGMOD
10	3,079	Data Warehousing and OLAP for Decision Support	1997	SIGMOD