Q:

What are the advantages and disadvantages of using a database?

A:

Quick Answer

There are many advantages to using a database, like a reduction of useless data, increasing consistency and improving data integrity while there are also disadvantages, like requiring lots of time for development and maintenance, substantial startup costs and application programs becoming reliant on the database. Databases can be extremely important tools for managing large amounts of data but they also have their own downsides.

Know More

Full Answer

Data is frequently redundant. There are numerous instances when data quickly becomes superfluous and reaches such massive proportions that it makes the collection almost impossible to use for practical purposes. This is why databases can be so important. They can be programmed to help organize the data, maintain it and even allow users to find exactly what they need without the hassle of having to sift through heaps of information they don't care about. Databases can also provide important security. They keep all of the information in one place. This doesn't just improve the expedience and functionality of various applications, it also protects those applications from being compromised. Databases, once made, also help to save various costs.

The problem with databases, though, is that creating them can be a long, costly venture. Once they are made, they can save money, but databases that are made from scratch can require huge amounts of money. Furthermore, databases oftentimes require hardware and software for their startup, and these things can also rack up big costs. What's also highly disadvantageous is that databases will be hooked up to various application programs. So, if the database is compromised, all of those applications will subsequently suffer.

Learn more about Software
Sources:

Related Questions

  • Q:

    What are some advantages and disadvantages of Oracle database?

    A:

    An Oracle database can run on all major platforms, including Windows and networking protocols. Oracle fully supports all industry standards and provides full support to developers. Other benefits are that Oracle supports online backup and recovery and has a wealth of development tools, covering various stages of the development cycle.

    Full Answer >
    Filed Under:
  • Q:

    What are the advantages and disadvantages of Microsoft Word?

    A:

    Some advantages of Microsoft Word are that it is widely used, has many training options available, offers users a variety of reading modes, works on mobile devices as well as computers, can access documents from the cloud, supports various file formats and lets users add multimedia to their documents. Some disadvantages are that the program can be costly and that it can take some time to learn to use the program's interface and features.

    Full Answer >
    Filed Under:
  • Q:

    What are the advantages and disadvantages of MRP systems?

    A:

    The advantages of MRP systems include the abilities to minimize inventory levels, reduce carrying costs, track material requirements, allocate production time and organize future capacity needs. The disadvantages of MRP systems include dependence on accurate input information, their time-consuming nature and the expensive cost of implementing the system. The primary functions of MRP systems include inventory control, production planning, scheduling and organization.

    Full Answer >
    Filed Under:
  • Q:

    What are the advantages of using Microsoft Excel?

    A:

    Microsoft Excel is a spreadsheet program that allows users to quickly log, sort and analyze data. To use Excel to its full functionality, users must be familiar with the basic formulas and commands Excel uses to find trends or make projections.

    Full Answer >
    Filed Under:

Explore