{"id":"https://openalex.org/W2081760831","doi":"https://doi.org/10.1145/1516241.1516253","title":"Pivoted table index for querying product-property-value information","display_name":"Pivoted table index for querying product-property-value information","publication_year":2009,"publication_date":"2009-02-15","ids":{"openalex":"https://openalex.org/W2081760831","doi":"https://doi.org/10.1145/1516241.1516253","mag":"2081760831"},"language":"en","primary_location":{"id":"doi:10.1145/1516241.1516253","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1516241.1516253","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 3rd International Conference on Ubiquitous Information Management and Communication","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5077599453","display_name":"Hyun-Ja Lee","orcid":null},"institutions":[{"id":"https://openalex.org/I31766871","display_name":"Sookmyung Women's University","ror":"https://ror.org/00vvvt117","country_code":"KR","type":"education","lineage":["https://openalex.org/I31766871"]}],"countries":["KR"],"is_corresponding":true,"raw_author_name":"Hyunja Lee","raw_affiliation_strings":["Sookmyung Women's University, Yongsan-gu, Seoul, Korea","Sookmyung Women's University, Yongsan-Gu, Seoul, Korea#TAB#"],"affiliations":[{"raw_affiliation_string":"Sookmyung Women's University, Yongsan-gu, Seoul, Korea","institution_ids":["https://openalex.org/I31766871"]},{"raw_affiliation_string":"Sookmyung Women's University, Yongsan-Gu, Seoul, Korea#TAB#","institution_ids":["https://openalex.org/I31766871"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5077087855","display_name":"Junho Shim","orcid":"https://orcid.org/0000-0003-4315-4117"},"institutions":[{"id":"https://openalex.org/I31766871","display_name":"Sookmyung Women's University","ror":"https://ror.org/00vvvt117","country_code":"KR","type":"education","lineage":["https://openalex.org/I31766871"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"Junho Shim","raw_affiliation_strings":["Sookmyung Women's University, Yongsan-gu, Seoul, Korea","Sookmyung Women's University, Yongsan-Gu, Seoul, Korea#TAB#"],"affiliations":[{"raw_affiliation_string":"Sookmyung Women's University, Yongsan-gu, Seoul, Korea","institution_ids":["https://openalex.org/I31766871"]},{"raw_affiliation_string":"Sookmyung Women's University, Yongsan-Gu, Seoul, Korea#TAB#","institution_ids":["https://openalex.org/I31766871"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5077599453"],"corresponding_institution_ids":["https://openalex.org/I31766871"],"apc_list":null,"apc_paid":null,"fwci":0.3525,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.55750237,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"58","last_page":"62"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9986000061035156,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9986000061035156,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9961000084877014,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9940000176429749,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.7630082964897156},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7416782379150391},{"id":"https://openalex.org/keywords/schema-evolution","display_name":"Schema evolution","score":0.6340557336807251},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.5760475993156433},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.5097452998161316},{"id":"https://openalex.org/keywords/star-schema","display_name":"Star schema","score":0.4715345501899719},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.45972201228141785},{"id":"https://openalex.org/keywords/property","display_name":"Property (philosophy)","score":0.45227062702178955},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4515664577484131},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4167996644973755},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.34555351734161377},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.2773953676223755},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.09197694063186646}],"concepts":[{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.7630082964897156},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7416782379150391},{"id":"https://openalex.org/C2780660560","wikidata":"https://www.wikidata.org/wiki/Q3951893","display_name":"Schema evolution","level":4,"score":0.6340557336807251},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.5760475993156433},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.5097452998161316},{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.4715345501899719},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.45972201228141785},{"id":"https://openalex.org/C189950617","wikidata":"https://www.wikidata.org/wiki/Q937228","display_name":"Property (philosophy)","level":2,"score":0.45227062702178955},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4515664577484131},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4167996644973755},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.34555351734161377},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.2773953676223755},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.09197694063186646},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1516241.1516253","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1516241.1516253","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 3rd International Conference on Ubiquitous Information Management and Communication","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.5,"display_name":"Decent work and economic growth","id":"https://metadata.un.org/sdg/8"}],"awards":[{"id":"https://openalex.org/G1719920873","display_name":null,"funder_award_id":"IITA-2008-C1090-0801-0031","funder_id":"https://openalex.org/F4320321640","funder_display_name":"Ministry of Knowledge Economy"}],"funders":[{"id":"https://openalex.org/F4320321640","display_name":"Ministry of Knowledge Economy","ror":"https://ror.org/008nkqk13"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":21,"referenced_works":["https://openalex.org/W29172951","https://openalex.org/W1561055565","https://openalex.org/W1562242228","https://openalex.org/W1567277549","https://openalex.org/W1603311785","https://openalex.org/W1812636409","https://openalex.org/W2022679230","https://openalex.org/W2082186095","https://openalex.org/W2102288093","https://openalex.org/W2104633534","https://openalex.org/W2129566748","https://openalex.org/W2132019011","https://openalex.org/W2134964460","https://openalex.org/W2138489156","https://openalex.org/W2140613126","https://openalex.org/W2145055832","https://openalex.org/W2149899289","https://openalex.org/W2157810258","https://openalex.org/W2157979971","https://openalex.org/W2292587472","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W2034415381","https://openalex.org/W2505630977","https://openalex.org/W2383709723","https://openalex.org/W1567213510","https://openalex.org/W149859995","https://openalex.org/W3038511590","https://openalex.org/W1545286006","https://openalex.org/W2133646318","https://openalex.org/W2613904075","https://openalex.org/W1678653077"],"abstract_inverted_index":{"The":[0],"query":[1,40,88],"for":[2,25,61],"triple":[3,63],"information":[4,64],"on":[5,89],"product":[6,96],"-attribute":[7],"(property)-value":[8],"is":[9,23,80],"one":[10],"of":[11,27,84],"the":[12,19,62,74,85,90],"most":[13],"frequent":[14,86],"queries":[15],"in":[16,65],"e-commerce.":[17],"Storing":[18],"triple,":[20],"schema":[21,31,36,55],"vertically":[22],"effective":[24],"avoidance":[26],"sparse":[28],"data":[29],"and":[30,67],"evolution.":[32],"However,":[33],"conventional":[34],"horizontal":[35],"often":[37],"shows":[38],"better":[39],"performance":[41,83],"when":[42],"properties":[43,92],"are":[44],"queried":[45],"as":[46,56],"groups":[47],"clustered":[48],"by":[49],"product.":[50],"Therefore,":[51],"we":[52],"propose":[53],"vertical":[54,76],"a":[57,68],"primary":[58],"table":[59,70],"structure":[60],"RDBMS":[66],"pivoted":[69],"index":[71,79],"created":[72],"from":[73],"basic":[75],"table.":[77],"This":[78],"beneficial":[81],"to":[82],"pattern":[87],"group":[91],"associated":[93],"with":[94],"each":[95],"class.":[97]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}