Why does TPC-D require update functions?
TPC-D models an environment where the database is accessed by users worldwide. Thus, the database must be available essentially on a 24 x 7 basis. At the same time, the database must be kept reasonably in sync with its operational data source. The environment being modeled is one in which read-only “extract” databases would be impractical; because there is no lengthy “refresh window” available in which the database could be reloaded, it must be able to be updated in order to add new data and remove obsolete data.
