SQL/LPP is a system that adds time-series extensions to SQL [Perng and Parker 1999]. SQL/LPP models time-series as attributed queues (queues aug- mented with attributes that are used to hold aggregate values and are updated uponmodifications to the queue). Each time-series is partitioned into segments that are stored in the database. The SQL/LPP optimizer uses pattern-length analysis to prune the search space and deduce properties of composite pat- terns from properties of the simple patterns. Here too, the pattern language is largely decoupled from SQL, bringing problems similar to those of SEQ. More- over, SQL/LPP doesn’t detect recursive patterns, and only supports a limited set of aggregate functions. While,.
