|Today’s global information economy has redefined the nature of business and the expectations of customers. The Internet, call centers, automatic tellers and other electronic transaction media put information-hungry customers directly at the corporate front door, at all hours. In addition, the corporate database must respond to input, edits and queries from employees and other internal sources. Faced with a sea of data, information systems must collect, analyze, categorize and redistribute information—quickly. Consequently, information professionals are under increasing pressure to improve productivity and operating efficiency, while accommodating more users, more often.
As corporations wrestle with this information bottleneck, many consider the advantages of implementing a data replication solution. This working copy of the production database can deliver several immediate benefits to both employees and customers, including:
- Reduced query traffic on the production database
- Faster response times for mission critical applications
- A dedicated resource for read-only inquiries
- System backup and continuous availability
E-Net offers its Remote Recovery Data Facility (RRDF) as a continuous-replication solution. RRDF works in concert with your current DBMS software. It captures each new log/journal record and transmits it, in real-time, to a remote replica database without affecting the performance of the production system. And, unlike other replication solutions, RRDF works continuously, propagating each transaction as it occurs.
RRDF’s homogeneous master/slave topology delivers a faster, unencumbered production database, and a perfect duplicate database, well suited for corporate Decision Support Systems (DSS) or other read-only applications, including:
- Data warehousing and data mining
- Complex SQL queries
- Batch reporting cycles (quarterly and year-end reports, etc.)
- Secure data access for Internet users
- Local database copies at multiple distant sites
- Load balancing
These functions can be performed freely on the shadow database, without affecting the performance of the production database, leaving it free to respond quickly to on-line transaction processing (OLTP) and other mission-critical requests.
RRDF’s spill file and gap recovery processing provide additional data protection. If a log/journal transmission is interrupted, updates are automatically buffered in a disk spill file. Then, when communication is restored, RRDF transmits the spill file data and resynchronizes with the receive site. During remote site outages or software/hardware failures, RRDF automatically retrieves any lost data from the send site log/journal files. It then transmits the data to the remote site. If the database writes a log/journal record, RRDF guarantees its arrival at the remote site while ensuring the integrity of the complete transaction.
Having a remote replica of a production database also intrinsically provides quick recovery capabilities in the event of an unplanned outage at the production site. In such an event,
it takes just a few minutes to switch processing from the production database to the
RRDF is a versatile solution, appropriate for companies that require the benefits of data replication along with instantaneous recovery from planned or unplanned outages.