From owner-freebsd-database@FreeBSD.ORG Thu Apr 5 15:32:52 2012 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 95AEB106566C for ; Thu, 5 Apr 2012 15:32:52 +0000 (UTC) (envelope-from rsb@berentweb.com) Received: from mail-lpp01m010-f54.google.com (mail-lpp01m010-f54.google.com [209.85.215.54]) by mx1.freebsd.org (Postfix) with ESMTP id 0C6938FC15 for ; Thu, 5 Apr 2012 15:32:51 +0000 (UTC) Received: by lagv3 with SMTP id v3so2459193lag.13 for ; Thu, 05 Apr 2012 08:32:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=berentweb.com; s=google; h=mime-version:x-originating-ip:date:message-id:subject:from:to :content-type; bh=QBN7jXCeu5hIBLDWQ8/T5NCo8JrrNoXIb1dWyjbBnN8=; b=iN2/5jsusJRpuDxv/Lkv09VpQ6vvRjzycazXHiwGXiAG4U44FfVy/ZV97DXrEolka2 WKQz+KmF1vRpjQ/ZsYDxDf4jZfXOy1E/BjvW90m/SxoRh+tFr3XQJjFV/eDnR40hbABg Cyp0zSAGqgiOaCOLo9S3FQtqyIg6HGNv5mn78= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=mime-version:x-originating-ip:date:message-id:subject:from:to :content-type:x-gm-message-state; bh=QBN7jXCeu5hIBLDWQ8/T5NCo8JrrNoXIb1dWyjbBnN8=; b=QvGX/VxXfOS9md5GA4Z6KaI56ddvGgnJ0ejuwwHPWTgzyBjlyecoCILF+WY7/4hhE/ v/I96JKlWA7dxwfFZfdDTGbHPBaiGetHGQCWcrMhHzYdSmGfdBEE6TznaMLzt5Ywrt5a tEiX9iGKlbox9vCIm/eo+f/Ooq8S/K8FKQMg4hn0YCwCIIS0IMAN/W2YxRAa/nEJQTPf dpU/uIu1C2ATC/L9+utXhkel0UzrawlHKFRPMKP4EFA58N2Ib9uOMIevvV8m9NcLoKN0 I4qJXTYC205Ap7o4GWcsYmpP9tPEyJZdrUBgoKtfgrBz151l/t0HrlBQnNkOYr+1XzU5 DVbg== MIME-Version: 1.0 Received: by 10.152.112.68 with SMTP id io4mr3582009lab.40.1333639970832; Thu, 05 Apr 2012 08:32:50 -0700 (PDT) Received: by 10.112.77.15 with HTTP; Thu, 5 Apr 2012 08:32:50 -0700 (PDT) X-Originating-IP: [85.110.138.250] Date: Thu, 5 Apr 2012 18:32:50 +0300 Message-ID: From: "Raif S. Berent" To: freebsd-database@freebsd.org X-Gm-Message-State: ALoCoQnVFcmEsddo1otGTiL2KalH4fL1z1/XXCZK0EmoZ4OnjsfMjEA1ch1wJPhnFsYgEbp0Zil/ Content-Type: text/plain; charset=ISO-8859-1 X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Subject: general question about time-series databases X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 05 Apr 2012 15:32:52 -0000 My knowledge of time-series data storage problems is theoretical. I have read that mysql and other relational db structures do not perform that well in time-series data and that java based db's perform better. I would like to ask anyone who has knowledge or experience in this area, which db or what tuning they would suggest for time-series data. My specific purpose for such a database and data is for academic research in the field of bank default risk prediction models based on quarterly financial data combined with a variety of financial market data. Regards. From owner-freebsd-database@FreeBSD.ORG Thu Apr 5 22:51:32 2012 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id CA73B1065673 for ; Thu, 5 Apr 2012 22:51:32 +0000 (UTC) (envelope-from m.e.sanliturk@gmail.com) Received: from mail-iy0-f182.google.com (mail-iy0-f182.google.com [209.85.210.182]) by mx1.freebsd.org (Postfix) with ESMTP id 83D268FC0C for ; Thu, 5 Apr 2012 22:51:32 +0000 (UTC) Received: by iahk25 with SMTP id k25so3190265iah.13 for ; Thu, 05 Apr 2012 15:51:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=gRX8r/AXev8cmPlyIQLO7w3FPBTrsn7vGZeqaKzM/ZE=; b=eXg5NqAACoD3MJbLpLaLvG1fJfQnxAR7h4cmcEBGiqJOk0djtStg3QcyDeWrs/0E/a rHkdVsLSmtbEUP6q3j4UtyitfCy9che9ciwLDMXjMSUCWtVQ/t1jQ0IAVj8x1fCtTVia a95NDLECmI8TqyFNprrUzPZBHXUIfryoEC0B8lLIm5L4hECyUp6BDnPwDY23cKQD3nPO ZVT+zJ5PcYgPOsvtbhJjdW+dZ4uAOw+4QIHoV9HPC5pO/1WcBht6WPuZhaooVMyvBgY5 GYKwWdM07m5F7BXtiICM5YAUQojCkQzuHagnFUoj4/fVmZgGs9YmMcbcec9s9QNLyU5o v6FQ== MIME-Version: 1.0 Received: by 10.50.154.167 with SMTP id vp7mr3558613igb.55.1333666292103; Thu, 05 Apr 2012 15:51:32 -0700 (PDT) Received: by 10.42.153.2 with HTTP; Thu, 5 Apr 2012 15:51:32 -0700 (PDT) In-Reply-To: References: Date: Thu, 5 Apr 2012 18:51:32 -0400 Message-ID: From: Mehmet Erol Sanliturk To: "Raif S. Berent" Content-Type: text/plain; charset=UTF-8 X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: freebsd-database@freebsd.org Subject: Re: general question about time-series databases X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 05 Apr 2012 22:51:32 -0000 On Thu, Apr 5, 2012 at 11:32 AM, Raif S. Berent wrote: > My knowledge of time-series data storage problems is theoretical. I have > read that mysql and other relational db structures do not perform that well > in time-series data and that java based db's perform better. > I would like to ask anyone who has knowledge or experience in this area, > which db or what tuning they would suggest for time-series data. My > specific purpose for such a database and data is for academic research in > the field of bank default risk prediction models based on quarterly > financial data combined with a variety of financial market data. > > Regards. > _______________________________________________ > The time series data base and time series analysis software should be considered together . The following pages may be useful : http://en.wikipedia.org/wiki/Category:Time_series_software http://en.wikipedia.org/wiki/Category:Time_series_analysis http://en.wikipedia.org/wiki/Category:Time_series_databases http://en.wikipedia.org/wiki/Time_series_database http://en.wikipedia.org/wiki/FAME_(database) http://www.sungard.com/fame http://tempo-db.com/ http://opentsdb.net/ http://www.autobox.com/ The following phrases may be searched in Internet : time series database time series database design statistical data time series database time series analysis time series analysis r time series analysis sas time series analysis spss time series analysis matlab time series analysis afs Thank you very much . Mehmet Erol Sanliturk