[
https://issues.apache.org/jira/browse/TRAFODION-49?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hans Zeller resolved TRAFODION-49.
----------------------------------
Resolution: Implemented
Fix Version/s: (was: 1.0 (pre-incubation))
2.0-incubating
Divisioning was implemented in R1.0 and R1.1, with some remaining bugs fixed in
the R2.0 development phase, see TRAFODION_13.
> LP Blueprint: cmp-divisioning - Support for multi-temperature data - part 1
> ---------------------------------------------------------------------------
>
> Key: TRAFODION-49
> URL: https://issues.apache.org/jira/browse/TRAFODION-49
> Project: Apache Trafodion
> Issue Type: New Feature
> Components: sql-cmp
> Reporter: Hans Zeller
> Assignee: Hans Zeller
> Fix For: 2.0-incubating
>
>
> Databases that maintain current and historical data often suffer from the
> problem of decreasing performance as the amount of historical data grows.
> Most database systems have features that avoid this performance and
> scalability problem, typically by ensuring that the recent (or “hot”) data is
> stored separately from the older (“cold”) data. We want to implement
> multi-temperature data by creating logical, not physical range partitions. We
> do this by adding the range partition number as a prefix to the key, so that
> hot data is stored together in a key range and that cold data is stored in a
> separate key range. We expect that these logical range partitions will exist
> within each region, and that this is achieved by salting. The range partition
> number is a computed system column, meaning that it is not normally
> user-visible and that it is automatically maintained by Trafodion.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
