{"id":"https://openalex.org/W2057917857","doi":"https://doi.org/10.4304/jsw.5.2.160-167","title":"Pivoted Table Index for Querying Product-Property-Value Information","display_name":"Pivoted Table Index for Querying Product-Property-Value Information","publication_year":2010,"publication_date":"2010-02-03","ids":{"openalex":"https://openalex.org/W2057917857","doi":"https://doi.org/10.4304/jsw.5.2.160-167","mag":"2057917857"},"language":"en","primary_location":{"id":"doi:10.4304/jsw.5.2.160-167","is_oa":false,"landing_page_url":"https://doi.org/10.4304/jsw.5.2.160-167","pdf_url":null,"source":{"id":"https://openalex.org/S114141714","display_name":"Journal of Software","issn_l":"1796-217X","issn":["1796-217X"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318660","host_organization_name":"Academy Publisher","host_organization_lineage":["https://openalex.org/P4310318660"],"host_organization_lineage_names":["Academy Publisher"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Software","raw_type":"journal-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":[],"countries":[],"is_corresponding":true,"raw_author_name":"Hyunja Lee","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5077087855","display_name":"Junho Shim","orcid":"https://orcid.org/0000-0003-4315-4117"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Junho Shim","raw_affiliation_strings":[],"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5077599453"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.3382,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.57881367,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"5","issue":"2","first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9993000030517578,"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.9993000030517578,"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.9980999827384949,"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.9945999979972839,"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/computer-science","display_name":"Computer science","score":0.8904538154602051},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.6708420515060425},{"id":"https://openalex.org/keywords/index","display_name":"Index (typography)","score":0.6603075861930847},{"id":"https://openalex.org/keywords/property","display_name":"Property (philosophy)","score":0.5858133435249329},{"id":"https://openalex.org/keywords/product","display_name":"Product (mathematics)","score":0.5330051183700562},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4775972366333008},{"id":"https://openalex.org/keywords/value","display_name":"Value (mathematics)","score":0.47003859281539917},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4056885540485382},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3213449716567993},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.290996253490448},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.05509597063064575}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8904538154602051},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.6708420515060425},{"id":"https://openalex.org/C2777382242","wikidata":"https://www.wikidata.org/wiki/Q6017816","display_name":"Index (typography)","level":2,"score":0.6603075861930847},{"id":"https://openalex.org/C189950617","wikidata":"https://www.wikidata.org/wiki/Q937228","display_name":"Property (philosophy)","level":2,"score":0.5858133435249329},{"id":"https://openalex.org/C90673727","wikidata":"https://www.wikidata.org/wiki/Q901718","display_name":"Product (mathematics)","level":2,"score":0.5330051183700562},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4775972366333008},{"id":"https://openalex.org/C2776291640","wikidata":"https://www.wikidata.org/wiki/Q2912517","display_name":"Value (mathematics)","level":2,"score":0.47003859281539917},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4056885540485382},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3213449716567993},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.290996253490448},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.05509597063064575},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"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":2,"locations":[{"id":"doi:10.4304/jsw.5.2.160-167","is_oa":false,"landing_page_url":"https://doi.org/10.4304/jsw.5.2.160-167","pdf_url":null,"source":{"id":"https://openalex.org/S114141714","display_name":"Journal of Software","issn_l":"1796-217X","issn":["1796-217X"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318660","host_organization_name":"Academy Publisher","host_organization_lineage":["https://openalex.org/P4310318660"],"host_organization_lineage_names":["Academy Publisher"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Software","raw_type":"journal-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.430.955","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.430.955","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://ojs.academypublisher.com/index.php/jsw/article/viewFile/0502160167/1548/","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.5699999928474426,"id":"https://metadata.un.org/sdg/8","display_name":"Decent work and economic growth"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":13,"referenced_works":["https://openalex.org/W29172951","https://openalex.org/W1567277549","https://openalex.org/W1812636409","https://openalex.org/W2022679230","https://openalex.org/W2102288093","https://openalex.org/W2132019011","https://openalex.org/W2134964460","https://openalex.org/W2138489156","https://openalex.org/W2140613126","https://openalex.org/W2145055832","https://openalex.org/W2157810258","https://openalex.org/W2157979971","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W2948670949","https://openalex.org/W4288047943","https://openalex.org/W4232484699","https://openalex.org/W2990655940","https://openalex.org/W2473636215","https://openalex.org/W1590279850","https://openalex.org/W3014091026","https://openalex.org/W2966805374","https://openalex.org/W4235635153","https://openalex.org/W2515075097"],"abstract_inverted_index":{"Abstract\u2014The":[0],"query":[1,45,96,112],"for":[2,30,72,94],"triple":[3,21,74],"information":[4,75],"on":[5,113],"product\u2013":[6],"attribute":[7],"(property)\u2013value":[8],"is":[9,28,102],"one":[10],"of":[11,108],"the":[12,20,48,73,85,106,109,114],"most":[13],"frequent":[14,110],"queries":[15],"in":[16,76],"e-commerce.":[17],"In":[18],"storing":[19],"(product\u2013attribute\u2013":[22],"value)":[23],"information,":[24],"a":[25,38,64,68,79],"vertical":[26,65,87,129],"schema":[27,35,41,66,130],"effective":[29],"avoiding":[31],"sparse":[32],"data":[33],"and":[34,78],"evolution,":[36],"while":[37],"conventional":[39],"horizontal":[40],"often":[42],"shows":[43],"better":[44],"performance,":[46],"since":[47],"properties":[49,116],"are":[50],"queried":[51],"as":[52,67,89],"groups":[53],"clustered":[54],"by":[55],"each":[56,119],"product.":[57],"Therefore,":[58],"we":[59],"propose":[60],"two":[61],"storage":[62],"schemas:":[63],"primary":[69],"table":[70,81,88,100],"structure":[71,93],"RDBMS":[77],"pivoted":[80,99,127],"index":[82,92,101],"created":[83],"from":[84],"basic":[86],"an":[90],"additional":[91],"accelerating":[95],"processing.":[97],"The":[98],"beneficial":[103],"to":[104],"improving":[105],"performance":[107],"pattern":[111],"group":[115],"associated":[117],"with":[118],"product":[120],"class.":[121],"Index":[122],"Terms\u2014Ontology,":[123],"index,":[124],"RDBMS,":[125],"e-commerce,":[126],"table,":[128],"I.":[131]},"counts_by_year":[],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}