What are the Most Common Types of Databases

A database is an electronic file that stores information in a series of records. Records are often contained in one or more tables.

There are many types of databases that vary by function and data model.

On Browsing and Manipulating
One way to classify different types of databases is by their function:

  • Look, but don't touch. Analytical databases, sometimes called On-line Analytical Processes (OLAP) are designed to assist in decision-making. Typically, an OLAP database contains statistical information that is read by users, but not modified.
  • Change is good. Operational databases, also known as On-line Transaction Processing (OLTP) can be manipulated by users. Records can be added, deleted or modified by users with the proper level of access.

A Model Citizen
The second way to classify different types of databases is by their "data model." A data model describes the structure of data and how it is accessed. There are several common data models:

  • Flat-file. Flat file databases most closely resemble paper files and file cabinets. Flat file databases, while simple to create and access, contain lots of redundant information. These redundancies slow down the search process, making the flat-file type of database inefficient.
  • Hierarchical. Hierarchical databases relate tables in a parent/child format. Although this reduces redundancy and increases organization, it is still a limiting way to handle data. The fact that child tables at the same level don't have links to each other makes searching problematic.
  • Relational. Relational databases link tables with common "key" fields allowing for sophisticated relationships between tables. Table links can be "indexed" or stored for future use, resulting in quicker searches in this type of database.
  • Object-oriented. Object oriented databases are structurally similar to relational databases. While most other types of databases are designed to hold text and numbers, object-oriented databases are designed to store audio, video and other mixed media objects.
Related Life123 Articles

Database management software has so many uses. Its basic function is as a program that stores information and then allows you or other users to search, retrieve, sort, revise, analyze and order data, making database software perfect for everything from keeping your library organized to running a business Web site smoothly.

Wondering "what is database software"? Database software is an application designed to store, organize and manage information.

Frequently Asked Questions on Ask.com
More Related Life123 Articles

Adding new fields in existing Access databases is relatively easy. You can either add a row, or you can use the Field Template feature.

What is a database used for? Not only does a database store information, but, depending on how the database is built, it can also help spread information among your employees and protect your company's data.

Relational databases are more complex that flat databases, in that they allow for connections among tables. As a result, queries of these databases bring up more meaningful data.

© 2014 Life123, Inc. All rights reserved. An IAC Company