Managing E-Commerce Catalogs in a DBMS with Native XML Support

14 years 25 days ago
Managing E-Commerce Catalogs in a DBMS with Native XML Support
Electronic commerce is emerging as a major application area for database systems. A large number of e-commerce stores provide electronic product catalogs that allow customers to search products of interest and store owners to manage various product information. Due to the constant schema evolution and the sparsity of e-commerce data, most commercial e-commerce systems use the so-called vertical schema for data storage. However, query processing for data stored using vertical schema is extremely inefficient because current RDBMSs, especially its cost-based query optimizer, are specifically designed to deal with traditional horizontal schemas. In this paper, we show that e-catalog management can be naturally supported in IBM’s System RX, the first DBMS that truly supports both XML and relational data in their native forms. By leveraging on System RX’s hybrid nature, we present a novel solution for storing, managing, and querying e-catalog data. In addition to traditional queries,...
Lipyeow Lim, Min Wang
Added 24 Jun 2010
Updated 24 Jun 2010
Type Conference
Year 2005
Authors Lipyeow Lim, Min Wang
Comments (0)