A database management system (DBMS) is a program, or collection of programs, thr
ID: 3843415 • Letter: A
Question
A database management system (DBMS) is a program, or collection of programs, through which users interact with a database. Popular DBMSs include Access, Oracle, DB2, MySQL, and SQL Server. Access currently is the most popular DBMS for use with personal computers. There are versions of Oracle, DB2, MySQL, and SQL Server that run under Windows, Unix, and Linux as well as mainframe operating systems.
Pick a DBMS and research its strengths and weaknesses. If you have had experience with one or more, provide insight on what you think it is best designed for and which areas are lacking.
Why would one choose one DBMS over another? Which applications and services would you choose one DBMS over another?
Explanation / Answer
Answer:
The database which we are experienced is with mongodb.The strengths of mongodb database are it can store any kind of unstructured data in JSON format and it is a schema less database and it supports aggregation for executing queries which are long and the weaknesses includes it does not support joins concept like relational databases and also the transaction concept is also not supported.It is used in many cases of balancing the data in the clusters is done automatically and data is divided with in the constarints of hardware.The process of replication of data is also easy as no human effort is needed to replicate the data automatically when any of the data sets goes down.The areas of mongodb database lacking are providing support for transaction and joins concepts and also the amount of data stored is huge as it can store any kind of unstructured data so sometimes it may lead to effect the performance.The reason we can choose mongodb database over other databases are if the requirement is as such no joins and transactions exist but only the data which is of huge amount which is of structured or semi structured or unstructured which consists of documents of JSON needed to be stored in database then we can choose mongodb than other relational databases.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.