The data-archival tag has no wiki summary.
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 ...
1
vote
0answers
84 views
Unable to recover database
How to resolve this issue, I am getting this error, when I'm trying to open my Oracle Database
ORA-16038: log 1 sequence# 59 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: ...
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 ...
0
votes
2answers
193 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 ...
1
vote
3answers
109 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 (
...
3
votes
2answers
122 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
1answer
95 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, ...
5
votes
1answer
388 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 ...
1
vote
1answer
274 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 ...
