Volume 5 Number 2 (Feb. 2010)
Home > Archive > 2010 > Volume 5 Number 2 (Feb. 2010) >
JSW 2010 Vol.5(2): 160-167 ISSN: 1796-217X
doi: 10.4304/jsw.5.2.160-167

Pivoted Table Index for Querying Product- Property-Value Information

Hyunja Lee and Junho Shim
Dept of Computer Science Sookmyung Women’s University 52 Hyochangwon-gil, Yongsan-gu Seoul, 140-742, Korea

Abstract—The query for triple information on product– attribute (property)–value is one of the most frequent queries in e-commerce. In storing the triple (product–attribute– value) information, a vertical schema is effective for avoiding sparse data and schema evolution, while a conventional horizontal schema often shows better query performance, since the properties are queried as groups clustered by each product. Therefore, we propose two storage schemas: a vertical schema as a primary table structure for the triple information in RDBMS and a pivoted table index created from the basic vertical table as an additional index structure for accelerating query processing. The pivoted table index is beneficial to improving the performance of the frequent pattern query on the group properties associated with each product class.

Index Terms—Ontology, index, RDBMS, e-commerce, pivoted table, vertical schema.

[PDF]

Cite: Hyunja Lee and Junho Shim, "Pivoted Table Index for Querying Product- Property-Value Information," Journal of Software vol. 5, no. 2, pp. 160-167, 2010.

General Information

ISSN: 1796-217X (Online)
Frequency: Monthly (2006-2019); Bimonthly (Since 2020)
Editor-in-Chief: Prof. Antanas Verikas
Executive Editor: Ms. Yoyo Y. Zhou
Abstracting/ Indexing: DBLP, EBSCO, Google Scholar, ProQuest, INSPEC, ULRICH's Periodicals Directory, WorldCat, etc
E-mail: jsw@iap.org
  • Dec 06, 2019 News!

    Vol 14, No 1- Vol 14, No 4 has been indexed by EI (Inspec)   [Click]

  • Jun 22, 2020 News!

    Papers published in JSW Vol 14, No 1- Vol 15 No 4 have been indexed by DBLP     [Click]

  • Sep 30, 2020 News!

    The papers published in Vol 15, No 6 have all received dois from Crossref   [Click]

  • Aug 01, 2018 News!

    [CFP] 2020 the annual meeting of JSW Editorial Board, ICCSM 2020, will be held in Rome, Italy, July 17-19, 2020   [Click]

  • Sep 30, 2020 News!

    Vol 15, No 6 has been published with online version     [Click]