{"id":"https://openalex.org/W2041668559","doi":"https://doi.org/10.1145/1457150.1457160","title":"DSM vs. NSM","display_name":"DSM vs. NSM","publication_year":2008,"publication_date":"2008-06-13","ids":{"openalex":"https://openalex.org/W2041668559","doi":"https://doi.org/10.1145/1457150.1457160","mag":"2041668559"},"language":"en","primary_location":{"is_oa":false,"landing_page_url":"https://doi.org/10.1145/1457150.1457160","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false},"type":"article","type_crossref":"proceedings-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/A5061001401","display_name":"Marcin \u017bukowski","orcid":"https://orcid.org/0009-0001-1366-6958"},"institutions":[{"id":"https://openalex.org/I1341640284","display_name":"Centrum Wiskunde & Informatica","ror":"https://ror.org/00x7ekv49","country_code":"NL","type":"facility","lineage":["https://openalex.org/I1341640284","https://openalex.org/I2800991832"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Marcin Zukowski","raw_affiliation_strings":["CWI, Amsterdam, The Netherlands"],"affiliations":[{"raw_affiliation_string":"CWI, Amsterdam, The Netherlands","institution_ids":["https://openalex.org/I1341640284"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5041092741","display_name":"Niels Nes","orcid":"https://orcid.org/0009-0000-5927-2551"},"institutions":[{"id":"https://openalex.org/I1341640284","display_name":"Centrum Wiskunde & Informatica","ror":"https://ror.org/00x7ekv49","country_code":"NL","type":"facility","lineage":["https://openalex.org/I1341640284","https://openalex.org/I2800991832"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Niels Nes","raw_affiliation_strings":["CWI, Amsterdam, The Netherlands"],"affiliations":[{"raw_affiliation_string":"CWI, Amsterdam, The Netherlands","institution_ids":["https://openalex.org/I1341640284"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5058712681","display_name":"Peter Boncz","orcid":"https://orcid.org/0000-0001-6256-0140"},"institutions":[{"id":"https://openalex.org/I1341640284","display_name":"Centrum Wiskunde & Informatica","ror":"https://ror.org/00x7ekv49","country_code":"NL","type":"facility","lineage":["https://openalex.org/I1341640284","https://openalex.org/I2800991832"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Peter Boncz","raw_affiliation_strings":["CWI, Amsterdam, The Netherlands"],"affiliations":[{"raw_affiliation_string":"CWI, Amsterdam, The Netherlands","institution_ids":["https://openalex.org/I1341640284"]}]}],"institution_assertions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":3.196,"has_fulltext":true,"fulltext_origin":"ngrams","cited_by_count":45,"citation_normalized_percentile":{"value":0.989745,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":93,"max":94},"biblio":{"volume":null,"issue":null,"first_page":"47","last_page":"54"},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Data Stream Management Systems and Techniques","score":0.9992,"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":"Data Stream Management Systems and Techniques","score":0.9992,"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/T11181","display_name":"Distributed Storage Systems and Network Coding","score":0.999,"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":"Trajectory Data Mining and Analysis","score":0.9984,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/column-oriented-database-systems","display_name":"Column-oriented Database Systems","score":0.572433},{"id":"https://openalex.org/keywords/main-memory-databases","display_name":"Main Memory Databases","score":0.513989},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query Optimization","score":0.510582},{"id":"https://openalex.org/keywords/stream-processing","display_name":"Stream Processing","score":0.509618},{"id":"https://openalex.org/keywords/data-stream-management","display_name":"Data Stream Management","score":0.50914},{"id":"https://openalex.org/keywords/on-the-fly","display_name":"On the fly","score":0.46639416}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8665955},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.78529876},{"id":"https://openalex.org/C43521106","wikidata":"https://www.wikidata.org/wiki/Q2165493","display_name":"Pipeline (software)","level":2,"score":0.6639056},{"id":"https://openalex.org/C2777210771","wikidata":"https://www.wikidata.org/wiki/Q4927124","display_name":"Block (permutation group theory)","level":2,"score":0.5700967},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.55081713},{"id":"https://openalex.org/C192209626","wikidata":"https://www.wikidata.org/wiki/Q190909","display_name":"Focus (optics)","level":2,"score":0.48923945},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.48009092},{"id":"https://openalex.org/C2781020372","wikidata":"https://www.wikidata.org/wiki/Q533093","display_name":"On the fly","level":2,"score":0.46639416},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.41138405},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.25465393},{"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},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"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},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C120665830","wikidata":"https://www.wikidata.org/wiki/Q14620","display_name":"Optics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"is_oa":false,"landing_page_url":"https://doi.org/10.1145/1457150.1457160","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false}],"best_oa_location":null,"sustainable_development_goals":[],"grants":[],"datasets":[],"versions":[],"referenced_works_count":20,"referenced_works":["https://openalex.org/W1570477871","https://openalex.org/W1874295121","https://openalex.org/W1993819379","https://openalex.org/W2005112390","https://openalex.org/W2097125969","https://openalex.org/W2099580433","https://openalex.org/W2123686039","https://openalex.org/W2124851765","https://openalex.org/W2130642985","https://openalex.org/W2132998471","https://openalex.org/W2133300302","https://openalex.org/W2138512691","https://openalex.org/W2140453381","https://openalex.org/W2144839430","https://openalex.org/W2147076738","https://openalex.org/W2157979971","https://openalex.org/W2161437384","https://openalex.org/W2166441508","https://openalex.org/W2171543585","https://openalex.org/W3138367763"],"related_works":["https://openalex.org/W4315705795","https://openalex.org/W4245395944","https://openalex.org/W2562731034","https://openalex.org/W2349562424","https://openalex.org/W2143551613","https://openalex.org/W2143345456","https://openalex.org/W2138823233","https://openalex.org/W2029210135","https://openalex.org/W1979740464","https://openalex.org/W1789991335"],"abstract_inverted_index":{"Comparisons":[0],"between":[1,84],"the":[2,18,32,40,53,56,74,81,94],"merits":[3],"of":[4,22,36,58],"row-wise":[5],"storage":[6,10,20],"(NSM)":[7],"and":[8,86,104,123],"columnar":[9],"(DSM)":[11],"are":[12],"typically":[13],"made":[14],"with":[15],"respect":[16],"to":[17],"persistent":[19],"layer":[21],"database":[23,112],"systems.":[24],"In":[25],"this":[26,78],"paper,":[27],"however,":[28],"we":[29,99],"focus":[30],"on":[31,93],"CPU":[33,75],"efficiency":[34],"tradeoffs":[35],"tuple":[37],"representations":[38],"inside":[39],"query":[41,59,95,106],"execution":[42,96],"engine,":[43],"while":[44],"tuples":[45,119],"flow":[46],"through":[47],"a":[48,66,90],"processing":[49,64],"pipeline.":[50],"We":[51],"analyze":[52],"performance":[54,82],"in":[55],"context":[57],"engines":[60],"using":[61,101],"so-called":[62],"\"block-oriented\"":[63],"--":[65],"recently":[67],"popularized":[68],"technique":[69],"that":[70,110],"can":[71,88,114],"strongly":[72],"improve":[73],"efficiency.":[76],"With":[77],"high":[79],"efficiency,":[80],"trade-offs":[83],"NSM":[85],"DSM":[87,121],"have":[89],"decisive":[91],"impact":[92],"performance,":[97],"as":[98],"demonstrate":[100],"both":[102],"microbenchmarks":[103],"TPC-H":[105],"1.":[107],"This":[108],"means":[109],"NSM-based":[111],"systems":[113],"sometimes":[115],"benefit":[116],"from":[117],"converting":[118],"into":[120],"on-the-fly,":[122],"vice":[124],"versa.":[125]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2041668559","counts_by_year":[{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":3},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":4},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":6}],"updated_date":"2024-10-04T23:11:18.634665","created_date":"2016-06-24"}
