{"id":"https://openalex.org/W3156363426","doi":"https://doi.org/10.4018/ijdwm.2021040105","title":"An Approach for Retrieving Faster Query Results From Data Warehouse Using Synonymous Materialized Queries","display_name":"An Approach for Retrieving Faster Query Results From Data Warehouse Using Synonymous Materialized Queries","publication_year":2021,"publication_date":"2021-04-01","ids":{"openalex":"https://openalex.org/W3156363426","doi":"https://doi.org/10.4018/ijdwm.2021040105","mag":"3156363426"},"language":"en","primary_location":{"id":"doi:10.4018/ijdwm.2021040105","is_oa":false,"landing_page_url":"https://doi.org/10.4018/ijdwm.2021040105","pdf_url":null,"source":{"id":"https://openalex.org/S53932126","display_name":"International Journal of Data Warehousing and Mining","issn_l":"1548-3924","issn":["1548-3924","1548-3932"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Data Warehousing and Mining","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/A5084725608","display_name":"Sonali Chakraborty","orcid":"https://orcid.org/0000-0003-4744-1949"},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Sonali Ashish Chakraborty","raw_affiliation_strings":["Gujarat Law Society University, India"],"affiliations":[{"raw_affiliation_string":"Gujarat Law Society University, India","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5060120863","display_name":"Jyotika Doshi","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jyotika Doshi","raw_affiliation_strings":["Gujarat Law Society University, India"],"affiliations":[{"raw_affiliation_string":"Gujarat Law Society University, India","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5084725608"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.1528,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.4747096,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"17","issue":"2","first_page":"85","last_page":"105"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9995999932289124,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9995999932289124,"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/T11106","display_name":"Data Management and Algorithms","score":0.9980999827384949,"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/T11719","display_name":"Data Quality and Management","score":0.9965000152587891,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.880260705947876},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.8770368099212646},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.8626947402954102},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.7875112891197205},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.7367678880691528},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.6775779724121094},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.6631350517272949},{"id":"https://openalex.org/keywords/query-expansion","display_name":"Query expansion","score":0.6252926588058472},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6160330176353455},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.5523126125335693},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.5293546319007874},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.5263577699661255},{"id":"https://openalex.org/keywords/web-query-classification","display_name":"Web query classification","score":0.5212641358375549},{"id":"https://openalex.org/keywords/metadata","display_name":"Metadata","score":0.4881065785884857},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.4230266511440277},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3971650302410126},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.24828580021858215},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.12339046597480774},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.08958110213279724}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.880260705947876},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.8770368099212646},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.8626947402954102},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.7875112891197205},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.7367678880691528},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.6775779724121094},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.6631350517272949},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.6252926588058472},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6160330176353455},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.5523126125335693},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.5293546319007874},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.5263577699661255},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.5212641358375549},{"id":"https://openalex.org/C93518851","wikidata":"https://www.wikidata.org/wiki/Q180160","display_name":"Metadata","level":2,"score":0.4881065785884857},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.4230266511440277},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3971650302410126},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.24828580021858215},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.12339046597480774},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.08958110213279724}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.4018/ijdwm.2021040105","is_oa":false,"landing_page_url":"https://doi.org/10.4018/ijdwm.2021040105","pdf_url":null,"source":{"id":"https://openalex.org/S53932126","display_name":"International Journal of Data Warehousing and Mining","issn_l":"1548-3924","issn":["1548-3924","1548-3932"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"International Journal of Data Warehousing and Mining","raw_type":"journal-article"},{"id":"pmh:oai:RePEc:igg:jdwm00:v:17:y:2021:i:2:p:85-105","is_oa":false,"landing_page_url":"https://services.igi-global.com/resolvedoi/resolve.aspx?doi=10.4018/IJDWM.2021040105","pdf_url":null,"source":{"id":"https://openalex.org/S4306401271","display_name":"RePEc: Research Papers in Economics","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I77793887","host_organization_name":"Federal Reserve Bank of St. Louis","host_organization_lineage":["https://openalex.org/I77793887"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/16","score":0.6399999856948853,"display_name":"Peace, Justice and strong institutions"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":5,"referenced_works":["https://openalex.org/W1964296520","https://openalex.org/W1975337935","https://openalex.org/W2039396857","https://openalex.org/W2072764742","https://openalex.org/W2907439311"],"related_works":["https://openalex.org/W1988774479","https://openalex.org/W2123931473","https://openalex.org/W1799555191","https://openalex.org/W3012397820","https://openalex.org/W175663584","https://openalex.org/W2554271401","https://openalex.org/W2150741898","https://openalex.org/W2186703450","https://openalex.org/W2970853428","https://openalex.org/W2955368753"],"abstract_inverted_index":{"The":[0,21,45,71,96,121,147,240,277],"enterprise":[1],"data":[2,9,54,58,86,238,292],"warehouse":[3,55,87],"stores":[4],"an":[5,42,223],"enormous":[6],"amount":[7],"of":[8,37,99,164,226,231,242],"collected":[10],"from":[11,52,85,212,237],"multiple":[12],"sources":[13],"for":[14,49,112,195,283],"analytical":[15,22,28],"processing":[16,23,29,230,266],"and":[17,60,68,79,92,132,153,167,179,198,254],"strategic":[18],"decision":[19],"making.":[20],"is":[24,41,102,117,140,193,235,245,256,268],"done":[25],"using":[26,259],"online":[27],"(OLAP)":[30],"queries":[31,101,124],"where":[32],"the":[33,105,115,129,157,176,180,190,206,215,219,229,250,273,284,291],"performance":[34,241],"in":[35,104,136,156,264,290],"terms":[36],"result":[38,82,234],"retrieval":[39,83],"time":[40,98,267],"important":[43],"factor.":[44],"major":[46,274],"existing":[47,207,275],"approaches":[48],"retrieving":[50],"results":[51,111,131,209],"a":[53,77,137,186,261],"are":[56,125,160,170,183,203,210],"multidimensional":[57],"cubes":[59],"materialized":[61,143],"views":[62],"that":[63],"incur":[64],"more":[65],"storage,":[66],"processing,":[67],"maintenance":[69,94],"costs.":[70],"present":[72,106],"study":[73],"strives":[74],"to":[75,172,272],"achieve":[76],"simpler":[78],"faster":[80],"query":[81,116,130,144,159,178,182,192,221,265],"approach":[84,107],"with":[88,128,162,249],"reduced":[89],"storage":[90],"space":[91],"minimal":[93],"cost.":[95],"execution":[97],"frequent":[100],"saved":[103],"by":[108,247],"storing":[109],"their":[110,287],"reuse":[113],"when":[114],"fired":[118],"next":[119],"time.":[120],"executed":[122],"OLAP":[123],"stored":[126,165,181,191,208,220],"along":[127],"necessary":[133],"metadata":[134],"information":[135],"relational":[138,151],"database":[139,145],"referred":[141],"as":[142,185,270],"(MQDB).":[146],"tables,":[148],"fields,":[149],"functions,":[150],"operators,":[152],"criteria":[154],"used":[155],"input":[158,177],"matched":[161],"those":[163],"query,":[166],"if":[168,199,218],"they":[169],"found":[171],"be":[173,281],"same,":[174],"then":[175,205,228],"considered":[184,236],"synonymous":[187],"query.":[188],"Further,":[189],"checked":[194],"incremental":[196,201,224,233],"updates,":[197],"no":[200],"updates":[202],"required,":[204],"fetched":[211],"MQDB.":[213],"On":[214],"other":[216],"hand,":[217],"requires":[222],"update":[225],"results,":[227],"only":[232],"marts.":[239],"MQDB":[243],"model":[244,279],"evaluated":[246],"comparing":[248],"developed":[251,278],"novel":[252],"approach,":[253],"it":[255],"observed":[257],"that,":[258],"MQDB,":[260],"significant":[262],"reduction":[263],"achieved":[269],"compared":[271],"approaches.":[276],"will":[280],"useful":[282],"organizations":[285],"keeping":[286],"historical":[288],"records":[289],"warehouse.":[293]},"counts_by_year":[{"year":2023,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}