{"id":"https://openalex.org/W2130598739","doi":"https://doi.org/10.1109/ideas.2003.1214908","title":"A multi-resolution block storage model for database design","display_name":"A multi-resolution block storage model for database design","publication_year":2003,"publication_date":"2003-10-31","ids":{"openalex":"https://openalex.org/W2130598739","doi":"https://doi.org/10.1109/ideas.2003.1214908","mag":"2130598739"},"language":"en","primary_location":{"id":"doi:10.1109/ideas.2003.1214908","is_oa":false,"landing_page_url":"https://doi.org/10.1109/ideas.2003.1214908","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Seventh International Database Engineering and Applications Symposium, 2003. Proceedings.","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://doi.org/10.7916/d8hd83j8","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5113621558","display_name":"Jingren Zhou","orcid":null},"institutions":[{"id":"https://openalex.org/I78577930","display_name":"Columbia University","ror":"https://ror.org/00hj8s172","country_code":"US","type":"education","lineage":["https://openalex.org/I78577930"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Jingren Zhou","raw_affiliation_strings":["Columbia University, USA","Columbia University-USA"],"affiliations":[{"raw_affiliation_string":"Columbia University, USA","institution_ids":["https://openalex.org/I78577930"]},{"raw_affiliation_string":"Columbia University-USA","institution_ids":["https://openalex.org/I78577930"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5021663937","display_name":"Kenneth A. Ross","orcid":"https://orcid.org/0000-0001-9397-6990"},"institutions":[{"id":"https://openalex.org/I78577930","display_name":"Columbia University","ror":"https://ror.org/00hj8s172","country_code":"US","type":"education","lineage":["https://openalex.org/I78577930"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"K.A. Ross","raw_affiliation_strings":["Columbia University, USA","Columbia University-USA"],"affiliations":[{"raw_affiliation_string":"Columbia University, USA","institution_ids":["https://openalex.org/I78577930"]},{"raw_affiliation_string":"Columbia University-USA","institution_ids":["https://openalex.org/I78577930"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5113621558"],"corresponding_institution_ids":["https://openalex.org/I78577930"],"apc_list":null,"apc_paid":null,"fwci":1.7361,"has_fulltext":false,"cited_by_count":28,"citation_normalized_percentile":{"value":0.88363668,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":97},"biblio":{"volume":"1","issue":null,"first_page":"22","last_page":"31"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9998000264167786,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9998000264167786,"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/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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9973000288009644,"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/computer-science","display_name":"Computer science","score":0.8114750385284424},{"id":"https://openalex.org/keywords/block","display_name":"Block (permutation group theory)","score":0.6897337436676025},{"id":"https://openalex.org/keywords/cache","display_name":"Cache","score":0.6786177754402161},{"id":"https://openalex.org/keywords/partition","display_name":"Partition (number theory)","score":0.6205533742904663},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.4972875416278839},{"id":"https://openalex.org/keywords/computer-data-storage","display_name":"Computer data storage","score":0.4429042637348175},{"id":"https://openalex.org/keywords/disk-buffer","display_name":"Disk buffer","score":0.4378981590270996},{"id":"https://openalex.org/keywords/block-size","display_name":"Block size","score":0.42449796199798584},{"id":"https://openalex.org/keywords/auxiliary-memory","display_name":"Auxiliary memory","score":0.4217432141304016},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.41940993070602417},{"id":"https://openalex.org/keywords/data-structure","display_name":"Data structure","score":0.4126623570919037},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.32981088757514954},{"id":"https://openalex.org/keywords/computer-hardware","display_name":"Computer hardware","score":0.20819905400276184},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.2064993679523468},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.19037115573883057}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8114750385284424},{"id":"https://openalex.org/C2777210771","wikidata":"https://www.wikidata.org/wiki/Q4927124","display_name":"Block (permutation group theory)","level":2,"score":0.6897337436676025},{"id":"https://openalex.org/C115537543","wikidata":"https://www.wikidata.org/wiki/Q165596","display_name":"Cache","level":2,"score":0.6786177754402161},{"id":"https://openalex.org/C42812","wikidata":"https://www.wikidata.org/wiki/Q1082910","display_name":"Partition (number theory)","level":2,"score":0.6205533742904663},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.4972875416278839},{"id":"https://openalex.org/C194739806","wikidata":"https://www.wikidata.org/wiki/Q66221","display_name":"Computer data storage","level":2,"score":0.4429042637348175},{"id":"https://openalex.org/C202623185","wikidata":"https://www.wikidata.org/wiki/Q375176","display_name":"Disk buffer","level":3,"score":0.4378981590270996},{"id":"https://openalex.org/C41431624","wikidata":"https://www.wikidata.org/wiki/Q1053357","display_name":"Block size","level":3,"score":0.42449796199798584},{"id":"https://openalex.org/C82687282","wikidata":"https://www.wikidata.org/wiki/Q66221","display_name":"Auxiliary memory","level":2,"score":0.4217432141304016},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.41940993070602417},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.4126623570919037},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.32981088757514954},{"id":"https://openalex.org/C9390403","wikidata":"https://www.wikidata.org/wiki/Q3966","display_name":"Computer hardware","level":1,"score":0.20819905400276184},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.2064993679523468},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.19037115573883057},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0}],"mesh":[],"locations_count":8,"locations":[{"id":"doi:10.1109/ideas.2003.1214908","is_oa":false,"landing_page_url":"https://doi.org/10.1109/ideas.2003.1214908","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Seventh International Database Engineering and Applications Symposium, 2003. Proceedings.","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.120.8186","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.120.8186","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.columbia.edu/~jrzhou/research/mbsm.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.132.2514","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.132.2514","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.columbia.edu/~jrzhou/research/zhou_ross_03_1.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.58.228","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.58.228","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.columbia.edu/~library/TR-repository/reports/reports-2003/cucs-007-03.ps.gz","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.73.6663","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.73.6663","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.columbia.edu/techreports/cucs-007-03.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.9.484","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.9.484","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.columbia.edu/~kar/pubsk/mbsmfinal.ps","raw_type":"text"},{"id":"pmh:oai:academiccommons.columbia.edu:10.7916/D8HD83J8","is_oa":false,"landing_page_url":"https://doi.org/10.7916/D8HD83J8","pdf_url":null,"source":{"id":"https://openalex.org/S4306402601","display_name":"Columbia Academic Commons (Columbia University)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I78577930","host_organization_name":"Columbia University","host_organization_lineage":["https://openalex.org/I78577930"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Reports"},{"id":"doi:10.7916/d8hd83j8","is_oa":true,"landing_page_url":"https://doi.org/10.7916/d8hd83j8","pdf_url":null,"source":{"id":"https://openalex.org/S4306402601","display_name":"Columbia Academic Commons (Columbia University)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I78577930","host_organization_name":"Columbia University","host_organization_lineage":["https://openalex.org/I78577930"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article-journal"}],"best_oa_location":{"id":"doi:10.7916/d8hd83j8","is_oa":true,"landing_page_url":"https://doi.org/10.7916/d8hd83j8","pdf_url":null,"source":{"id":"https://openalex.org/S4306402601","display_name":"Columbia Academic Commons (Columbia University)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I78577930","host_organization_name":"Columbia University","host_organization_lineage":["https://openalex.org/I78577930"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article-journal"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/16","score":0.5099999904632568,"display_name":"Peace, Justice and strong institutions"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":21,"referenced_works":["https://openalex.org/W1488422606","https://openalex.org/W1570477871","https://openalex.org/W1602137482","https://openalex.org/W1645807896","https://openalex.org/W2055468282","https://openalex.org/W2063601856","https://openalex.org/W2104680817","https://openalex.org/W2111967617","https://openalex.org/W2130598739","https://openalex.org/W2130642985","https://openalex.org/W2155651153","https://openalex.org/W2157979971","https://openalex.org/W2168395296","https://openalex.org/W2753710282","https://openalex.org/W3021418519","https://openalex.org/W4232718973","https://openalex.org/W6634065580","https://openalex.org/W6636014027","https://openalex.org/W6637090028","https://openalex.org/W6679222520","https://openalex.org/W6679817081"],"related_works":["https://openalex.org/W2072336782","https://openalex.org/W2041762692","https://openalex.org/W144222265","https://openalex.org/W2094057806","https://openalex.org/W2567477113","https://openalex.org/W2088116875","https://openalex.org/W1982298310","https://openalex.org/W2097224604","https://openalex.org/W2084587984","https://openalex.org/W102979902"],"abstract_inverted_index":{"We":[0,120,138,226],"propose":[1],"a":[2,42,47,54,60,68,107,126,135,200,211],"new":[3],"storage":[4,10,150,154],"model":[5],"called":[6],"MBSM":[7,18,142,207],"(multiresolution":[8],"block":[9],"model)":[11,155],"for":[12,161,229],"laying":[13],"out":[14],"tables":[15,132],"on":[16,100],"disks.":[17],"is":[19,58,205],"intended":[20],"to":[21,65,130,216,232,238,245],"speed":[22],"up":[23],"operations":[24],"such":[25,134,146],"as":[26,147],"scans":[27,168],"that":[28,59,63,81,141],"are":[29,37,117,174],"typical":[30],"of":[31,71,78,94,110,167,183,198],"data":[32],"warehouse":[33],"workloads.":[34],"Disk":[35],"blocks":[36,52,77,109,233],"grouped":[38],"into":[39,103],"\"super-blocks,\"":[40],"with":[41],"single":[43],"record":[44,201],"stored":[45,118],"in":[46,53,125,169,210,236],"partitioned":[48,213],"fashion":[49],"among":[50],"the":[51,83,91,101,111,122,181,191,196,247],"superblock.":[55],"The":[56],"intention":[57],"scan":[61],"operation":[62],"needs":[64],"consult":[66],"only":[67],"small":[69],"number":[70],"attributes":[72,159,173,209,231],"can":[73],"access":[74],"just":[75],"those":[76],"each":[79],"super-block":[80,248],"contain":[82],"desired":[84],"attributes.":[85],"To":[86],"achieve":[87],"good":[88,222],"performance":[89,178],"given":[90],"physical":[92],"characteristics":[93],"modern":[95],"disks,":[96],"we":[97,189],"organize":[98],"super-blocks":[99,235],"disk":[102,136],"fixed-size":[104],"\"mega-blocks.\"":[105],"Within":[106],"megablock,":[108],"same":[112],"type":[113],"(from":[114],"various":[115],"super-blocks)":[116],"contiguously.":[119],"describe":[121,227],"changes":[123],"needed":[124],"conventional":[127],"database":[128],"system":[129],"manage":[131],"using":[133],"organization.":[137],"demonstrate":[139],"experimentally":[140],"outperforms":[143],"competing":[144],"approaches":[145],"NSM":[148],"(N-ary":[149],"model),":[151],"DSM":[152],"(decomposition":[153],"and":[156,186,218,242,249],"PAX":[157],"(partition":[158],"across),":[160],"I/O":[162],"bound":[163],"decision-support":[164],"workloads":[165],"consisting":[166],"which":[170],"not":[171],"all":[172],"required.":[175],"This":[176],"improved":[177],"comes":[179],"at":[180],"expense":[182],"single-record":[184],"insert":[185],"delete":[187],"performance;":[188],"quantify":[190],"trade-offs":[192],"involved.":[193],"Unlike":[194],"DSM,":[195],"cost":[197],"reconstructing":[199],"from":[202],"its":[203],"partitions":[204],"small.":[206],"stores":[208],"vertically":[212],"manner":[214],"similar":[215],"PAX,":[217],"thus":[219],"shares":[220],"PAX's":[221],"CPU":[223],"cache":[224],"behavior.":[225],"methods":[228],"mapping":[230],"within":[234],"order":[237],"optimize":[239],"overall":[240],"performance,":[241],"show":[243],"how":[244],"tune":[246],"mega-block":[250],"sizes.":[251]},"counts_by_year":[{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":3},{"year":2013,"cited_by_count":3},{"year":2012,"cited_by_count":1}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}