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

ginortS in Python - HackerRank solution

-
Solution for hackerRank problem ginortS in Python Problem : You are given a string S.  S contains alphanumeric characters only.  'SORTING' Your task is to sort the string S in the following manner: All sorted lowercase letters are ahead of uppercase letters. All sorted uppercase letters are ahead of digits. All sorted odd digits are ahead of sorted even digits. Input Format A single line of input contains the string S. Constraints 0 < len(S) < 1000 Output Format Output the sorted string S. Sample Input Sorting1234 Sample Output ginortS1324 Code : s = str(input()) Upper = [] lower = [] odd_no = [] even_no = [] for i in s:     if(i.isupper()):         Upper += [i]     if(i.islower()):         lower += [i]     if(i.isnumeric()):         if(int(i)%2 == 0):             even_no += [i]         else :             odd_no += [i] Upper.sort() lower.sort() odd_no.sort() even_no.sort() Upper = "".join(Upper) lower = "".join(lower) odd = "".join(odd_no) ev
Read more