상세 보기
Pivoted table index for querying product-property-value information
- Lee, Hyunja;
- Shim, Junho
Citations
WEB OF SCIENCE
0Citations
SCOPUS
1초록
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. Copyright 2009 ACM.
키워드
E-commerce; Index; Ontology; Pivot; RDBMS; Vertical schema; E-commerce; Index; Pivot; RDBMS; Vertical schema; Electronic commerce; Ontology; Information management
- 제목
- Pivoted table index for querying product-property-value information
- 저자
- Lee, Hyunja; Shim, Junho
- 발행일
- 2009-02
- 유형
- Conference Paper
- 저널명
- Proceedings of the 3rd International Conference on Ubiquitous Information Management and Communication, ICUIMC'09
- 페이지
- 58 ~ 62