-
Data Migration: Handling Data Types
Handling the structure, and deciding which fields, data types, or data points, relate to which fields or target elements within the destination database are one thing. Normally you can make an intelligent decision about the information that is being transferred and how that structural information should be handled. The actual data can be a completely…
-
Data Migration: Moving the Actual Data
There are two key elements to the exchange of any information between databases. One is the data structure used for the exchange, and the other is the transformation required to reach those structures. Some of these are driven by the source database, others by the target database. For example, when moving data from RDBMS to…
-
Data Migration: Methods
Throughout the series we will examine four distinct methods for moving and sharing information stored in databases, and each have their specific meanings, techniques and tricks to get the best out of the process. The four methods are: Moving – this refers to the process of moving data to another database for a simple export…
-
Data Migration: Database Terms and Structures
In the previous post we looked at a number of different database types and solutions, and it should be clear that there are a huge range of different terms for the different entities that make up the database structure. All the different entities fit into one of four categories, and they have significance because when moving…
-
Data Migration: Understanding the Challenges
Data migration – that is, the practice of sharing and distributing information between databases – requires some very careful consideration. Are you moving the data permanently, temporarily, sharing it between applications? Do want to share all of it, some of it? Are you changing databases, or trying to move some data to access or use the…
-
Making Real-Time Analytics a Reality — TDWI -The Data Warehousing Institute
My article on how to make the real-time processing of information from traditional transactional stores into Hadoop a reality has been published over at TDWI: Making Real-Time Analytics a Reality — TDWI -The Data Warehousing Institute.