{"id":"https://openalex.org/W1997180378","doi":"https://doi.org/10.1145/973620.973646","title":"Index structure for the fact table of a star-join schema and template query processing","display_name":"Index structure for the fact table of a star-join schema and template query processing","publication_year":2003,"publication_date":"2003-01-01","ids":{"openalex":"https://openalex.org/W1997180378","doi":"https://doi.org/10.1145/973620.973646","mag":"1997180378"},"language":"en","primary_location":{"id":"doi:10.1145/973620.973646","doi":"https://doi.org/10.1145/973620.973646","is_oa":false,"landing_page_url":"https://doi.org/10.1145/973620.973646","pdf_url":null,"source":{"id":"https://openalex.org/S4210222260","display_name":"International Conference on Computer Systems and Technologies (CompSysTech)","issn_l":"1313-8936","issn":["1313-8936","1313-9037"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 4th international conference conference on Computer systems and technologies e-Learning - CompSysTech '03","raw_type":"proceedings-article"},"volume":null,"type":"paratext","is_traditional":false,"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/A5086248113","display_name":"Anna Rozeva","orcid":"https://orcid.org/0000-0001-6069-5826","observed_orcids":["https://orcid.org/0000-0001-6069-5826"]},"institutions":[{"id":"https://openalex.org/I170627324","display_name":"University of Forestry","ror":"https://ror.org/033t8gt11","country_code":"BG","type":"education","lineage":["https://openalex.org/I170627324"]}],"countries":["BG"],"is_corresponding":true,"raw_author_name":"Anna Rozeva","raw_affiliation_strings":["Department of Computer Systems and Informatics, University of Forestry Sofia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Systems and Informatics, University of Forestry Sofia","institution_ids":["https://openalex.org/I170627324"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5086248113"],"corresponding_institution_ids":["https://openalex.org/I170627324"],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"153","last_page":"158"},"is_retracted":false,"is_paratext":true,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9940999746322632,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9940999746322632,"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"}},{"id":"https://openalex.org/T11891","display_name":"Big Data and Business Intelligence","score":0.002099999925121665,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.001500000013038516,"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/fact-tables","display_name":"fact tables","score":0.6700000166893005},{"id":"https://openalex.org/keywords/index-structures","display_name":"index structures","score":0.9200000166893005},{"id":"https://openalex.org/keywords/data-warehousing","display_name":"data warehousing","score":0.8669999837875366},{"id":"https://openalex.org/keywords/composite-keys","display_name":"composite keys","score":0.9580000042915344},{"id":"https://openalex.org/keywords/temporal-dimension","display_name":"temporal dimension","score":0.6980000138282776},{"id":"https://openalex.org/keywords/stream-processing","display_name":"stream processing","score":0.8379999995231628},{"id":"https://openalex.org/keywords/aggregation","display_name":"aggregation","score":0.5759999752044678}],"concepts":[{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.8664687275886536},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7952574491500854},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.6852641105651855},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5679209232330322},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.5502026081085205},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.5462926030158997},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5188435316085815},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4801023304462433},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.44951748847961426},{"id":"https://openalex.org/C2777382242","wikidata":"https://www.wikidata.org/wiki/Q6017816","display_name":"Index (typography)","level":2,"score":0.43087825179100037},{"id":"https://openalex.org/C103578098","wikidata":"https://www.wikidata.org/wiki/Q277680","display_name":"A* search algorithm","level":2,"score":0.4284501075744629},{"id":"https://openalex.org/C2780897414","wikidata":"https://www.wikidata.org/wiki/Q7600592","display_name":"Star (game theory)","level":2,"score":0.421394407749176},{"id":"https://openalex.org/C203570394","wikidata":"https://www.wikidata.org/wiki/Q4060688","display_name":"Sort-merge join","level":3,"score":0.4148527979850769},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.40546804666519165},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.36999329924583435},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3547174632549286},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.2813427448272705},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.15117496252059937},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.11725249886512756},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.08382666110992432},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.07620823383331299},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/973620.973646","doi":"https://doi.org/10.1145/973620.973646","is_oa":false,"landing_page_url":"https://doi.org/10.1145/973620.973646","pdf_url":null,"source":{"id":"https://openalex.org/S4210222260","display_name":"International Conference on Computer Systems and Technologies (CompSysTech)","issn_l":"1313-8936","issn":["1313-8936","1313-9037"],"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 4th international conference conference on Computer systems and technologies e-Learning - CompSysTech '03","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":6,"referenced_works":["https://openalex.org/W1508412218","https://openalex.org/W1542795329","https://openalex.org/W1567767785","https://openalex.org/W1594809416","https://openalex.org/W2002128741","https://openalex.org/W2103465290"],"related_works":["https://openalex.org/W4238329074","https://openalex.org/W7097783557","https://openalex.org/W2139534868","https://openalex.org/W4233118104","https://openalex.org/W1835980735","https://openalex.org/W7098833534","https://openalex.org/W2140646908","https://openalex.org/W1593041112","https://openalex.org/W2171064633","https://openalex.org/W2587045575"],"abstract_inverted_index":{"Star-join":[0],"is":[1],"a":[2,16,64],"database":[3],"scheme":[4,18],"designed":[5],"for":[6,24,33,52,72],"the":[7,34,42,53,82,86],"purpose":[8],"of":[9,44,85],"data":[10],"warehousing.":[11],"A":[12,49],"typical":[13],"query":[14,47,87],"on":[15],"star-join":[17,35],"as":[19,21,63,79,81],"well":[20,80],"an":[22],"algorithm":[23],"its":[25],"processing":[26,67,88],"has":[27,38,58,69],"been":[28,39,59,70],"examined.":[29],"An":[30],"index":[31,51],"structure":[32],"fact":[36,54],"table":[37],"proposed":[40],"with":[41],"aim":[43],"facilitating":[45],"template":[46],"processing.":[48],"multilevel":[50],"table's":[55],"composite":[56],"key":[57],"built":[60],"having":[61],"time_key":[62],"top'level.":[65],"Stream":[66],"technique":[68],"implemented":[71],"resolving":[73],"query's":[74],"application":[75],"and":[76],"join":[77],"constraints":[78],"aggregation":[83],"step":[84],"algorithm.":[89]},"counts_by_year":[],"updated_date":"2026-10-26T11:51:55.731654","created_date":"2016-06-24T00:00:00"}