{"id":"https://openalex.org/W2743513849","doi":"https://doi.org/10.3906/elk-1608-112","title":"TSGV: a table-like structure-based greedy method for materialized view selection in data warehouses","display_name":"TSGV: a table-like structure-based greedy method for materialized view selection in data warehouses","publication_year":2017,"publication_date":"2017-01-01","ids":{"openalex":"https://openalex.org/W2743513849","doi":"https://doi.org/10.3906/elk-1608-112","mag":"2743513849"},"language":"en","primary_location":{"id":"doi:10.3906/elk-1608-112","is_oa":false,"landing_page_url":"https://doi.org/10.3906/elk-1608-112","pdf_url":null,"source":{"id":"https://openalex.org/S32837994","display_name":"TURKISH JOURNAL OF ELECTRICAL ENGINEERING & COMPUTER SCIENCES","issn_l":"1300-0632","issn":["1300-0632","1303-6203"],"is_oa":false,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310318422","host_organization_name":"Scientific and Technological Research Council of Turkey (TUBITAK)","host_organization_lineage":["https://openalex.org/P4310318422"],"host_organization_lineage_names":["Scientific and Technological Research Council of Turkey (TUBITAK)"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"TURKISH JOURNAL OF ELECTRICAL ENGINEERING & COMPUTER SCIENCES","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"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/A5045821587","display_name":"Mohammad Karim Sohrabi","orcid":"https://orcid.org/0000-0001-8066-0356"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Mohammad Karim SOHRABI","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5057916757","display_name":"Hossein Azgomi","orcid":"https://orcid.org/0000-0001-7974-1845"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Hossein AZGOMI","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":2.6629,"has_fulltext":false,"cited_by_count":21,"citation_normalized_percentile":{"value":0.90404683,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":"25","issue":null,"first_page":"3175","last_page":"3187"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9995999932289124,"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.9995999932289124,"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.9991999864578247,"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.9969000220298767,"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/materialized-view","display_name":"Materialized view","score":0.9674368500709534},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7989513874053955},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.731486976146698},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.7046636939048767},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.6939128637313843},{"id":"https://openalex.org/keywords/greedy-algorithm","display_name":"Greedy algorithm","score":0.6287522912025452},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5871180295944214},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.5565497279167175},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5334292650222778},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4605952501296997},{"id":"https://openalex.org/keywords/data-structure","display_name":"Data structure","score":0.45616182684898376},{"id":"https://openalex.org/keywords/plan","display_name":"Plan (archaeology)","score":0.43012750148773193},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.3723788261413574},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.1634627878665924},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.14247119426727295},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.10730180144309998}],"concepts":[{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.9674368500709534},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7989513874053955},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.731486976146698},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.7046636939048767},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.6939128637313843},{"id":"https://openalex.org/C51823790","wikidata":"https://www.wikidata.org/wiki/Q504353","display_name":"Greedy algorithm","level":2,"score":0.6287522912025452},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5871180295944214},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5565497279167175},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5334292650222778},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4605952501296997},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.45616182684898376},{"id":"https://openalex.org/C2776505523","wikidata":"https://www.wikidata.org/wiki/Q4785468","display_name":"Plan (archaeology)","level":2,"score":0.43012750148773193},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.3723788261413574},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.1634627878665924},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.14247119426727295},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.10730180144309998},{"id":"https://openalex.org/C95457728","wikidata":"https://www.wikidata.org/wiki/Q309","display_name":"History","level":0,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C166957645","wikidata":"https://www.wikidata.org/wiki/Q23498","display_name":"Archaeology","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.3906/elk-1608-112","is_oa":false,"landing_page_url":"https://doi.org/10.3906/elk-1608-112","pdf_url":null,"source":{"id":"https://openalex.org/S32837994","display_name":"TURKISH JOURNAL OF ELECTRICAL ENGINEERING & COMPUTER SCIENCES","issn_l":"1300-0632","issn":["1300-0632","1303-6203"],"is_oa":false,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310318422","host_organization_name":"Scientific and Technological Research Council of Turkey (TUBITAK)","host_organization_lineage":["https://openalex.org/P4310318422"],"host_organization_lineage_names":["Scientific and Technological Research Council of Turkey (TUBITAK)"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"TURKISH JOURNAL OF ELECTRICAL ENGINEERING & COMPUTER SCIENCES","raw_type":"journal-article"},{"id":"pmh:oai:dergipark.gov.tr:article/400716","is_oa":false,"landing_page_url":"http://dergipark.gov.tr/tbtkelektrik/issue/35785/400716","pdf_url":null,"source":{"id":"https://openalex.org/S4306401840","display_name":"DergiPark (Istanbul University)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I67581229","host_organization_name":"Istanbul University","host_organization_lineage":["https://openalex.org/I67581229"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"\\n Volume: 25, Issue: 4\\n 3175-3187\\n \\n","raw_type":"info:eu-repo/semantics/article"},{"id":"pmh:oai:dergipark.org.tr:article/400716","is_oa":false,"landing_page_url":"https://dergipark.org.tr/tr/pub/tbtkelektrik/issue/35785/400716","pdf_url":null,"source":{"id":"https://openalex.org/S4306401840","display_name":"DergiPark (Istanbul University)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I67581229","host_organization_name":"Istanbul University","host_organization_lineage":["https://openalex.org/I67581229"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"\\n Volume: 25, Issue: 4\\n 3175-3187\\n \\n","raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":22,"referenced_works":["https://openalex.org/W192938905","https://openalex.org/W1602422951","https://openalex.org/W1967587054","https://openalex.org/W2038093581","https://openalex.org/W2040929975","https://openalex.org/W2047809518","https://openalex.org/W2072916859","https://openalex.org/W2081417442","https://openalex.org/W2086028392","https://openalex.org/W2087869882","https://openalex.org/W2098416578","https://openalex.org/W2100109822","https://openalex.org/W2100251446","https://openalex.org/W2117654209","https://openalex.org/W2122902664","https://openalex.org/W2143515359","https://openalex.org/W2174588258","https://openalex.org/W2289945304","https://openalex.org/W2556688773","https://openalex.org/W3152002993","https://openalex.org/W4232177466","https://openalex.org/W4289258943"],"related_works":["https://openalex.org/W2162280381","https://openalex.org/W2185691065","https://openalex.org/W2363712075","https://openalex.org/W2383931363","https://openalex.org/W2348265434","https://openalex.org/W2108498730","https://openalex.org/W2142569422","https://openalex.org/W2087983779","https://openalex.org/W152305489","https://openalex.org/W1635132392"],"abstract_inverted_index":{"Since":[0,49],"a":[1,26,68,107,117,125,138],"data":[2,9,22,101],"warehouse":[3,102],"deals":[4],"with":[5],"huge":[6],"amounts":[7],"of":[8,56,60,67,71,86,98,120,155,166,190],"and":[10,16,53,159,162],"complex":[11],"analytical":[12,47,157],"queries,":[13],"online":[14],"processing":[15,37,140],"answering":[17],"to":[18,33,42,73,100],"users'":[19],"queries":[20,154],"in":[21,45,94,131,173,188],"warehouses":[23],"can":[24],"be":[25],"serious":[27],"challenge.":[28],"Materialized":[29],"views":[30,57,62,72,87,121],"are":[31,170],"used":[32],"speed":[34],"up":[35],"query":[36],"rather":[38],"than":[39,184],"direct":[40],"access":[41],"the":[43,50,61,83,96,153,160,167],"database":[44],"on-line":[46],"processing.":[48],"large":[51],"number":[52],"high":[54],"volume":[55],"prevents":[58],"all":[59],"from":[63,124,137],"being":[64],"stored,":[65],"selection":[66,111,147],"proper":[69,118],"subset":[70,85,169],"materialization":[74,89,123],"is":[75,113,135,150],"inevitable.":[76],"Proposing":[77],"an":[78,91,156],"appropriate":[79],"method":[80,149],"for":[81,88,122],"selecting":[82],"optimal":[84],"plays":[90],"essential":[92],"role":[93],"increasing":[95],"efficiency":[97],"responding":[99],"queries.":[103],"In":[104],"this":[105,132,174],"paper,":[106],"greedy":[108,145],"materialized":[109],"view":[110,146,163],"algorithm":[112],"represented,":[114],"which":[115],"selects":[116],"set":[119],"novel":[126],"table-like":[127,133,143],"structure.":[128],"The":[129,176],"information":[130],"structure":[134],"extracted":[136],"multivalue":[139],"plan.":[141],"This":[142],"structure-based":[144],"(TSGV)":[148],"evaluated":[151],"using":[152],"database,":[158],"query-processing":[161],"maintenance":[164],"costs":[165],"selected":[168],"both":[171],"considered":[172],"evaluation.":[175],"experimental":[177],"results":[178],"show":[179],"that":[180],"TSGV":[181],"operates":[182],"better":[183],"previously":[185],"represented":[186],"methods":[187],"terms":[189],"time.":[191]},"counts_by_year":[{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":5},{"year":2018,"cited_by_count":5},{"year":2017,"cited_by_count":3}],"updated_date":"2026-08-18T07:49:30.821534","created_date":"2025-10-10T00:00:00"}