Skip to main content
SpringerLink
Log in

Update

  • Chapter
  • First Online:
A Course in In-Memory Data Management

  • 1499 Accesses

Abstract

The “UPDATE” is part of SQL’s data manipulation language (DML) and is used for changing one or more tuples in a table.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 74.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 99.00
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  1. J. Krüger, C. Kim, M. Grund, N. Satish, D. Schwalb, J. Chhugani, H. Plattner, P. Dubey, A. Zeier, Fast updates on read-optimized databases using multi-core cpus. PVLDB 5(1), 61–72 (2011)

    Google Scholar 

  2. H. Plattner, in A common database approach for OLTP and OLAP using an in-memory column database, ed. by U. Çetintemel, S. Zdonik, D. Kossmann. SIGMOD Conference (ACM, Newyork, 2009), pp. 1–2

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Hasso Plattner Institute, August-Bebel-Str. 88, 14482, Potsdam, Brandenburg, Germany

    Hasso Plattner

Authors
  1. Hasso Plattner
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Hasso Plattner .

Self Test Questions

Self Test Questions

 

  1. 1.

    Status Update Realization

    How do we want to realize status updates for binary status variables?

    1. (a)

      Single status field: “false” means state 1, “true” means state 2

    2. (b)

      Two status fields: “true/false” means state 1, “false/true” means state 2

    3. (c)

      Single status field: “null” means state 1, a timestamp signifies transition to state 2

    4. (d)

      Single status field: timestamp 1 means state 1, timestamp 2 means state 2.

  2. 2.

    Value Updates

    What is a “value update”?

    1. (a)

      Changing the value of an attribute

    2. (b)

      Changing the value of a materialized aggregate

    3. (c)

      The addition of a new column

    4. (d)

      Changing the value of a status variable.

  3. 3.

    Attribute Vector Rewriting after Updates

    Consider the world population table (first name, last name) that includes all people in the world: Angela Mueller marries Friedrich Schulze and becomes Angela Schulze. Should the complete attribute vector for the last name column be rewritten?

    1. (a)

      No, because ‘Schulze’ is already in the dictionary and only the valueID in the respective row will be replaced

    2. (b)

      Yes, because ‘Schulze’ is moved to a different position in the dictionary

    3. (c)

      It depends on the position: All values after the updated row need to be rewritten

    4. (d)

      Yes, because after each update, all attribute vectors affected by the update are rewritten.

Rights and permissions

Reprints and permissions

Copyright information

© 2013 Springer-Verlag Berlin Heidelberg

About this chapter

Cite this chapter

Plattner, H. (2013). Update. In: A Course in In-Memory Data Management. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-36524-9_12

Download citation

Publish with us

Policies and ethics

Search

Navigation