On 12/19/11 11:20 PM, David Pennell wrote:
In a large scale time series row-store DB (Oracle), I'm accustomed to partitioning fact tables on time. This has has a couple of benefits:
Dear David,
If the table is sorted on the time dimension then MonetDB will already automagically use horizontal column partitioning (at no cost) to speed up queries in a multicore setting.
- since queries always include predicates on the time field, partition elimination can help a lot
- when the time based partitions map one-to-one with tablespaces, removing old data is extremely fast. (when you've reached the maximum data retention period, you need to remove data as fast as you can load it).
That feature will most likely be released in Q1. It can be mimicked easily using base tables glued together with a view definition.
Are there any features in monetdb that would facilitate these needs (or ameliorate them)?
regards, Martin Kersten
TIA, -david
Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev
MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users