|
|
Analysts predict that data growth estimates will
continue to tax the practical limits of database
performance and maintenance requirements. Although
processing power doubles and disk prices are halved
every 18 months, no such scalability model applies to
database software. The degree of query complexity,
physical design limitations, and CPU-bound versus
I/O-bound transactions precludes linear database
performance improvement even as processing power and
additional storage spindles are added.
Exacerbating the issue of more and more data is the need
to maintain duplicate application environments (e.g.,
quality assurance, high availability, disaster recovery)
to address important operational requirements. The
growth of data in the primary production database is now
multiplied, and the impact can be noticeable in both
hardware and people costs. In addition, more stringent
record-keeping requirements as a result of recent
corporate scandals will increase the demand for access
to as much historical data as possible.
One option gaining popularity is continuous archiving
and deletion of completed or closed transactional data
from the primary application. Omega Tech provides a solution
that is designed for precisely this purpose.
|