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 the components of a database?

    A:

    Database components include one or more tables for the data, a query language that retrieves specific data elements, and forms for entering or displaying data. Additional components include reporting tools and customized page views of data. Relational databases have a schema that defines the relationship between tables and may include components that automate routine tasks.

    Full Answer >
    Filed Under:
  • Q:

    When using a database, what is a field?

    A:

    In a database, the field is the smallest source of input for users to enter data. For example, a field in a database may ask for a company's name, tax identification number or income. A group of many fields is called a record, and a field in a spreadsheet is known as a cell.

    Full Answer >
    Filed Under:
  • Q:

    What is the purpose of a database?

    A:

    A database is used to collect and organize data. Although an electronic version such as one created in Microsoft Access may be the first that comes to mind, there are many non-automated database versions as well, such as a personal phone and address book.

    Full Answer >
    Filed Under:
  • Q:

    What is a database environment?

    A:

    A database environment is a system of components that regulate the collection, management and use of data. It includes software, hardware, people, procedures and the data itself.

    Full Answer >
    Filed Under:

Explore