{"_id":"mkELqaydn7Zt22h9E","bibbaseid":"broneske-bre-saake-databasescanvariantsonmoderncpusaperformancestudy-2015","authorIDs":[],"author_short":["Broneske, D.","Breß, S.","Saake, G."],"bibdata":{"bibtype":"incollection","type":"incollection","abstract":"Main-memory databases rely on highly tuned database operations to achieve peak performance. Recently, it has been shown that different code optimizations for database operations favor different processors. However, it is still not clear how the combination of code optimizations (e.g., loop unrolling and vectorization) will affect the performance of database algorithms on different processors. In this paper, we extend prior studies by an in-depth performance analysis of different variants of the scan operator. We find that the performance of the scan operator for different processors gets even harder to predict when multiple code optimizations are combined. Since the scan is the most simple database operator, we expect the same effects for more complex operators such as joins. Based on these results, we identify practical problems for a query processor and discuss how we can counter these challenges in future work.","added-at":"2015-04-10T18:02:47.000+0200","author":[{"propositions":[],"lastnames":["Broneske"],"firstnames":["David"],"suffixes":[]},{"propositions":[],"lastnames":["Breß"],"firstnames":["Sebastian"],"suffixes":[]},{"propositions":[],"lastnames":["Saake"],"firstnames":["Gunter"],"suffixes":[]}],"biburl":"https://www.bibsonomy.org/bibtex/253b22759ffc8fde8b7d7825ef282e6c4/christophv","booktitle":"In Memory Data Management and Analysis","interhash":"631224ee49d4e191aca73454a247b03a","intrahash":"53b22759ffc8fde8b7d7825ef282e6c4","keywords":"Predication CPU Loop_unrolling Scan Expose Branching Vectorization","pages":"97–111","publisher":"Springer International Publishing","series":"Lecture Notes in Computer Science","timestamp":"2016-01-04T14:22:08.000+0100","title":"Database Scan Variants on Modern CPUs: A Performance Study","year":"2015","bibtex":"@incollection{Broneske2015-xy,\n abstract = {Main-memory databases rely on highly tuned database operations\n to achieve peak performance. Recently, it has been shown that\n different code optimizations for database operations favor\n different processors. However, it is still not clear how the\n combination of code optimizations (e.g., loop unrolling and\n vectorization) will affect the performance of database\n algorithms on different processors. In this paper, we extend\n prior studies by an in-depth performance analysis of different\n variants of the scan operator. We find that the performance of\n the scan operator for different processors gets even harder to\n predict when multiple code optimizations are combined. Since the\n scan is the most simple database operator, we expect the same\n effects for more complex operators such as joins. Based on these\n results, we identify practical problems for a query processor\n and discuss how we can counter these challenges in future work.},\n added-at = {2015-04-10T18:02:47.000+0200},\n author = {Broneske, David and Bre\\ss{}, Sebastian and Saake, Gunter},\n biburl = {https://www.bibsonomy.org/bibtex/253b22759ffc8fde8b7d7825ef282e6c4/christophv},\n booktitle = {In Memory Data Management and Analysis},\n interhash = {631224ee49d4e191aca73454a247b03a},\n intrahash = {53b22759ffc8fde8b7d7825ef282e6c4},\n keywords = {Predication CPU Loop_unrolling Scan Expose Branching Vectorization},\n pages = {97--111},\n publisher = {Springer International Publishing},\n series = {Lecture Notes in Computer Science},\n timestamp = {2016-01-04T14:22:08.000+0100},\n title = {Database Scan Variants on Modern {CPUs}: A Performance Study},\n year = 2015\n}\n\n","author_short":["Broneske, D.","Breß, S.","Saake, G."],"key":"Broneske2015-xy","id":"Broneske2015-xy","bibbaseid":"broneske-bre-saake-databasescanvariantsonmoderncpusaperformancestudy-2015","role":"author","urls":{},"keyword":["Predication CPU Loop_unrolling Scan Expose Branching Vectorization"],"downloads":0},"bibtype":"incollection","biburl":"http://www.bibsonomy.org/bib/author/broneske?items=1000","creationDate":"2019-08-28T10:39:22.177Z","downloads":0,"keywords":["predication cpu loop_unrolling scan expose branching vectorization"],"search_terms":["database","scan","variants","modern","cpus","performance","study","broneske","breß","saake"],"title":"Database Scan Variants on Modern CPUs: A Performance Study","year":2015,"dataSources":["EagnwML9y7FbaR4Ty"]}