InhaltsangabeChapter 1: Understanding the Challenges of Data MigrationThis chapter helps the reader understand the different components of any migration of data. This includes changing the format, changing the way the data is referenced and referred to internally, and the basic mechanics of getting the data in in the first place.Chapter 2: Data Mapping and TransformationsThere 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 considerations are driven by the source database, and others by the target database. Moving data from RDBMS to a NoSQL database, for example, generally requires constructing documents from what might be tabular, or joined-tabular, data. The other aspect is the difference between source and target data types. Document databases and Big Data stores tend not to care about the data type, whereas RDBMS cannot live without them. In this chapter we’ll examine some of the key differences and problems with transferring data that transcend the mechanics of the process, and how to deal with them effectively.Chapter 3: Moving Data for RDBMSRDBMS systems have a unique place in the world of data; they are universally accepted and very popular (Oracle, MySQL, Microsoft SQL Server). Their tabular structure makes them look easily exchangeable. but they require careful techniques when sharing the data. In this chapter, we’ll examine some of the key issues with migrating data to and from RDBMS, including: - Exchanging table data Exchanging complex queries Preparing for twoway transfers Row, Statement, or Other Chapter 4: Migrating for RDBMS using Export/ImportExport and import is the simplest and most readily used method for sharing and exchanging data, but there is more to it than just dumping the information. You need to consider formatting and structure, and whether you want identical tables, or a complex structure exchanged. We’ll examine a variety of techniques, from base export, character separated/delimited types, and structured organization like JSON. The chapter also covers choosing a file format and dealing with raw table data or joined structuresChapter 5: Sharing Data for RDBMS through ReplicationReplication is the purest and simplest form of sharing data, but it is not without its limitations or problems. Most replication is designed to handle scale-out environments, not data sharing, but there are solutions and tricks that make replication a suitable alternative for exchanging data. But how do you cope with changes to the original schema once it reaches its target database. How do you make it usable and match the target environment? That’s what this chapter explains. It will cover: - Replicating between RDBMS Replicating out of RDBMS Replicating in to RDBMS Chapter 6: Integrating Data for RDBMS through ReplicationData integration is about actively sharing and exchanging data—not just replicating it, but actually using different formats and data sources. Using the methods described in this chapter, you’ll learn how to exchange data and even share information between an RDBMS and other data types, including methods for running queries and joins across the different types. We’ll also look at solutions for building applications that can natively integrate and share this information according to the application needs. This allows an application to combine the RDBMS data alongside an internal representation that may be suitable for document-based storage and has the capability to merge that back again. Chapter 7: Moving Data for NoSQL DatabasesNoSQL databases cause problems for traditional RDBMS types because the data is not often defined or stored in the same structured format. NoSQL encompasses everything from key/value

A professional writer for over 15 years, Martin (MC) Brown is the author and contributor to more than 26 books covering an array of topics, including the recently published Getting Started with CouchDB. His expertise spans myriad development languages and platforms: Perl, Python, Java, JavaScript, Basic, Pascal, Modula-2, C, C++, Rebol, Gawk, Shellscript, Windows, Solaris, Linux, BeOS, Microsoft WP, Mac OS and more. He is currently senior information architect for Continuent.