Create database partitioning for analyzing time-series
<p>I have 100 000 sources/sensors/symbols. From each one I read a value on a daily basis.</p>

<p>I load a database table with these daily data/values. One row for each value AND symbol, thats 100 000 rows per day.</p>

<p>Query1:</p>

<p>As I want to analyze daily data over all symbols I partition the database on year, month, week, day. </p>

<p>Query2:</p>

<p>But I also want to analyze trends/statistics over time for each symbol by reading data up to 24 months back in time per symbol.</p>

<p>Query2 is along another dimension (time-axis) and I dont want to query over several partitions (y,m,w,d) optimized for query1.</p>

<p>What kind of design do you propose ?</p>