SIGMOD '85 Proceedings of the 1985 ACM SIGMOD international conference on Management of data
IEEE Internet Computing
A Query Processing Strategy for the Decomposed Storage Model
Proceedings of the Third International Conference on Data Engineering
On Efficiently Implementing SchemaSQL on an SQL Database System
VLDB '99 Proceedings of the 25th International Conference on Very Large Data Bases
Storage and Querying of E-Commerce Data
Proceedings of the 27th International Conference on Very Large Data Bases
Sesame: A Generic Architecture for Storing and Querying RDF and RDF Schema
ISWC '02 Proceedings of the First International Semantic Web Conference on The Semantic Web
Extending RDBMSs To Support Sparse Datasets Using An Interpreted Attribute Storage Format
ICDE '06 Proceedings of the 22nd International Conference on Data Engineering
PIVOT and UNPIVOT: optimization and execution strategies in an RDBMS
VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30
Scalable semantic web data management using vertical partitioning
VLDB '07 Proceedings of the 33rd international conference on Very large data bases
Pivoting approaches for bulk extraction of Entity-Attribute-Value data
Computer Methods and Programs in Biomedicine
COVER model pivot view indexing for efficient XML data management
Proceedings of the 2010 Conference of the Center for Advanced Studies on Collaborative Research
| Hi-index | 0.00 |
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.