Categories

See More
Popular Forum

MBA (4887) B.Tech (1769) Engineering (1486) Class 12 (1030) Study Abroad (1004) Computer Science and Engineering (988) Business Management Studies (865) BBA (846) Diploma (746) CAT (651) B.Com (648) B.Sc (643) JEE Mains (618) Mechanical Engineering (574) Exam (525) India (462) Career (452) All Time Q&A (439) Mass Communication (427) BCA (417) Science (384) Computers & IT (Non-Engg) (383) Medicine & Health Sciences (381) Hotel Management (373) Civil Engineering (353) MCA (349) Tuteehub Top Questions (348) Distance (340) Colleges in India (334)
See More

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

General Tech Technology & Software
Max. 2000 characters
Replies

usr_profile.png
Naveen Shastri

User

( 4 months 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?

usr_profile.png
Charles Kyobe

User

( 4 months 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.

what's your interest


forum_ban8_5d8c5fd7cf6f7.gif