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 MySQL , Oracle and Microsoft databases
  • Has limited autoscale options.
 Database size upto 64 TiB( can be extended to 96TiB) Used in mobile and web applications.
Oracle RDBMS
  • Encompasses larger database, takes less space.
  • High data security.
  • Smooth transactional process.
  • Price range is too high.
  • Client applications are often plugged in automatically.
 Database size upto 5GB Used in online transaction processing.
IBM DB2
  • Easy installation.
  • It runs queries more faster.
  • Stores large amount of data instantly.
  • Too much functional features.
 Maximum size of a table per database partition = 64 TB Helps to drive customer personalisation.
Mongo DB
  • Works well in cloud.
  • We can store objects with nested data in one collection.
  • Easy to get started.
  • High data consumption.
 Stores 32 TB data for each database Used in document database(i.e. Aadhar uses Mongo DB to store data).
Maria DB
  • Functions are easy to implement.
  • Stronger security.
  • Has virtual column that performs calculations at database level.
  • Not completely compatible with MySQL.
 Upto 64 TB for each table Used in storage engines(i.e. Google, Mozilla).

Comments

Post a Comment

Popular posts from this blog

Finding the percentage in python - HackerRank solution

-
Solution for hackerRank problem Finding the percentage in python Problem : The provided code stub will read in a dictionary containing key/value pairs of name:[marks] for a list of students. Print the average of the marks array for the student name provided, showing 2 places after the decimal. Example The  query_name  is 'beta'. beta's average score is  . Input Format The first line contains the integer  , the number of students' records. The next lines contain the names and marks obtained by a student, each value separated by a space. The final line contains  query_name , the name of a student to query. Constraints 2<=n<=10 0<=marks[i]<=100 length of marks arrays = 3 Output Format Print one line: The average of the marks obtained by the particular student correct to 2 decimal places. Sample Input 0 3 Krishna 67 68 69 Arjun 70 98 63 Malika 52 56 60 Malika Sample Output 0 56.00 Explanation 0 Explanation 0 Marks for Malika are   whose average is  Sample Input
Read more

HackerRank challenges with solutions (Rearrangement, Formula, Word sorting, Numbers, Sentence)

-
Image
  1.  Rearrangement Given a list A elements of length n , ranging from 1 to n. All elements may not be present in the array. If the element is not present then there will be -1 present in the array. Rearrange the array such that A[i]=i and if i is not present display -1 at that place. Input format : The first line contains a n numbers with each number separated by space. Output format : Print the elements of the list after modification. Sample input : -1 -1 6 1 9 3 2 -1 4 -1 Sample Output : -1 1 2 3 4 -1 6 -1 -1 9 Explanation : The modified list contains elements such that A[i]=i . Code : Output :   2.  Formula Write a program that calculates and prints the value according to the given formula , Q=square root of [(2*C*D)/H]. Following are the fixed values of C and H , C=50 ,H=30. D is the variable whose values should be input to your program in a comma separated sequence. Input format : A sequence of values for D with each value separated by comma. Output format : Print the sequence of
Read more

What's your name, Tuple - HackerRank solution in python

-
Solution for hackerRank problems  What's your name, Tuple in Python. 1. What's your name You are given the first name and lastname of a person on two different lines. Your task is to read them and print the following: "Hello firstname lastname! You just delved into python." Function Description Complete the  print_full_name  function in the editor below. print_full_name  has the following parameters: string first:  the first name string last:  the last name Prints string:  'Hello firstname lastname! You just delved into python' where firstname and lastname are replaced with first and last. Input Format The first line contains the first name, and the second line contains the last name. Constraints The length of the first and last names are each ≤  . Sample Input 0 Ross Taylor Sample Output 0 Hello Ross Taylor! You just delved into python. Explanation 0 The input read by the program is stored as a string data type. A string is a collection of characters. Procedu
Read more