PT2520 Week 4 Essay 4142015
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 -UNLIMITED
8 KB- Row sizes
Max database size and table size 524528 TB
Row sizes are unlimited
Max columns a table can have 30000
512 TB table size
32677B Row size
Open source license
Disadvantages
4 GB table sizes
Max columns a table can have 1000
Does not support Unix or Mac OS
Max binary value size 2 GB
Max database size 512 TB
Max columns a table can have 1012
Max binary value size 2 GB
I would think that have to choose MySQL would be the best fit for Wild Wood Apartments. It may run higher in query testing but the overall processes and structure would work better for a small to medium size company. It meets all the requirements that the Wild Wood Apartments has for operating systems, table and row size, Much of MySQL's appeal originates in its relative simplicity and ease of use. This will be necessary for people who are not use to using this type of system.
MySQL is a free, open-source, multithreaded, and multi-user SQL database management system which has more than 10 million installations. The basic program runs as a server providing multi-user access to a number of databases. MySQL includes a broad subset of ANSI SQL 99, as well as extensions, cross-platform support, stored procedures, triggers,
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 -UNLIMITED
8 KB- Row sizes
Max database size and table size 524528 TB
Row sizes are unlimited
Max columns a table can have 30000
512 TB table size
32677B Row size
Open source license
Disadvantages
4 GB table sizes
Max columns a table can have 1000
Does not support Unix or Mac OS
Max binary value size 2 GB
Max database size 512 TB
Max columns a table can have 1012
Max binary value size 2 GB
I would think that have to choose MySQL would be the best fit for Wild Wood Apartments. It may run higher in query testing but the overall processes and structure would work better for a small to medium size company. It meets all the requirements that the Wild Wood Apartments has for operating systems, table and row size, Much of MySQL's appeal originates in its relative simplicity and ease of use. This will be necessary for people who are not use to using this type of system.
MySQL is a free, open-source, multithreaded, and multi-user SQL database management system which has more than 10 million installations. The basic program runs as a server providing multi-user access to a number of databases. MySQL includes a broad subset of ANSI SQL 99, as well as extensions, cross-platform support, stored procedures, triggers,
References: © The Authors JCSCR. (2012). A Comparative Study on the Performance. LACSC – Lebanese Association for Computational Sciences Registered under No. 957, 2011, Beirut, Lebanon, 1-12. Wikimedia Foundation, I. (2014, 10 13). From Wikipedia, the free encyclopedia. Retrieved from From Wikipedia, the free encyclopedia: http://en.wikipedia.org/wiki/MySQL