Preview

PT2520 Week 4 Essay 4142015

Good Essays
Open Document
Open Document
664 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
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,


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
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Good Essays

    PHIL240 Essay Set 2 101113
    • 747 Words
    • 3 Pages

    PHIL240 Essay Set 2 101113

    1) Describe the “minimal” facts approach to the resurrection question. Be sure in your answer, to provide a general description and outline of this approach when applied to the resurrection of Christ. Do you agree or disagree with this approach?…

    • 747 Words
    • 3 Pages
    Good Essays
    Read More
  • Powerful Essays

    Final Exam Review Questions
    • 1917 Words
    • 8 Pages

    Final Exam Review Questions

    A database language must enable the user to create database and table structures to perform basic data management chores.…

    • 1917 Words
    • 8 Pages
    Powerful Essays
    Read More
  • Good Essays

    Week Five Essay PM 3110
    • 1317 Words
    • 4 Pages

    Week Five Essay PM 3110

    The changes into the project will be introduce when I have research the hole project, in general this may not be a problem. (Pinto 2010 p. 213) it has a way to build the model for considering the introduction for the change. “What, Who, when, and why is a way to star brain storming and find the many ways that it can be altered with efficiency. The model also calls for research into the Managerial Contingency, Mitigation Strategies, Control and Documentation…

    • 1317 Words
    • 4 Pages
    Good Essays
    Read More
  • Good Essays

    Pos 220 Take Home Essay 1
    • 421 Words
    • 2 Pages

    Pos 220 Take Home Essay 1

    In Arizona, the state legislature is a citizen legislature. What that means is instead of having career politicians running the legislature, Arizona’s legislature is run by the citizens. A legislator in Arizona must be at least 25 years of age, an Arizona resident for three years, a county resident (of the county they wish to represent) for one year, a registered voter, and English proficient. These qualifications are weak when you consider the qualifications for President but, Arizona sought to be-rid career politician for fear that they would become corrupt. Arizona’s citizens also wanted someone they could relate to so most legislators are small business owners or work in real estate, banking, or insurance. The term limits for legislators contradict the want to be-rid career politicians. A legislator only has to sit out of the election for a two year term then they can run for office again. Because of this contradiction I feel they should not have a raise. Not only were the legislators intended to be part-time, they were intended to be regular citizens. A raise would make it easier to have full-time, career politicians. Although $24,000 is a mere amount for a full time job, being an Arizona state legislator is not a full time job. However, one could argue that the time spent in meetings as a legislator when the rules were made is in fact different and more time consuming now. When Arizona first became a state the legislature was only in session for roughly 100 days. In 2010, the legislature was in session for 217 days. That means the legislators only had 148 days for the other job they were committed to. Even though they seem to not have time for the other job, they should have taken into consideration that the governor can call special meetings that the legislator has to be present for. These meetings could last a couple days to a couple months. That hardly seems like a schedule most people would be willing to keep up with. But, I feel that the original…

    • 421 Words
    • 2 Pages
    Good Essays
    Read More
  • Powerful Essays

    Database Plan for Riordan Manufacturing Material Ordering
    • 2376 Words
    • 10 Pages

    Database Plan for Riordan Manufacturing Material Ordering

    References: Rob, Peter and Coronel, Carlos. (2005). Database Systems: Design, Implementation, and Management. United States: Thomson Course Technology.…

    • 2376 Words
    • 10 Pages
    Powerful Essays
    Read More
  • Better Essays

    HUM3321 Capstone Essay
    • 1631 Words
    • 7 Pages

    HUM3321 Capstone Essay

    Over the years, racial stereotypes have evolved from being offensive preconceptions regarding race to be humorous generalizations. They now serve as a source of entertainment in movies, TV shows, and other forms of media. By presenting these stereotypes as entertaining elements in popular media they shed light on real racial problems in our society today in an unaggressive manner. In Guess Who (2005) Percy Jones and Simon Green’s dysfunctional relationship is used to identify the underlying racial tensions between African American’s and Caucasians, including the issues about employment, physical characteristics, and lifestyle choices; Simultaneously, director Kevin Sullivan sends the message that the issues presented in the movie are not specific to one race, but rather to our society as a whole.…

    • 1631 Words
    • 7 Pages
    Better Essays
    Read More
  • Better Essays

    Avaya: Best Reporting, IP Contact Center
    • 980 Words
    • 5 Pages

    Avaya: Best Reporting, IP Contact Center

    In order to have an efficient call center we must deploy an effective system. After evaluating the company needs for an IP PBX solution and diligent research, I have come to the conclusion that the IP PBX system should be based on Avaya IP Office and Aura. These reasons include the experience and connectivity that Ayala provides, as well as Multimedia support and Total cost of the System.…

    • 980 Words
    • 5 Pages
    Better Essays
    Read More
  • Satisfactory Essays

    Assignment 1 Exploring Programming Lang
    • 374 Words
    • 2 Pages

    Assignment 1 Exploring Programming Lang

    I am writing a brief essay on the history of SQL and database developers that have to offer “Express” versions of their database. SQL that is also known as Structured Query Language, is the standard language used to communicate with a relational database. The model was originally developed by IBM using Dr. E.F. Codd’s paper as a model of data for large shared data bank. In 1979, not long after IBM’s prototype, the first SQL product, Oracle, was released by Relational Software, Incorporated.…

    • 374 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Essay 1.1
    • 778 Words
    • 4 Pages

    Essay 1.1

    EMILY is a small commercial vessel operated as a passenger launch and skippered charter vessel in and around Port Fraser Harbour.…

    • 778 Words
    • 4 Pages
    Satisfactory Essays
    Read More
  • Better Essays

    Bigdata
    • 3484 Words
    • 14 Pages

    Bigdata

    Zettabyte = 1,000,000,000,000,000,000,000 Bytes Graph based on IDC and UC Berkeley Data Growth Estimates, Source: IDC & CosmoBC.com: http://techblog.cosmobc.com/2011/08/26/data‐storage‐ infographic/…

    • 3484 Words
    • 14 Pages
    Better Essays
    Read More
  • Better Essays

    Firebase Database Vs. Mysql-Aler Case Study
    • 1155 Words
    • 5 Pages

    Firebase Database Vs. Mysql-Aler Case Study

    Starting with the more traditional MySQL, this database system is open source and based on a relational database approach. In relational database management systems…

    • 1155 Words
    • 5 Pages
    Better Essays
    Read More
  • Powerful Essays

    DATABASE MANAGEMENT
    • 1145 Words
    • 5 Pages

    DATABASE MANAGEMENT

    1. MySQL is the world's second most widely used open-source relational database management system (RDBMS). It is named after co-founder Michael HYPERLINK "http://en.wikipedia.org/wiki/Michael_Widenius"Widenius's daughter, My. The SQL phrase stands for Structured Query Language.…

    • 1145 Words
    • 5 Pages
    Powerful Essays
    Read More
  • Powerful Essays

    DBMS
    • 3523 Words
    • 15 Pages

    DBMS

    Structural metadata is about the design and specification of data structures and is more properly called "data about the containers of data".…

    • 3523 Words
    • 15 Pages
    Powerful Essays
    Read More
  • Satisfactory Essays

    sql server notes
    • 36521 Words
    • 147 Pages

    sql server notes

    SQL is a database computer language designed for the retrieval and management of data in relational…

    • 36521 Words
    • 147 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    Database
    • 6803 Words
    • 28 Pages

    Database

    Outside the world of professional information technology, the term database is sometimes used casually to refer to any collection of data (perhaps a spreadsheet, maybe even a card index). This article is concerned only with databases where the size and usage requirements necessitate use of a database management system.[1]…

    • 6803 Words
    • 28 Pages
    Powerful Essays
    Read More

Related Topics