Cost models for Main-Memory database systems

Cost models for Main-Memory database systems

Cost models for Main-Memory database

systems Peter Boncz

Stefan Manegold CWI (Amsterdam)

Contents

Region size

No overlap

Perfect cacheline reuse

Compulsory misses + data misses

Beware automatic prefetching!

Sequential access is much

cheaper -5GB/s vs 500MB/s

Workaround: use amoritzed latency for sequential accesse

Sequential memory access Random memory access

Perfect reuse

No reuse

LRU reuse

keys

buckets collision-list

0 1

BAT

mask

link

Writes are non-blocking Latency

=0

Recently Viewed Presentations

  • Commonly Abused Drugs

    Commonly Abused Drugs

    Other Schedule II substances: amobarbital, glutethimide, and pentobarbital. DEA Schedule Schedule III/IIIN Controlled Substances (3/3N): Substances in this schedule have a potential for abuse less than substances in Schedules I or II and abuse may lead to moderate or low...
  • Workplace Health Centers: Driving employee wellness and productivity

    Workplace Health Centers: Driving employee wellness and productivity

    afeditab cr 30 mg tablet. afeditab cr 60 mg tablet. aggrenox capsule sa. ah-chew tablet chew. alavert d-12 allergy-sinus tab. albuterol 0.83 mg/ml solution. albuterol 5 mg/ml solution. albuterol 90 mcg inhaler. albuterol sul 1.25 mg/3 ml sol. albuterol sulf...
  • 05-0021-00 - IEEE Standards Association

    05-0021-00 - IEEE Standards Association

    Goals Present estimated parameters for Saleh-Valenzuela model with direction-of-arrival extension (currently considered by 802.15.3c channel model subgroup) for library environment Minimize the impact of TX/RX antenna patterns in IMST measurements data on extracted parameters of the channel model Measurements Scenarios...
  • Diapositiva 1 - CI-PIRE

    Diapositiva 1 - CI-PIRE

    "The Bird's Nest" - Beijing National Stadium. Overlooking The Forbidden City. Xi'an is one of the four great ancient capitals of China and is home to the world famous Terracotta Army Museum. Since Xi'an is located approximately 750 miles from...
  • Safe Operation of Forklifts - Washington

    Safe Operation of Forklifts - Washington

    Safe Operation of Forklifts and other powered industrial trucks (PITs) May, 2011 Correct answer is "go down the incline backwards" * The correct answer is "pull your arms in and hold on" * The correct answer is "inform maintenance or...
  • Radian Trigonometry: Radians KUS objectives BAT convert fluently

    Radian Trigonometry: Radians KUS objectives BAT convert fluently

    Introduction to Radian measure1. For a circle of radius r, the angle at the centre, which subtends an arc of length r, is equal to 1 radian 'If arc AB has length r, then angle AOB is 1 radian (1c...
  • UDMIS.info

    UDMIS.info

    Systems Implementation with DBMS/ Database Management Dave Salisbury [email protected] (email) http://www.davesalisbury.com/ (web site)
  • Position Statement for People with Types 1 and

    Position Statement for People with Types 1 and

    For individuals managed on any insulin regimen, less intensive glycemic targets during Ramadan, aiming for fasting and pre-meal SMBGs of 5.5 to 7.5 mmol/L are preferred to reduce the risk of hypoglycemia. ... PowerPoint Presentation Last modified by: