It is really important to choose the right database to use in your project. There are more than 300 database management systems available in the market. You have a variety of options available on relational ( MySQL, PostgresSQL, OracleDB, etc) and non-relational ( MongoDB, Apache HBase, Cassandra, etc.) database bit you need to understand none of them fits on all kinds of project requirements. Each of them have their own strengths and weaknesses.
Now, here are some key aspects that you need to consider when choosing the right database for your application.
- Integration- it is important thing to know while choosing the right data base is “what system you need to integrate together?” Make share that your database management system can be integrated with other tools and services within your project.
- Scaling requirement- it is really important to know how much database are you really talking about. Most databases are growing unbounded over time, so you need to make sure that your database can handle thousands of users querying terabytes or petabytes of data.
- Support consideration- you need to think about the support you might need for your database. Its going to be harder than you think if you’re using this in the real world. You should have the in-house expertise to spin it up and actually configure it properly.
- CAP consideration- CAP stands for Consistency, means that any read request will return the most recent write. Availability, means that a non-responding node must respond in a retainable amount of time. Lastly, Partition tolerance, means the system will continue to operate despite work or node failures.
You can only pick two out of three at a time and that totally depends on the priorities of your requirements. The type of application will determine what you want to use and only you know the actual requirements.
- Schemas or Data Model- relational databases store data in a fixed and predefined structure. It means when you start to develop you have to define your data schema in terms of tables and columns. You have to change the schema every time the requirements change.
NoSQL database provides much more flexibility when comes to handling data. It doesn’t put restriction on the types of data you can store together. That allows you to add more or need types as your needs change.
Able Home & Office – Mt. Hagen
Unit 3, Dae Won Shopping Center (Opposite Hagen Park Secondary School)
Lots 2, 3, 4 & 9 Section 7, Moka Place Road
Mt. Hagen, Western Highlands Province, PNG
Ph: 542 3188 / 542 1847