Aviva Directory » Computers & Internet » Software » Database

Databases are organized collections of data that are stored and accessed through a computer. Database software is known as the database management system (DBMS)

The DBMS interacts with end-users, applications, and the database itself, capturing and analyzing data. The database software is responsible for administering the database. In general usage, the term "database" is used to refer to the database system software, as well as applications associated with the database.

Database software refers to any software designed for creating and managing the information stored in databases. These database management systems are database software tools used to store, modify, extract, and search for information contained within a database.

There are different types of database software. Generally, the type of DBMS software used depends on the method of storage (single or multifile) or the purpose of its use within a company or institution. Single file database software is also known as flat-file, while multifile database software is relational. The software used in both single and multifile databases is used to accommodate various storage needs.

A relational database management system (RDBMS) supports single and multifile options, while non-RDBMS software supports only single-file storage. A non-RDBMS software option is sufficient for managing small records, such as names, addresses, and telephone numbers.

DBMS software can also be classified according to the purpose of its use. This classification system may include operational databases, external databases, end-user databases, distributed databases, data warehouse databases, analytical databases, and hypermedia databases.

An operational database is also known as an online transaction processing (OLTP) database. Used to manage dynamic data in real-time, this type of database software allows for the addition, deletion, and modification of data in the database, and is often used in customer relationship management transactions and financial operations. This type of database allows users to gather, enter, and retrieve large amounts of data, which might include legal notices, financial data, personal employee information, call logs, and so on.

External databases are used to manage information gathered for use by multiple individuals or organizations, either by subscription or for free. This type of database is accessed online by users who access privately-owned data. The Internet Movie Database (IMDb) is an example of this type of database.

End user databases are used to store data created by an end-user. These include the databases created by word processing and spreadsheet applications.

In a distributed database, the software is distributed at various geographical locations. Under the control of one central DBMS, the storage devices of the distributed database are connected to different CPUs. This type of database can reside on a LAN, a WAN, the Internet, or on various network servers or extranets.

A data warehouse database contains a collection of information extracted from various other databases, and stored in one place. Data warehouses are usually used for reporting purposes, and for drawing insights.

Analytical databases are used to store data from other databases for data analysis. The data in an analytical database software can be edited, filtered, and used by analysts of a business or organization, and are often used for the analysis of employee or organizational performance.

Hypermedia database software is used to store multimedia web pages. Data is stored online and can be accessed by multiple users at the same time.

There are several database software programs. Some of the better-known programs are ADABAS, IBM DB2, Microsoft Access, Microsoft Excel, Microsoft SQL Server, MySQL, Oracle RDBMS, Quick Base, SAP Sybase ASE, and Teradata.

Databases may reside on a desktop hard drive, be web-enabled, or installed on a server. Desktop databases are the smallest and least expensive. Web-enabled databases include a desktop application and web integration. Server-based systems are the largest and most expensive, but designed to accommodate multiple users.

The focus of this category is on database software and closely related resources.



Recommended Resources

Search for Database on Google, Bing, or Yahoo!