[jira] [Resolved] (TRAFODION-49) LP Blueprint: cmp-divisioning - Support for multi-temperature data - part 1

["Hans Zeller (JIRA)" <ji...@apache.org>]

     [ 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)