Q:

What is database software used for?

A:

Quick Answer

Database software is used for the management and storage of data and databases. The organization of databases is exceedingly important when comprising a database of criminals, evaluating medical and school information, and storing government and driver information.

Continue Reading
What is database software used for?
Credit: tyndyra E+ Getty Images

Full Answer

Database software is typically easy to use so that end users can evaluate data, store it, add to it, and edit it or delete it. The capture and analyzing of data is typically performed by database management systems, otherwise known as DBMSs. These types of database software systems are programmed in SQL, and examples include Microsoft SQL Server, MySQL, Oracle SAP HANA and FoxPro.

Not all database software requires a person to be knowledgeable in SQL or needs programming queries. Web-based database programs such as Microsoft Access are available and can be much easier for a novice to use. The user can navigate the database via the program's GUI controls, without using SQL.

DBMS types of software have four main categories: definition of data, update, retrieval and administration. A DBMS system is also required to protect the integrity of data and provide its security. The precursor to database software was revolutionized by Edgar F. Codd in 1970, with his relational model.

Learn more about Software

Related Questions

  • Q:

    What is the meaning of "database system"?

    A:

    A database system is a high-level definition of the structure and relationship between stored data, a database or databases, users and the hardware or operating system used for the storage.

    Full Answer >
    Filed Under:
  • Q:

    How do you recover data from a memory card?

    A:

    To recover data from a memory card, download a file recovery program designed for external storage devices, start the software and scan the card. Select desired files to recover them.

    Full Answer >
    Filed Under:
  • 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:

    What are the different types of databases?

    A:

    The different types of databases include operational databases, end-user databases, distributed databases, analytical databases, relational databases, hierarchical databases and database models. Databases are classified according to their type of content, application area and technical aspect. For instance, a deductive database combines logic programming with a relational database, while a graph database uses graph structures to represent and store information.

    Full Answer >
    Filed Under:

Explore