{"id":"https://openalex.org/W2069321657","doi":"https://doi.org/10.4018/jdwm.2007010101","title":"Statistical Sampling to Instantiate Materialized View Selection Problems in Data Warehouses","display_name":"Statistical Sampling to Instantiate Materialized View Selection Problems in Data Warehouses","publication_year":2007,"publication_date":"2007-01-01","ids":{"openalex":"https://openalex.org/W2069321657","doi":"https://doi.org/10.4018/jdwm.2007010101","mag":"2069321657"},"language":"en","primary_location":{"id":"doi:10.4018/jdwm.2007010101","is_oa":false,"landing_page_url":"https://doi.org/10.4018/jdwm.2007010101","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/A5103408565","display_name":"Mesbah Uddin Ahmed","orcid":null},"institutions":[{"id":"https://openalex.org/I90871651","display_name":"University of Toledo","ror":"https://ror.org/01pbdzh19","country_code":"US","type":"education","lineage":["https://openalex.org/I90871651"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Mesbah U. Ahmed","raw_affiliation_strings":["University of Toledo, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Toledo, USA","institution_ids":["https://openalex.org/I90871651"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102798429","display_name":"Vikas Agrawal","orcid":"https://orcid.org/0000-0003-1184-7330"},"institutions":[{"id":"https://openalex.org/I184654094","display_name":"Fayetteville State University","ror":"https://ror.org/03rj92e31","country_code":"US","type":"education","lineage":["https://openalex.org/I184654094"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Vikas Agrawal","raw_affiliation_strings":["Fayetteville State University, USA","[Fayetteville State University, USA]"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Fayetteville State University, USA","institution_ids":["https://openalex.org/I184654094"]},{"raw_affiliation_string":"[Fayetteville State University, USA]","institution_ids":["https://openalex.org/I184654094"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5005532023","display_name":"Udayan Nandkeolyar","orcid":null},"institutions":[{"id":"https://openalex.org/I90871651","display_name":"University of Toledo","ror":"https://ror.org/01pbdzh19","country_code":"US","type":"education","lineage":["https://openalex.org/I90871651"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Udayan Nandkeolyar","raw_affiliation_strings":["University of Toledo, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Toledo, USA","institution_ids":["https://openalex.org/I90871651"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5003560469","display_name":"P. S. Sundararaghavan","orcid":null},"institutions":[{"id":"https://openalex.org/I90871651","display_name":"University of Toledo","ror":"https://ror.org/01pbdzh19","country_code":"US","type":"education","lineage":["https://openalex.org/I90871651"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"P. S. Sundararaghavan","raw_affiliation_strings":["University of Toledo, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Toledo, USA","institution_ids":["https://openalex.org/I90871651"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":8,"citation_normalized_percentile":{"value":0.16159427,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":"3","issue":"1","first_page":"1","last_page":"28"},"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.9927999973297119,"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.9927999973297119,"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.9925000071525574,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9872999787330627,"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.8972058296203613},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8735643625259399},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.7944053411483765},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5416209697723389},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.532817542552948},{"id":"https://openalex.org/keywords/sampling","display_name":"Sampling (signal processing)","score":0.5078981518745422},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.5046402215957642},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.47859784960746765},{"id":"https://openalex.org/keywords/decision-support-system","display_name":"Decision support system","score":0.4671670198440552},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.42565327882766724},{"id":"https://openalex.org/keywords/order","display_name":"Order (exchange)","score":0.41753077507019043},{"id":"https://openalex.org/keywords/operations-research","display_name":"Operations research","score":0.3396034240722656},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.1667921245098114},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.1547250747680664},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.10913404822349548}],"concepts":[{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.8972058296203613},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8735643625259399},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.7944053411483765},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5416209697723389},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.532817542552948},{"id":"https://openalex.org/C140779682","wikidata":"https://www.wikidata.org/wiki/Q210868","display_name":"Sampling (signal processing)","level":3,"score":0.5078981518745422},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.5046402215957642},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.47859784960746765},{"id":"https://openalex.org/C107327155","wikidata":"https://www.wikidata.org/wiki/Q330268","display_name":"Decision support system","level":2,"score":0.4671670198440552},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.42565327882766724},{"id":"https://openalex.org/C182306322","wikidata":"https://www.wikidata.org/wiki/Q1779371","display_name":"Order (exchange)","level":2,"score":0.41753077507019043},{"id":"https://openalex.org/C42475967","wikidata":"https://www.wikidata.org/wiki/Q194292","display_name":"Operations research","level":1,"score":0.3396034240722656},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.1667921245098114},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.1547250747680664},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.10913404822349548},{"id":"https://openalex.org/C31972630","wikidata":"https://www.wikidata.org/wiki/Q844240","display_name":"Computer vision","level":1,"score":0.0},{"id":"https://openalex.org/C10138342","wikidata":"https://www.wikidata.org/wiki/Q43015","display_name":"Finance","level":1,"score":0.0},{"id":"https://openalex.org/C106131492","wikidata":"https://www.wikidata.org/wiki/Q3072260","display_name":"Filter (signal processing)","level":2,"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/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.4018/jdwm.2007010101","is_oa":false,"landing_page_url":"https://doi.org/10.4018/jdwm.2007010101","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:digitalcommons.uncfsu.edu:college_business_economics-1320","is_oa":false,"landing_page_url":"https://digitalcommons.uncfsu.edu/college_business_economics/321","pdf_url":null,"source":{"id":"https://openalex.org/S4306400276","display_name":"DigitalCommons@Fayetteville State University (Fayetteville State University)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I184654094","host_organization_name":"Fayetteville State University","host_organization_lineage":["https://openalex.org/I184654094"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"College of Business and Economics","raw_type":"text"},{"id":"pmh:oai:RePEc:igg:jdwm00:v:3:y:2007:i:1:p:1-28","is_oa":false,"landing_page_url":"https://services.igi-global.com/resolvedoi/resolve.aspx?doi=10.4018/jdwm.2007010101","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":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"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":{"In":[0,12,110,128,167],"any":[1],"online":[2,112],"decision":[3,21,113],"support":[4,22,114],"system,":[5],"the":[6,35,38,45,48,56,91,95,107,119,144,159,164,173],"backbone":[7],"is":[8,25,117],"a":[9,26,67,73,134],"data":[10,39,93],"warehouse.":[11,40],"order":[13,64],"to":[14,18,29,54,61,65,125,137,163],"facilitate":[15],"rapid":[16,100],"response":[17],"complex":[19],"business":[20],"queries,":[23],"it":[24,42],"common":[27],"practice":[28],"materialize":[30,62],"an":[31,111],"appropriate":[32],"set":[33,58],"of":[34,47,59,70,76,106,118,143],"views":[36,60],"at":[37],"However,":[41],"typically":[43],"requires":[44],"solution":[46,105],"Materialized":[49],"View":[50],"Selection":[51],"(MVS)":[52],"problem":[53,146],"select":[55],"right":[57],"in":[63,90,121,177,180],"achieve":[66],"certain":[68],"level":[69],"service":[71],"given":[72],"limited":[74],"amount":[75],"resource":[77],"such":[78],"as":[79],"materialization":[80],"time,":[81],"storage":[82],"space,":[83],"or":[84],"view":[85],"maintenance":[86],"time.":[87],"Dynamic":[88],"changes":[89],"source":[92],"and":[94,101,104,139,151],"end":[96],"users":[97],"requirement":[98],"necessitate":[99],"repetitive":[102],"instantiation":[103],"MVS":[108,145],"problem.":[109,127],"context,":[115],"time":[116,181],"essence":[120],"finding":[122],"acceptable":[123],"solutions":[124,157,161],"this":[126,129],"chapter,":[130],"we":[131,170],"have":[132],"used":[133],"novel":[135],"approach":[136,175],"instantiate":[138],"solve":[140],"four":[141],"versions":[142],"using":[147],"three":[148],"sampling":[149,174],"techniques":[150],"two":[152],"databases.":[153],"We":[154],"compared":[155],"these":[156],"with":[158],"optimal":[160],"corresponding":[162],"actual":[165],"problems.":[166],"our":[168],"experimentation,":[169],"found":[171],"that":[172],"resulted":[176],"substantial":[178],"savings":[179],"while":[182],"producing":[183],"good":[184],"solutions.":[185]},"counts_by_year":[{"year":2016,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":2},{"year":2012,"cited_by_count":3}],"updated_date":"2026-08-11T07:18:39.950985","created_date":"2025-10-10T00:00:00"}