Skip to main content
Network Efficiency Matters in Data Replication

A few years ago I worked with an ultra-fast analytical columnar database Vectorwise (now called Vector). At the time I thought Vectorwise could beat any row-based database on query performance thanks to the extremely efficient software. Then one day a…

Read on
How to Perform an Initial Load During Real-Time Data Integration

Imagine your employer decided to gradually migrate away from your current primary database technology to an alternative technology. And you are the one who has to make this happen. Initially, the alternative technology will only be used for real-time reporting,…

Read on
Beyond Just Data Replication

Data Warehouse Replication Most readers will be familiar with the proverb “If you have a hammer, then everything looks like a nail” to indicate that one may be inclined to use the wrong tool to accomplish a task simply due…

Read on
Four Ways to Prepare For Active/Active Replication

What is Active/Active? Active/active replication is a setup in which multiple databases with the same application tables operate independently with changes synchronized between them. Geographical replication is a popular use case for active/active replication, but it may also be of…

Read on
Near Real-Time Data Warehouse

Near Real-Time Data Warehouses: A Primer Business leaders are constantly on the lookout for ways to improve responsiveness to customers. And new technologies are helping them meet that objective. Take data warehousing technology. Because data warehouses once only operated in…

Read on
Data Replication For High Availability

High Availability (HA) has many angles. An obvious angle in the context of data replication technology is high availability of a replicated database. However, there is more around HA, especially in the context of heterogeneous replication, because in such a…

Read on
What is Application Down Time?

And what does it cost? The simplified view of application availability is binary: the application is available, or it is not. There is however a large grey area related to availability to indicate whether the application performs as well as…

Read on
Real-Time Analysis Matters

Every industry has real-time analysis use cases. Yet on any average day opportunities are lost and unnecessary expenses are made because organizations don’t analyze data properly, or they don’t do it at the right time. In this blog post I…

Read on
SQL Server Replication Software

SQL Server Replication Software Knowing your options If you’re looking for data replication out of and into SQL Server, one option is HVR, which enables replication in both homogeneous (SQL Server to SQL Server) and heterogeneous environments. HVR version 5 introduced…

Read on
What are the Different Methods of Change Data Capture (CDC)?

Four Methods of Change Data Capture As its name suggests, Change Data Capture (CDC) techniques are used to identify changes. CDC can be the basis to synchronize another system with the same incremental changes, or to store an audit trail…

Read on
Columnar databases: How to Perform Real-Time Business Intelligence

How can you perform high-performance real-time Business Intelligence on a columnar database? Columnar databases – in contrast to row-based databases – physically store data for columns together in data blocks (both on disk and in-memory). Queries retrieving data from many…

Read on
MPP Databases: Even Data Distribution

MMP Databases Massively-Parallel Processing (MPP) databases such as Teradata, Greenplum or Actian Matrix (formerly ParAccel) achieve ultimate performance through parallel execution across multiple servers. In order for this approach to work well data must be distributed as evenly as possible,…

Read on
Why is data replication slow?

How can we speed up replication? Every now and again I come across the question: how can we speed up the replication? Irrespective of the target database the desirable answer for the person responsible for the replication implementation may be:…

Read on
Data Replication Tools: Comparison and Selection Guide

Selecting the Right Data Replication Software for Your Business There are a million reasons you might need a real-time data replication solution. Maybe you’re migrating applications to the cloud or looking for a hybrid cloud solution. Or maybe you’re implementing…

Read on
How To: SQL Server Data Replication

SQL Server Data Replication Done Fast and Reliably Data Replication for SQL Server and Heterogeneous Environments An overview, how-to videos and a case study to see how easy it can be to use HVR for SQL Server Replication Scenarios in Heterogeneous…

Read on
Exciting Times for Data Integration

More Important Than Ever as Real-Time Analytics Catches Fire According to a TDWI Best Practices Report on Real Time Data, BI, and Analytics, real-time analytics is taking off. A survey of BI and data warehousing professionals cited in the report…

Read on
1 6 7 8 9 10