PT2520 Week 4 Essay 4142015

678 WordsApr 18, 20153 Pages
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

    More about PT2520 Week 4 Essay 4142015

      Open Document