{"id":"https://openalex.org/W3209024345","doi":"https://doi.org/10.1145/3468081.3471064","title":"Materialized View Driven Architecture over Lattice of Cuboids in Data Warehouse","display_name":"Materialized View Driven Architecture over Lattice of Cuboids in Data Warehouse","publication_year":2021,"publication_date":"2021-06-20","ids":{"openalex":"https://openalex.org/W3209024345","doi":"https://doi.org/10.1145/3468081.3471064","mag":"3209024345"},"language":"en","primary_location":{"id":"doi:10.1145/3468081.3471064","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3468081.3471064","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the the 8th International Virtual Conference on Applied Computing & Information Technology","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/A5077727233","display_name":"Partha Ghosh","orcid":"https://orcid.org/0000-0003-2843-2668"},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Partha Ghosh","raw_affiliation_strings":["Kingston School of Management & Science, India"],"affiliations":[{"raw_affiliation_string":"Kingston School of Management & Science, India","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5110227863","display_name":"Takaaki Goto","orcid":"https://orcid.org/0009-0000-1450-235X"},"institutions":[{"id":"https://openalex.org/I158123994","display_name":"Toyo University","ror":"https://ror.org/059d6yn51","country_code":"JP","type":"education","lineage":["https://openalex.org/I158123994"]}],"countries":["JP"],"is_corresponding":false,"raw_author_name":"Takaaki Goto","raw_affiliation_strings":["Toyo University\u00a0, Japan"],"affiliations":[{"raw_affiliation_string":"Toyo University\u00a0, Japan","institution_ids":["https://openalex.org/I158123994"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5070896564","display_name":"Jyotsna Kumar Mandal","orcid":"https://orcid.org/0000-0001-9447-647X"},"institutions":[{"id":"https://openalex.org/I77501641","display_name":"University of Kalyani","ror":"https://ror.org/03v783k16","country_code":"IN","type":"education","lineage":["https://openalex.org/I77501641"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Jyotsna Kumar Mandal","raw_affiliation_strings":["University of Kalyani, India"],"affiliations":[{"raw_affiliation_string":"University of Kalyani, India","institution_ids":["https://openalex.org/I77501641"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5080702284","display_name":"Soumya Sen","orcid":"https://orcid.org/0000-0002-9178-6410"},"institutions":[{"id":"https://openalex.org/I106542073","display_name":"University of Calcutta","ror":"https://ror.org/01e7v7w47","country_code":"IN","type":"education","lineage":["https://openalex.org/I106542073"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Soumya Sen","raw_affiliation_strings":["University of Calcutta, India"],"affiliations":[{"raw_affiliation_string":"University of Calcutta, India","institution_ids":["https://openalex.org/I106542073"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5077727233"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.3047,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.55456389,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":95},"biblio":{"volume":null,"issue":null,"first_page":"27","last_page":"31"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9997000098228455,"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.9997000098228455,"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.9984999895095825,"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.998199999332428,"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/cuboid","display_name":"Cuboid","score":0.9176527857780457},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.8922491669654846},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.776236891746521},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6886947751045227},{"id":"https://openalex.org/keywords/data-cube","display_name":"Data cube","score":0.6330793499946594},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.5966950058937073},{"id":"https://openalex.org/keywords/dimensional-modeling","display_name":"Dimensional modeling","score":0.5246120691299438},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5063081979751587},{"id":"https://openalex.org/keywords/lattice","display_name":"Lattice (music)","score":0.49651747941970825},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4804055988788605},{"id":"https://openalex.org/keywords/dimension","display_name":"Dimension (graph theory)","score":0.44875770807266235},{"id":"https://openalex.org/keywords/cube","display_name":"Cube (algebra)","score":0.4446754455566406},{"id":"https://openalex.org/keywords/architecture","display_name":"Architecture","score":0.44188374280929565},{"id":"https://openalex.org/keywords/data-structure","display_name":"Data structure","score":0.4348057806491852},{"id":"https://openalex.org/keywords/warehouse","display_name":"Warehouse","score":0.42995309829711914},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.16904816031455994},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.15109285712242126},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.11349201202392578},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.1127825379371643},{"id":"https://openalex.org/keywords/geometry","display_name":"Geometry","score":0.08278265595436096}],"concepts":[{"id":"https://openalex.org/C203527163","wikidata":"https://www.wikidata.org/wiki/Q262959","display_name":"Cuboid","level":2,"score":0.9176527857780457},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8922491669654846},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.776236891746521},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6886947751045227},{"id":"https://openalex.org/C78168278","wikidata":"https://www.wikidata.org/wiki/Q5227269","display_name":"Data cube","level":2,"score":0.6330793499946594},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.5966950058937073},{"id":"https://openalex.org/C143008350","wikidata":"https://www.wikidata.org/wiki/Q3432172","display_name":"Dimensional modeling","level":2,"score":0.5246120691299438},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5063081979751587},{"id":"https://openalex.org/C2781204021","wikidata":"https://www.wikidata.org/wiki/Q6497091","display_name":"Lattice (music)","level":2,"score":0.49651747941970825},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4804055988788605},{"id":"https://openalex.org/C33676613","wikidata":"https://www.wikidata.org/wiki/Q13415176","display_name":"Dimension (graph theory)","level":2,"score":0.44875770807266235},{"id":"https://openalex.org/C53051483","wikidata":"https://www.wikidata.org/wiki/Q861555","display_name":"Cube (algebra)","level":2,"score":0.4446754455566406},{"id":"https://openalex.org/C123657996","wikidata":"https://www.wikidata.org/wiki/Q12271","display_name":"Architecture","level":2,"score":0.44188374280929565},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.4348057806491852},{"id":"https://openalex.org/C50416739","wikidata":"https://www.wikidata.org/wiki/Q181623","display_name":"Warehouse","level":2,"score":0.42995309829711914},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.16904816031455994},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.15109285712242126},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.11349201202392578},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.1127825379371643},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.08278265595436096},{"id":"https://openalex.org/C202444582","wikidata":"https://www.wikidata.org/wiki/Q837863","display_name":"Pure mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C162853370","wikidata":"https://www.wikidata.org/wiki/Q39809","display_name":"Marketing","level":1,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C142362112","wikidata":"https://www.wikidata.org/wiki/Q735","display_name":"Art","level":0,"score":0.0},{"id":"https://openalex.org/C24890656","wikidata":"https://www.wikidata.org/wiki/Q82811","display_name":"Acoustics","level":1,"score":0.0},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.0},{"id":"https://openalex.org/C153349607","wikidata":"https://www.wikidata.org/wiki/Q36649","display_name":"Visual arts","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3468081.3471064","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3468081.3471064","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the the 8th International Virtual Conference on Applied Computing & Information Technology","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":15,"referenced_works":["https://openalex.org/W1977747497","https://openalex.org/W2085440169","https://openalex.org/W2180277224","https://openalex.org/W2320814027","https://openalex.org/W2799270018","https://openalex.org/W2849741571","https://openalex.org/W2889026268","https://openalex.org/W2963983258","https://openalex.org/W2965706512","https://openalex.org/W2980855655","https://openalex.org/W3000264510","https://openalex.org/W3080833062","https://openalex.org/W3113323589","https://openalex.org/W3118935356","https://openalex.org/W4234591895"],"related_works":["https://openalex.org/W1988774479","https://openalex.org/W2123931473","https://openalex.org/W1799555191","https://openalex.org/W2381646725","https://openalex.org/W2160457037","https://openalex.org/W2026863370","https://openalex.org/W1503756376","https://openalex.org/W1535822977","https://openalex.org/W6138692","https://openalex.org/W1518802638"],"abstract_inverted_index":{"Data":[0],"warehouse":[1,56,132],"is":[2,11,51,76,101,110],"used":[3],"across":[4],"the":[5,14,23,37,54,72,79,84,93,105,113,120,141,153],"organizations":[6],"for":[7,20,115,134],"analytical":[8],"processing.":[9,107],"It":[10],"organized":[12],"in":[13,53,63,74,97,119,152],"form":[15],"of":[16,18,26,30,32,39,46,78,87,89],"lattice":[17,31,88],"cuboids":[19,33,90],"carrying":[21],"out":[22],"different":[24],"types":[25],"analysis.":[27],"The":[28,48],"structure":[29,86],"grows":[34],"exponentially":[35],"with":[36,83,92],"number":[38],"dimensions.":[40],"Every":[41],"cuboid":[42,99],"contains":[43],"huge":[44],"amount":[45],"data.":[47],"data":[49,55,73,96,146],"size":[50],"multiplied":[52],"as":[57],"a":[58,126],"new":[59],"entry":[60],"takes":[61],"place":[62],"any":[64],"dimension.":[65],"In":[66],"modern":[67],"day":[68],"business":[69],"analysis,":[70],"processing":[71,118],"real-time":[75,106],"one":[77],"intrinsic":[80],"requirements.":[81],"However,":[82],"gigantic":[85],"along":[91],"highly":[94],"loaded":[95],"every":[98],"it":[100],"difficult":[102],"to":[103],"achieve":[104],"View":[108],"materialization":[109],"practiced":[111],"over":[112],"decades":[114],"faster":[116,145],"query":[117],"database":[121],"applications.":[122],"This":[123],"research":[124],"proposed":[125,142],"fuzzy":[127],"based":[128],"materialized":[129,154],"data-cube":[130],"driven":[131],"architecture":[133],"fast":[135],"decision":[136],"making.":[137],"Experimental":[138],"output":[139],"shows":[140],"methodology":[143],"achieves":[144],"analysis":[147],"and":[148],"better":[149],"hit-miss":[150],"ratio":[151],"data-cubes.":[155]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2022,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}