000 04718nam a22005415i 4500
001 978-3-031-01858-9
003 DE-He213
005 20240730163734.0
007 cr nn 008mamaa
008 220601s2017 sz | s |||| 0|eng d
020 _a9783031018589
_9978-3-031-01858-9
024 7 _a10.1007/978-3-031-01858-9
_2doi
050 4 _aTK5105.5-5105.9
072 7 _aUKN
_2bicssc
072 7 _aCOM043000
_2bisacsh
072 7 _aUKN
_2thema
082 0 4 _a004.6
_223
100 1 _aAilamaki, Anastasia.
_eauthor.
_4aut
_4http://id.loc.gov/vocabulary/relators/aut
_980289
245 1 0 _aDatabases on Modern Hardware
_h[electronic resource] /
_cby Anastasia Ailamaki, Erietta Liarou, Pınar Tözün, Danica Porobic, Iraklis Psaroudakis.
250 _a1st ed. 2017.
264 1 _aCham :
_bSpringer International Publishing :
_bImprint: Springer,
_c2017.
300 _aXII, 101 p.
_bonline resource.
336 _atext
_btxt
_2rdacontent
337 _acomputer
_bc
_2rdamedia
338 _aonline resource
_bcr
_2rdacarrier
347 _atext file
_bPDF
_2rda
490 1 _aSynthesis Lectures on Data Management,
_x2153-5426
505 0 _aIntroduction -- Exploiting Resources of a Processor Core -- Minimizing Memory Stalls -- Scaling-up OLTP -- Scaling-up OLAP Workloads -- Outlook -- Summary -- Bibliography -- Authors' Biographies.
520 _aData management systems enable various influential applications from high-performance online services (e.g., social networks like Twitter and Facebook or financial markets) to big data analytics (e.g., scientific exploration, sensor networks, business intelligence). As a result, data management systems have been one of the main drivers for innovations in the database and computer architecture communities for several decades. Recent hardware trends require software to take advantage of the abundant parallelism existing in modern and future hardware. The traditional design of the data management systems, however, faces inherent scalability problems due to its tightly coupled components. In addition, it cannot exploit the full capability of the aggressive micro-architectural features of modern processors. As a result, today's most commonly used server types remain largely underutilized leading to a huge waste of hardware resources and energy. In this book, we shed light on the challenges present while running DBMS on modern multicore hardware. We divide the material into two dimensions of scalability: implicit/vertical and explicit/horizontal. The first part of the book focuses on the vertical dimension: it describes the instruction- and data-level parallelism opportunities in a core coming from the hardware and software side. In addition, it examines the sources of under-utilization in a modern processor and presents insights and hardware/software techniques to better exploit the microarchitectural resources of a processor by improving cache locality at the right level of the memory hierarchy. The second part focuses on the horizontal dimension, i.e., scalability bottlenecks of database applications at the level of multicore and multisocket multicore architectures. It first presents a systematic way of eliminating such bottlenecks in online transaction processing workloads, which is based on minimizing unbounded communication, and shows severaltechniques that minimize bottlenecks in major components of database management systems. Then, it demonstrates the data and work sharing opportunities for analytical workloads, and reviews advanced scheduling mechanisms that are aware of nonuniform memory accesses and alleviate bandwidth saturation.
650 0 _aComputer networks .
_931572
650 0 _aData structures (Computer science).
_98188
650 0 _aInformation theory.
_914256
650 1 4 _aComputer Communication Networks.
_980290
650 2 4 _aData Structures and Information Theory.
_931923
700 1 _aLiarou, Erietta.
_eauthor.
_4aut
_4http://id.loc.gov/vocabulary/relators/aut
_980291
700 1 _aTözün, Pınar.
_eauthor.
_4aut
_4http://id.loc.gov/vocabulary/relators/aut
_980292
700 1 _aPorobic, Danica.
_eauthor.
_4aut
_4http://id.loc.gov/vocabulary/relators/aut
_980293
700 1 _aPsaroudakis, Iraklis.
_eauthor.
_4aut
_4http://id.loc.gov/vocabulary/relators/aut
_980294
710 2 _aSpringerLink (Online service)
_980295
773 0 _tSpringer Nature eBook
776 0 8 _iPrinted edition:
_z9783031007309
776 0 8 _iPrinted edition:
_z9783031029868
830 0 _aSynthesis Lectures on Data Management,
_x2153-5426
_980296
856 4 0 _uhttps://doi.org/10.1007/978-3-031-01858-9
912 _aZDB-2-SXSC
942 _cEBK
999 _c84933
_d84933