|
Demo:
Relational Data Archiving
|
Eliminate Database Slowdowns, Identify Drivers for Data Retention, and Maintain your Database Integrity
|
|
|
|
Data Management |
|
|
|
As your Amdocs CRM system transactional volume grows the need to invest in more processing power and database storage
becomes increasingly imperative. Archiving and removal of production transactional data provides a way to maintain your
current hardware investment and system performance. Relational Data Archiving solution provides an easy and cost efficient
way to archive the data.
The Amdocs data model requires a very high level of expertise to maintain data integrity when removing data from the
database. To manually create the programming required to only remove and maintain data integrity for a single database
object such as table_case is a large undertaking.
There are a number of drivers for using Relational Data Archiving:
-
The most common stated reason for the need to remove and archive remove data was due to performance issues,
such as slowdowns in query response times. These performance issues were found to occur when there are millions
of interactions or records in some of the Amdocs tables. We saw performance issues as clients went to upgrade
to the new Amdocs Thin Client. Many clients with larger terabyte size databases need to purge and or archive
copious amounts of data. We found that our solution provided substantially increase response time after the
purge archive was completed, resulted in drastically reduced call center operating costs.
-
The second most common issue is the cost of the CRM Production Level Database Storage and Management.
An analysis of the costs of storing infrequently used application data in a live CRM production environment vs.
cheap network of off-line storage shows that basic network storage is 80% cheaper than database storage will all
associated costs. Data Archiving provides an immediate ROI just on the reducing storage costs by moving old
transactional data to network storage.
-
Third, many clients were also looking for an easy to use tool for better managing industry compliance issues
or other Federal or State regulations regarding maintaining easy access to archived data. Many companies require
removing unused data from the database but retain this data for up to 5 or ten years as a result of corporate
retention policies and needs for data mining for market research purposes.
-
Customers that handle consumer credit data need to locate and securely delete financial sensitive information for
PCIA audit compliance.
-
After archiving the selected data, all customers required the ability to view the archived data from the Amdocs
desktop, without going through the lengthy process of restoral to production using an expensive DBA.
-
The Relational Data Archiving tool is easily integrated with any CRM or other transactional platform since all
documents are stored in industry standard format.
Data Management Features and Benefits:
- Free-up programmers and DBAs from complex one-time archive and restoral processes
- Archive to highly compressible XML or PDF to move data from database production environment to lower-cost
network storage
- Superior performance in purge and archive speeds and flexibility
- Optimize your CRM transactional system for peak performance and improved response times
- Handles all Amdocs CRM Business or Custom Objects
- Access and Search archived data from the Amdocs desktop or outside Clarify application
- Customizable archived formats so only key business data is presented
- Purge and/or Archive on a one-time basis for initial clean-up or special projects Purge and Archive on a
continuous basis
- All relevant parties in an organization will have the capability to retrieve data for investigative purposes
- Ability to customize not only the format, but which archived data will be brought back for viewing and analysis
- Create the ability for one-off purges for clean up purposes or for special projects
|
|
Company Overview
