What are the types of database software
Database software
Database software is designed to create databases and to store, manage, change, search, and extract the information contained in them. A complete database software program is sometimes called a database management system.
Database Software Classification
Database software is generally classified into six subtypes:
- Analytical Database Software
- Database software for data storage
- Distributed Database Software
- End User Database Software
- External database software
- Operational database software
Analytical Database Software
It allows the user to pull data from a variety of databases and examine it for the purpose of quantitatively evaluating performance (business, departmental, employee, etc.).
data storage software
It allows the user to extract key data from a variety of databases and store it in a central location in order to obtain and report critical information. Data warehousing helps ensure data integrity by easily identifying inconsistencies.
Distributed Database Software
It involves a centralized database management system that controls information stored in a variety of locations (including the cloud, a company LAN, or a network server). The distributed model is often considered the most secure due to its natural data redundancy.
End User Database Software
It stores information that is primarily used by one person (Microsoft Excel and its spreadsheets are an example).
External Database Software
It collects information that needs to be accessed by multiple users, often over the Internet.
Operational database software
It allows the user to modify the data in real time (for purposes such as financial and customer relationship management).
