preview

PT2520 Week 4 Essay 4142015

Decent Essays

PT1420 WEEK 4 ESSAY

Implementing Physical Design

Max Haney

4/14/2015

PT

Oracle 11G
MySQL
IBM DB2
Microsoft SQL Server 2008
Operating Systems Supported
Runs on Windows, Linux, and Unix operating systems
Unix Linux, Windows, OS X, IOS, BSD, Amigos, Symbian, z/OS, IOS, Android
Unix Linux, Windows, OSX, IOS
Windows
Interface Supported
API & GUI & SQL
GUI & SQL
GUI & SQL
GUI & SQL
Stored Procedures basic PL/SQL block structure
API
Remote physical table, STOCK.
Transact-SQL
Latest Stable Version and Year of Release

1979-2011
12c Release 1

2008 R2 (v10.5)
1995-11
5.6.21

10.5

1983
1989

2014 (12)

Advantages
Max binary value size - unlimited
Brute force protection - Supported
Max database size …show more content…

On most Linux distributions the package management system can download and install MySQL with minimal effort, though further configuration is often required to adjust security and optimization settings.
Though MySQL began as a low-end alternative to more powerful proprietary databases, it has gradually evolved to support higher-scale needs as well. It is still most commonly used in small to medium scale single-server deployments, either as a component in a LAMP-based web application or as a standalone database server. Much of MySQL's appeal originates in its relative simplicity and ease of use, which is enabled by an ecosystem of open source tools such as php MyAdmin. In the medium range, MySQL can be scaled by deploying it on more powerful hardware, such as a multi-processor server with gigabytes of memory.
The master server synchronizes continually with its slaves so in the event of failure a slave can be promoted to become the new master, minimizing downtime. Further improvements in performance can be achieved by caching the results from

Get Access