Shivakumar, N. and Garcia-Molina, H. (1998) Wave-Indices: Indexing Evolving Databases. Technical Report. Stanford InfoLab.
In many applications, new data is being generated every day. Often an index of the data of a past window of days is required to answer queries effciently. For example, in a warehouse one may need an index on the sales records of the last week for effcient data mining, or in a Web service one may provide an index of Netnews articles of the past month. In this paper, we propose a variety of wave indices where the data of a new day can be effciently added, and old data can be quickly expired, to maintain the required window. We compare these schemes based on several system performance measures, such as storage, query response time, and maintenance work, as well as on their simplicity and ease of coding. Keywords: Indexing, sliding windows, temporal databases Note to Referees: This paper is an extended version of a prior conference publication in ACM SIGMOD'97 with the same title. The material has been extended significantly.
|Item Type:||Techreport (Technical Report)|
|Uncontrolled Keywords:||indexing, sliding windows, SCAM, search engines|
|Subjects:||Computer Science > Databases and the Web|
|Related URLs:||Project Homepage||http://www-diglib.stanford.edu/diglib/pub/|
|Deposited By:||Import Account|
|Deposited On:||25 Feb 2000 16:00|
|Last Modified:||29 Dec 2008 12:32|
Repository Staff Only: item control page