The data-archival tag has no wiki summary.
5
votes
1answer
390 views
Database archive solutions
In continuation to a question posted by me on Is it a good idea to move high-volume and highly-accessed tables to a separate database?, am looking out for different techniques/solutions available for ...
3
votes
2answers
123 views
Support ticket system - when/how to move old tickets?
I don't have access to the partitioning feature, but consider a support ticket system with tens of thousands of tickets being opened everyday and taking about a week to a couple of months in getting ...
1
vote
3answers
110 views
Design for archiving a sorted list (with ability for a few INSERT)
I have a somewhat static sorted list of words which I want to save in a database table:
-- simplified!
-- Note: the rank/order of each item is NOT calculable from other values!
CREATE table words (
...
1
vote
1answer
96 views
Archive database on Postgres
I have a table with more than 60mio records, where every month I have to add about 2-4 milions. It's not insert only table, I need to read from it and update recently added rows (status changes, ...
1
vote
1answer
275 views
Data archival strategy that handles schema changes?
I am working with a legacy application that has about ten years of customer data. A majority of this data is not used in day-to-day operations but there is a business requirement to have the data ...
0
votes
2answers
195 views
Delete and archive old data from several related tables
Our schema looks like this:
table tblTrip: stores start and end trip date and time
table tblTripData: keeps all the trip data
table tblTripEvent: stores events related to the particular trip.
Then ...
0
votes
3answers
48 views
Using MySQL InnoDB as an Archive
My site has a main MySQL InnoDB table that it does most of its work on. New rows get inserted at a rate of 1 million per week, and rows older than a week gets moved over to an archive table on a daily ...
0
votes
0answers
53 views
Tape rotation strategies
I am trying to find a tape rotation strategy that would be optimal under the following conditions:
Backup Media Rotation strategy should support the following:
Media Archives required ...
