Find White Papers
Home
About Us
List Your Papers
    
> IBM > Proven Strategies for Archiving Complex Relational Data

Proven Strategies for Archiving Complex Relational Data

White Paper Published By: IBM

This white paper explains how the IBM® Optim™ Data Growth Solution provides proven technology and comprehensive capabilities that make archiving complex relational data both practical and desirable.



Tags : 
ibm integrated data management, database growth, optim data growth solution, database archiving, idm, disaster recovery, database referential integrity, data management

IBM
Published:  Feb 18, 2009
Type:  White Paper
Length:  24 pages

Integrated Data Management SolutionsDecember 2008
IBM Information Management software
Proven strategies for archiving
complex relational dataProven strategies for archiving complex relational dataPage 2
Executive summaryContents Continued database growth, long-term data retention regulations and storage requirements are increasing operational costs. As a result, more CIOs are examining 2 Executive summary the potential benefits of implementing cost-effective strategies for managing data 3 Database growth: impact and information throughout its lifecycle. Because most of the historical data stored and opportunity in high-performance application databases is inactive, more companies are realizing 6 Database archiving: the challenges the value of database archiving as an essential component in an effective data 10 Finding the ideal solution management strategy.11 Advanced technology for archiving Allowing application data growth to continue can degrade performance, limit complex relational data availability, increase costs and slow disaster recovery. Yet, archiving complex 15 Typical database archiving relational data poses many challenges. Organizations need the capability to archive scenario historical data and safely remove it from the production environment. They also 19 Researching and restoring need capabilities to store archives cost-effectively, retain access and dispose of data archived data appropriately to comply with data retention regulations. In short, organizations need 22 BM Optim delivers business value an effective archiving strategy for managing application data throughout its lifecycle.
In searching for the ideal archiving solution, some organizations consider in-house development, but soon realize that the short- and long-term costs do not offset the expected return on investment. Implementing an off-the-shelf archiving solution does offer advantages in faster acquisition and implementation. However, the ideal solution must provide the archiving capabilities needed to support current and future data management requirements across often heterogeneous application environments.Proven strategies for archiving complex relational dataPage 3
This white paper explains how the IBM® OptimT Data Growth Solution provides proven technology and comprehensive capabilities that make archiving complex relational data both practical and desirable. Archives can be easily managed and stored on the most cost-effective media, and historical data remains accessible until retention periods expire. Maintaining only current active data in production environments improves service levels, increases availability and improves disaster recovery initiatives. Archiving allows organizations to reclaim valuable capacity and lower costs.
As one of the solutions in the IBM Optim Integrated Data Management (IDM) portfolio, the IBM Optim Data Growth Solution addresses a critical operational need for enterprises that rely on large complex relational databases.
Database growth: impact and opportunityIndustry analysts and leading computing publications report that the rapid accumulation of data worldwide continues at an unprecedented rate. Forrester estimates that on average, data repositories for large applications grow by 50 percent 1annually. Enterprise databases are doubling and even tripling in size and exceeding projected estimates, resulting in serious consequences.
Accumulating more data means degraded performance and slower response time. Availability is limited because routine database maintenance requires more processing time, often taking systems out of service. Managing larger databases also has an impact on critical disaster recovery time. If your company relies on data-intensive, mission-critical business applications, then unmanaged database growth directly affects your bottom line, as you risk losing customers, frustrating users and missing new revenue opportunities.Proven strategies for archiving complex relational dataPage 4
Managing and storing enterprise data are becoming top priorities for IT executives. CIOs face an increasing demand for 100 percent availability of mission-critical applications, 24/7 eBusiness support and scalable access to enterprise data on a variety of platforms. However, corporate databases are growing so large that just maintaining traditional service levels has become a demanding challenge for many I... [download for more]

Browse Technology Topics

Data Center

Virtualization, Cloud Computing, Infrastructure, Design and Facilities, Power and Cooling, Green Computing  
    

Data Management

Application Integration, Analytical Applications, Business Intelligence, Configuration Management, Database Development, Data Integration, Data Mining, Data Protection, Data Quality, Data Replication, Database Security, EDI, SOAP, Service Oriented Architecture, Web Service Management, Data Warehousing  
    

Enterprise Applications

Application Integration, Application Performance Management, Best Practices, Business Activity Monitoring, Business Analytics, Business Integration, Business Intelligence, Business Management, Business Metrics, Business Process Automation, Business Process Management, Call Center Management, Call Center Software, Change Management, Corporate Governance, Customer Interaction Service, Customer Relationship Management, Customer Satisfaction, Customer Service, EBusiness, Enterprise Resource Planning, Enterprise Software, EProcurement, Extranets, Groupware Workflow, HIPAA Compliance, IP Faxing, IT Spending, Marketing Automation, Performance Testing, Product Lifecycle Management, Project Management, Return On Investment, Risk Management, Sales & Marketing Software, Sales Automation, Server Virtualization, Simulation Software, Supply Chain Management, System Management Software, Total Cost of Ownership, Video Conferencing, Voice Recognition, Voice Over IP, Workforce Management, Incentive Compensation, Spend Management, Manufacturing Execution Systems, International Computing  

Human Resource Technology

Human Resources Services, Payroll Software, Time and Attendance Software, Workforce Management Software, Financial Management, Employee Monitoring Software, Employee Training Software, Recruiting Software/Services, Employee Performance Management, ELearning, Benefits Management, Expense Management  
    

IT Career Advancement

Cisco Certification, Microsoft Certification, Linux Certification, Network Security Certification, Software Development Certification  

IT Management

Employee Performance, ITIL, Productivity, Project Management, Software Compliance, Sarbanes Oxley Compliance, Service Management, Desktop Management  
    

Knowledge Management

Collaboration, Collaborative Commerce, Contact Management, Content Delivery, Content Integration, Content Management System, Corporate Portals, Customer Experience Management, Document Management, Information Management, Intranets, Messaging, Records Management, Search And Retrieval, Search Engines, Secure Content Management, SLA  

Networking

Active Directory, Bandwidth Management, Convergence, Distributed Computing, Ethernet Networking, Fibre Channel, Gigabit Networking, Governance, Grid Computing, Infrastructure, Internetworking Hardware, Interoperability, IP Networks, IP Telephony, Local Area Networking, Load Balancing, Migration, Monitoring, Network Architecture, Network Management, Network Performance, Network Performance Management, Network Provisioning, Network Security, OLAP, Optical Networking, Quality Of Service, Remote Access, Remote Network Management, Server Hardware, Servers, Small Business Networks, TCP/IP Protocol, Test And Measurement, Traffic Management, Tunneling, Utility Computing, VPN, Wide Area Networks, Green Computing, Cloud Computing, Power and Cooling, Data Center Design and Management, Colocation and Web Hosting  
    

Platforms

AS/400, Domino, Linux, Microsoft Exchange, Oracle, PeopleSoft, SAP, Siebel, Solaris, Tivoli, Unix, Web Sphere, Windows, Windows Server  

Security

Access Control, Anti Spam, Anti Spyware, Anti Virus, Application Security, Auditing, Authentication, Biometrics, Business Continuity, Compliance, DDoS, Disaster Recovery, Email Security, Encryption, Firewalls, Hacker Detection, High Availability, Identity Management, Internet Security, Intrusion Detection, Intrusion Prevention, IPSec, Network Security Appliance, Password Management, Patch Management, Phishing, PKI, Policy Based Management, Security Management, Security Policies, Single Sign On, SSL, Secure Instant Messaging, Web Service Security, PCI Compliance, Vulnerability Management  
    

Software Development

.NET, C++, Database Development, Java, Middleware, Open Source, Software Outsourcing, Quality Assurance, Scripting, SOAP, Software Testing, Visual Basic, Web Development, Web Services, Web Service Security, XML  

Storage

Backup And Recovery, Blade Servers, Clustering, IP Storage, ISCSI, Network Attached Storage, RAID, Storage Area Networks, Storage Management, Storage Virtualization, Email Archiving, Data Deduplication  
    

Wireless

802.11, Bluetooth, CDMA, GPS, Mobile Computing, Mobile Data Systems, Mobile Workers, PDA, RFID, Smart Phones, WiFi, Wireless Application Software, Wireless Communications, Wireless Hardware, Wireless Infrastructure, Wireless Messaging, Wireless Phones, Wireless Security, Wireless Service Providers, WLAN  
Search