A correlation of MySQL And Oracle .

Uploaded on:
Category: Medical / Health
Significance of picking the right database. High cost for a venture systemDatabases can hold the
Slide 1

A correlation of MySQL And Oracle Jeremy Haubrich

Slide 2

Importance of picking the privilege database High cost for a venture framework Databases can hold the "keys to the palace" Databases can give organizations an upper hand

Slide 3

Direct examination isn\'t reasonable Oracle and MySQL are worked for various markets Oracle is intended for the endeavor client with a sufficiently major spending plan and more unpredictable business needs MySQL is a lower cost database that is most normally utilized for database driven sites and non mission basic applications Features that seem to be indistinguishable in a pamphlet might be actualized in an unexpected way (ex. push level locking)

Slide 4

Cost Oracle $36,000 per processor for Enterprise Edition + discretionary $8,000 for support and programming overhauls $5,000 per processor for Standard Edition + discretionary $1,100 for support and programming redesigns MySQL Free to download $500 for a business permit + discretionary $1,500-$62,000 for various levels of support

Slide 5

Oracle Features Oracle Management Server Central organization, checking, and tuning of different databases Schedule and impart database errands to different administrators Oracle Change Manager Allows you to make a change plan and see the impacts of your progressions before really actualizing them Also demonstrates any progressions that can\'t be connected Administrative Alerts Oracle will contact the administrator by email or pager when a mistake condition happens Can be booked to decrease false positives

Slide 6

More Oracle Features Capacity Planning Tracks use examples to help administrators anticipate updates Feedback on CPU, circle and inquiry execution Query Optimizer Oracle picks the most effective approach to execute a SQL articulation Analyzes tables and files to limit the cost of the exchange

Slide 7

MySQL Features Easy to begin with Many free GUI administration instruments like PHPMyAdmin Speed is underscored over lesser utilized components Uses almost no overhead MySQL utilizes just shy of 1MB of RAM on my tablet My Oracle 9i establishment utilizes 128MB while sit out of gear

Slide 8

More MySQL Features Beginning to bolster propelled highlights Stored Procedures, Triggers, Views in the following form (5) Select proclamations with sub-questions were presented in the present rendition (4) Transactional tables Cascading upgrades and erases Available through the outsider InnoDB stockpiling motor

Slide 9

Migragtion from MySQL to Oracle As your organization develops Oracle might be a superior fit Migration devices are accessible (Oracle Migration Kit) Companies may utilize both Oracle and MySQL

Slide 10

Differences in linguistic structure http://troels.arvin.dk/db/rdbms/Not all databases utilize the same SQL grammar Example: Returning the initial 5 lines of a question MySQL Select sections FROM tablename ORDER BY key ASC LIMIT 5; Oracle Select * FROM ( SELECT segments FROM tablename ORDER BY key ASC ) WHERE ROWNUM <= 5;

Slide 11

Timestamps MySQL Create a field of sort TIMESTAMP and enter an invalid date. For this situation February 29 2003. mysql> embed into analyzer values (\'2003-02-29 00:05:00\'); Query OK, 1 push influenced (0.07 sec) Notice that MySQL doesn\'t gripe about the date. Verifying what MySQL enters you see that it simply changed the date to the main day in March. mysql> select * from analyzer; + - + | time | + - + | 20030301000500 | + - + 1 push in set (0.00 sec)

Slide 12

Timestamps Oracle This will work,    INSERT INTO tablename (columnname)    VALUES (TIMESTAMP\'2003-02-28 00:05:00\') while this will fizzle:    INSERT INTO tablename (columnname)    VALUES (TIMESTAMP\'2003-02-29 00:05:00\' )

Slide 13

Concatenation SQL Standard image for concat is || MySQL utilizes || as the OR administrator Uses concat(string1, string2) More commonplace to software engineers Breaks the standard Oracle utilizes || for concat Ex. string1 || string2

Slide 14

Which is better? MySQL For non mission-basic situations Great for database empowered sites Attractive value point Oracle Rock strong steadfastness, dependability, and elements Steep expectation to absorb information and costly Designed because of the venture

View more...