Q:

What are the different types of databases?

A:

Quick Answer

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.

Know More

Full Answer

Other types of databases include hypertext databases, mobile databases, parallel databases, active databases, cloud databases, in-memory databases, spatial databases, temporal databases, real-time databases, probabilistic databases and embedded databases.

A database is an organized collection of data. Its primary function is to interact with a database management system to capture and analyze data. A database management system is a software system designed to allow the creation, querying and administration of databases. Some popular database management systems include PostgreSQL, MySQL, Microsoft SQL Server, Oracle, IBM DB2 and SAP.

Databases are designed to operate large amounts of information by inputting, storing, retrieving and managing it. They are set up in a way that allows users to easily and intuitively gain access to all the information. A database management maintains the integrity and security of stored data. It is also used for data recovery, in case of system failure.

Learn more about Software

Related Questions

  • Q:

    What are the uses of database management systems?

    A:

    Database management systems, or DBMSs are computer programs that facilitate the systematic management and creation of databases by allowing end users and other applications to freely interact with the database. The DBMS guarantees that the database is organized constantly and accessible quickly to enable the storage, modification and extraction of data.

    Full Answer >
    Filed Under:
  • Q:

    How secure is the SSN database?

    A:

    The Social Security Administration uses validation certificates and two-factor authentication technology to secure access to their databases. Its internal security measures are not published, but none of the 10 major federal data breaches in 2014 involved the Social Security Administration.

    Full Answer >
    Filed Under:
  • Q:

    What is data integrity testing?

    A:

    Data integrity testing refers to a manual or automated process used by database administrators to verify the accuracy, quality and functionality of data stored in databases or data warehouses. This test is regularly done by administrators to ensure that stored data has remained unaltered and to discover system design bugs that could compromise the files in a database.

    Full Answer >
    Filed Under:
  • Q:

    What are the different uses of spreadsheets?

    A:

    Spreadsheets are used for simple lists and complex numerical calculations. Spreadsheets turn information into detailed graphs to show a visual representation of the data. Spreadsheets provide many sorting options to filter information.

    Full Answer >
    Filed Under:

Explore