skip to main content
10.1145/1516241.1516253acmconferencesArticle/Chapter ViewAbstractPublication PagesicuimcConference Proceedingsconference-collections
research-article

Pivoted table index for querying product-property-value information

Published: 15 February 2009 Publication History

Abstract

The query for triple information on product -attribute (property)-value is one of the most frequent queries in e-commerce. Storing the triple, schema vertically is effective for avoidance of sparse data and schema evolution. However, conventional horizontal schema often shows better query performance when properties are queried as groups clustered by product. Therefore, we propose vertical schema as a primary table structure for the triple information in RDBMS and a pivoted table index created from the basic vertical table. This index is beneficial to performance of the frequent pattern query on the group properties associated with each product class.

References

[1]
J. D. Abadi, A. Marcus, S. R. Madden, and K. Hollenbach, Scalable Semantic Web Data Management Using Vertical Partitioning, In Proc. of VLDB 2007, 2007
[2]
R. Agrawal, A. Somani, and Y. Xu, Storage and Querying of E-Commerce Data, In Proc. of VLDB 2001, 2001
[3]
J. Beckmann, A. Halverson, R. Krishnamurthy, J. Naughton, Extending RDBMSs To Support Sparse Datasets Using An Interpreted Attribute Storage Format, In Proc. of ICDE, 2006.
[4]
J. Broekstra, A. Kampman and F. v. Harmelen, Sesame: A generic Architecture for Storing and Querying RDF and RDF Schema, In Proc. of International Semantic Web Conference, 2002.
[5]
C. Cunningham, C. A. Galindo-Legaria, and G. Graefe, PIVOT and UNPIVOT: Optimization and Execution Strategies in an RDBMS, In Proc. of VLDB2004
[6]
J. Corwin, A. Silberschatz, P. L. Miller, and L. Marenco. Dynamic tables: An architecture for managing evolving, heterogeneous biomedical data in relational database management systems. Journal of the American Medical Informatics Association, 14(1):86--93, 2007
[7]
G. P. Copeland and S. N. Khoshafian. A decomposition storage model. In Proc. of SIGMOD, 1985.
[8]
D. Valentin, P. Nadkarni, and C. Brandt, Pivoting approaches for bulk extraction of Entity-Attribute-Value data Comp Meth Programs Biomed 2006;82: 38--43, 2006.
[9]
S. Khoshafian, G. P. Copeland, T. Jagodis, H. Boral, and P. Valduriez. A query processing strategy for the decomposed storage model. In Proc. of the Third International Conference on Data Engineering, 1987.
[10]
Z. H. Liu, M. Krishnaprasad, H. J. Chang, and V. Arora, XML Table Index -- An Efficient Way of Indexing and Querying XML Property Data, In Proc. of ICDE2007,2007
[11]
T. Lee, I. Lee, S. Lee, S. Lee, D. Kim, J. Chun, H. Lee, and J. Shim, Building an Operational Product Ontology System, Electronic Commerce Research and Applications, 2006.
[12]
L. V. S. Lakshmanan, F. Sadri, and S. N. Subramanian. On Efficiently Implementing SchemaSQL on a SQL Database, In Proc. of VLDB99, 1999
[13]
B. McBirds, Jena: A semantic web toolkit, IEEE Internet Computing, 2002.
[14]
Z. Pan and J. Heflin, DLDB: Extending Relational Databases to Support Semantic Web Queries, In Proc. of International Workshop on Practical and Scalable Semantic Web Systems, 2003.
[15]
R. Volz, D. Oberle, S. Staab, and B. Motik, KAON SERVER - A Semantic Web Management System, In Proc. of WWW2003, 2003
[16]
K. Wilkinson. Jena property table implementation. In Proc. of SSWS, 2006.
[17]
K. Wilkinson, C. Sayers, H. A. Kuno, and D. Reynolds, Efficient RDF Storage and Retrieval in Jena2, In Proc. of SWDB, 2003

Cited By

View all
  • (2010)COVER model pivot view indexing for efficient XML data managementProceedings of the 2010 Conference of the Center for Advanced Studies on Collaborative Research10.1145/1923947.1923958(100-114)Online publication date: 1-Nov-2010
  1. Pivoted table index for querying product-property-value information

    Recommendations

    Comments

    Information & Contributors

    Information

    Published In

    cover image ACM Conferences
    ICUIMC '09: Proceedings of the 3rd International Conference on Ubiquitous Information Management and Communication
    February 2009
    704 pages
    ISBN:9781605584058
    DOI:10.1145/1516241
    Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

    Sponsors

    Publisher

    Association for Computing Machinery

    New York, NY, United States

    Publication History

    Published: 15 February 2009

    Permissions

    Request permissions for this article.

    Check for updates

    Author Tags

    1. RDBMS
    2. e-commerce
    3. index
    4. ontology
    5. pivot
    6. vertical schema

    Qualifiers

    • Research-article

    Funding Sources

    Conference

    ICUIMC '09
    Sponsor:

    Contributors

    Other Metrics

    Bibliometrics & Citations

    Bibliometrics

    Article Metrics

    • Downloads (Last 12 months)3
    • Downloads (Last 6 weeks)0
    Reflects downloads up to 13 Feb 2025

    Other Metrics

    Citations

    Cited By

    View all
    • (2010)COVER model pivot view indexing for efficient XML data managementProceedings of the 2010 Conference of the Center for Advanced Studies on Collaborative Research10.1145/1923947.1923958(100-114)Online publication date: 1-Nov-2010

    View Options

    Login options

    View options

    PDF

    View or Download as a PDF file.

    PDF

    eReader

    View online with eReader.

    eReader

    Figures

    Tables

    Media

    Share

    Share

    Share this Publication link

    Share on social media