Oracle vs Mysql, how they implement concepts of database.

15 pts.
Tags:
MySQL
Oracle
I am confused between oracle and mysql how they implement databases philosophy. In oracle is user means database and in mysql why do we have only root password unlike oracle. Is database more secure in oracle compared to MySQL. 

Software/Hardware used:
Oracle vs mysql

Answer Wiki

Thanks. We'll let you know when a new response is added.

When it comes to security they are pretty much equal. That is as long as they are set up properly.  MySql has a max database size of 256T and oracle like to process in blocks, to see there limits check out this Oracle link 

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Subhendu Sen

    This is basically depends on database's own mechanism. How they offer to enter their own interface for starting work. While SQL Server offers GUI method to start working. No, Oracle & MySQL, both provide a good security system. Generally, Oracle can use for a large database system. By the way, are you going to design database design for your organization? Or it is a part of your home work?

    120,190 pointsBadges:
    report
  • Subhendu Sen
    120,190 pointsBadges:
    report
  • Tech2rp
    Thanks for replying........... 

    Actually i am from Java background so I didn't take database very deeply.I worked mostly with mysql.  Now I have my personal project to develop so I come across to understand mysql and oracle. So while trying to understand oracle I come across to two concepts User and Schema. So these two terms confusing me. Many article describes user and Schema are both same thing than question is that if both are same thing then why do have two different concept. 
    15 pointsBadges:
    report
  • Subhendu Sen
    As you mentioned, you are a Java programmer and mostly work with MySQL, it is better to go for MySQL for your personal project. That does not mean, you never experience with new software.
    120,190 pointsBadges:
    report
  • TheRealRaven
    User vand Schema might be thought of in terms of driving cars. A 'User (driver)' is someone who has obtained a driver's license -- this person is allowed to drive cars on public rights-of-way. A 'Schema' is a particular car -- perhaps most 'Users' have their own personal 'Schema' (or 'car').

    Even though a car 'User' (driver) has a personal 'Schema' (car), the 'User' (driver) may be authorized to use someone else's 'Schema' (car). Further, the 'User' may grant authority for others to use his/her 'Schema'.

    But there's a significant difference between databases and driving. One reason that the two concepts get tied together for databases is that creating a 'User' will often cause a 'Schema' to be created for that 'User'. A 'Schema' is a collection of definitions used to create objects in a personal database. As tables and views are created by the 'User', they get created as objects inside of the 'Schema'.

    Of course, when a driver is licensed, there is no car that is automatically handed over for personal use.
    28,945 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: