{"id":"https://openalex.org/W2806359774","doi":"https://doi.org/10.7916/d8q25g8h","title":"Analytical Query Execution Optimized for all Layers of Modern Hardware","display_name":"Analytical Query Execution Optimized for all Layers of Modern Hardware","publication_year":2018,"publication_date":"2018-01-01","ids":{"openalex":"https://openalex.org/W2806359774","doi":"https://doi.org/10.7916/d8q25g8h","mag":"2806359774"},"language":"en","primary_location":{"id":"pmh:oai:academiccommons.columbia.edu:10.7916/D8Q25G8H","is_oa":false,"landing_page_url":"https://doi.org/10.7916/D8Q25G8H","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":"Theses"},"type":"article","indexed_in":["datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://doi.org/10.7916/d8q25g8h","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5077806101","display_name":"Orestis Polychroniou","orcid":"https://orcid.org/0000-0002-3164-0137"},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Polychroniou, Orestis","raw_affiliation_strings":[],"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5077806101"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.06522283,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13983","display_name":"Cybersecurity and Information Systems","score":0.8913999795913696,"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/T13983","display_name":"Cybersecurity and Information Systems","score":0.8913999795913696,"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/T10904","display_name":"Embedded Systems Design Techniques","score":0.852400004863739,"subfield":{"id":"https://openalex.org/subfields/1708","display_name":"Hardware and Architecture"},"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/T14470","display_name":"Advanced Data Processing Techniques","score":0.8482000231742859,"subfield":{"id":"https://openalex.org/subfields/2207","display_name":"Control and Systems Engineering"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"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.6715662479400635},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.3243628740310669},{"id":"https://openalex.org/keywords/computer-hardware","display_name":"Computer hardware","score":0.32172340154647827}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6715662479400635},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.3243628740310669},{"id":"https://openalex.org/C9390403","wikidata":"https://www.wikidata.org/wiki/Q3966","display_name":"Computer hardware","level":1,"score":0.32172340154647827}],"mesh":[],"locations_count":3,"locations":[{"id":"pmh:oai:academiccommons.columbia.edu:10.7916/D8Q25G8H","is_oa":false,"landing_page_url":"https://doi.org/10.7916/D8Q25G8H","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":"Theses"},{"id":"mag:2806359774","is_oa":false,"landing_page_url":"https://academiccommons.columbia.edu/doi/10.7916/D8Q25G8H","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":null},{"id":"doi:10.7916/d8q25g8h","is_oa":true,"landing_page_url":"https://doi.org/10.7916/d8q25g8h","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/d8q25g8h","is_oa":true,"landing_page_url":"https://doi.org/10.7916/d8q25g8h","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":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W3093670264","https://openalex.org/W2318937435","https://openalex.org/W2638720987","https://openalex.org/W1553111368","https://openalex.org/W2030804818","https://openalex.org/W2462587875","https://openalex.org/W2893682266","https://openalex.org/W2055659711","https://openalex.org/W70437322","https://openalex.org/W2046785791","https://openalex.org/W1503940619","https://openalex.org/W1563873991","https://openalex.org/W2260410408","https://openalex.org/W1520610152","https://openalex.org/W2945727922","https://openalex.org/W2059570954","https://openalex.org/W2489715164","https://openalex.org/W2582188941","https://openalex.org/W3028142200","https://openalex.org/W1844918618"],"abstract_inverted_index":{"Analytical":[0],"database":[1,39,96],"queries":[2,49],"are":[3],"at":[4],"the":[5,15,57,66,89,113,121,127,137,144,155,159,168,171,175,180,201,242,248],"core":[6,202],"of":[7,18,28,77,81,93,106,130,170,184,244,250],"business":[8],"intelligence":[9],"and":[10,41,55,91,120,136,174,192,218,224,228,255],"decision":[11],"support.":[12],"To":[13,178,196],"analyze":[14],"vast":[16],"amounts":[17],"data":[19],"available":[20],"today,":[21],"query":[22,71,101,198,235,276],"execution":[23,102,138,199],"needs":[24],"to":[25,50,62,69,167],"be":[26,75],"orders":[27],"magnitude":[29],"faster.":[30],"Hardware":[31],"advances":[32],"have":[33],"made":[34],"a":[35,149,233,266],"profound":[36],"impact":[37],"on":[38,88,220,225],"design":[40,90,237],"implementation.":[42],"The":[43,109],"large":[44],"main":[45,118],"memory":[46,54,63,119,160,181],"capacity":[47],"allows":[48],"execute":[51],"exclusively":[52],"in":[53,232,259],"shifts":[56],"bottleneck":[58],"from":[59],"disk":[60],"access":[61,182],"bandwidth.":[64],"In":[65,247],"new":[67,234],"setting,":[68],"optimize":[70,188],"performance,":[72],"databases":[73,271],"must":[74],"aware":[76,166],"an":[78],"unprecedented":[79],"multitude":[80],"complicated":[82],"hardware":[83,110,223,251],"features.":[84],"This":[85],"thesis":[86,262],"focuses":[87],"implementation":[92],"highly":[94],"efficient":[95],"systems":[97],"by":[98],"optimizing":[99],"analytical":[100,275],"for":[103,268],"all":[104],"layers":[105,111],"modern":[107],"hardware.":[108],"include":[112],"network":[114,145,156],"across":[115,124,132,211],"multiple":[116,125,128,133,212],"machines,":[117],"NUMA":[122,176],"interconnection":[123],"processors,":[126],"levels":[129],"caches":[131,173],"processor":[134],"cores,":[135],"pipeline":[139],"within":[140,200],"each":[141],"core.":[142],"For":[143,158],"layer,":[146],"we":[147,162,187,204],"introduce":[148,205],"distributed":[150],"join":[151],"algorithm":[152],"that":[153,238],"minimizes":[154],"traffic.":[157],"hierarchy,":[161],"describe":[163],"partitioning":[164],"variants":[165,191],"dynamics":[169],"CPU":[172],"interconnection.":[177],"improve":[179],"rate":[183],"linear":[185],"scans,":[186],"lightweight":[189],"compression":[190],"evaluate":[193,215],"their":[194],"trade-offs.":[195],"accelerate":[197],"pipeline,":[203],"advanced":[206],"SIMD":[207],"vectorization":[208],"techniques":[209,219,231],"generalizable":[210],"operators.":[213],"We":[214],"our":[216,230],"algorithms":[217],"both":[221],"mainstream":[222],"many-integrated-core":[226],"platforms,":[227],"combine":[229],"engine":[236],"can":[239,263],"better":[240],"utilize":[241],"features":[243],"many-core":[245],"CPUs.":[246],"era":[249],"becoming":[252],"increasingly":[253],"parallel":[254],"datasets":[256],"consistently":[257],"growing":[258],"size,":[260],"this":[261],"serve":[264],"as":[265],"compass":[267],"developing":[269],"hardware-conscious":[270],"with":[272],"truly":[273],"high-performance":[274],"execution.":[277]},"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":2}],"updated_date":"2025-11-06T06:51:31.235846","created_date":"2025-10-10T00:00:00"}