A business has launched a new product line that has resulted in significant business and related data growth. A database/TPS application is facing issues with using too much disk storage. It is becoming critical and the organization may need to buy additional data storage at a cost of $20,000. The system has been storing information for the last 15 years and the business says this information is required for internal reporting. Data growth for years 1 through 12, was about 5% a year. For the past 3 years, it’s been a steady 20% per year. Similar data exists in the data warehouse, but specific business analysts say the data warehouse requires too much time to generate necessary reports.
1-How could you use the theory of 90/90 data use to determine how much data is actually required for real-time reporting? Provide an example of a proposed solution for the business to reduce the dependency on the TPS for reporting data that is > 1 year old.
2- Explain why you would or would not just buy the data storage now to eliminate any additional debate and minimize any changes to the system.
3- You could just force the business to use only the last 90 days of data with the TPS application, and require them to use the data warehouse for any data > 90 days. While technically this makes sense, explain why this may not be a good business move for the IT department.