After this stage, we usually convert the information categories into data producing ER-Diagrams
An important consideration that is usually ignored is, what happens when a product is up and running for a sample period Eg. 5yrs where CRUD operations especially deletions take place.
Some standard practices are unwritten principles,
- if ACTION = DELETE, default it to soft-deletion keeping it in active storage.
- Deciding to push data to cold storage for archival if primary storage has grown considerably,
- Elimination process of data ageing based on years of inactivity.
At the discovery phase of the Information view, if it is feasible, it is a good idea to strategize solutioning data ageing conditions whether backup Vs archival as is or differentially or transform data to suit purposes of learning or analytics.
How do we know if this analysis is feasible?
a. If the product has CRUD transactions, management of data as part of activities done, then thinking about retention and archival can be solutioned at this stage
b. If the product is has extensive realtime processing such as creation of algorithms, then the benchmarking for information that become candidates for archival, could be arrived only after a couple of pilot tests.
For the given use case, let's try to think of ways to archive
Information categories and strategies for archival for the Simple management system
1. Company: CASE ACTIVE, then in active storage
CASE DELETED, then soft-deleted but in active storage
DELETED, PERIOD > 1yr, then data required for reporting archived, without violating IP
Eg: Company Name, Company Id, Total Employees, Subsystems used, Highly used Subsystems / day / year
2. Employee: CASE ACTIVE, then in active storage
CASE DELETED, PERIOD < 1yr, move to cold storage info as is
CASE DELETED, PERIOD > 5yrs, then transform data to be archived for analytics purpose
Eg: Emp name, Emp Id, Performance index, last designation, total years in employment, compliants or non-compliances etc
3. Designation & Department: CASE ACTIVE, then in active storage
CASE DELETED, soft-delete but in active storage
4. Subsystems: CASE ACTIVE, then in active storage
CASE DELETED, PERIOD > 1yr, then cold storage as is
