Advertisement

Migrating Oracle Database

  • Deepak Vohra

Abstract

MongoDB is the leading NoSQL database. MongoDB stores documents using the BSON (binary JSON) data format, which is the most flexible of data models with provisions to create hierarchies of data structures. Oracle Database stores data in a fixed schema table format. The database models of the two databases are vastly different: MongoDB being based on Document store while Oracle Database is based on the fixed table format with two-dimensional matrices made of columns and rows. In this chapter we shall migrate an Oracle Database table to MongoDB Server. While a direct migration tool is not available for migrating from Oracle to MongoDB, the latter provides an import tool called the mongoimport tool for importing data from a CSV, TSV, or JSON file into a MongoDB database. We shall first export Oracle Database table to a CSV file. Subsequently we shall import the CSV file data into MongoDB Server using the mongoimport tool. This chapter covers the following topics.

Keywords

Server State Table Format Database Model Running Mode Oracle Database 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Supplementary material

978-1-4842-1598-2_8_MOESM1_ESM.zip (0 kb)
Ch8 (zip 1 kb)

Copyright information

© Deepak Vohra 2015

Authors and Affiliations

  • Deepak Vohra
    • 1
  1. 1.BCCanada

Personalised recommendations