000 04571nam a22004695i 4500
999 _c387266
_d387266
001 387266
003 ES-MaUEC
005 20230219130610.0
006 a||||fo|||| 00| 0
007 cr nn 008mamaa
008 220601s2017 sz | s |||| 0|eng d
020 _a9783031018589
024 7 _a10.1007/978-3-031-01858-9
_2doi
040 _aES-MaUEC
_bspa
_cES-MaUEC
_dES-MaUEC
050 4 _aQA76.9.D3
_b2017 EB
100 1 _aAilamaki, Anastassia
_eautor
_4aut
_4http://id.loc.gov/vocabulary/relators/aut
_9687023
245 1 0 _aDatabases on Modern Hardware
_cby Anastasia Ailamaki, Erietta Liarou, Pinar Tözün, Danica Porobic, Iraklis Psaroudakis
250 _a1st edition 2017
264 1 _aCham
_bSpringer International Publishing
_c2017
300 _a1 recurso en línea (XII, 101 páginas)
336 _atexto
_btxt
_2rdacontent
337 _aelectrónico
_bc
_2rdamedia
338 _arecurso electrónico
_bcr
_2rdacarrier
347 _aarchivo de texto
_bPDF
490 0 _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 several techniques 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.
988 _aSynthesis Collection of Technology_2017
650 7 _2embne
_9150569
_aSistemas de gestión de bases de datos
650 7 _2embne
_9141180
_aProceso de datos
650 7 _2embne
_9673019
_aMultiprocesadores
700 1 _aLiarou, Erietta,
_d1980-
_eautor
_4aut
_4http://id.loc.gov/vocabulary/relators/aut
_9687024
700 1 _aTözün, Pinar
_eautor
_4aut
_4http://id.loc.gov/vocabulary/relators/aut
_9687025
700 1 _aPorobic, Danica
_eautor
_4aut
_4http://id.loc.gov/vocabulary/relators/aut
_9687026
700 1 _aPsaroudakis, Iraklis
_eautor
_4aut
_4http://id.loc.gov/vocabulary/relators/aut
_9687027
776 0 8 _iPrinted edition:
_z9783031007309
776 0 8 _iPrinted edition:
_z9783031029868
856 4 0 _uhttps://go.openathens.net/redirector/universidadeuropea.es?url=https://doi.org/10.1007/978-3-031-01858-9
_zAcceso a este recurso digital (usuarios Universidad Europea de Madrid)
942 _2lcc
_cLE
998 _b02/2023
_dz
_esc
_zSI