Common practices to determine what database technology to use [closed]

General Tech Technology & Software 2 years ago

0 2 0 0 0 tuteeHUB earn credit +10 pts

5 Star Rating 1 Rating

Posted on 16 Aug 2022, this text provides information on Technology & Software related to General Tech. Please note that while accuracy is prioritized, the data presented might not be entirely correct or up-to-date. This information is offered for general knowledge and informational purposes only, and should not be considered as a substitute for professional advice.

Take Quiz To Earn Credits!

Turn Your Knowledge into Earnings.

tuteehub_quiz

Answers (2)

Post Answer
profilepic.png
manpreet Tuteehub forum best answer Best Answer 2 years ago

Supposing I've started a new project that needs a database for persistence purposes.

What are common practices to determine which database technology (MSSQL, MySQL, MongoDB, etc...) would best fit the requirements of the project?

What are important considerations to keep in mind when looking for a proper database technology?

profilepic.png
manpreet 2 years ago


Adding a no-answer as I don't know of a formal method for choosing a database architecture (remember you buy a architecture with special backup requirement, HA feature, hardware requirements). Basically it boils down to

  • You need the optimal database for the enterprise not only your project (If a "optimal" database for your project would be DB2 on AIX is of no use to your project if all your operating team does only Windows and SQL Server)
  • Do you need HA? which one? Switchover? active-active?
  • What type of disaster recovery do you need?
  • Formal (e.g. customer requirements, supported OS) and legal requirements
  • What type of infrastructure is on the customer site (SAN? virtualization? cloud?)
  • Monitoring? Backup? (If your backup software does not support a RAC database or the modules for backing it up cost more than the rest of your project, it's pointless to use that database. Same is valid for monitoring
  • Skill of your operating teams
  • type of data (Geodata?) Is it business critical? (your HR has slightly different impact than a simple database the tags on your website
  • amount of data

There is a whole lot more to consider but in my experience these are good starting points.


0 views   0 shares

No matter what stage you're at in your education or career, TuteeHub will help you reach the next level that you're aiming for. Simply,Choose a subject/topic and get started in self-paced practice sessions to improve your knowledge and scores.

tuteehub community

Join Our Community Today

Ready to take your education and career to the next level? Register today and join our growing community of learners and professionals.

tuteehub community