Data Archiving
Data archiving is distinct from sharding: it separates hot data from cold data rather than distributing load for scalability. Archiving moves older, infrequently accessed data to separate storage so the primary database stays focused on ac…
1 sources - 4 claims
Data archiving is distinct from sharding: it separates hot data from cold data rather than distributing load for scalability. Archiving moves older, infrequently accessed data to separate storage so the primary database stays focused on active data. Moving data to an archive is sufficient to realize performance benefits; deleting archived data is not necessary. Data required by at least 80% of system functionality should remain in the primary database, while the remaining 20% can reside in a slower secondary database.