wiki:S2S_PERSIST_ARCHIVING_R0

Version 2 (modified by kyli, 16 years ago) (diff)

--

Error: Macro BackLinksMenu(None) failed
compressed data is corrupt

Error: Macro TicketQuery(summary=S2S_PERSIST_ARCHIVING_R0, format=table, col=summary|owner|status|type|component|priority|effort|importance, rows=description|analysis_owners|analysis_reviewers|analysis_score|design_owners|design_reviewers|design_score|implementation_owners|implementation_reviewers|implementation_score|test_owners|test_reviewers|test_score|) failed
current transaction is aborted, commands ignored until end of transaction block

Analysis

Overview

Different kind of resources are going to be persisted on th Sophie2 server - users, books, etc. For now, resources are stored in a database. We should not allow this database to be bloated, so a way for cleaning it up must be defined.

Task requirements

Design and implement a model for S2S database archiving. Think about the following aspects:

  • Archiving old resource changes.
  • Dealing with old comments.
  • Archiving unused accounts.

Make decisions on these and apply them to the org.sophie2.server.persistence layer.

Task result

Source code - extra features in org.sophie2.server.persistence.

Implementation idea

1st: Implement this task after (or together with) S2S_PERSIST_CHANGES_R0?. The problem here is that this task is in the next revision.
2nd: Think out just the mechanism for archiving, apply it to the currently persisted objects. Changes' shrinking can be implemented with the next (main) revision.

In chronological order:
S2S_PERSISTENCE_COMMONS_R0
S2S_PERSIST_MODEL_R0
S2S_PERSIST_RESOURCES_R0
S2S_PERSIST_META_R0

How to demo

Design

(Describe your design here.)

Implementation

(Describe and link the implementation results here (from the wiki or the repository).)

Testing

(Place the testing results here.)

Comments

(Write comments for this or later revisions here.)