Hi, On Tue, 2002-02-19 at 16:25, S Aravind wrote: > My company has developed a project using Java and > Oracle. The client for whom the project has been > developed wants mySQL. As a member of the team, I've > been asked to find out the basic differences between > Oracle SQL queries and your mySQL queries. I tried my > level best on all search engines, but not in a > position to get a clear answer. > > Could you help me out solve this problem? I'm > reponsible for giving a presentation that shows the > basic and core differences. > > I shall be beholden and obliged. Honestly I'm also new > for mySQL.
It's not as easy as that, I'm afraid ;-) Yes they are both RDBMS, but the number of features and options in both are so large and diverse that a simple comparison won't do justice to either. You also have to realise that it is not MySQL's objective to be an Oracle clone, MySQL has its own roadmap, priorities and strengths. And of course if you look at from the Oracle angle, then it will quickly be apparently that some features are "lacking" in MySQL. The question is though.... do you want or need those particular featues? You're dealing with an existing application, so what you'll want to look at is which features it uses that may be implemented differently on MySQL, or not supported. Then, point by point, you'll want to find out how difficult it would be to work around these differences. Naturally, if your application is stuffed full with views, stored procedures, triggers and subqueries, the outlook might be a bit bleak if you're in a rush. But I'll bet that your app is not like that.... it's quite likely to be using some subqueries (since that is what people are used to writing), but lots of those can be easily rewritten with joins in a single select, and the rest can be recoded as multiple SELECTs, possibly using MySQL's very nice support for temporary/heap tables. So what do you get with MySQL? - Low system (CPU/RAM/HD) requirements and fairly easy installation. - Low total cost of ownership. (Either or both of these may be particularly important to your clients!) - Professional support, consulting, training available. - You can get fairly direct contact with the developers, and that's something Oracle won't be offering you ;-) - Quick resolution of bugs, patches immediately available. - Very fast support, naturally depending on support contract. - Speed. Of course this depends on how you design your application. - Special features, particularly useful in for instance web applications (like the LIMIT clause, replication, the query cache, etc). - Full ACID transactional support with multi-versioning/row-level locking, using the InnoDB table handler. This is only a small excerpt... have a browse in the online manual (www.mysql.com/doc/) to get more ideas, since you know Oracle you can recognise differences and nice features when you spot them, and take notes. You may wish to contact [EMAIL PROTECTED] to talk about possible assistance for adapting your application, and maybe even for your presentation. Since you said you're new to MySQL, I might also suggest training (www.mysql.com/training/). While MySQL is not difficult to work with, naturally you won't become an instant expert just by taking a quick look at it. You can accelerate this learning curve with training. This may help you both with the decision making process, as well as possible porting. Both consulting and training could speed up either or both processes, which of course would reduce the development costs for you. Hope this helps! Regards, Arjen. -- Get MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
