Posts

Showing posts with the label MySQL

Comparison of different DataBase Management Systems (DBMS)

COMPARISON OF DIFFERENT DBMS DBMS ADVANTAGE LIMITATIONS STORAGE CAPACITY APPLICATION Microsoft SQL server Easy to setup Handles complicated queries Execution of long queries take more time. It needs a new firewall protection system. Database size upto 5,24,272 terabytes Used to store website information or blogspot information. MySQL Low cost Data development process is adjustible for small and heavy application. It's compatible with upto date industry's DBMS packages Overdependence on third party add-ons. Queries get stuck even after a refresh or restart. Database size upto 65,536 TB Used for storing sales records in table format. Amazon RDS Has flexibility and scalable storage options. Heavy workloads can be processed in a single database. It can get access to