Abstract: With the continuous development of hardware technology, computer performance has been continuously strengthened, and also the database. However, there has come forth some new problems, such as cache access delay and cache conflict. According to the classification of the various optimization technologies,we analyzed various research resups in database algorithm optimization based on modern processor in the past 10 years,and looked to the future trend of database optimization based on new hardware.

Key words: Cache optimization,Multithreaded optimization,CMP,SMT