Homepage Forums Career & Academia MySQL or NoSQL for enterprise level project Reply To: MySQL or NoSQL for enterprise level project

  • Satya Mukherjee

    Administrator
    June 22, 2021 at 11:28 pm
    8836 Coins
    484 Gems
    Helpful
    Up
    1
    Down
    Not Helpful

    First thing to keep in mind is that any NoSQL database is a document database which makes it really difficult to automatically convert a typical relational database like MySQL to a document base db like MongoDB.

    In NoSQL you have a single collection of documents, and each document will probably contain data that would be in related rows in multiple tables. The advantage of a NoSQL redesign is that most data access is simpler and faster without requiring you to write complex join statements.

    If you automatically convert each MySQL table to a corresponding NoSQL collection, you really won’t be taking advantage of a NoSQL DB. This is because you’ll end up loading many more documents, and thus make many more calls to the database than needed and thus loosing simplicity and speediness of NoSQL DB.

    Perhaps a better approach is to look at how your applications use the MySQL database and go from there. You might then consider writing a simple utility script knowing fully well your MySQL database design.

New Report

Close