preview

Database Analysis : Database Management System Essay

Good Essays

Databases are fundamentally containers for data. When data for any organization needs to be stored, databases can be used. For example, let’s say a public library stores books, we could say that the library is a database of books. But specifically, databases are computer structures that save, organize, safeguard and produce and/or deliver data. A database platform is essentially a database management system (DBMS) which is a computer software application that interacts with the user, other applications, and with the database itself to capture and analyze data. A general-purpose DBMS is designed in a way to allow the definition, creation, querying, update, and administration of databases1. Before we dive deeper into databases and the types, we need to know the difference between what a database is and what a DBMS is so we don’t confuse ourselves.

Database is a collection of related data stored in several different tables, and linked with each other using foreign keys. A DBMS is a Database Management System, is a piece of software that manages databases and lets you create, edit and delete databases, their tables and their data. Examples of a DBMS include, MySQL, MY SQL Server, Oracle, PostgreSQL, and SQLite.

When Organizations involved in combining various data sources may well be looking to source a Database Management system. There are various factors to consider during the process. Some of the factors include:
1) Usability – When considering a database, you have to

Get Access