Supporting Efficient Parametric Search of E-Commerce Data: A Loosely-Coupled Solution [chapter]

Min Wang, Yuan-Chi Chang, Sriram Padmanabhan
<span title="">2002</span> <i title="Springer Berlin Heidelberg"> <a target="_blank" rel="noopener" href="https://fatcat.wiki/container/2w3awgokqne6te4nvlofavy5a4" style="color: black;">Lecture Notes in Computer Science</a> </i> &nbsp;
Electronic commerce is emerging as a major application area for database systems. A large number of e-commerce sites provide electronic product catalogs that allow users to search products of interest. Due to the constant e v olution and the high 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 slow because current RDBMS, especially its costbased query
more &raquo; ... ptimizer, is designed to deal with traditional horizontal schema e ciently. Most e-commerce systems would like to o er advanced parametric search capabilities to their users. However, most searches are expected to be online which means that the query execution should be very fast. RDBMSs require new capabilities and enhancements before they can satisfy the search performance criteria against vertical schema. The tightly-coupled enhancements and additions to a DBMS require considerable amount o f work and may t a k e a long time to be accomplished. In this paper, we describe an alternative approach called SAL, a Search Assistant L a yer that can be implemented outside a database engine to accommodate the urgent n e e d f o r e c i e n t parametric search on e-commerce data. Our experimental results show that dramatic performance improvement is provided by SAL for search queries.
<span class="external-identifiers"> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1007/3-540-45876-x_27">doi:10.1007/3-540-45876-x_27</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/ypfvrfq4hbaetcvvftonm6ynr4">fatcat:ypfvrfq4hbaetcvvftonm6ynr4</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20030313170118/http://www.cs.duke.edu:80/~minw/Publication/edbt02.pdf" title="fulltext PDF download" data-goatcounter-click="serp-fulltext" data-goatcounter-title="serp-fulltext"> <button class="ui simple right pointing dropdown compact black labeled icon button serp-button"> <i class="icon ia-icon"></i> Web Archive [PDF] <div class="menu fulltext-thumbnail"> <img src="https://blobs.fatcat.wiki/thumbnail/pdf/d3/49/d3497435df2352a162b1fa82bc4947d2778cff6c.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener noreferrer" href="https://doi.org/10.1007/3-540-45876-x_27"> <button class="ui left aligned compact blue labeled icon button serp-button"> <i class="external alternate icon"></i> springer.com </button> </a>