October 3, 2016 at 8:23 am
Hello all!
I wanna studying Oracle after a long time working with MySQl..
Is really really difficult to work with Oracle?
Does oracle have a lot of difference with Mysql?
thank for watching!
October 3, 2016 at 8:51 am
I'm only somewhat acquainted with Oracle, enough to form an opinion without forming an attachment. In my opinion, Oracle has a lot of "junk in it's trunk" dating back to the 1980s; a lot of cryptic sysadmin commands, old-style SQL syntax, and backward compatibility. In contrast, MySQL is new enough not to suffer from that affliction, and Microsoft periodically deprecates obsolete features from SQL Server (which in my opinion is a good thing). From the perspective of someone coming in new, Oracle's commitment to legacy support is a negative; it makes learning the product more difficult.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 3, 2016 at 9:10 am
To me, they're not really the same thing. MySQL is more of a replacement for xBase than a proper enterprise product, it's certainly nowhere like Oracle or SQL Server in terms of support for critical systems where your data "matters". Obviously though, the price points are also worlds apart.
MySQL is simpler and regarded as faster due to less overhead for smaller projects. For a Mom n' Pop's corner shop online presence where if the site dies you can rebuild it without breaking into a sweat and no great demands on it, MySQL fits the bill. You wouldn't want them to be storing your medical records in it though (at least I would be horrified at the idea). Certainly a paid license version of Oracle would be colossal overkill and as mentioned above would add both cost and complexity to a small project.
If your data is "important", frequently updated with minimal dataloss requirements and transactional and referential consistency, that's where Oracle would come in.
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
October 3, 2016 at 9:38 am
andrew gothard (10/3/2016)
To me, they're not really the same thing. MySQL is more of a replacement for xBase than a proper enterprise product, it's certainly nowhere like Oracle or SQL Server in terms of support for critical systems where your data "matters". Obviously though, the price points are also worlds apart.MySQL is simpler and regarded as faster due to less overhead for smaller projects. For a Mom n' Pop's corner shop online presence where if the site dies you can rebuild it without breaking into a sweat and no great demands on it, MySQL fits the bill. You wouldn't want them to be storing your medical records in it though (at least I would be horrified at the idea). Certainly a paid license version of Oracle would be colossal overkill and as mentioned above would add both cost and complexity to a small project.
If your data is "important", frequently updated with minimal dataloss requirements and transactional and referential consistency, that's where Oracle would come in.
Or you could start with SQL Server Express (free) and do an easy upgrade to Standard or Enterprise.
Here's a link (a bit obsolete) that compares different implementations of SQL database systems. http://troels.arvin.dk/db/rdbms/
October 3, 2016 at 9:52 am
Hmm... the interface for oracle is pretty primitive and very similar to mysql, I hope you like command line 🙂 But on the back end in terms of what the database engine is actually doing and the capabilities you have as a dba you'll very quickly realize you're dealing with an actual enterprise application vs. a freeware application. Just look at the differences in how backups/restores are handled between them to get an idea.
October 3, 2016 at 11:04 am
ZZartin (10/3/2016)
Hmm... the interface for oracle is pretty primitive and very similar to mysql, I hope you like command line 🙂 But on the back end in terms of what the database engine is actually doing and the capabilities you have as a dba you'll very quickly realize you're dealing with an actual enterprise application vs. a freeware application. Just look at the differences in how backups/restores are handled between them to get an idea.
Actually if you use Cloud Control - the latest version of the oracle enterprise manager - then the interface is excellent. You can do pretty much anything without going to the command line.
November 14, 2016 at 6:43 am
FridayNightGiant (10/3/2016)
ZZartin (10/3/2016)
Hmm... the interface for oracle is pretty primitive and very similar to mysql, I hope you like command line 🙂 But on the back end in terms of what the database engine is actually doing and the capabilities you have as a dba you'll very quickly realize you're dealing with an actual enterprise application vs. a freeware application. Just look at the differences in how backups/restores are handled between them to get an idea.Actually if you use Cloud Control - the latest version of the oracle enterprise manager - then the interface is excellent. You can do pretty much anything without going to the command line.
Not only that but the newest Version of SQL Developer is quite nifty. I use it alot and even prefer it to some products such as Toad and DBArtisan....and it is free.
On the other side however, I would recommend learning SQL Server over Oracle. The reasoning here is that more and more companies are making exactly that Switch mainly due to TCO and complexity within the Oracle environment.
After working with both RDBMSs over the last 15 years I have found the learning curve with SQL Server on Windows to be much easier to master than Oracle on *nix. There are companies and organisations that run Oracle on Windows but that is like playing Tennis with a Badminton racket.....a terrible mix.....
November 14, 2016 at 7:37 am
Title of this post:
Difference between MySQL and Oracle? What's better?
Answer: SQL Server. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
November 14, 2016 at 7:42 am
Jeff Moden (11/14/2016)
Title of this post:
Difference between MySQL and Oracle? What's better?Answer: SQL Server. 😉
and thus start the flame wars.... 😀
November 14, 2016 at 8:04 am
kevaburg (11/14/2016)
Jeff Moden (11/14/2016)
Title of this post:
Difference between MySQL and Oracle? What's better?Answer: SQL Server. 😉
and thus start the flame wars.... 😀
No... no flame wars. Considering that the OP has apparently done zero research on the differences of two very different database engines, I thought I'd throw in a third. We can also throw in NoSQL and a ton of other "engines" because no one engine has everything that might ever occur when it comes to "which is better". The OP even appears oblivious that MySQL has two different engines and, unless you need support, is basically free compared to the rather expensive Oracle.
I really am concerned for those companies and people where people post such questions. It means they've done zero homework and there's no way that a single thread like this one could actually answer such a question. You're talking about something the company or an individual career is going to need to live with for a long time so trivial answers on a thread such as this should not be a driving factor in what a company or individual chooses but frequently is, and it's frightening.
Either that or Yabingooglehoo is broke again. 😀
--Jeff Moden
Change is inevitable... Change for the better is not.
November 15, 2016 at 12:59 am
Jeff Moden (11/14/2016)
kevaburg (11/14/2016)
Jeff Moden (11/14/2016)
Title of this post:
Difference between MySQL and Oracle? What's better?Answer: SQL Server. 😉
and thus start the flame wars.... 😀
No... no flame wars. Considering that the OP has apparently done zero research on the differences of two very different database engines, I thought I'd throw in a third. We can also throw in NoSQL and a ton of other "engines" because no one engine has everything that might ever occur when it comes to "which is better". The OP even appears oblivious that MySQL has two different engines and, unless you need support, is basically free compared to the rather expensive Oracle.
I really am concerned for those companies and people where people post such questions. It means they've done zero homework and there's no way that a single thread like this one could actually answer such a question. You're talking about something the company or an individual career is going to need to live with for a long time so trivial answers on a thread such as this should not be a driving factor in what a company or individual chooses but frequently is, and it's frightening.
Either that or Yabingooglehoo is broke again. 😀
I know what you mean with you second paragraph. I actually like Oracle alot. It is hideously complex for the same Action in SQL Server most of the time, basic functions like partitioning, spatial and Real Application Testing cost an enormous amount and are only available as add-ons (even though Oracle ships the functions with the Software...) but I learned the most about databases thanks to the need to know and understand the architecture inside out.
With SQL Server I have found that anyone that can use a mouse and can log on to the database immediately thinks they are an admin (read that for almost every Microsoft product) and they produce the most awful results. There are very few that REALLY put the effort in to learning the concept of a database. This is what I think is most dangerous but then said individuals and companies need to realise that themselves.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply