Databases today are not stand-alone silos of discrete data. Instead, data is moved and shared between multiple databases and systems. Some of this is performed for operational reasons, such as when you need to take advantage of NoSQL databases for web performance, while at the same time storing the long-term data in traditional RDBMS. At other times, you need to migrate data between systems. Finally—and more often now than ever—you need to move data between systems to take advantage of specific features, such as merging data into Big Data stores (like Hadoop) for analytics, then moving the data back into a traditional RDBMS or NoSQL environment for display and analysis.
Moving data can be difficult. Yet, as Moving Data: How to Move, Share, and Integrate SQL, NoSQL, and Big Data shows, there’s always a method to accomplish the task at hand. Database expert MC Brown covers a range of solutions and techniques for moving, migrating, sharing, and integrating data between different databases and environments. He also shows how to transform the data between different representation formats, and how to automate or set up live replication of this data between the different databases systems.
The information couldn’t be more timely, as the need to move data around to accomplish specific tasks continues to grow with no letup in sight. As a result, the specialized skills you’ll learn from this book are soon going to be required for database administrators, IT professionals, and database architects, among others. You’ll learn how to:
- Migrate data to and from RDBMS
- Move data from RDBMS to NoSQL databases
- Move or migrate data into or out of Big Data stores
- Integrate Big Data sources with applications and databases
Best, the book is specially designed to provide both generic advice for each database solution, and more specific advice for different combinations. For example, there is generic advice about how to handle the idiomatic structure of an RDBMS, but also more specific advice for permanently migrating data from an RDBMS to a NoSQL store, for replicating data between these two stores, and finally for using both systems concurrently.
Moving Data covers territory found in no other book; it is an essential go-to reference for anyone charged with moving data among systems successfully.
What youll learn
- The fundamental database architectures and differences that create challenges to moving or migrating data
- How to export, import, and share data among RDBMS, NoSQL databases, and Big Data stores
- How to replicate and exchange data in real-time between different database systems
- How to cope with data format and transformation challenges when moving data
- How the migration and sharing of data can improve your business goals, performance, and data-processing needs
Who this book is for
Database administrators, IT managers, and implementors of database systems and big data environments, including most modern website and database-driven organizations.