Access, DB2, Oracle And Mysql Advantages And Disadvantages

Great Essays
Register to read the introduction… Each offering has both advantages and disadvantages and this paper cannot do justice to the amount of information available in regards to the technical capabilities available on the very limited set of offerings described in this paper. Looking at Access, DB2, Oracle, and MySQL would only be the beginning of what an IT department might be tasked with if given a project to determine where a company should spend its capital resources, both time and money, on investing in.  On the other hand, if they were to look elsewhere, what would be the advantage today? Is there enough differentiation to warrant a broader search and investigation? (Sometimes too much study provides little to no additional benefit. Where would you draw the line?) Each available offering need to meet the distinct needs of the corporation implementing the system and each item listed here should be analyzed in great detail to ensure that this investment is not a wasted effort. Some of the items that need to be researched when making a decision include the …show more content…
Each DBMS available on the market today remains there for some reason, whether there be a feature that they only support or an operating system that is specific or that their price is cheap or that their support is better than others is all part of the decision making process. Oracle and IBM DB2 charge some unbelievable prices but there has to be a reason that they stay in business, they offer a service or a feature that others see valuable and are willing to pay them for it, that's the bottom line. I've seen firsthand some of expenses incurred when doing an Oracle database application and while I thought the prices were outrageous I do have to admit that the application did exactly as we specified when it was all said and done. Doing research for a decision such as this is not an easy task and should be taken very seriously. I believe all of the discussed DBMS offerings will be with us for quite a while. Each has a competitive advantage and enough of a following to ensure that they will be here for the long term. As previously stated, you get what you pay

Related Documents

  • Improved Essays

    Nt1310 Unit 4 Test Paper

    • 419 Words
    • 2 Pages

    1. Maintains an exact replica of one disk on another offering 100% fault tolerance. 2. Data redundancy - If one disk fails, data can be recovered from the other. 3.…

    • 419 Words
    • 2 Pages
    Improved Essays
  • Improved Essays

    Selecting the right accounting software for business is a daunting task. There are many applications on the market for the core business function within the company. When deciding which software application to use depends on the type of business you have and the complexity of the core accounting functions in your organization. The basic accounting functions of Accounts payable, receivable and debt collection are all common in an accounting package. Also, you need general ledger, billing and invoicing, and general accounting for purchase and sales orders.…

    • 486 Words
    • 2 Pages
    Improved Essays
  • Great Essays

    Sc300 Unit 3 Assignment

    • 1018 Words
    • 5 Pages

    BUSINESS JUSTIFICATION An alternative to face to face instructions at the collegiate level is the virtual classroom. Many universities offer online courses as part or all of their requirements for degrees in various subject areas. To offer online classes robust interactive internet based software is required allowing students to interact with fellow students and the instructor, complete and submit assignments as well as receive grades.…

    • 1018 Words
    • 5 Pages
    Great Essays
  • Improved Essays

    Ba501 Week 1 Assignment

    • 740 Words
    • 3 Pages

    BA501 Overview of Business Intelligence Week 1 Assignment David Nagus Grantham University Professor Jackson May 6, 2015 I Introduction With any business with a database system there are bound to be changes and different metrics used in the decisions of running a business. These days almost all businesses have a computer system or network of computers that are interlinked. One aspect of a business is how they secure their network and who has access to data and who does not. On a almost daily basis businesses are being targeted with threats from outside sources to steal data, cause harm or disrupt the daily workings of a business and affecting people's lives.…

    • 740 Words
    • 3 Pages
    Improved Essays
  • Improved Essays

    The Louisiana Health Information Exchanged (LaHIE) launched in 2011 is a secured, standardized electronic system that allows for the sharing of important health information within the state and eventually across states. They are partnered with Orion Health a software company that works globally with companies to meet their software needs. LaHIE has a web-based access system that allows access to health records with an iPad, personal computers and PC networking. It has a Hybrid Program meaning it uses a paper record system as well as electronic system that helps the state with overwhelming health care expenses improving in the electronic access and sharing of medical records using a network that is secure and confidential. This program also…

    • 735 Words
    • 3 Pages
    Improved Essays
  • Improved Essays

    Grant Enterprises is considering an opportunity cost, “where one will choose one alternative over another and are relevant costs for decision-making purposes” (Sawyer, Jackson & Jenkins, 2013, p. 10). What elements will management need to consider to make a relevant decision about a new product? Marketing could survey the marketplace to get a fill for how a new product could be received. This data would be useful in determining a possible price; manufacturer suggested retail price range, discounts for volume purchases and acceptance and likely demand. Marketing will need to understand the products general deign and function to provide a marketing campaign portfolio, ultimately providing the material needed by the sales department.…

    • 372 Words
    • 2 Pages
    Improved Essays
  • Improved Essays

    Nt1310 Unit 7 Pestel

    • 414 Words
    • 2 Pages

    The three companies have a product which caters the requirement of the company that has 250 members who shared 12TB of data and 3TB for database. The systems needs to handle Microsoft server enterprise, email applications, and Microsoft SQL. The selection of a system should be done keeping the requirements in mind. In case of a small enterprise where a team of 15 members handle server. The basic server having atom processor would suffice the requirement.…

    • 414 Words
    • 2 Pages
    Improved Essays
  • Improved Essays

    EGT1 Task 2

    • 731 Words
    • 3 Pages

    “What is the minimum set of measures necessary to demonstrate your project has achieved its benefits? How much to measure?” “Where should we measure?” “How to Present the…

    • 731 Words
    • 3 Pages
    Improved Essays
  • Improved Essays

    PESTE Economic One of the most important things to consider when analyzing the case is the input…

    • 1569 Words
    • 7 Pages
    Improved Essays
  • Improved Essays

    Considering all there is to accomplish when choosing to move from a paper-based medical record to the electronic health record, the organization must first assess their readiness for this new practice. Gathering an analysis of the current system is a huge undertaking, and the organization must look at all aspects, such as administrative, financial, structural, and clinical processes and collection of data. In doing so, they will be able to determine what works well or needs improvement and whether the technology will improve their processes. Rather, what is it that they envision for their patients and staff for the future? Next, they must set specific goals that are attainable and relevant to their practice.…

    • 292 Words
    • 2 Pages
    Improved Essays
  • Great Essays

    Data-centric and process-centric integration are both parts of the integrated structure that Carrier has defined. He defined in 1999 that data-centric is the automation and integration of data, and those data can be exchanged between the information system. Process-centric, on the other hand, is more of involving data and applications together at all levels. Linthicum, Morgenthal and La Forge believes that process-centric integration is the highest level of integration for the business. They are two different integration and organizations can choose what kind of integration structure to use based on what the goal of the organization is since there are pros and cons to both of the integration.…

    • 1110 Words
    • 5 Pages
    Great Essays
  • Brilliant Essays

    Now, assume that sufficient evidence exists to support the selling price of $95,000 for the assembly line system. However, there is some concern regarding the $12,000 charged for the installation services that ALI heard about from a prior customer. What type of analysis must be done related to the $12,000 price for installation services to decide whether it should be used to allocate revenue to the components in the sales agreement? Explain your answer. 4.…

    • 1851 Words
    • 8 Pages
    Brilliant Essays
  • Great Essays

    Name Muhammad Shahzad (73537) Who are Agero constituents? Broadly speaking Agero has four different types of constituents which are mentioned below • Drivers • Service provider • OEM • Insurance Companies…

    • 1277 Words
    • 6 Pages
    Great Essays
  • Great Essays

    Perfect Pizza, Inc.

    • 1254 Words
    • 6 Pages

    Perfect Pizza, Inc., a regional pizza delivery shop with multiple locations, has decided to implement a new online ordering system that will allow customers to place orders online, and allow in-house staff to enter orders into the same system, which is also integrated into the organization’s inventory and accounting systems. The hope is that this will increase sales and improve the efficiency of the ordering process. What is the purpose of performing a feasibility assessment?10 Please identify and briefly explain10 five (5) types of feasibility typically addressed in a Baseline Project Plan. Using the Perfect Pizza ordering system project above, please provide an example of an issue that should be addressed for each type of feasibility.10…

    • 1254 Words
    • 6 Pages
    Great Essays
  • Improved Essays

    Information System Briefing Maria Espinosa, Thomas Gordon, Vanessa Best, and Jason Lacher HCS/483 November 16, 2015 Information System Briefing This briefing will grant the ability to explain the process, selection, acquisition of an information system. Our team has provided our healthcare organization’s goals which makes a huge impact of selection process.…

    • 876 Words
    • 4 Pages
    Improved Essays