title: A user-defined data type for the storage of time series data allowing efficient similarity screening.
abstract: The volume of the experimentally measured time series data is rapidly growing, while storage solutions offering better data types than simple arrays of numbers or opaque blobs for keeping series data are sorely lacking. A number of indexing methods have been proposed to provide efficient access to time series data, but none has so far been integrated into a tried-and-proven database system. To explore the possibility of such integration, we have developed a data type for time series storage in PostgreSQL, an object-relational database system, and equipped it with an access method based on SAX (Symbolic Aggregate approXimation). This new data type has been successfully tested in a database supporting a large-scale plant gene expression experiment, and it was additionally tested on a very large set of simulated time series data.
authors.affiliation: School of Informatics, The University of Edinburgh, Informatics Forum, 10 Crichton Street, Edinburgh, EH8 9AB, UK. lptolik@gmail.com
authors.forename: Anatoly
authors.initials: A
authors.lastname: Sorokin
authors.forename: Gene
authors.initials: G
authors.lastname: Selkov
authors.forename: Igor
authors.initials: I
authors.lastname: Goryanin
mesh_terms: D000465:Algorithms; D000818:Animals; D003198:Computer Simulation; D057225:Data Mining; D003628:Database Management Systems; D018506:Gene Expression Regulation, Plant; D006801:Humans; D016247:Information Storage and Retrieval; D008954:Models, Biological; D049490:Systems Biology; D018511:Systems Integration; D013997:Time Factors