Storage and Querying of E-Commerce Data

Summary: Vertical storage of objects as (id, attr, value) tuples enables sparse, evolving e-commerce schemas. A logical horizontal view maps view queries to the vertical format; the paper reports implementations, performance results, and DBMS facilities needed. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 8930
Venue: VLDB
Year: 2001
Pagerank: 0.00012476189
Overall Rank: 1,038 | 92.89%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. Rakesh Agrawal (IBM)
2. Amit Somani (IBM)
3. Yirong Xu (IBM)

BibTeX Citation

@article{agrawal_vldb01,
        title = {{Storage and Querying of E-Commerce Data}},
        author = {Agrawal, Rakesh and Somani, Amit and Xu, Yirong},
        journal = {PVLDB},
        series = {{VLDB} '01},
        year = {2001}
}

Incoming Citations (Sorted by Pagerank)

Showing 15 of 15 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
366	Scalable Semantic Web Data Management Using Vertical Partitioning	2007	VLDB	0.00020039981
394	A Case for Fractured Mirrors	2002	VLDB	0.00019306179
1,477	Multi-Tenant Databases for Software as a Service: Schema-Mapping Techniques	2008	SIGMOD	0.00010654969
1,691	PIVOT and UNPIVOT: Optimization and Execution Strategies in an RDBMS	2004	VLDB	9.9999141e-05
1,738	Sinew: A SQL System for Multi-Structured Data	2014	SIGMOD	9.8823494e-05
2,724	A Relational Approach to Incrementally Extracting and Querying Structure in Unstructured Data	2007	VLDB	8.2048095e-05
2,800	JSON Data Management – Supporting Schema-less Development in RDBMS	2014	SIGMOD	8.1124117e-05
4,217	The Case for a Wide-Table Approach to Manage Sparse Relational Data Sets	2007	SIGMOD	6.8269451e-05
6,047	Column Stores For Wide and Sparse Data	2007	CIDR	5.9952702e-05
6,541	A Dataspace Odyssey: The iMeMex Personal Dataspace Management System	2007	CIDR	5.8471331e-05
7,278	One Table Stores All: Enabling Painless Free-and-Easy Data Publishing and Sharing	2007	CIDR	5.6579198e-05
8,109	Relational Support for Flexible Schema Scenarios	2008	VLDB	5.4843869e-05
8,186	A Comparison of Flexible Schemas for Software as a Service	2009	SIGMOD	5.4705133e-05
9,216	Management of Flexible Schema Data in RDBMSs - Opportunities and Limitations for NoSQL	2015	CIDR	5.3051647e-05
12,853	Database Technologies for Electronic Commerce	2002	VLDB	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 7 of 7 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
115	A Decomposition Storage Model	1985	SIGMOD	0.00032338948
980	Integrating Association Rule Mining with Relational Database Systems: Alternatives and Implications	1998	SIGMOD	0.00012844074
1,672	Language Features for Interoperability of Databases with Schematic Discrepancies	1991	SIGMOD	0.0001004199
1,708	Using Schematically Heterogeneous Structures	1998	SIGMOD	9.958846e-05
1,928	Relations with Relation Names as Arguments: Algebra and Calculus	1992	PODS	9.4692029e-05
3,889	On Efficiently Implementing SchemaSQL on a SQL Database System	1999	VLDB	7.0440224e-05
4,922	A Domain Based Internal Schema For Relational Database Machines	1982	SIGMOD	6.4445907e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	3,357	Columnar Storage and List-based Processing for Graph Database Management Systems	2021	VLDB
2	1,679	Self-organizing Tuple Reconstruction in Column-stores	2009	SIGMOD
3	6,047	Column Stores For Wide and Sparse Data	2007	CIDR
4	5,383	Compressed Representations of Conjunctive Query Results	2018	PODS
5	1,395	Column-oriented Database Systems	2009	VLDB
6	630	Performance Tradeoffs in Read-Optimized Databases	2006	VLDB
7	60	Integrating Compression and Execution in Column-Oriented Database Systems	2006	SIGMOD
8	12,853	Database Technologies for Electronic Commerce	2002	VLDB
9	4,217	The Case for a Wide-Table Approach to Manage Sparse Relational Data Sets	2007	SIGMOD
10	14,133	E-Commerce Database Issues and Experience	1999	SIGMOD